Author: Not specified | Language: abap |
Description: Not specified | Timestamp: 2018-03-26 06:57:45 +0000 |
View raw paste | Reply |
SELECT SINGLE
lfa1~lifnr
lfa1~name1
lfa1~name2
lfa1~stras
lfa1~pstlz
lfa1~ort01
lfa1~pstl2
lfa1~pfach
lfa1~land1
lzus~gjvon
lzus~gjbis
lzus~gjvon_alt
lzus~gjbis_alt
FROM
lfa1
INNER JOIN
/gicom/01_lifzus AS lzus
ON
lzus~lifnr = lfa1~lifnr
INTO CORRESPONDING FIELDS OF
me->gs_lif_data
WHERE
lfa1~lifnr EQ i_lifnr AND
/gicom/01_lifzus~lifkz EQ abap_true.
SELECT SINGLE
lfa1~lifnr,
lfa1~name1,
lfa1~name2,
lfa1~stras,
lfa1~pstlz,
lfa1~ort01,
lfa1~pstl2,
lfa1~pfach,
lfa1~land1,
lzus~gjvon,
lzus~gjbis,
lzus~gjvon_alt,
lzus~gjbis_alt
FROM
lfa1
INNER JOIN
/gicom/01_lifzus AS lzus
ON
lzus~lifnr = lfa1~lifnr
WHERE
lfa1~lifnr = i_lifnr AND
lzus~lifkz = abap_true
INTO CORRESPONDING FIELDS OF
me->gs_lif_data.
lfa1~lifnr
lfa1~name1
lfa1~name2
lfa1~stras
lfa1~pstlz
lfa1~ort01
lfa1~pstl2
lfa1~pfach
lfa1~land1
lzus~gjvon
lzus~gjbis
lzus~gjvon_alt
lzus~gjbis_alt
FROM
lfa1
INNER JOIN
/gicom/01_lifzus AS lzus
ON
lzus~lifnr = lfa1~lifnr
INTO CORRESPONDING FIELDS OF
me->gs_lif_data
WHERE
lfa1~lifnr EQ i_lifnr AND
/gicom/01_lifzus~lifkz EQ abap_true.
SELECT SINGLE
lfa1~lifnr,
lfa1~name1,
lfa1~name2,
lfa1~stras,
lfa1~pstlz,
lfa1~ort01,
lfa1~pstl2,
lfa1~pfach,
lfa1~land1,
lzus~gjvon,
lzus~gjbis,
lzus~gjvon_alt,
lzus~gjbis_alt
FROM
lfa1
INNER JOIN
/gicom/01_lifzus AS lzus
ON
lzus~lifnr = lfa1~lifnr
WHERE
lfa1~lifnr = i_lifnr AND
lzus~lifkz = abap_true
INTO CORRESPONDING FIELDS OF
me->gs_lif_data.
View raw paste | Reply |