I_ExciseAcntAsgmnt

Excise Account Assignment | view: ISDEXCACTASNG | Extraction: Not supported | Component: Logistics India
Tables used: J_1IEXCACC
Column Name Description
ExciseGroup FK Excise Group
ExciseTransactionType FK Excise Transaction Type
CompanyCode FK Company Code
ExciseSubTransType Sub Transaction Type
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
GLAcctReg23aAddlTx1 G/L account RG23A AT1 account SAKNR
GLAcctReg23cAddlTx1 G/L account RG23C AT1 account SAKNR
GLAcctPLAAddlTx1 G/L account for PLA AT1 (Personal Ledger Account) SAKNR
GLAcctReg23aAddlTx2 G/L account RG23A AT2 account SAKNR
GLAcctReg23cAddlTx2 G/L account for RG23C AT2 SAKNR
GLAcctPLAAddlTx2 G/L account for PLA AT2 (Personal Ledger Account) SAKNR
GLAcctReg23AAddlTx3 G/L account RG23A AT3 account SAKNR
GLAcctReg23cAddlTx3 G/L account for RG23C AT3 SAKNR
GLAcctPLAAddlTx3 G/L account for PLA AT3 (Personal Ledger Account) SAKNR
Master Data Relations | to Other Relations ↓ Join Conditions
Foreign Key for J_1IEXCACC-J_1IKTOPL
  • Chart of Accounts
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == T004.KTOPL
  • I_EXCISEACNTASGMNT.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • I_EXCISEACNTASGMNT.MANDT == T001.MANDT
  • I_EXCISEACNTASGMNT.COMPANYCODE == T001.BUKRS
Foreign Key for J_1IEXCACC-J_1IOFFSET
  • Chart of Accounts
  • G/L Account for CENVAT Offset
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTCENVATOFFSET == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
Foreign Key for J_1IEXCACC-J_1IONHOLD
  • Chart of Accounts
  • Client
  • G/L Account for CENVAT On Hold
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
  • I_EXCISEACNTASGMNT.GLACCTCENVATONHOLD == SKA1.SAKNR
Foreign Key for J_1IEXCACC-J_1IREVERS
  • Chart of Accounts
  • G/L Account for CENVAT Reversal
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTCENVATRVSL == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
Foreign Key for J_1IEXCACC-J_1IMSUSP
  • Chart of Accounts
  • G/L Account for CENVAT Suspense
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTCENVATSUSPENSE == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
Foreign Key for J_1IEXCACC-J_1ICLEAR
  • Chart of Accounts
  • G/L account for Modvat Clearing
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTMODVATCLRG == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
G/L account for PLA AED (Personal Ledger Account)
  • Chart of Accounts
  • G/L account for PLA AED (Personal Ledger Account)
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTPLAAED == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
Foreign Key for J_1IEXCACC-J_1IPLA
  • Chart of Accounts
  • G/L account for PLA BED (Personal Ledger Account)
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTPLABED == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
G/L account for PLA CESS (Personal Ledger Account)
  • Chart of Accounts
  • G/L account for PLA CESS (Personal Ledger Account)
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTPLACESS == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
Foreign Key for J_1IEXCACC-J_1IPLAECS
  • Chart of Accounts
  • Client
  • G/L account for PLA ECS
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
  • I_EXCISEACNTASGMNT.GLACCTPLAECS == SKA1.SAKNR
G/L account for PLA NCCD
  • Chart of Accounts
  • Client
  • G/L account for PLA NCCD
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
  • I_EXCISEACNTASGMNT.GLACCTPLANCCD == SKA1.SAKNR
Foreign Key for J_1IEXCACC-J_1IPSUSP
  • Chart of Accounts
  • Client
  • G/L account for PLA On Hold
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
  • I_EXCISEACNTASGMNT.GLACCTPLAONHOLD == SKA1.SAKNR
G/L account for PLA SED (Personal Ledger Account)
  • Chart of Accounts
  • G/L account for PLA SED (Personal Ledger Account)
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTPLASED == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
Foreign Key for J_1IEXCACC-J_1IRG23AA
  • Chart of Accounts
  • G/L account RG23A AED account
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTREG23AAED == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
Foreign Key for J_1IEXCACC-J_1IRG23AB
  • Chart of Accounts
  • Client
  • G/L account RG23A BED account
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
  • I_EXCISEACNTASGMNT.GLACCTREG23ABED == SKA1.SAKNR
Foreign Key for J_1IEXCACC-J_1IRG23AE
  • Chart of Accounts
  • G/L account for RG23A ECS
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTREG23AECS == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
G/L account for RG23A NCCD
  • Chart of Accounts
  • G/L account for RG23A NCCD
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTREG23ANCCD == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
Foreign Key for J_1IEXCACC-J_1IRG23AS
  • Chart of Accounts
  • G/L account for RG23A SED
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTREG23ASED == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
Foreign Key for J_1IEXCACC-J_1IRG23CA
  • Chart of Accounts
  • Client
  • G/L account for RG23C AED
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
  • I_EXCISEACNTASGMNT.GLACCTREG23CAED == SKA1.SAKNR
Foreign Key for J_1IEXCACC-J_1IRG23AB
  • Chart of Accounts
  • G/L account for RG23C BED
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTREG23CBED == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
Foreign Key for J_1IEXCACC-J_1IRG23CE
  • Chart of Accounts
  • G/L account for RG23C ECS
  • Client
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.GLACCTREG23CECS == SKA1.SAKNR
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
G/L account for RG23C NCCD
  • Chart of Accounts
  • Client
  • G/L account for RG23C NCCD
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
  • I_EXCISEACNTASGMNT.GLACCTREG23CNCCD == SKA1.SAKNR
Foreign Key for J_1IEXCACC-J_1IRG23CS
  • Chart of Accounts
  • Client
  • G/L account for RG23C SED
  • I_EXCISEACNTASGMNT.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_EXCISEACNTASGMNT.MANDT == SKA1.MANDT
  • I_EXCISEACNTASGMNT.GLACCTREG23CSED == SKA1.SAKNR
Other Relations | to Master Data Relations ↑ Join Conditions
Excise Group
  • ?
  • Excise Group
  • Client
  • I_EXCISEACNTASGMNT.[column in domain "WERKS_D"] == J_1IEXGRPS.J_1IWERKS
  • I_EXCISEACNTASGMNT.EXCISEGROUP == J_1IEXGRPS.J_1IEXCGRP
  • I_EXCISEACNTASGMNT.MANDT == J_1IEXGRPS.MANDT
Excise Transaction Type
  • Excise Transaction Type
  • Client
  • I_EXCISEACNTASGMNT.EXCISETRANSACTIONTYPE == J_1ITRAN.J_1ITRNTYP
  • I_EXCISEACNTASGMNT.MANDT == J_1ITRAN.MANDT