P_EnterpriseProjectCmtmtCosts

Project Cost Line Items with Commitment Costs | view: PENTPRJCMTMT | Extraction: Not supported | Component: VDM views for Costs
Tables used: ACDOCA, FINSC_AVC_PROF, TKA01, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, T000, FINSC_SEM_TAG, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_LEDGER_REP
Column Name Description
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
ActualPlanJournalEntryItem Actual Plan Journal Entry Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
CmtmtCostInTransacCrcy Actual Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
CmtmtCostInCCCrcy Actual Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
CmtmtCostInGlobalCurrency Actual Amount in Global Currency
ActlCmtmtCumltvAmtInGlobCrcy Amount in Global Currency
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in Object Currency
CmtmtCostInProjCrcy Actual Amount in Object Currency
AssgdValForBudgetInProjCrcy Amount in Object Currency
Column Name Description
Column Name Description
PostingDate Posting Date
CreationDate Creation Date
PlannedStartDate Project planned start date
PlannedEndDate Project planned finish date
Column Name Description
ActualPlanCode Actual Plan Code Show values
IsCommitment Indicator: Is Commitment Show values
ControllingDebitCreditCode Controlling Debit Credit Code Show values
PartnerOrderCategory Partner Order Category Show values
DebitCreditCode Debit/Credit Code Show values
AvailabilityControlIsActive Availability control indicator(AVC) Show values
AvailyCtrlTimeRangeType Budget Availability Control: Time Range Show values
BudgetCurrencyRole Budget Availability Control: Budget Currency Type Show values
ProcessingStatus Object Processing Status Show values
Column Name Description Domain name
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
FinancialPlanningEntryItem Financial Planning Entry Item RSNUMRECORD
LedgerFiscalYear Ledger Fiscal Year GJAHR
Project Project Number (External) Edited PS_PSPID_EDIT
WBSElement WBS Element FIS_WBS_NO_CONV
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerProject Partner Project FIS_PROJECT_NO_CONV
PartnerWBSElement Partner WBS Element FIS_WBS_NO_CONV
PartnerWBSElementInternalID Partner WBS Element Internal ID FIS_WBSINT_NO_CONV
OrderOperation Operation/Activity Number VORNR
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
PlanningCategory Plan Category FCOM_CATEGORY
IsSettled null
SemanticTag Semantic Tag of a Hierarchy Node FINS_SEM_TAG
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
PlanningCategory1 Plan Category FCOM_CATEGORY
PlanningCategory2 Plan Category FCOM_CATEGORY
WBSDescription WBS Element Name TEXT40
ProjectType Task Type DPR_TSK_TYPE
ProjectDescription Project Name TEXT40
ProjectUUID Entity Guid /S4PPM/GUID
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
Master Data Relations Join Conditions
Availability profile for project
  • Budget Availability Control: Profile
  • Client
  • P_ENTERPRISEPROJECTCMTMTCOSTS.AVAILABILITYCONTROLPROFILE == FINSC_AVC_PROF.PROFILE
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == FINSC_AVC_PROF.MANDT
Business Area
  • Client
  • Business Area
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == TGSB.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.BUSINESSAREA == TGSB.GSBER
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == T004.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == T001.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == TCURC.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == TKA01.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.CONTROLLINGAREA == TKA01.KOKRS
CO Object Currency
  • Client
  • CO Object Currency
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == TCURC.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Cost Center
  • Client
  • ?
  • Controlling Area
  • Cost Center
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == CSKS.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.[column in domain "DATBI"] == CSKS.DATBI
  • P_ENTERPRISEPROJECTCMTMTCOSTS.CONTROLLINGAREA == CSKS.KOKRS
  • P_ENTERPRISEPROJECTCMTMTCOSTS.COSTCENTER == CSKS.KOSTL
Activity Type
  • Client
  • ?
  • Controlling Area
  • Activity Type
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == CSLA.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.[column in domain "DATBI"] == CSLA.DATBI
  • P_ENTERPRISEPROJECTCMTMTCOSTS.CONTROLLINGAREA == CSLA.KOKRS
  • P_ENTERPRISEPROJECTCMTMTCOSTS.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == T009.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.FISCALYEARVARIANT == T009.PERIV
