I_PubSecCmtmtActlItemCube

Commitment and Actual Items - Cube | view: IPSMS4CCOMACTANC | TRAN | Extraction: Not supported | Component: Information system
Tables used: SCAL_TT_DATE, ACDOCA, T004, T001, TKA02, FMFINCODE, SKA1, SKB1, PROJ, PSM_D_BDGTCNSTY, T001, PRPS, PSM_D_GLACCTX, FINSC_LEDGER_REP
Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
PubSecExpnCmtmtAmtInTransCrcy Commitment Expense Amount in Transaction Currency
PubSecExpnActlAmtInTransCrcy Actual Expense Amount in Transaction Currency
PubSecRevnCmtmtAmtInTransCrcy Commitment Revenue Amount in Transaction Currency
PubSecRevnActlAmtInTransCrcy Actual Revenue Amount in Transaction Currency
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
PubSecExpnCmtmtAmtInCoCodeCrcy Commitment Expense Amount in Company Code Currency
PubSecExpnActlAmtInCoCodeCrcy Actual Expense Amount in Company Code Currency
PubSecRevnCmtmtAmtInCoCodeCrcy Commitment Revenue Amount in Company Code Currency
PubSecRevnActlAmtInCoCodeCrcy Actual Revenue Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
PubSecExpnCmtmtAmtInGlobalCrcy Commitment Expense Amount in Global Currency
PubSecExpnActlAmtInGlobalCrcy Actual Expense Amount in Global Currency
PubSecRevnCmtmtAmtInGlobalCrcy Commitment Revenue Amount in Global Currency
PubSecRevnActlAmtInGlobalCrcy Actual Revenue Amount in Global Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
CreationDate Creation Date
ServicesRenderedDate Date on which services are rendered
ClearingDate Clearing Date
AssetValueDate Asset Value Date
PubSecBudgetCnsmpnDate Budget Consumption Date
Column Name Description
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
IsSettlement Indicator: Item is Settling or Transferring Another Item Show values
IsSettled Indicator: Line Item is Settled or Transferred Show values
IsCommitment Indicator: Is Commitment Show values
JrnlEntryItemObsoleteReason Journal Entry Item Obsolete Reason Show values
DebitCreditCode Debit/Credit Code Show values
AccountingDocumentCategory Journal Entry Category Show values
OriginObjectType Type of Origin Object Show values
GLAccountType Type of a General Ledger Account Show values
ReferencePurchaseOrderCategory Category of Reference Purchase Order Show values
FinancialAccountType Account Type Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
IsBalanceSheetAccount Indicator: Account is a balance sheet account? Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
InventorySpecialStockValnType Inventory Special Stock Valuation Type Show values
ControllingDebitCreditCode Controlling Debit Credit Code Show values
ControllingObjectDebitType Controlling Object Debit Type Show values
QuantityIsIncomplete Indicator: Quantity Is Incomplete Show values
OffsettingAccountType Offsetting Account Type Show values
LineItemIsCompleted Indicator: Line Item is Completed Show values
ControllingObjectClass Object Class Show values
PartnerControllingObjectClass Partner object class Show values
OrderCategory Order category Show values
PartnerOrderCategory Partner Order Category Show values
PubSecBudgetCnsmpnAmtType Budget Consumption Amount Type Show values
PubSecBudgetIsRelevant Budget-Relevant Indicator Show values
PubSecBdgtAcctRevnExpnCode Expense or Revenue on Budget Account Show values
IsStatisticalOrder Indicator: Internal Order is Statistical Account Assignment Show values
IsStatisticalCostCenter Indicator: Cost Center is Statistical Account Assignment Show values
IsStatisticalSalesDocument Sales Document is statistical Show values
WBSIsStatisticalWBSElement Indicator: WBS Element is Statistical Account Assignment Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Item NUMC6
ReferenceDocumentItemGroup Reference Document Item Group NUMC6
ReversalReferenceDocumentCntxt Reversal Reference Document Context AWORG
ReversalReferenceDocument Reversal Reference Document AWREF
PredecessorReferenceDocCntxt Predecessor Reference Document Context AWORG
PredecessorReferenceDocument Predecessor Reference Document AWREF
PredecessorReferenceDocItem Predecessor Reference Document Item NUMC6
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
AccountingDocumentItem Journal Entry Posting View Item BUZEI
AssignmentReference Assignment Reference ZUONR
TransactionTypeDetermination Transaction Key CHAR3
LastChangeDateTime Time Stamp of Last Change TZNTSTMPS
CreationDateTime Time Stamp of Creation TZNTSTMPS
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
FollowOnDocumentType Follow-On Document Type REBZT
InvoiceItemReference Invoice Item Reference BUZEI
AccountAssignmentNumber Account Assignment Number NUM02
DocumentItemText Item Text TEXT50
SalesDocumentItem Sales Document Item POSNR
ConditionContract Condition Contract WCB_COCO_NUM
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
CostEstimate Cost Estimate CK_KALNR
InventorySpecialStockType Inventory Special Stock Type SOBKZ
InventorySpclStkSalesDocument Inventory Special Stock Sales Document VBELN
InventorySpclStkSalesDocItm Inventory Special Stock Sales Document Item POSNR
InventorySpecialStockSupplier Supplier of Inventory Special Stock LIFNR
SenderGLAccount Sender G/L Account CHAR10
SenderAccountAssignment Sender Account Assignment ACCAS
OffsettingAccount Offsetting Account GKONT
OffsettingChartOfAccounts Offsetting Chart of Accounts KTOPL
PersonnelNumber Personnel Number PERNR
AccountAssignment Account Assignment ACCAS
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
PartnerWBSElementInternalID Partner WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerWBSElementExternalID Partner WBS Element External ID FIS_WBSEXT_NO_CONV
ProjectExternalID Project External ID FIS_PROJECTEXT_NO_CONV
PartnerProjectExternalID Partner Project External ID FIS_PROJECTEXT_NO_CONV
WorkPackage Plan Item /CPD/PLAN_ITEM_ID
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
PartnerServiceDocumentItem Partner Service Document Item
PartnerAccountAssignment Partner Account Assignment ACCAS
CustomerSupplierCorporateGroup Customer Supplier Corporate Group KONZS
GrantID Grant GM_GRANT_NBR
PartnerGrant Partner Grant GM_GRANT_NBR
PubSecBudgetCnsmpnFsclPeriod CC Fiscal Period for Budget Consumption Date POPER
PubSecBudgetCnsmpnFsclYear CC Fiscal Year for Budget Consumption Date GJAHR
SponsoredClass Sponsored Class GM_SPONSORED_CLASS
SponsoredProgram Sponsored Program GM_SPONSORED_PROG
GteeMBudgetValidityNumber Budget Validity Number GM_BDGT_VLDTY_NBR
PurchaseOrder Purchase Order Number EBELN
PurchaseRequisition Purchase requisition number BANFN
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarYearQuarter Year Quarter NUM5
CalendarMonth Calendar Month NUM2
CalendarYearMonth Year Month NUM6
CalendarWeek Calendar Week NUM2
CalendarYearWeek Year Week NUM6
GLAccountAuthorizationGroup Authorization Group BRGRU
SupplierBasicAuthorizationGrp Authorization Group BRGRU
CustomerBasicAuthorizationGrp Authorization Group BRGRU
AcctgDocTypeAuthorizationGroup Authorization Group BRGRU
OrderType Order Type AUFART
SalesOrderType Sales Document Type AUART
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T003.MANDT
Alternative G/L Account Number In Company Code
  • Client
  • Alternative Chart of Accounts for Country/Region
  • Alternative G/L Account Number In Company Code
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == SKA1.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • I_PUBSECCMTMTACTLITEMCUBE.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Asset Class
  • Asset Class
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.ASSETCLASS == ANKA.ANLKL
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == ANKA.MANDT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TABW.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.ASSETTRANSACTIONTYPE == TABW.BWASL
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T006.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.BASEUNIT == T006.MSEHI
Billing Type
  • Billing Type
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TVFK.MANDT
Bill-to Party
  • Client
  • Bill-to Party
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == KNA1.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.BILLTOPARTY == KNA1.KUNNR
Budget Period
  • Fund
  • Financial Management Area
  • Budget Period
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.FUND == FMFUNDBPD.FINCODE
  • I_PUBSECCMTMTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_PUBSECCMTMTACTLITEMCUBE.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FMFUNDBPD.MANDT
