P_ProjCmtmtCostLineItms

Project Cost Line Items with Commitment Costs | view: PPRJBYCMTMTCST | Extraction: Not supported | Component: VDM views for Costs
Tables used: ACDOCA, FINSC_AVC_PROF, TKA01, 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
Column Name Description
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in Object Currency
CmtmtCostInProjCrcy Amount in Object Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
CmtmtCostInGlobalCurrency Amount in Global Currency
💲 Functional Currency (FunctionalCurrency):
CmtmtAmountInFunctionalCrcy Amount in Functional Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
CmtmtCostInFreeDefinedCrcy1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
CmtmtCostInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
CmtmtCostInFreeDefinedCrcy3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
CmtmtCostInFreeDefinedCrcy4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
CmtmtCostInFreeDefinedCrcy5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
CmtmtCostInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
CmtmtCostInFreeDefinedCrcy7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
CmtmtCostInFreeDefinedCrcy8 Amount in Freely Defined Currency 8
Column Name Description
Column Name Description
CreationDate Creation Date
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
ActualPlanCode Actual Plan Code Show values
PartnerOrderCategory Partner Order Category Show values
DebitCreditCode Debit/Credit Code Show values
ControllingDebitCreditCode Controlling Debit Credit Code Show values
IsCommitment Indicator: Is Commitment Show values
MaintenanceOrderIsSelected Boolean Variable (X = True, - = False, Space = Unknown) 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
Column Name Description Domain name
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number FIS_RSPM_TSN
FinancialPlanningDataPacket Financial Planning Data Packet Number NUM6
ActualPlanJournalEntryItem Actual Plan Journal Entry Item
LedgerFiscalYear Ledger Fiscal Year GJAHR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
FinancialPlanningEntryItem Financial Planning Entry Item RSNUMRECORD
PartnerWBSElement Partner WBS Element FIS_WBS_NO_CONV
PartnerProject Partner Project FIS_PROJECT_NO_CONV
WBSElement Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
Project Project Number (External) Edited PS_PSPID_EDIT
ProjectInternalID Project (internal) PS_S4_PROJ_PSPNR
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
IsSettled null
PlanningCategory Plan Category FCOM_CATEGORY
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
SemanticTag Semantic Tag of a Hierarchy Node FINS_SEM_TAG
WBSDescription WBS Element Name TEXT40
ProjectDescription Project Name TEXT40
Master Data Relations Join Conditions
Availability profile for project
  • Budget Availability Control: Profile
  • Client
Business Area
  • Business Area
  • Client
  • P_PROJCMTMTCOSTLINEITMS.BUSINESSAREA == TGSB.GSBER
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TGSB.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_PROJCMTMTCOSTLINEITMS.CHARTOFACCOUNTS == T004.KTOPL
  • P_PROJCMTMTCOSTLINEITMS.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_PROJCMTMTCOSTLINEITMS.COMPANYCODE == T001.BUKRS
  • P_PROJCMTMTCOSTLINEITMS.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_PROJCMTMTCOSTLINEITMS.COMPANYCODECURRENCY == TCURC.WAERS
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCURC.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TKA01.MANDT
  • P_PROJCMTMTCOSTLINEITMS.CONTROLLINGAREA == TKA01.KOKRS
CO Object Currency
  • CO Object Currency
  • Client
  • P_PROJCMTMTCOSTLINEITMS.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCURC.MANDT
Cost Center
  • Client
  • Cost Center
  • ?
  • Controlling Area
  • P_PROJCMTMTCOSTLINEITMS.MANDT == CSKS.MANDT
  • P_PROJCMTMTCOSTLINEITMS.COSTCENTER == CSKS.KOSTL
  • P_PROJCMTMTCOSTLINEITMS.[column in domain "DATBI"] == CSKS.DATBI
  • P_PROJCMTMTCOSTLINEITMS.CONTROLLINGAREA == CSKS.KOKRS
