topic Re: SQL Stmts for sales order. in Application Development and Automation Discussions

SQL Stmts for sales order.

Former Member — Fri, 06 May 2005 03:54:18 GMT

Hi, How do I select

sales order no,

stock loc,

promised date,

requested date,

date entered,

Customer number,

Line No,

Material,

order Qty,

Shipped Qty,

Bin location.

for the sales order report.

I have problem with the dates, in the schedule line level.

How can they be captured regardingly. Order quantity is also not been captured, into internal table.

Regards,

Ajju

Re: SQL Stmts for sales order.

Former Member — Fri, 06 May 2005 04:04:48 GMT

Hi Syed,

The details that you wish to obtain are not all stored in the same table. You will have to go to three different tables -

VBAK - Sales Order Header

VBAP - Sales Order Item Details

VBEP - Schedule Line Data

Regards,

Anand Mandalika.

Re: SQL Stmts for sales order.

Former Member — Fri, 06 May 2005 04:26:31 GMT

Thanks for the reply,

I wanted to know, how to join all the fields together.

can it be done with nested select statements or individual select statements. and how?

hope U could provide some more light on it

Regards,

Ajju

Re: SQL Stmts for sales order.

jayanthi_jayaraman — Fri, 06 May 2005 05:49:46 GMT

Hi,

I suggest you to retrive records(required fields) from VBAK first.

Then use for all entries(I_VBAK) to retrive records(required fields) from VBAP .

Then use for all entries for the second itab i_VBAP to fetch records from VBEP.

Then combine the internal tables.

Select fields from VBAK into table I_VBAK.

select fields from VBAP into table I_VBAP for all entries in I_VBAK where vbeln = I_VBAK-vbeln.

select fields from VBEP into table I_VBEK for all

entries in I_VBAP where vbeln = I_VBAP-vbeln

and posnr = I_VBAP-posnr.

Loop at I_VBAK."Assumed that table with header line

I_OUTPUT-field1 = I_VBAK-field1.

...

Loop at I_VBAP where vbeln = I_VBAK-vbeln.

I_OUTPUT-field2 = I_VBAK-field2.

...

Loop at I_VBEP where vbeln = I_VBAP-vbeln

and posnr = I_VBAP-posnr.

I_OUTPUT-field3 = I_VBAK-field3.

append I_OUTPUT.

Endloop.

Hope this helps.If not , get back to me.

Rgds,

J.Jayanthi