Business Area
  • Client
  • Business Area
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TGSB.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.BUSINESSAREA == TGSB.GSBER
Business Process
  • Controlling Area
  • Business Process
  • Client
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == CBPR.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.BUSINESSPROCESS == CBPR.PRZNR
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CBPR.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CBPR.DATBI
Business Transaction Type
  • Client
  • Business Transaction Type
Cash Origin Account
  • Client
  • Cash Origin Account
  • Chart of Accounts
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == SKA1.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.CASHLEDGERACCOUNT == SKA1.SAKNR
  • I_PUBSECCMTMTACTLITEMCUBE.CHARTOFACCOUNTS == SKA1.KTOPL
Cash Origin Company Code
  • Client
  • Cash Origin Company Code
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T001.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.CASHLEDGERCOMPANYCODE == T001.BUKRS
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T004.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.COMPANYCODE == T001.BUKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TCURC.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TKA01.MANDT
Cost Analysis Resource
  • Controlling Area
  • Client
  • Cost Analysis Resource
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == CSKR.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CSKR.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.COSTANALYSISRESOURCE == CSKR.RESRC
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CSKR.DATBI
Cost Center
  • Controlling Area
  • Client
  • Cost Center
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CSKS.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.COSTCENTER == CSKS.KOSTL
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
Activity Type
  • Activity Type
  • Controlling Area
  • Client
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CSLA.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CSLA.DATBI
Cost Object
  • Cost Object
  • Client
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.COSTOBJECT == CKPH.KSTRG
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CKPH.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CKPH.DATBI
Origin Group as Subdivision of Cost Element
  • Controlling Area
  • Client
  • Origin Group as Subdivision of Cost Element
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == TKKH1.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TKKH1.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.COSTORIGINGROUP == TKKH1.HRKFT
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "HRKTYP"] == TKKH1.KOATY
Cost Source Unit
  • Client
  • Cost Source Unit
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T006.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.COSTSOURCEUNIT == T006.MSEHI
Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative Chart of Accounts for Country/Region
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T004.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
Customer Number
  • Customer Number
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.CUSTOMER == KNA1.KUNNR
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T151.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T005.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T016.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TVTW.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Elimination Profit Center
  • Elimination Profit Center
  • Controlling Area
  • Client
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.ELIMINATIONPROFITCENTER == CEPC.PRCTR
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CEPC.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
Financial Management Area
  • Financial Management Area
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FM01.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T856.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.FISCALYEARVARIANT == T009.PERIV
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T009.MANDT
Asset Subnumber
  • ?
  • Client
  • Fixed Asset
  • Asset Subnumber
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == ANLA.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.MASTERFIXEDASSET == ANLA.ANLN1
  • I_PUBSECCMTMTACTLITEMCUBE.FIXEDASSET == ANLA.ANLN2
