Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 16, 2011 at 08:40 AM

    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

    Add comment
    10|10000 characters needed characters exceeded