P_EnterpriseProjectPlnCosts

Project Cost Line Items with Planning Category Costs | view: PENTPRJPLN | Extraction: Not supported | Component: VDM views for Costs

Tables used: ACDOCP, FINSC_AVC_PROF, T001, TKA02, TKA01, AUFK, FINSC_LEDGER, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, T000, FINSC_SEM_TAG, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys (8)
💰 Amounts (12)
∑ Quantities
📅 Dates (4)
☰ Categorical (9)
Other (27)
🔗 Relations (19)

Column Name	Description
SourceLedger	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
ActualAmountInTransactionCrcy	Actual Amount in Transaction Currency
PlanAmountInTransactionCrcy	Plan Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency	Amount in Company Code Currency
ActualAmountInCompanyCodeCrcy	Actual Amount in Company Code Currency
PlanAmountInCompanyCodeCrcy	Plan Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency	Amount in Global Currency
ActualAmountInGlobalCurrency	Actual Amount in Global Currency
PlanAmountInGlobalCurrency	Plan Amount in Global Currency
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency	Amount in CO Object Currency
ActualAmountInObjectCurrency	Actual Amount in Object Currency
PlndCostAmtInProjCrcy	Plan 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: Commitment	Show values
ControllingDebitCreditCode	CO Debit/Credit Indicator	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	FIS_INT4_UNSIGNED
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
Project	Project Number (External) Edited	PS_PSPID_EDIT
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
WBSElementInternalID	WBS Element Internal ID	FIS_WBSINT_NO_CONV
PartnerProject	Partner Project	PS_PSPID
PartnerWBSElement	Partner WBS Element	PS_POSID
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
FiscalYearVariant	Fiscal Year Variant	PERIV
AccountingDocCreatedByUser	User Name	XUBNAME
IsSettled	null
SemanticTag	Semantic Tag of a Hierarchy Node	FINS_SEM_TAG
SourceReferenceDocumentType	Source Document Type	AWTYP
SourceLogicalSystem	Source Document System	LOGSYS
SourceReferenceDocumentCntxt	Organizational Unit of Source Document	AWORG
SourceReferenceDocument	Source Document Number	AWREF
SourceReferenceDocumentItem	Line Item in Source Document	NUMC6
SourceReferenceDocSubitem	Subitem in Source Document	NUMC6
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_ENTERPRISEPROJECTPLNCOSTS.AVAILABILITYCONTROLPROFILE == FINSC_AVC_PROF.PROFILE` `P_ENTERPRISEPROJECTPLNCOSTS.MANDT == FINSC_AVC_PROF.MANDT`
Business Area Business Area Client	`P_ENTERPRISEPROJECTPLNCOSTS.BUSINESSAREA == TGSB.GSBER` `P_ENTERPRISEPROJECTPLNCOSTS.MANDT == TGSB.MANDT`
Business Transaction Category Business Transaction Category Client	`P_ENTERPRISEPROJECTPLNCOSTS.BUSINESSTRANSACTIONTYPE == FINSC_BTTYPE.BTTYPE` `P_ENTERPRISEPROJECTPLNCOSTS.MANDT == FINSC_BTTYPE.MANDT`
Chart of Accounts Chart of Accounts Client	`P_ENTERPRISEPROJECTPLNCOSTS.CHARTOFACCOUNTS == T004.KTOPL` `P_ENTERPRISEPROJECTPLNCOSTS.MANDT == T004.MANDT`
Company Code Company Code Client	`P_ENTERPRISEPROJECTPLNCOSTS.COMPANYCODE == T001.BUKRS` `P_ENTERPRISEPROJECTPLNCOSTS.MANDT == T001.MANDT`
Controlling Area Client Controlling Area	`P_ENTERPRISEPROJECTPLNCOSTS.MANDT == TKA01.MANDT` `P_ENTERPRISEPROJECTPLNCOSTS.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center ? Cost Center Client Controlling Area	`P_ENTERPRISEPROJECTPLNCOSTS.[column in domain "DATBI"] == CSKS.DATBI` `P_ENTERPRISEPROJECTPLNCOSTS.COSTCENTER == CSKS.KOSTL` `P_ENTERPRISEPROJECTPLNCOSTS.MANDT == CSKS.MANDT` `P_ENTERPRISEPROJECTPLNCOSTS.CONTROLLINGAREA == CSKS.KOKRS`
Functional Area Client Functional Area	`P_ENTERPRISEPROJECTPLNCOSTS.MANDT == TFKB.MANDT` `P_ENTERPRISEPROJECTPLNCOSTS.FUNCTIONALAREA == TFKB.FKBER`
G/L Account Chart of Accounts Client G/L Account	`P_ENTERPRISEPROJECTPLNCOSTS.CHARTOFACCOUNTS == SKA1.KTOPL` `P_ENTERPRISEPROJECTPLNCOSTS.MANDT == SKA1.MANDT` `P_ENTERPRISEPROJECTPLNCOSTS.GLACCOUNT == SKA1.SAKNR`
Ledger in General Ledger Accounting Ledger in General Ledger Accounting Client	`P_ENTERPRISEPROJECTPLNCOSTS.LEDGER == FINSC_LEDGER.RLDNR` `P_ENTERPRISEPROJECTPLNCOSTS.MANDT == FINSC_LEDGER.MANDT`
Partner Functional Area Client Partner Functional Area	`P_ENTERPRISEPROJECTPLNCOSTS.MANDT == TFKB.MANDT` `P_ENTERPRISEPROJECTPLNCOSTS.PARTNERFUNCTIONALAREA == TFKB.FKBER`
Plan Category Plan Category Client	`P_ENTERPRISEPROJECTPLNCOSTS.PLANNINGCATEGORY == FCOMC_CATEGORY.CATEGORY` `P_ENTERPRISEPROJECTPLNCOSTS.MANDT == FCOMC_CATEGORY.MANDT`
Profit Center ? Profit Center Profit Center Client Controlling Area	`P_ENTERPRISEPROJECTPLNCOSTS.[column in domain "DATBI"] == CEPC.DATBI` `P_ENTERPRISEPROJECTPLNCOSTS.WBSELEMENTPROFITCENTER == CEPC.PRCTR` `P_ENTERPRISEPROJECTPLNCOSTS.PROFITCENTER == CEPC.PRCTR` `P_ENTERPRISEPROJECTPLNCOSTS.MANDT == CEPC.MANDT` `P_ENTERPRISEPROJECTPLNCOSTS.CONTROLLINGAREA == CEPC.KOKRS`
Project Category Client Project Category	`P_ENTERPRISEPROJECTPLNCOSTS.MANDT == DPR_PRO_CATEG.CLIENT` `P_ENTERPRISEPROJECTPLNCOSTS.PROJECTCATEGORY == DPR_PRO_CATEG.PRO_CATEGORY`
Profile ID for project structure Client Project Profile	`P_ENTERPRISEPROJECTPLNCOSTS.MANDT == TCJ41.MANDT` `P_ENTERPRISEPROJECTPLNCOSTS.PROJECTPROFILECODE == TCJ41.PROFIDPROJ`
Responsible cost center ? Responsible Cost Center Client ?	`P_ENTERPRISEPROJECTPLNCOSTS.[column in domain "DATBI"] == CSKS.DATBI` `P_ENTERPRISEPROJECTPLNCOSTS.RESPONSIBLECOSTCENTER == CSKS.KOSTL` `P_ENTERPRISEPROJECTPLNCOSTS.MANDT == CSKS.MANDT` `P_ENTERPRISEPROJECTPLNCOSTS.[column in domain "KOKRS"] == CSKS.KOKRS`
Profit Center ? ? Profit Center Profit Center Client	`P_ENTERPRISEPROJECTPLNCOSTS.[column in domain "KOKRS"] == CEPC.KOKRS` `P_ENTERPRISEPROJECTPLNCOSTS.[column in domain "DATBI"] == CEPC.DATBI` `P_ENTERPRISEPROJECTPLNCOSTS.WBSELEMENTPROFITCENTER == CEPC.PRCTR` `P_ENTERPRISEPROJECTPLNCOSTS.PROFITCENTER == CEPC.PRCTR` `P_ENTERPRISEPROJECTPLNCOSTS.MANDT == CEPC.MANDT`