Functional Area
  • Functional Area
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.FUNCTIONALAREA == TFKB.FKBER
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TFKB.MANDT
Fund
  • Fund
  • Financial Management Area
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.FUND == FMFINCODE.FINCODE
  • I_PUBSECCMTMTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FMFINCODE.MANDT
Funded Program
  • Financial Management Area
  • Funded Program
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FMMEASURE.FMAREA
  • I_PUBSECCMTMTACTLITEMCUBE.FUNDEDPROGRAM == FMMEASURE.MEASURE
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FMMEASURE.CLIENT
Funds Management Center
  • Funds Management Center
  • Financial Management Area
  • Client
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.FUNDSCENTER == FMFCTR.FICTR
  • I_PUBSECCMTMTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FMFCTR.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
FM Fund Type
  • Client
  • Financial Management Area
  • FM Fund Type
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FMFUNDTYPE.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FMFUNDTYPE.FM_AREA
  • I_PUBSECCMTMTACTLITEMCUBE.FUNDTYPE == FMFUNDTYPE.FUND_TYPE
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.GLACCOUNT == SKB1.SAKNR
  • I_PUBSECCMTMTACTLITEMCUBE.COMPANYCODE == SKB1.BUKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TCURC.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.GLOBALCURRENCY == TCURC.WAERS
Group Asset Subnumber
  • ?
  • Group Asset Subnumber
  • Client
  • Group Asset
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_PUBSECCMTMTACTLITEMCUBE.GROUPFIXEDASSET == ANLA.ANLN2
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == ANLA.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.GROUPMASTERFIXEDASSET == ANLA.ANLN1
Inventory Valuation Type
  • Client
  • Inventory Valuation Type
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T149D.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.INVENTORYVALUATIONTYPE == T149D.BWTAR
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Logical System I_PUBSECCMTMTACTLITEMCUBE.LOGICALSYSTEM == TBDLS.LOGSYS
Operating concern
  • Client
  • Operating concern
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TKEB.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.OPERATINGCONCERN == TKEB.ERKRS
Order ID
  • Client
  • Order ID
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == AUFK.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.ORDERID == AUFK.AUFNR
Division
  • Client
  • Division
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TSPA.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.ORGANIZATIONDIVISION == TSPA.SPART
Origin Cost Center
  • Controlling Area
  • Client
  • Origin Cost Center
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CSKS.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.ORIGINCOSTCENTER == CSKS.KOSTL
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
Origin Cost Center Activity Type
  • Origin Cost Center Activity Type
  • Controlling Area
  • Client
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CSLA.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CSLA.DATBI
Origin Profit Center
  • Controlling Area
  • Client
  • Origin Profit Center
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CEPC.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.ORIGINPROFITCENTER == CEPC.PRCTR
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
FM: Partner Budget Period
  • Partner Fund
  • Financial Management Area
  • Client
  • FM: Partner Budget Period
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERFUND == FMFUNDBPD.FINCODE
  • I_PUBSECCMTMTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FMFUNDBPD.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERBUDGETPERIOD == FMFUNDBPD.BUDGET_PD
Partner Business Area
  • Client
  • Partner Business Area
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TGSB.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERBUSINESSAREA == TGSB.GSBER
Partner Business Process
  • Controlling Area
  • Client
  • ?
  • Partner Business Process
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == CBPR.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CBPR.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CBPR.DATBI
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERBUSINESSPROCESS == CBPR.PRZNR
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERCOMPANY == T880.RCOMP
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T880.MANDT
Partner Company Code
  • Client
  • Partner Company Code
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T001.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERCOMPANYCODE == T001.BUKRS
Partner Cost Center
  • Controlling Area
  • Client
  • Partner Cost Center
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CSKS.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERCOSTCENTER == CSKS.KOSTL
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
Partner Cost Center Activity Type
  • Partner Cost Center Activity Type
  • Controlling Area
  • Client
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CSLA.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CSLA.DATBI
Partner Cost Object
  • Partner Cost Object
  • Client
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERCOSTOBJECT == CKPH.KSTRG
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CKPH.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CKPH.DATBI
Partner Functional Area
  • Client
  • Partner Functional Area
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TFKB.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Fund
  • Partner Fund
  • Financial Management Area
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERFUND == FMFINCODE.FINCODE
  • I_PUBSECCMTMTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FMFINCODE.MANDT
Partner Order
  • Partner Order
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERORDER == AUFK.AUFNR
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == AUFK.MANDT
Partner Profit Center
  • Partner Profit Center
  • Controlling Area
  • Client
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERPROFITCENTER == CEPC.PRCTR
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CEPC.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
Partner Project Internal ID
  • Partner Project Internal ID
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERPROJECTINTERNALID == PROJ.PSPNR
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == PROJ.MANDT
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FAGL_SEGM.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Partner Service Document
  • Partner Service Document Item
  • Client
  • Partner Service Document
  • Partner Service Document Type
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERSERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERSERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERSERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Partner Service Document Type
  • Client
  • Partner Service Document Type
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CRMC_PROC_TYPE.CLIENT
  • I_PUBSECCMTMTACTLITEMCUBE.PARTNERSERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Plant
  • Client
  • Plant
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T001W.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.PLANT == T001W.WERKS
Posting Key
  • Client
  • Posting Key
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TBSL.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.POSTINGKEY == TBSL.BSCHL
Predecessor Reference Document Type I_PUBSECCMTMTACTLITEMCUBE.PREDECESSORREFERENCEDOCTYPE == TTYP.AWTYP
Product Number
  • Product Number
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.PRODUCT == MARA.MATNR
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == MARA.MANDT
Profit Center
  • Profit Center
  • Controlling Area
  • Client
  • ?
  • I_PUBSECCMTMTACTLITEMCUBE.PROFITCENTER == CEPC.PRCTR
  • I_PUBSECCMTMTACTLITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == CEPC.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
