hi all, can any one tell how to qurrey this
IF
Company Code (BSEG-BUKRS) = 2000
Document type (BKPF-BLART) = IP
Posting key (BSEG-BSCHL) = 40 or 50 or 31 or 21
Advice Field Name Source Data Source System
Pack Slip If BSEG-SGTXT(01) = C (consignment)
Pack Slip = BSEG-SGTXT(04-28)
Else
Pack Slip = BSEG-XREF3
Receipt # If BSEG-SGTXT(01) = C (consignment)
Receipt# = BSEG-XREF3
Else
Receipt# = BSEG-SGTXT(04-28)
Date Recd BKPF-BLDAT
Part No BSEG-MATNR
P.O. # BSEG-XREF2
Quantity BSEG-MENGE
Unit Price BSEG-SGTXT(30-50)
Extension BSEG-WRBTR
Total for document no. BSEG-BELNR or BKPF-BELNR/BKPF- XBLNR
Bluesky
