J_1IEXCACC

Excise Account Assignment table | #other | Component: Logistics India

🔑 Keys (5)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical
Other (9)
🔗 Relations (27)

Column Name	Description
MANDT FK	Client
J_1IEXGRP FK	Excise Group
J_1ITRNTYP FK	Excise Transaction Type
J_1IBUKRS FK	Company Code
J_1ISTRTYP	Sub Transaction Type

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description	Domain name
J_1IRG23AAT1	G/L account RG23A AT1 account	SAKNR
J_1IRG23CAT1	G/L account RG23C AT1 account	SAKNR
J_1IPLAAT1	G/L account for PLA AT1 (Personal Ledger Account)	SAKNR
J_1IRG23AAT2	G/L account RG23A AT2 account	SAKNR
J_1IRG23CAT2	G/L account for RG23C AT2	SAKNR
J_1IPLAAT2	G/L account for PLA AT2 (Personal Ledger Account)	SAKNR
J_1IRG23AAT3	G/L account RG23A AT3 account	SAKNR
J_1IRG23CAT3	G/L account for RG23C AT3	SAKNR
J_1IPLAAT3	G/L account for PLA AT3 (Personal Ledger Account)	SAKNR

Master Data Relations \| to Other Relations ↓	Join Conditions
Company Code	`J_1IEXCACC.MANDT == T001.MANDT` `J_1IEXCACC.J_1IBUKRS == T001.BUKRS`
Foreign Key for J_1IEXCACC-J_1ICLEAR Chart of Accounts Client G/L account for Modvat Clearing	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1ICLEAR == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IKTOPL Chart of Accounts Client	`J_1IEXCACC.J_1IKTOPL == T004.KTOPL` `J_1IEXCACC.MANDT == T004.MANDT`
Foreign Key for J_1IEXCACC-J_1IMSUSP Chart of Accounts Client G/L Account for CENVAT Suspense	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IMSUSP == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IOFFSET Chart of Accounts Client G/L Account for CENVAT Offset	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IOFFSET == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IONHOLD Chart of Accounts Client G/L Account for CENVAT On Hold	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IONHOLD == SKA1.SAKNR`
G/L account for PLA AED (Personal Ledger Account) Chart of Accounts Client G/L account for PLA AED (Personal Ledger Account)	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IPLAAED == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IPLA Chart of Accounts Client G/L account for PLA BED (Personal Ledger Account)	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IPLABED == SKA1.SAKNR`
G/L account for PLA CESS (Personal Ledger Account) Chart of Accounts Client G/L account for PLA CESS (Personal Ledger Account)	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IPLACES == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IPLAECS Chart of Accounts Client G/L account for PLA ECS	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IPLAECS == SKA1.SAKNR`
G/L account for PLA NCCD Chart of Accounts Client G/L account for PLA NCCD	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IPLANCCD == SKA1.SAKNR`
G/L account for PLA SED (Personal Ledger Account) Chart of Accounts Client G/L account for PLA SED (Personal Ledger Account)	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IPLASED == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IPSUSP Chart of Accounts Client G/L account for PLA On Hold	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IPONHLD == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IREVERS Chart of Accounts Client G/L Account for CENVAT Reversal	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IREVERS == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IRG23AA Chart of Accounts Client G/L account RG23A AED account	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IRG23AA == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IRG23AB Chart of Accounts Client G/L account RG23A BED account	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IRG23AB == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IRG23AE Chart of Accounts Client G/L account for RG23A ECS	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IRG23AE == SKA1.SAKNR`
G/L account for RG23A NCCD Chart of Accounts Client G/L account for RG23A NCCD	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IRG23AN == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IRG23AS Chart of Accounts Client G/L account for RG23A SED	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IRG23AS == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IRG23CA Chart of Accounts Client G/L account for RG23C AED	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IRG23CA == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IRG23AB Chart of Accounts Client G/L account for RG23C BED	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IRG23CB == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IRG23CE Chart of Accounts Client G/L account for RG23C ECS	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IRG23CE == SKA1.SAKNR`
G/L account for RG23C NCCD Chart of Accounts Client G/L account for RG23C NCCD	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IRG23CN == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-J_1IRG23CS Chart of Accounts Client G/L account for RG23C SED	`J_1IEXCACC.J_1IKTOPL == SKA1.KTOPL` `J_1IEXCACC.MANDT == SKA1.MANDT` `J_1IEXCACC.J_1IRG23CS == SKA1.SAKNR`
Foreign Key for J_1IEXCACC-MANDT	`J_1IEXCACC.MANDT == T000.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Excise Group ? Excise Group	`J_1IEXCACC.MANDT == J_1IEXGRPS.MANDT` `J_1IEXCACC.[column in domain "WERKS_D"] == J_1IEXGRPS.J_1IWERKS` `J_1IEXCACC.J_1IEXGRP == J_1IEXGRPS.J_1IEXCGRP`
Excise Transaction Type Excise Transaction Type Client	`J_1IEXCACC.J_1ITRNTYP == J_1ITRAN.J_1ITRNTYP` `J_1IEXCACC.MANDT == J_1ITRAN.MANDT`