Skip to Content
0
Former Member
Nov 22, 2006 at 06:06 AM

what is best way to select Complete sales Cycle data

65 Views

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>