C_MstrProjJournalQ001

Master Project Journal Query | view: CMPJRNLQ001 | Extraction: Not supported | 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
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
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
ValuationQuantity Valuation Quantity
Column Name Description
DocumentDate Journal Entry Date
Column Name Description
FinancialAccountType Account Type Show values
OrderCategory Order category Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
WBSElement WBS Element FIS_WBS
RelatedNetworkActivity Network activity VORNR
ReferenceDocument Reference document number AWREF
PostingDate null
ReferenceDocumentItem Reference Document Item NUMC6
DocumentItemText Item Text TEXT50
PersonnelNumber Personnel Number PERNR
AccountAssignment Account Assignment ACCAS
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_MSTRPROJJOURNALQ001.MANDT == T006.MANDT
  • C_MSTRPROJJOURNALQ001.BASEUNIT == T006.MSEHI
Billing Type
  • Billing Type
  • Client
  • C_MSTRPROJJOURNALQ001.BILLINGDOCUMENTTYPE == TVFK.FKART
  • C_MSTRPROJJOURNALQ001.MANDT == TVFK.MANDT
Business Area
  • Business Area
  • Client
  • C_MSTRPROJJOURNALQ001.BUSINESSAREA == TGSB.GSBER
  • C_MSTRPROJJOURNALQ001.MANDT == TGSB.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Company Code
  • Company Code
  • Client
  • C_MSTRPROJJOURNALQ001.COMPANYCODE == T001.BUKRS
  • C_MSTRPROJJOURNALQ001.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_MSTRPROJJOURNALQ001.CONTROLLINGAREA == TKA01.KOKRS
  • C_MSTRPROJJOURNALQ001.MANDT == TKA01.MANDT
CO Object Currency
  • Client
  • CO Object Currency
  • C_MSTRPROJJOURNALQ001.MANDT == TCURC.MANDT
  • C_MSTRPROJJOURNALQ001.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Cost Center
  • Controlling Area
  • Cost Center
  • ?
  • Client
  • C_MSTRPROJJOURNALQ001.CONTROLLINGAREA == CSKS.KOKRS
  • C_MSTRPROJJOURNALQ001.COSTCENTER == CSKS.KOSTL
  • C_MSTRPROJJOURNALQ001.[column in domain "DATBI"] == CSKS.DATBI
  • C_MSTRPROJJOURNALQ001.MANDT == CSKS.MANDT
Activity Type
  • Controlling Area
  • Activity Type
  • ?
  • Client
  • C_MSTRPROJJOURNALQ001.CONTROLLINGAREA == CSLA.KOKRS
  • C_MSTRPROJJOURNALQ001.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • C_MSTRPROJJOURNALQ001.[column in domain "DATBI"] == CSLA.DATBI
  • C_MSTRPROJJOURNALQ001.MANDT == CSLA.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • C_MSTRPROJJOURNALQ001.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_MSTRPROJJOURNALQ001.MANDT == TVTW.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • C_MSTRPROJJOURNALQ001.COMPANYCODE == SKB1.BUKRS
  • C_MSTRPROJJOURNALQ001.GLACCOUNT == SKB1.SAKNR
  • C_MSTRPROJJOURNALQ001.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Material Number
  • Material Number
  • Client
  • C_MSTRPROJJOURNALQ001.MATERIAL == MARA.MATNR
  • C_MSTRPROJJOURNALQ001.MANDT == MARA.MANDT
Order ID
  • Order ID
  • Client
  • C_MSTRPROJJOURNALQ001.ORDERID == AUFK.AUFNR
  • C_MSTRPROJJOURNALQ001.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • C_MSTRPROJJOURNALQ001.ORGANIZATIONDIVISION == TSPA.SPART
  • C_MSTRPROJJOURNALQ001.MANDT == TSPA.MANDT
Partner Cost Center
  • Controlling Area
  • Partner Cost Center
  • ?
  • Client
  • C_MSTRPROJJOURNALQ001.CONTROLLINGAREA == CSKS.KOKRS
  • C_MSTRPROJJOURNALQ001.PARTNERCOSTCENTER == CSKS.KOSTL
  • C_MSTRPROJJOURNALQ001.[column in domain "DATBI"] == CSKS.DATBI
  • C_MSTRPROJJOURNALQ001.MANDT == CSKS.MANDT
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • C_MSTRPROJJOURNALQ001.PROJECTNETWORK == AUFK.AUFNR
  • C_MSTRPROJJOURNALQ001.MANDT == AUFK.MANDT
Sales Organization
  • Client
  • Sales Organization
  • C_MSTRPROJJOURNALQ001.MANDT == TVKO.MANDT
  • C_MSTRPROJJOURNALQ001.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_MSTRPROJJOURNALQ001.SEGMENT == FAGL_SEGM.SEGMENT
  • C_MSTRPROJJOURNALQ001.MANDT == FAGL_SEGM.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • C_MSTRPROJJOURNALQ001.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_MSTRPROJJOURNALQ001.MANDT == TCURC.MANDT