Standard report:: sales order document starting from delivery number

[Former Member]

Hi all,

is there a standard report that gives me the sales document number starting from the delivery number?

Thx

F

[former_member183879 · Accepted solution]

Give the delivery document number as the input in the table VBFA for the field VBELV. now you get the value of the field VBFA-VBELN. This is the sales order number.

VBFA is the document flow table in SD

Hope this helps you.

Pls reward if this helps.

[Former Member · Accepted solution]

Hi,

I need a standard report that users can execute. I have reasons for not creating queries.

Thx,

F

[Former Member · Accepted solution]

Hi Felix,

(all authorised) users can do it with the standard report VL06F.

In the fifth area "Doc. Data" fill in relevant delivery note number(s) in field "Delivery" and execute.

In the layout choose "item view" and pick "ref.doc.".

Arrange what else is necessary for your users in the layout and save as standard layout.

Regards,

Nicole