C_AccrEngineAccrItemDEX

Data Extraction for Accrual Item | view: CACESOITEMDX | TRAN | Extraction: Full or Incremental | Component: Accrual Engine
Tables used: ACESOBJ_ITEM
Column Name Description
AccrualEngineAccrualObjectType FK Accrual Engine Application Component
AccrualObjectLogicalSystem Logical System of Accrual Object
CompanyCode Company Code
AccrualObject Identifier of the Accrual Object
AccrualSubobject Identifier of the Accrual Subobject
AccrualItemType Accrual Item Type
Ledger Ledger in General Ledger Accounting
AccrSubobjectItmValdtyEndDte To Date of Accrual Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
TotalAccrAmountInTransCrcy Total Accrual/Deferral Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
TotalAccrAmtInCompanyCodeCrcy Total Accrual/Deferral Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
TotalAccrAmountInGlobalCrcy Total Accrual/Deferral Amount in Global Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
TotalAccrAmountInFreeDfndCrcy1 Total Accrual/Deferral Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
TotalAccrAmountInFreeDfndCrcy2 Total Accrual/Deferral Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
TotalAccrAmountInFreeDfndCrcy3 Total Accrual/Deferral Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
TotalAccrAmountInFreeDfndCrcy4 Total Accrual/Deferral Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
TotalAccrAmountInFreeDfndCrcy5 Total Accrual/Deferral Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
TotalAccrAmountInFreeDfndCrcy6 Total Accrual/Deferral Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
TotalAccrAmountInFreeDfndCrcy7 Total Accrual/Deferral Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
TotalAccrAmountInFreeDfndCrcy8 Total Accrual/Deferral Amount in Freely Defined Currency 8
Column Name Description
📏 Unit of Measure for Accrual Items (TotalAccrualQuantityUnit):
TotalAccrualQuantity Total Quantity to Accrue
Column Name Description
AccrSubobjectItmValdtyEndDte To Date of Accrual Item
AccrSubobjectItmValdtyStrtDte From Date of an Entry
AccrSubobjHdrStartOfLifeDate Start of Life of an Accrual Subobject or Item
AccrSubobjHdrEndOfLifeDate End of Life of an Accrual Subobject or Item
Column Name Description
AccrualItemIsObsolete Accrual Item is Obsolete Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Accrual/Deferral Account for Closing Posting
  • Accrual/Deferral Account for Closing Posting
  • Client
  • ?
  • C_ACCRENGINEACCRITEMDEX.ACCRCLSGPOSTGACCRACCOUNT == SKA1.SAKNR
  • C_ACCRENGINEACCRITEMDEX.MANDT == SKA1.MANDT
  • C_ACCRENGINEACCRITEMDEX.[column in domain "KTOPL"] == SKA1.KTOPL
Document Type for Closing Posting
  • Document Type for Closing Posting
  • Client
  • C_ACCRENGINEACCRITEMDEX.ACCRCLSGPOSTGDOCUMENTTYPE == T003.BLART
  • C_ACCRENGINEACCRITEMDEX.MANDT == T003.MANDT
Offsetting Account for Closing Posting
  • Client
  • ?
  • Offsetting Account for Closing Posting
  • C_ACCRENGINEACCRITEMDEX.MANDT == SKA1.MANDT
  • C_ACCRENGINEACCRITEMDEX.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_ACCRENGINEACCRITEMDEX.ACCRCLSGPOSTGOFFSTGACCOUNT == SKA1.SAKNR
Accrual/Deferral Account for Opening Posting
  • Client
  • ?
  • Accrual/Deferral Account for Opening Posting
  • C_ACCRENGINEACCRITEMDEX.MANDT == SKA1.MANDT
  • C_ACCRENGINEACCRITEMDEX.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_ACCRENGINEACCRITEMDEX.ACCROPNGPOSTGACCRACCOUNT == SKA1.SAKNR
Document Type for Opening Posting
  • Client
  • Document Type for Opening Posting
  • C_ACCRENGINEACCRITEMDEX.MANDT == T003.MANDT
  • C_ACCRENGINEACCRITEMDEX.ACCROPNGPOSTGDOCUMENTTYPE == T003.BLART
