logic for J_1IEXCDTL-TRNTYP

[former_member213112]

Hi,

For my report in BI I want to add new column J_1IEXCDTL-TRNTYP,  I am already having material document number in my current report as primary key.

I am passing that material document no(MSEG-MBLNR) to J_1IGXREF and getting excise official no and excise year. The values which I am fetching are passed to J_1IEXCDTL table to fetch TRNTYP. But this logic is failing as official excise no and excise year are not primary keys.

Simply How can I fetch Excise Transaction Type ? the fields which I am having is MBLNR & EBELN from (WB2_V_MKPF_MSEG2 View) .

Thanks,

Avinash.

[former_member185414]

Hi,

Technically you can go to transaction SQVI transaction and find the join condition/relation between any number of tables.

And what i found is below in your case -

i.e. they are related via the year.

In your case you can get multiple Transaction types(technically) and have to consult business that whether is there any possibility of such values getting maintained in real life. If yes, then you need to take a call to pick the latest one or first one whatever the business decides.

BR.