Sales report to be created

[Former Member]

Dear friends,

I need to generate a report for sales document as below.

Input:

Document date From to

Sales order From to

Sales org From to

Sold to customer From to

Plant

output.

a) Sales Order No. - Get VBAP-VBELN

b) Item - Get VBAP-POSNR

c) Customer – Get VBAK -KUNNR

d) Payer – Pass VBAK-KUNNR to VBPA table and get PARVW (where PARVW = PY)

e) Transportation Zone

f) Plant – Pass VBAK-VBELN to VBAP table and get WERKS

g) Loading Date - Get VBEP-LDDAT ( if available, take confirmed loading date form schedule lines)

h) Material – VBAP-MATNR

i) Material description – Get VBAP-ARKTX

j) Price – VBAP-NETWR

k) Currency - Get VBAP - WEARKS

l) Billing Block - Get VBAP -FAKSK

m) Order qty - Get VBAP - KWMENG

n) FD Number – Pass VBAK-VBELN to VBKD-VBELN and get LCNUM.

o) L/C number (Ext FD number) - Pass VBKD-LCNUM to AKKB and get BAANR

p) Terms of Payment code / description – Get VBKD-ZTERM

q) Inco Terms – Get VBKD-INCO1

r) Created on - Get VBAK-ERDAT

s) Created by - Get VBAK-ERNAM

t) Order Type - Get VBAK-AUART

u) Ship to country

Here i find difficulties for 2 fields ( ship to country & transportation zone) how to link with customer master with the sales document.

I dont find any table - field link

Please help & you may suggest some extra if you find any thing good out of it.

Thanks in advance.

Ranjan

[mandar_shete]

Hi,

You can link SO with Ship-To Country and Transportation zone using table VBPA.

If you pass Sales Order No. and line item to this table you will get all Header/Item level partner numbers.

If Item no. is 000000, then it will be a header level and if Item no. is other than 000000, then it is item level.

Regards,

Mandar

[Former Member]

Dear,

Here could you tell the table & field for sh to party at item level

which i am facing the difficulty.

Ranjan

[Former Member]

Hi,

Since you are using basic tables for your report.

You can try using transaction SQVI and do table join for these tables VBAK, VBKD, VBPA, VBAP.

This will surely help.

Try getting an ABAPer if you are getting confused.

Reward points if helpful.

Regards

Ravi