Report with Invoice No, SO No, EQUNR...

[Former Member]

Dear Experts,

I have requirement to develop report with output containing following fields

Invoice No, Equpiment No, Material Code, Serial No, Material Descr, Sold-to Party, Ship-to Party, Sales Order Number, Sales Person ID, and Sales Person

if anyone knows Please let me know the tables and fields and its relationships that I can take to develop this report.

Thanks in Advance...

BR

Venkat

[Former Member]

Hi

Table VBRP

VBELN Billing Document

MATNR Material Number

VBRK

KUNAG Sold-to party

Pass VBELN in VBFA to get sales order number

Select VBELV with VBTYP_V as C. That is sales order number

Pass MATNR in MAKT to get MAKTX - material description

[Former Member]

Hi Aditya,

thanks for your reply, I got your point how about getting data EQUNR, SERNR ?

Rgds

Venkat

[Former Member]

Hi

Use table EQUI to get EQUNR,SERNR with MATNR