Project Internal ID
  • Client
  • Project Internal ID
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == PROJ.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.PROJECTINTERNALID == PROJ.PSPNR
Budget Account
  • Client
  • Budget Account
  • Chart of Accounts
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == SKA1.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.PUBSECBUDGETACCOUNT == SKA1.SAKNR
  • I_PUBSECCMTMTACTLITEMCUBE.CHARTOFACCOUNTS == SKA1.KTOPL
Budget Account Company Code
  • Budget Account Company Code
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.PUBSECBUDGETACCOUNTCOCODE == T001.BUKRS
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T001.MANDT
Budget Consumption Type
  • Budget Consumption Type
  • Client
Reference Document Type I_PUBSECCMTMTACTLITEMCUBE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales District
  • Sales District
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.SALESDISTRICT == T171.BZIRK
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T171.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TVKO.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.SEGMENT == FAGL_SEGM.SEGMENT
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FAGL_SEGM.MANDT
Service Contract ID
  • Client
  • Service Contract Item ID
  • Service Contract Type
  • Service Contract ID
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_PUBSECCMTMTACTLITEMCUBE.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_PUBSECCMTMTACTLITEMCUBE.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
Service Contract Item ID
  • Client
  • Service Contract Item ID
  • Service Contract Type
  • Service Contract ID
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_PUBSECCMTMTACTLITEMCUBE.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_PUBSECCMTMTACTLITEMCUBE.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
Service Contract Type
  • Client
  • Service Contract Type
Service Document ID
  • Client
  • Service Document ID
  • Service Document Item ID
  • Service Document Type
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_PUBSECCMTMTACTLITEMCUBE.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_PUBSECCMTMTACTLITEMCUBE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Item ID
  • Client
  • Service Document ID
  • Service Document Item ID
  • Service Document Type
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_PUBSECCMTMTACTLITEMCUBE.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_PUBSECCMTMTACTLITEMCUBE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Type
  • Client
  • Service Document Type
Ship-to Party
  • Ship-to Party
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.SHIPTOPARTY == KNA1.KUNNR
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • I_PUBSECCMTMTACTLITEMCUBE.SOLDPRODUCT == MARA.MATNR
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == MARA.MANDT
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Source Logical System I_PUBSECCMTMTACTLITEMCUBE.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type I_PUBSECCMTMTACTLITEMCUBE.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Special G/L Indicator
  • Client
  • Special G/L Indicator
  • Account Type
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T074U.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.SPECIALGLCODE == T074U.UMSKZ
  • I_PUBSECCMTMTACTLITEMCUBE.FINANCIALACCOUNTTYPE == T074U.KOART
Subledger-Specific Line Item Type I_PUBSECCMTMTACTLITEMCUBE.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Supplier
  • Client
  • Supplier
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == LFA1.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.SUPPLIER == LFA1.LIFNR
Tax on Sales/Purchases Code
  • Client
  • ?
  • Tax on Sales/Purchases Code
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T007A.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.[column in domain "KALSM_D"] == T007A.KALSM
  • I_PUBSECCMTMTACTLITEMCUBE.TAXCODE == T007A.MWSKZ
Transaction Currency
  • Client
  • Transaction Currency
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == TCURC.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation area
  • Client
  • Valuation area
  • I_PUBSECCMTMTACTLITEMCUBE.MANDT == T001K.MANDT
  • I_PUBSECCMTMTACTLITEMCUBE.VALUATIONAREA == T001K.BWKEY