Skip to Content
0
Jun 19, 2015 at 03:46 AM

logic for J_1IEXCDTL-TRNTYP

14 Views

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.