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!

[nru_house]

Customer name can be read from KNA1 table KUMNR.

Hope it helps

BR,

Nr.

[ajaycwa1981]

Customer balances can be read from KNC1, KNC3

Line items from Index Tables BSID/BSAD

[former_member337800]

What is the field name for Line Item Posting Status in FBL5N

means

1) open

2) cleared

[former_member219086]

Hi Azeemuddin,

This is not a field. It is just a symbol defined in the program.

Your ABAP'er should know how to define this in the custom program.

Based on the open and cleared items read from index tables, the data can be displayed with these symbols like ICON_4 ICON_RED_LIGHT for open items.

Hope this helps. Thank you!!

Srinath