Functional Area
  • Client
  • Functional Area
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == TFKB.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_ENTERPRISEPROJECTCMTMTCOSTS.GLACCOUNT == SKB1.SAKNR
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == SKB1.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == TCURC.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • P_ENTERPRISEPROJECTCMTMTCOSTS.LEDGER == FINSC_LEDGER.RLDNR
  • P_ENTERPRISEPROJECTCMTMTCOSTS.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == FINSC_LEDGER.MANDT
Order ID
  • Client
  • Order ID
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == AUFK.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.ORDERID == AUFK.AUFNR
Partner Cost Center Activity Type
  • Partner Cost Center Activity Type
  • Client
  • ?
  • Controlling Area
  • P_ENTERPRISEPROJECTCMTMTCOSTS.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == CSLA.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.[column in domain "DATBI"] == CSLA.DATBI
  • P_ENTERPRISEPROJECTCMTMTCOSTS.CONTROLLINGAREA == CSLA.KOKRS
Partner Functional Area
  • Client
  • Partner Functional Area
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == TFKB.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Order
  • Client
  • Partner Order
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == AUFK.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.PARTNERORDER == AUFK.AUFNR
Partner Project Internal ID
  • Client
  • Partner Project Internal ID
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == PROJ.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.PARTNERPROJECTINTERNALID == PROJ.PSPNR
Profit Center
  • Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • P_ENTERPRISEPROJECTCMTMTCOSTS.WBSELEMENTPROFITCENTER == CEPC.PRCTR
  • P_ENTERPRISEPROJECTCMTMTCOSTS.PROFITCENTER == CEPC.PRCTR
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == CEPC.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.[column in domain "DATBI"] == CEPC.DATBI
  • P_ENTERPRISEPROJECTCMTMTCOSTS.CONTROLLINGAREA == CEPC.KOKRS
Project Category
  • Client
  • Project Category
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == DPR_PRO_CATEG.CLIENT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.PROJECTCATEGORY == DPR_PRO_CATEG.PRO_CATEGORY
Project Internal ID
  • Client
  • Project Internal ID
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == PROJ.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.PROJECTINTERNALID == PROJ.PSPNR
Profile ID for project structure
  • Project Profile
  • Client
  • P_ENTERPRISEPROJECTCMTMTCOSTS.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == TCJ41.MANDT
Responsible cost center
  • ?
  • Responsible Cost Center
  • ?
  • Client
  • P_ENTERPRISEPROJECTCMTMTCOSTS.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_ENTERPRISEPROJECTCMTMTCOSTS.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • P_ENTERPRISEPROJECTCMTMTCOSTS.[column in domain "DATBI"] == CSKS.DATBI
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == CSKS.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == FINSC_LEDGER.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.LEDGER == FINSC_LEDGER.RLDNR
  • P_ENTERPRISEPROJECTCMTMTCOSTS.SOURCELEDGER == FINSC_LEDGER.RLDNR
Source Logical System P_ENTERPRISEPROJECTCMTMTCOSTS.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type P_ENTERPRISEPROJECTCMTMTCOSTS.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Client
  • Transaction Currency
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == TCURC.MANDT
  • P_ENTERPRISEPROJECTCMTMTCOSTS.TRANSACTIONCURRENCY == TCURC.WAERS
Profit Center
  • Profit Center
  • Profit Center
  • ?
  • ?
  • Client
  • P_ENTERPRISEPROJECTCMTMTCOSTS.WBSELEMENTPROFITCENTER == CEPC.PRCTR
  • P_ENTERPRISEPROJECTCMTMTCOSTS.PROFITCENTER == CEPC.PRCTR
  • P_ENTERPRISEPROJECTCMTMTCOSTS.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_ENTERPRISEPROJECTCMTMTCOSTS.[column in domain "DATBI"] == CEPC.DATBI
  • P_ENTERPRISEPROJECTCMTMTCOSTS.MANDT == CEPC.MANDT