cancel
Showing results for 
Search instead for 
Did you mean: 

Report in order

Former Member
0 Kudos

Hai experts

I need one report in SD regarding party ordered 100 quantity on 19.11.2008

First delivery 19.11.2008 50 quantity

Second delivery 30.11.2008 20 quantity

Third delivery 25.12.2008 30 quantity

These r the scheduline dates my report is total ordered quantity, first delivered quantity with dates second delivery quantity with dates pending quantity to be delivered with date.

where I will i get

thanku

Accepted Solutions (0)

Answers (1)

Answers (1)

Lakshmipathi
Active Contributor
0 Kudos

Go to SE16, input Table VBEP and execute. There give the sale order references and execute. You will get the required datas there.

thanks

G. Lakshmipathi

Former Member
0 Kudos

Thank u Lakshmipathy for quick replay

I need Customer (SP) wise

thank u in advance

Lakshmipathi
Active Contributor
0 Kudos

In that case, you have to table join in SQVI the tables VBAK and VBEP

thanks

G. Lakshmipathi

Former Member
0 Kudos

Hi lakshmipati,

How we can add two tables in SQVI, Please explain.

Thanks

Rao

Lakshmipathi
Active Contributor
0 Kudos

Go to SQVI and do the following:-

- Give some description in "Quickview"

- Click "Create" button

- Give some description in "Title"

- From the tab "Data Source", select "Table Join" and click blue tick

- Press "Shift + F1"

- Give the table you wanted and press enter

- Again Press "Shift + F1"

- Again give the table you wanted and press enter

- Press F3

- On your left screen you can see those two tables with header "List fields" and "Selection Field"

- Whatever data you want to give as input, (say for example based on sales organisation, you want some report), select the white box under selection field

- Whatever data you want as report format, select those fields under "List fields"

- Execute the report

thanks

G. Lakshmipathi

Former Member
0 Kudos

Thank u Lakshmipathy