I_MPJournalEntryItemCube

Master Project Accounting Journal Entry Item Cube | view: IMPJRNLCUBE | TRAN | Extraction: Full only | Component: Commercial Project Management - Project Workspace
Tables used: ACDOCA, T003, T003T, T001, TKA02, TKA01, FINSC_LEDGER, FINSC_LEDGER_T, T000, FINSC_ACTVE_APPL, FINSC_LEDGER_REP
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in Object Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
FixedQuantity Fixed Quantity
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity Valuation Quantity
Column Name Description
DocumentDate Journal Entry Date
Column Name Description
GLRecordType Record Type Show values
AccountingDocumentCategory Journal Entry Category Show values
FinancialAccountType Account Type Show values
OrderCategory Order category Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
LedgerName Ledger Name TEXT30
CompanyCodeName Company Code Name TEXT25
ControllingAreaName Controlling Area Name TEXT25
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Item NUMC6
ReferenceDocumentItemGroup Reference Document Item Group NUMC6
FiscalPeriod Fiscal Period POPER
PostingDate null
AccountingDocumentTypeName Document Type Name TEXT20
AccountingDocumentItem Journal Entry Posting View Item BUZEI
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
SalesOrderItem Sales Order Item POSNR
PersonnelNumber Personnel Number PERNR
AccountAssignment Account Assignment ACCAS
WBSElement WBS Element FIS_WBS
WorkPackage Plan Item /CPD/PLAN_ITEM_ID
Project Project FIS_PROJECT
RelatedNetworkActivity Network activity VORNR
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_MPJOURNALENTRYITEMCUBE.MANDT == T003.MANDT
  • I_MPJOURNALENTRYITEMCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_MPJOURNALENTRYITEMCUBE.BASEUNIT == T006.MSEHI
  • I_MPJOURNALENTRYITEMCUBE.MANDT == T006.MANDT
Billing Type
  • Billing Type
  • Client
  • I_MPJOURNALENTRYITEMCUBE.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_MPJOURNALENTRYITEMCUBE.MANDT == TVFK.MANDT
Business Area
  • Business Area
  • Client
  • I_MPJOURNALENTRYITEMCUBE.BUSINESSAREA == TGSB.GSBER
  • I_MPJOURNALENTRYITEMCUBE.MANDT == TGSB.MANDT
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_MPJOURNALENTRYITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_MPJOURNALENTRYITEMCUBE.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • I_MPJOURNALENTRYITEMCUBE.MANDT == T001.MANDT
  • I_MPJOURNALENTRYITEMCUBE.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • I_MPJOURNALENTRYITEMCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_MPJOURNALENTRYITEMCUBE.MANDT == TKA01.MANDT
CO Object Currency
  • Client
  • CO Object Currency
  • I_MPJOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
  • I_MPJOURNALENTRYITEMCUBE.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Cost Center
  • Cost Center
  • Controlling Area
  • Client
  • ?
  • I_MPJOURNALENTRYITEMCUBE.COSTCENTER == CSKS.KOSTL
  • I_MPJOURNALENTRYITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_MPJOURNALENTRYITEMCUBE.MANDT == CSKS.MANDT
  • I_MPJOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
Activity Type
  • Controlling Area
  • Client
  • Activity Type
  • ?
  • I_MPJOURNALENTRYITEMCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_MPJOURNALENTRYITEMCUBE.MANDT == CSLA.MANDT
  • I_MPJOURNALENTRYITEMCUBE.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_MPJOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CSLA.DATBI
Cost Source Unit
  • Cost Source Unit
  • Client
  • I_MPJOURNALENTRYITEMCUBE.COSTSOURCEUNIT == T006.MSEHI
  • I_MPJOURNALENTRYITEMCUBE.MANDT == T006.MANDT
Customer Number
  • Customer Number
  • Client
  • I_MPJOURNALENTRYITEMCUBE.CUSTOMER == KNA1.KUNNR
  • I_MPJOURNALENTRYITEMCUBE.MANDT == KNA1.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_MPJOURNALENTRYITEMCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_MPJOURNALENTRYITEMCUBE.MANDT == TVTW.MANDT
G/L Account
  • G/L Account
  • Client
  • Company Code
  • I_MPJOURNALENTRYITEMCUBE.GLACCOUNT == SKB1.SAKNR
  • I_MPJOURNALENTRYITEMCUBE.MANDT == SKB1.MANDT
  • I_MPJOURNALENTRYITEMCUBE.COMPANYCODE == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Material Number
  • Client
  • Material Number
  • I_MPJOURNALENTRYITEMCUBE.MANDT == MARA.MANDT
  • I_MPJOURNALENTRYITEMCUBE.MATERIAL == MARA.MATNR
Order ID
  • Client
  • Order ID
  • I_MPJOURNALENTRYITEMCUBE.MANDT == AUFK.MANDT
  • I_MPJOURNALENTRYITEMCUBE.ORDERID == AUFK.AUFNR
Division
  • Client
  • Division
  • I_MPJOURNALENTRYITEMCUBE.MANDT == TSPA.MANDT
  • I_MPJOURNALENTRYITEMCUBE.ORGANIZATIONDIVISION == TSPA.SPART
Partner Cost Center
  • Controlling Area
  • Client
  • ?
  • Partner Cost Center
  • I_MPJOURNALENTRYITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_MPJOURNALENTRYITEMCUBE.MANDT == CSKS.MANDT
  • I_MPJOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_MPJOURNALENTRYITEMCUBE.PARTNERCOSTCENTER == CSKS.KOSTL
Plant
  • Client
  • Plant
  • I_MPJOURNALENTRYITEMCUBE.MANDT == T001W.MANDT
  • I_MPJOURNALENTRYITEMCUBE.PLANT == T001W.WERKS
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • I_MPJOURNALENTRYITEMCUBE.MANDT == AUFK.MANDT
  • I_MPJOURNALENTRYITEMCUBE.PROJECTNETWORK == AUFK.AUFNR
Reference Document Type I_MPJOURNALENTRYITEMCUBE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales Organization
  • Client
  • Sales Organization
  • I_MPJOURNALENTRYITEMCUBE.MANDT == TVKO.MANDT
  • I_MPJOURNALENTRYITEMCUBE.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_MPJOURNALENTRYITEMCUBE.MANDT == FAGL_SEGM.MANDT
  • I_MPJOURNALENTRYITEMCUBE.SEGMENT == FAGL_SEGM.SEGMENT
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Supplier
  • Supplier
  • Client
  • I_MPJOURNALENTRYITEMCUBE.SUPPLIER == LFA1.LIFNR
  • I_MPJOURNALENTRYITEMCUBE.MANDT == LFA1.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • I_MPJOURNALENTRYITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_MPJOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT