topic Re: querry in Application Development and Automation Discussions

querry

Former Member — Fri, 22 Jun 2007 13:28:35 GMT

hi all, can any one tell how to qurrey this

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 — Fri, 22 Jun 2007 14:08:41 GMT

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

rob

Former Member — Fri, 22 Jun 2007 14:16:07 GMT

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

Former Member — Fri, 22 Jun 2007 18:43:49 GMT

Thanks for motivating, i got it now

Former Member — Fri, 22 Jun 2007 18:46:36 GMT

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

Rob