Hi Experts,
Im working on pdc and I use bsis to get the data but also need to get zuonr. I check with bseg but the connection i got is bseg-augbl = bsis-belnr. augbl is not a key field. could anyone help on how can i transfer the data of it_bseg_b to my final table. many thanks. below is my code.
SELECT bukrs
hkont
gjahr
belnr
budat
waers
blart
shkzg
wrbtr
dmbtr
augdt
xragl
buzei
augbl
FROM bsis
INTO TABLE it_bsis
WHERE hkont EQ c_sales_pdc
AND bukrs IN s_bukrs
AND belnr IN s_belnr
AND budat LE p_budat.
DELETE it_bsis WHERE blart NE 'DZ'
AND blart NE 'PD'.
DELETE it_bsis WHERE xragl NE ''.
SELECT bukrs belnr kunnr gjahr augbl zuonr
FROM bseg INTO TABLE it_bseg_b
FOR ALL ENTRIES IN it_bsis
WHERE bukrs = it_bsis-bukrs
AND kunnr IN s_kunnr
AND belnr = it_bsis-belnr
AND gjahr = it_bsis-gjahr.
LOOP AT it_bsis.
it_final3-bukrs = it_bsis-bukrs.
it_final3-hkont = it_bsis-hkont.
it_final3-gjahr = it_bsis-gjahr.
it_final3-belnr = it_bsis-belnr.
it_final3-budat = it_bsis-budat.
it_final3-waers = it_bsis-waers.
it_final3-blart = it_bsis-blart.
it_final3-shkzg = it_bsis-shkzg.
it_final3-wrbtr = it_bsis-wrbtr.
it_final3-dmbtr = it_bsis-dmbtr.
it_final3-augdt = it_bsis-augdt.
it_final3-xragl = it_bsis-xragl.
READ TABLE it_bseg_b WITH KEY belnr = it_final3-belnr
bukrs = it_final3-bukrs.
it_final3-kunnr = it_bseg-kunnr.
it_final3-vbeln = it_bseg-vbeln.
it_final3-zuonr = it_bseg-zuonr.
APPEND it_final3.
CLEAR it_final3.
ENDLOOP.