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>