Customized Sales Representative Report

[former_member337800]

I am creating a customized Sales Representative Report combining Transactions VA01,VL01N,VF01,FD10N,FBL5N and MC-Q

VA01

Customer Number=VBAK-KUNNR

Sales Order Number=VBAK-VBELN

Material Number=VBAP-MATNR

Material Quantity=VBAP-KWMENG

Sales Organization=VBAK-VKORG

Distribution Channel=VBAK-VTWEG

Division=VBAK-SPART

VL01N

Delivery Date=LIKP-BLDAT

Delivery Number=LIKP-VBELN

Material Number=LIPS-MATNR

Delivered Quantity=LIPS-LFIMG

VF01

Invoice Number=VBRK-VBELN

Material Number=VBRP-MATNR

Billed Quantity=VBRP-FKIMG

Net Value=VBRK-NETWR

FD10N

Customer Number=?

Customer Balance=?

FBL5N

Customer Number=?

Line Item Posting Status=?

MC-Q

Sales Personnel Number=S006-VRTNR

Sales Organization=S006-VKORG

Please Advise!

[Former Member]

I see that FD10N selects KUNNR from table KNB1 and strogly beleve balance is calculated.

FBL5N reads data from KNB1, LFA1, BSID, BSIK.

Maybe it would be better, if you post the question in Finance are of the forum, as it's not SD transactions. 

[Lakshmipathi]

Try with KNC1 and KNC3 tables

[former_member337800]

Please Advise!

FD10N

Customer Number=?

Customer Balance=?

FBL5N

Customer Number=?

Line Item Posting Status=?