Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

what is best way to select Complete sales Cycle data

Former Member
0 Kudos

Hi,

i have a requirement to select the complete sales cycle data start from the SO to Shipping..(vbak,vbap,vbep,vbpa, likp,lips, vbrk,vbrp, vttk),

i need to summurise all the details in areport.

iam suppose to use join for the related tables

i.e. .<b>one select for tables vbak,vbap,vbep,vbpa</b>.

.<b>one select for tables likp,lips</b>.

.<b>one select for tables vbrk,vbrp</b>.

<b>what iam expecting is.. is there any other best way to do this?</b>

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hello Naresh,

It is not good to select the data from all the sales tables in one shot. What I would suggest it u can look for

1. releavant FM which can give me the necessary data

2. access VBFA document flow table and from there u can get what all things are processed for the sales order and then individually access the sales tables.

This will give a better grip on the performance of ur program.

5 REPLIES 5

Former Member
0 Kudos

Hi ,

Try with RV_SALES_DOCUMENT_VIEW_2, RV_SALES_DOCUMENT_VIEW_3,RV_SALES_DOCUMENT_VIEW_4.

Regards,

Raghav

Former Member
0 Kudos

Hello Naresh,

It is not good to select the data from all the sales tables in one shot. What I would suggest it u can look for

1. releavant FM which can give me the necessary data

2. access VBFA document flow table and from there u can get what all things are processed for the sales order and then individually access the sales tables.

This will give a better grip on the performance of ur program.

Former Member
0 Kudos

use the following function module to get complete sales documents

SD_SELECT_SALES_DOCUMENTS

thanks

Sekhar.

Former Member
0 Kudos

Thank you for ur relpy's.

I am using joins, because the FM's are not meeting my exact requirements

Former Member
0 Kudos

thank you all

I have used joins, because the FM's are nor meeting my reuirments