Dear All,
I am having below existing query. In this query now I want modification in such a way that
it_eine_latest will retain all values and EKBE will be joined in such a way that in case no entries from EKBE, the column from EKBE will be blank in it_eine_latest and if EKBE has values for EBELN/EBELP then those values should be available.
(D~BUDAT is nothing but EKBE~BUDAT)
SELECT a~infnr
a~ebeln
a~ebelp
a~datlb
a~netpr
a~peinh
b~netpr
c~lifnr
c~waers
D~BUDAT
FROM eine AS a JOIN
ekpo AS b
ON a~ebeln = b~ebeln AND
a~ebelp = b~ebelp
JOIN ekko AS c "ADORNAL CTASK0043115
ON b~ebeln = c~ebeln "ADORNAL CTASK0043115
INTO TABLE it_eine_latest
FOR ALL ENTRIES IN it_eina
WHERE a~infnr = it_eina-infnr AND
( a~esokz = '0' OR a~esokz = '3' ) AND " Std Order⋐con
a~bstyp = 'F' AND " PO
b~loekz = space AND
( b~pstyp = '0' OR b~pstyp = '3' )
AND c~bsart = 'NB'.
I will be thankful for kindly helping with above query.
Regards.
Bluesky
