Excise Query Issue

Anusha Yarlagadda

Mar 4, 2012 7:37 AM

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

Re: Excise Query Issue

Anusha Yarlagadda Mar 4, 2012 12:14 PM (in response to Anusha Yarlagadda)

Currently Being Moderated

Friends waiting for your replay .... please tell me if any coding is possible to fixing the issue..?
Report Abuse

Like (0)
- Re: Excise Query Issue
  
  Anusha Yarlagadda Mar 5, 2012 4:27 AM (in response to Anusha Yarlagadda)
  
  Currently Being Moderated
  
  hi
  
  Report Abuse
  
  Like (0)
Re: Excise Query Issue

sridhar shetty Mar 5, 2012 5:49 AM (in response to Anusha Yarlagadda)

Currently Being Moderated

Hi Anusha,
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).

Regards
Sridhar
Report Abuse

Like (0)
- Re: Excise Query Issue
  
  Anusha Yarlagadda Mar 5, 2012 4:46 PM (in response to sridhar shetty)
  
  Currently Being Moderated
  
  Hi Shridhar ,
  
  i need the values from J_1IPART2 table . for material and vendor , base amount, qty, am join the table J_1IEXCDTL . please anbody help me to create this query
  
  Rgds,
  Anu
  
  Report Abuse
  
  Like (0)
  - Re: Excise Query Issue
    
    Anusha Yarlagadda Mar 6, 2012 8:31 PM (in response to Anusha Yarlagadda)
    
    Currently Being Moderated
    
    HI Friends
    
    any solution........
    
    Report Abuse
    
    Like (0)
Re: Excise Query Issue

Brinda R Mar 5, 2012 12:30 PM (in response to Anusha Yarlagadda)

Currently Being Moderated

Hi,

Why will J1IH entries not be in J_1IEXCDTL table?
It will be available in J_1IEXCDTL table. Check correctly.
In the report include all ETTs then all the documents will flow.

OR yes you can select the entries from J_1IPART2 table as well

Regards,
Brinda
Report Abuse

Like (0)
- Re: Excise Query Issue
  
  Anusha Yarlagadda Mar 5, 2012 4:43 PM (in response to Brinda R)
  
  Currently Being Moderated
  
  Hi Brinda,
  
  all j1ih transactions are will display in J_1IEXCHDR not in J_1iexcdtl . cdtl will display only the ett - dlfc ,grpo & ceiv transactions.
  
  Rgds,
  Anu
  
  Report Abuse
  
  Like (0)

Go to original post