am creating a query report for rigister wise excise balances in sq01 with joining tables J_1ipart2 and J_1iexcdtl . the joint condition of both tables is internal no. BED ,ECS,SHE thease values i have taken from J_1ipart2. documents which we have posted from J1ih transaction is not comming in report because those documents will not be available in J_1iexcdtl table . if i select condition left cutter all values are comming with duplication. can i get all the internal document no of J_1ipart2 table with out duplication which is document no not matching with other table also....? .because the table J_1ipart2 values are matching with my TB,
kindly help me
Thanks & Regards,
Edited by: Anusha19 on Mar 4, 2012 7:31 AM
Edited by: Anusha19 on Mar 4, 2012 7:36 AM
kindly check these tables J_1IEXCHDR, J_1IEXCDTL, J_1IGRXSUB and develop a BDC recording for the transaction J1IFQ. Do you have condition type 'UTXJ' in your pricing procedure for exports? The base value is update from this condition type (hard coded).