I_ManagementAccountingCube

Management Accounting - Cube | view: IFIMGMTACCCUBE | TRAN | Extraction: Not supported | Component: Information System
Tables used: ACDOCA, FINSC_LEDGER_REP
Column Name Description
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy Fixed Amount in Global Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
DebitAmountInTransCrcy Debit Amount in Balance Transaction Currency
CreditAmountInTransCrcy Credit Amount in Balance Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in Object Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ClearingDate Clearing Date
AssetValueDate Asset Value Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
ReferencePurchaseOrderCategory Category of Reference Purchase Order Show values
FinancialAccountType Account Type Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
InventorySpecialStockValnType Inventory Special Stock Valuation Type 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
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
AccountAssignment Account Assignment ACCAS
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocument Reference document number AWREF
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
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
SalesOrderItem Sales Order Item POSNR
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
InventorySpecialStockType Inventory Special Stock Type SOBKZ
OffsettingAccount Offsetting Account GKONT
PersonnelNumber Personnel Number PERNR
WBSElement WBS Element FIS_WBS
Project Project FIS_PROJECT
PartnerWBSElement Partner WBS Element FIS_WBS
PartnerProject Partner Project FIS_PROJECT
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
AssetClass Asset Class ANLKL
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T003.MANDT
Additional Quantity 1 Unit
  • Additional Quantity 1 Unit
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.ADDITIONALQUANTITY1UNIT == T006.MSEHI
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T006.MANDT
Additional Quantity 2 Unit
  • Additional Quantity 2 Unit
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.ADDITIONALQUANTITY2UNIT == T006.MSEHI
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T006.MANDT
Additional Quantity 3 Unit
  • Additional Quantity 3 Unit
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.ADDITIONALQUANTITY3UNIT == T006.MSEHI
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T006.MANDT
Alternative G/L Account Number In Company Code
  • Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • I_MANAGEMENTACCOUNTINGCUBE.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == SKA1.MANDT
Transaction Type Category I_MANAGEMENTACCOUNTINGCUBE.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TABW.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.ASSETTRANSACTIONTYPE == TABW.BWASL
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TCURC.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.BASEUNIT == T006.MSEHI
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T006.MANDT
Billing Type
  • Billing Type
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TVFK.MANDT
Business Area
  • Business Area
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.BUSINESSAREA == TGSB.GSBER
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TGSB.MANDT
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T004.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T001.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TCURC.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TKA01.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.CONTROLLINGAREA == TKA01.KOKRS
CO Object Currency
  • CO Object Currency
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TCURC.MANDT
Cost Center
  • Cost Center
  • Client
  • ?
  • Controlling Area
  • I_MANAGEMENTACCOUNTINGCUBE.COSTCENTER == CSKS.KOSTL
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == CSKS.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_MANAGEMENTACCOUNTINGCUBE.CONTROLLINGAREA == CSKS.KOKRS
Activity Type
  • Client
  • ?
  • Controlling Area
  • Activity Type
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == CSLA.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.[column in domain "DATBI"] == CSLA.DATBI
  • I_MANAGEMENTACCOUNTINGCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_MANAGEMENTACCOUNTINGCUBE.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.CUSTOMER == KNA1.KUNNR
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T151.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.CUSTOMERGROUP == T151.KDGRP
Distribution Channel
  • Distribution Channel
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TVTW.MANDT
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T856.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.FISCALYEARVARIANT == T009.PERIV
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T009.MANDT
Asset Subnumber
  • Fixed Asset
  • ?
  • Client
  • Asset Subnumber
  • I_MANAGEMENTACCOUNTINGCUBE.MASTERFIXEDASSET == ANLA.ANLN1
  • I_MANAGEMENTACCOUNTINGCUBE.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == ANLA.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.FIXEDASSET == ANLA.ANLN2
