querry

[Former Member]

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

[Former Member]

Why dojn't you try coding this yourself, and if you run into problems, get back to the forum then.

rob

[Former Member]

Why dojn't you try coding this yourself, and if you run into problems, get back to the forum then.

rob

[Former Member]

Hi , I'm trying since 3 days but i could'nt get

[Former Member]

Thanks for motivating, i got it now

[Former Member]

Now <b>that</b> is the way I like to earn points - glad it worked out.

Rob