Offsetting Account for Opening Posting
  • Offsetting Account for Opening Posting
  • Client
  • ?
  • C_ACCRENGINEACCRITEMDEX.ACCROPNGPOSTGOFFSTGACCOUNT == SKA1.SAKNR
  • C_ACCRENGINEACCRITEMDEX.MANDT == SKA1.MANDT
  • C_ACCRENGINEACCRITEMDEX.[column in domain "KTOPL"] == SKA1.KTOPL
Accrual/Deferral Account for Periodic Posting
  • Client
  • Accrual/Deferral Account for Periodic Posting
  • ?
  • C_ACCRENGINEACCRITEMDEX.MANDT == SKA1.MANDT
  • C_ACCRENGINEACCRITEMDEX.ACCRPERDCPOSTGACCRACCOUNT == SKA1.SAKNR
  • C_ACCRENGINEACCRITEMDEX.[column in domain "KTOPL"] == SKA1.KTOPL
Document Type for Periodic Accrual Posting
  • Client
  • Document Type for Periodic Accrual Posting
  • C_ACCRENGINEACCRITEMDEX.MANDT == T003.MANDT
  • C_ACCRENGINEACCRITEMDEX.ACCRPERDCPOSTGDOCUMENTTYPE == T003.BLART
Offsetting Account for Periodic Posting
  • Client
  • ?
  • Offsetting Account for Periodic Posting
  • C_ACCRENGINEACCRITEMDEX.MANDT == SKA1.MANDT
  • C_ACCRENGINEACCRITEMDEX.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_ACCRENGINEACCRITEMDEX.ACCRPERDCPOSTGOFFSTGACCT == SKA1.SAKNR
Accrual Engine Application Component
  • Accrual Engine Application Component
  • Client
  • C_ACCRENGINEACCRITEMDEX.ACCRUALENGINEACCRUALOBJECTTYPE == TACECOMP.COMP
  • C_ACCRENGINEACCRITEMDEX.MANDT == TACECOMP.MANDT
Accrual/Deferral Method
  • Client
  • ?
  • Accrual/Deferral Method
Company Code Currency
  • Client
  • Company Code Currency
  • C_ACCRENGINEACCRITEMDEX.MANDT == TCURC.MANDT
  • C_ACCRENGINEACCRITEMDEX.COMPANYCODECURRENCY == TCURC.WAERS
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • C_ACCRENGINEACCRITEMDEX.MANDT == TCURC.MANDT
  • C_ACCRENGINEACCRITEMDEX.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • C_ACCRENGINEACCRITEMDEX.MANDT == TCURC.MANDT
  • C_ACCRENGINEACCRITEMDEX.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • C_ACCRENGINEACCRITEMDEX.MANDT == TCURC.MANDT
  • C_ACCRENGINEACCRITEMDEX.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • C_ACCRENGINEACCRITEMDEX.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • C_ACCRENGINEACCRITEMDEX.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • C_ACCRENGINEACCRITEMDEX.MANDT == TCURC.MANDT
  • C_ACCRENGINEACCRITEMDEX.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • C_ACCRENGINEACCRITEMDEX.MANDT == TCURC.MANDT
  • C_ACCRENGINEACCRITEMDEX.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • C_ACCRENGINEACCRITEMDEX.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • C_ACCRENGINEACCRITEMDEX.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • C_ACCRENGINEACCRITEMDEX.MANDT == TCURC.MANDT
  • C_ACCRENGINEACCRITEMDEX.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Global Currency
  • Client
  • Global Currency
  • C_ACCRENGINEACCRITEMDEX.MANDT == TCURC.MANDT
  • C_ACCRENGINEACCRITEMDEX.GLOBALCURRENCY == TCURC.WAERS
Unit of Measure for Accrual Items
  • Unit of Measure for Accrual Items
  • Client
  • C_ACCRENGINEACCRITEMDEX.TOTALACCRUALQUANTITYUNIT == T006.MSEHI
  • C_ACCRENGINEACCRITEMDEX.MANDT == T006.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • C_ACCRENGINEACCRITEMDEX.MANDT == TCURC.MANDT
  • C_ACCRENGINEACCRITEMDEX.TRANSACTIONCURRENCY == TCURC.WAERS