SD Report

[Former Member]

To,

SD GURUS

Any T-code available in SAP SD for seeing the sales order number, delivery document number, Invoice Number in one report

anand

[former_member206215]

Please go to VA03 put the sales order number and press document flow tab that is F5 You will see all the necessary details regarding order delivery and billing and secondly go to transactio SE16 in ABAP and if VBFA add delivery number or billing document number you will get all necessary details towards the same

[jignesh_mehta3]

Dear Anand,

There is no standard T-Code availalbe for seeing the sales order number, delivery document number, Invoice Number in one report

For a single Document you can see in document flow of any sales, delivery of invoice document.

If you want to generate a one time report then you can use T-code - SE16N & access table VBUK & VBUK for Document flow.

But if you want to get this information frequently or give a t-code to end-user, then generate a query in SQ00 & assign a t-code to it.

Alternatively, you can develop a Z-report with help of ABAPers.

Hope this helps...

Thanks,

Jignesh Mehta

[Former Member]

Hi

Make a query using t.code SQVI & create new z tcode using t code SE93

a) for seeing the sales order number, delivery document number, Invoice Number

Use table VBRP &

select the screen fields options for sales order number, delivery document number, Invoice Number, so that if you know any one , you should be able to search remaing details using that t.code

b) for seeing the sales order number, delivery document number, Invoice Number along with the Excise invoice

Use table join VBRP & J_1IEXCDTL where the Reference document 1 or Reference document 2 field of the later table can be used to link with VBRP

select the screen fields options for Excise invoice no., sales order number, delivery document number, Invoice Number, so that if you know any one , you should be able to search remaing details using that t.code

Regards

Tejpal

[reazuddin_md]

you can get the same in VBFA- document Flow table, but in sequence as you mentioned.

[Former Member]

Hi Anand,

Go to "SE16" and enter "VBFA" AND give the sales document number as the preceding document number, you will get all the details.(Doc Flow).

Regards

Ram Pedarla

[Former Member]

hi

you can see all this in VBRP table

regards

vardhan