Activity Type
  • Client
  • ?
  • Controlling Area
  • Activity Type
  • P_PROJCMTMTCOSTLINEITMS.MANDT == CSLA.MANDT
  • P_PROJCMTMTCOSTLINEITMS.[column in domain "DATBI"] == CSLA.DATBI
  • P_PROJCMTMTCOSTLINEITMS.CONTROLLINGAREA == CSLA.KOKRS
  • P_PROJCMTMTCOSTLINEITMS.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • P_PROJCMTMTCOSTLINEITMS.MANDT == T009.MANDT
  • P_PROJCMTMTCOSTLINEITMS.FISCALYEARVARIANT == T009.PERIV
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCMTMTCOSTLINEITMS.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCMTMTCOSTLINEITMS.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCMTMTCOSTLINEITMS.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCMTMTCOSTLINEITMS.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCMTMTCOSTLINEITMS.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCMTMTCOSTLINEITMS.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCMTMTCOSTLINEITMS.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCMTMTCOSTLINEITMS.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TFKB.MANDT
  • P_PROJCMTMTCOSTLINEITMS.FUNCTIONALAREA == TFKB.FKBER
Functional Currency
  • Client
  • Functional Currency
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCMTMTCOSTLINEITMS.FUNCTIONALCURRENCY == TCURC.WAERS
G/L Account
  • Company Code
  • Client
  • G/L Account
  • P_PROJCMTMTCOSTLINEITMS.COMPANYCODE == SKB1.BUKRS
  • P_PROJCMTMTCOSTLINEITMS.MANDT == SKB1.MANDT
  • P_PROJCMTMTCOSTLINEITMS.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Global Currency
  • Client
  • P_PROJCMTMTCOSTLINEITMS.GLOBALCURRENCY == TCURC.WAERS
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Order ID
  • Client
  • Order ID
  • P_PROJCMTMTCOSTLINEITMS.MANDT == AUFK.MANDT
  • P_PROJCMTMTCOSTLINEITMS.ORDERID == AUFK.AUFNR
Partner Order
  • Client
  • Partner Order
  • P_PROJCMTMTCOSTLINEITMS.MANDT == AUFK.MANDT
  • P_PROJCMTMTCOSTLINEITMS.PARTNERORDER == AUFK.AUFNR
Profit Center
  • Client
  • ?
  • Controlling Area
  • Profit Center
  • Profit Center
  • P_PROJCMTMTCOSTLINEITMS.MANDT == CEPC.MANDT
  • P_PROJCMTMTCOSTLINEITMS.[column in domain "DATBI"] == CEPC.DATBI
  • P_PROJCMTMTCOSTLINEITMS.CONTROLLINGAREA == CEPC.KOKRS
  • P_PROJCMTMTCOSTLINEITMS.PROFITCENTER == CEPC.PRCTR
  • P_PROJCMTMTCOSTLINEITMS.WBSELEMENTPROFITCENTER == CEPC.PRCTR
Profile ID for project structure
  • Project Profile
  • Client
  • P_PROJCMTMTCOSTLINEITMS.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCJ41.MANDT
Responsible cost center
  • ?
  • ?
  • Responsible Cost Center
  • Client
  • P_PROJCMTMTCOSTLINEITMS.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PROJCMTMTCOSTLINEITMS.[column in domain "DATBI"] == CSKS.DATBI
  • P_PROJCMTMTCOSTLINEITMS.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • P_PROJCMTMTCOSTLINEITMS.MANDT == CSKS.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Source Logical System P_PROJCMTMTCOSTLINEITMS.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type P_PROJCMTMTCOSTLINEITMS.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Client
  • Transaction Currency
  • P_PROJCMTMTCOSTLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCMTMTCOSTLINEITMS.TRANSACTIONCURRENCY == TCURC.WAERS
Profit Center
  • ?
  • ?
  • Profit Center
  • Profit Center
  • Client
  • P_PROJCMTMTCOSTLINEITMS.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PROJCMTMTCOSTLINEITMS.[column in domain "DATBI"] == CEPC.DATBI
  • P_PROJCMTMTCOSTLINEITMS.PROFITCENTER == CEPC.PRCTR
  • P_PROJCMTMTCOSTLINEITMS.WBSELEMENTPROFITCENTER == CEPC.PRCTR
  • P_PROJCMTMTCOSTLINEITMS.MANDT == CEPC.MANDT