Functional Area
  • Client
  • Functional Area
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TFKB.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == SKB1.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.GLACCOUNT == SKB1.SAKNR
  • I_MANAGEMENTACCOUNTINGCUBE.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Global Currency
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.GLOBALCURRENCY == TCURC.WAERS
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TCURC.MANDT
House Bank Key
  • ?
  • Client
  • House Bank Key
  • I_MANAGEMENTACCOUNTINGCUBE.[column in domain "BUKRS"] == T012.BUKRS
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T012.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.HOUSEBANK == T012.HBKID
House Bank Account
  • ?
  • House Bank Account
  • Client
  • House Bank Key
  • I_MANAGEMENTACCOUNTINGCUBE.[column in domain "BUKRS"] == T012K.BUKRS
  • I_MANAGEMENTACCOUNTINGCUBE.HOUSEBANKACCOUNT == T012K.HKTID
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T012K.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.HOUSEBANK == T012K.HBKID
Inventory Valuation Type
  • Inventory Valuation Type
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T149D.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Logical System I_MANAGEMENTACCOUNTINGCUBE.LOGICALSYSTEM == TBDLS.LOGSYS
Material Number
  • Client
  • Material Number
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == MARA.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.MATERIAL == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.MATERIALGROUP == T023.MATKL
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T023.MANDT
Operating concern
  • Client
  • Operating concern
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TKEB.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.OPERATINGCONCERN == TKEB.ERKRS
Order ID
  • Order ID
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.ORDERID == AUFK.AUFNR
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == AUFK.MANDT
Division
  • Client
  • Division
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TSPA.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.ORGANIZATIONDIVISION == TSPA.SPART
Origin Cost Center
  • Origin Cost Center
  • Client
  • ?
  • Controlling Area
  • I_MANAGEMENTACCOUNTINGCUBE.ORIGINCOSTCENTER == CSKS.KOSTL
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == CSKS.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_MANAGEMENTACCOUNTINGCUBE.CONTROLLINGAREA == CSKS.KOKRS
Origin Cost Center Activity Type
  • Client
  • ?
  • Controlling Area
  • Origin Cost Center Activity Type
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == CSLA.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.[column in domain "DATBI"] == CSLA.DATBI
  • I_MANAGEMENTACCOUNTINGCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_MANAGEMENTACCOUNTINGCUBE.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
Partner Business Area
  • Client
  • Partner Business Area
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TGSB.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T880.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.PARTNERCOMPANY == T880.RCOMP
Partner Company Code
  • Partner Company Code
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.PARTNERCOMPANYCODE == T001.BUKRS
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T001.MANDT
Partner Cost Center
  • Client
  • Partner Cost Center
  • ?
  • Controlling Area
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == CSKS.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.PARTNERCOSTCENTER == CSKS.KOSTL
  • I_MANAGEMENTACCOUNTINGCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_MANAGEMENTACCOUNTINGCUBE.CONTROLLINGAREA == CSKS.KOKRS
Partner Cost Center Activity Type
  • Partner Cost Center Activity Type
  • Client
  • ?
  • Controlling Area
  • I_MANAGEMENTACCOUNTINGCUBE.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == CSLA.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.[column in domain "DATBI"] == CSLA.DATBI
  • I_MANAGEMENTACCOUNTINGCUBE.CONTROLLINGAREA == CSLA.KOKRS
Partner Functional Area
  • Client
  • Partner Functional Area
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TFKB.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Order
  • Partner Order
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.PARTNERORDER == AUFK.AUFNR
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == AUFK.MANDT
Partner Profit Center
  • Client
  • ?
  • Controlling Area
  • Partner Profit Center
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == CEPC.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_MANAGEMENTACCOUNTINGCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_MANAGEMENTACCOUNTINGCUBE.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == FAGL_SEGM.MANDT
Plant
  • Plant
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.PLANT == T001W.WERKS
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T001W.MANDT
Posting Key
  • Client
  • Posting Key
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TBSL.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.POSTINGKEY == TBSL.BSCHL
Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • I_MANAGEMENTACCOUNTINGCUBE.PROFITCENTER == CEPC.PRCTR
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == CEPC.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_MANAGEMENTACCOUNTINGCUBE.CONTROLLINGAREA == CEPC.KOKRS
Reference Document Type I_MANAGEMENTACCOUNTINGCUBE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales Organization
  • Client
  • Sales Organization
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TVKO.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == FAGL_SEGM.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.SEGMENT == FAGL_SEGM.SEGMENT
Service Document ID
  • Client
  • Service Document ID
  • ?
  • Service Document Type
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_MANAGEMENTACCOUNTINGCUBE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_MANAGEMENTACCOUNTINGCUBE.[column in domain "FCO_SRVDOC_ITEM_ID"] == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_MANAGEMENTACCOUNTINGCUBE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Type
  • Client
  • Service Document Type
Supplier
  • Supplier
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.SUPPLIER == LFA1.LIFNR
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == LFA1.MANDT
Tax on Sales/Purchases Code
  • ?
  • Tax on Sales/Purchases Code
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.[column in domain "KALSM_D"] == T007A.KALSM
  • I_MANAGEMENTACCOUNTINGCUBE.TAXCODE == T007A.MWSKZ
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T007A.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == TCURC.MANDT
Valuation area
  • Valuation area
  • Client
  • I_MANAGEMENTACCOUNTINGCUBE.VALUATIONAREA == T001K.BWKEY
  • I_MANAGEMENTACCOUNTINGCUBE.MANDT == T001K.MANDT