7 Replies Latest reply: Mar 6, 2012 8:31 PM by Anusha Yarlagadda RSS

Excise Query Issue

Anusha Yarlagadda
Currently Being Moderated

Hi Friends,

 

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,

Anu

 

Edited by: Anusha19 on Mar 4, 2012 7:31 AM

 

Edited by: Anusha19 on Mar 4, 2012 7:36 AM

Actions