P_ProjPMOCostLineItms

Project Cost Line Items with PMO Costs | view: PPRJBYPMIOCST | Extraction: Not supported | Component: VDM views for Costs

Tables used: SCAL_TT_DATE, AFKO, AFIH, AFVC, PRTE, ACDOCA, ACDOCP, T001, TKA02, TKA01, FINSC_LEDGER, AUFK, PROJ, T000, FINSC_SEM_TAG, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, PSORDERCATMAP, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys (10)
💰 Amounts (42)
∑ Quantities
📅 Dates (3)
☰ Categorical (4)
Other (21)
🔗 Relations (34)

Column Name	Description
ProjectInternalID FK	Project Internal ID
OrderID FK	Order ID
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
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency	Amount in Object Currency
ActlCostInProjCrcy	Amount in Object Currency
CmtmtCostInProjCrcy	Amount in CO Object Currency
PlndCostAmtInProjCrcy	Amount in CO 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
ActualAmountInGlobalCurrency	Amount in Global Currency
CmtmtCostInGlobalCurrency	Amount in Global Currency
PlanAmountInGlobalCurrency	Amount in Global Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
ActualAmountInFreeDfndCrcy1	Amount in Freely Defined Currency 1
CmtmtCostInFreeDefinedCrcy1	Amount in Freely Defined Currency 1
PlanAmountInFreeDefinedCrcy1	Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
ActualAmountInFreeDfndCrcy2	Amount in Freely Defined Currency 2
CmtmtCostInFreeDefinedCrcy2	Amount in Freely Defined Currency 2
PlanAmountInFreeDefinedCrcy2	Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
ActualAmountInFreeDfndCrcy3	Amount in Freely Defined Currency 3
CmtmtCostInFreeDefinedCrcy3	Amount in Freely Defined Currency 3
PlanAmountInFreeDefinedCrcy3	Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
ActualAmountInFreeDfndCrcy4	Amount in Freely Defined Currency 4
CmtmtCostInFreeDefinedCrcy4	Amount in Freely Defined Currency 4
PlanAmountInFreeDefinedCrcy4	Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
ActualAmountInFreeDfndCrcy5	Amount in Freely Defined Currency 5
CmtmtCostInFreeDefinedCrcy5	Amount in Freely Defined Currency 5
PlanAmountInFreeDefinedCrcy5	Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
ActualAmountInFreeDfndCrcy6	Amount in Freely Defined Currency 6
CmtmtCostInFreeDefinedCrcy6	Amount in Freely Defined Currency 6
PlanAmountInFreeDefinedCrcy6	Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
ActualAmountInFreeDfndCrcy7	Amount in Freely Defined Currency 7
CmtmtCostInFreeDefinedCrcy7	Amount in Freely Defined Currency 7
PlanAmountInFreeDefinedCrcy7	Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
ActualAmountInFreeDfndCrcy8	Amount in Freely Defined Currency 8
CmtmtCostInFreeDefinedCrcy8	Amount in Freely Defined Currency 8
PlanAmountInFreeDefinedCrcy8	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
PartnerOrderCategory	Partner Order Category	Show values
DebitCreditCode	Debit/Credit Code	Show values
ControllingDebitCreditCode	Controlling Debit Credit Code	Show values
IsLeadingLedger	Indicator: Leading Ledger	Show values

Column Name	Description	Domain name
OrderOperation	Operation/Activity Number	VORNR
MaintenanceOrderDesc	Description	TEXT40
OperationDescription	Operation Short Text	TEXT40
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
LedgerGLLineItem	Ledger Journal Entry Item	DOCLN6
FinancialPlanningEntryItem	Financial Planning Entry Item	RSNUMRECORD
PartnerWBSElement	Partner WBS Element	FIS_WBS
PartnerProject	Partner Project	FIS_PROJECT
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
Project	Project	FIS_PROJECT
SourceReferenceDocumentCntxt	Source Reference Document Context	AWORG
SourceReferenceDocument	Source Reference Document	AWREF
SourceReferenceDocumentItem	Source Reference Document Item	NUMC6
SourceReferenceDocSubitem	Source Reference Document Subitem	NUMC6
IsCommitment	null
IsSettled	null
PlanningCategory	Plan Category	FCOM_CATEGORY
PlanningCategory1	Plan Category	FCOM_CATEGORY
PlanningCategory2	Plan Category	FCOM_CATEGORY
FiscalPeriod	Fiscal Period	POPER
FiscalYearPeriod	Fiscal Year Period	FIS_JAHRPER_CONV

Master Data Relations	Join Conditions
Business Area Business Area Client	`P_PROJPMOCOSTLINEITMS.BUSINESSAREA == TGSB.GSBER` `P_PROJPMOCOSTLINEITMS.MANDT == TGSB.MANDT`
Business Transaction Type Business Transaction Type Client	`P_PROJPMOCOSTLINEITMS.BUSINESSTRANSACTIONTYPE == FINSC_CUSTBTTYPE.CBTTYPE` `P_PROJPMOCOSTLINEITMS.MANDT == FINSC_CUSTBTTYPE.MANDT`
Chart of Accounts Chart of Accounts Client	`P_PROJPMOCOSTLINEITMS.CHARTOFACCOUNTS == T004.KTOPL` `P_PROJPMOCOSTLINEITMS.MANDT == T004.MANDT`
Company Code Company Code Client	`P_PROJPMOCOSTLINEITMS.COMPANYCODE == T001.BUKRS` `P_PROJPMOCOSTLINEITMS.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`P_PROJPMOCOSTLINEITMS.COMPANYCODECURRENCY == TCURC.WAERS` `P_PROJPMOCOSTLINEITMS.MANDT == TCURC.MANDT`
Controlling Area Controlling Area Client	`P_PROJPMOCOSTLINEITMS.CONTROLLINGAREA == TKA01.KOKRS` `P_PROJPMOCOSTLINEITMS.MANDT == TKA01.MANDT`
CO Object Currency CO Object Currency Client	`P_PROJPMOCOSTLINEITMS.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS` `P_PROJPMOCOSTLINEITMS.MANDT == TCURC.MANDT`
Cost Center ? Controlling Area Cost Center Client	`P_PROJPMOCOSTLINEITMS.[column in domain "DATBI"] == CSKS.DATBI` `P_PROJPMOCOSTLINEITMS.CONTROLLINGAREA == CSKS.KOKRS` `P_PROJPMOCOSTLINEITMS.COSTCENTER == CSKS.KOSTL` `P_PROJPMOCOSTLINEITMS.MANDT == CSKS.MANDT`
Activity Type ? Controlling Area Activity Type Client	`P_PROJPMOCOSTLINEITMS.[column in domain "DATBI"] == CSLA.DATBI` `P_PROJPMOCOSTLINEITMS.CONTROLLINGAREA == CSLA.KOKRS` `P_PROJPMOCOSTLINEITMS.COSTCTRACTIVITYTYPE == CSLA.LSTAR` `P_PROJPMOCOSTLINEITMS.MANDT == CSLA.MANDT`
Fiscal Year Variant Fiscal Year Variant Client	`P_PROJPMOCOSTLINEITMS.FISCALYEARVARIANT == T009.PERIV` `P_PROJPMOCOSTLINEITMS.MANDT == T009.MANDT`
Freely Defined Currency 1 Freely Defined Currency 1 Client	`P_PROJPMOCOSTLINEITMS.FREEDEFINEDCURRENCY1 == TCURC.WAERS` `P_PROJPMOCOSTLINEITMS.MANDT == TCURC.MANDT`
Freely Defined Currency 2 Client Freely Defined Currency 2	`P_PROJPMOCOSTLINEITMS.MANDT == TCURC.MANDT` `P_PROJPMOCOSTLINEITMS.FREEDEFINEDCURRENCY2 == TCURC.WAERS`
Freely Defined Currency 3 Freely Defined Currency 3 Client	`P_PROJPMOCOSTLINEITMS.FREEDEFINEDCURRENCY3 == TCURC.WAERS` `P_PROJPMOCOSTLINEITMS.MANDT == TCURC.MANDT`
Freely Defined Currency 4 Freely Defined Currency 4 Client	`P_PROJPMOCOSTLINEITMS.FREEDEFINEDCURRENCY4 == TCURC.WAERS` `P_PROJPMOCOSTLINEITMS.MANDT == TCURC.MANDT`
Freely Defined Currency 5 Freely Defined Currency 5 Client	`P_PROJPMOCOSTLINEITMS.FREEDEFINEDCURRENCY5 == TCURC.WAERS` `P_PROJPMOCOSTLINEITMS.MANDT == TCURC.MANDT`
Freely Defined Currency 6 Freely Defined Currency 6 Client	`P_PROJPMOCOSTLINEITMS.FREEDEFINEDCURRENCY6 == TCURC.WAERS` `P_PROJPMOCOSTLINEITMS.MANDT == TCURC.MANDT`
Freely Defined Currency 7 Client Freely Defined Currency 7	`P_PROJPMOCOSTLINEITMS.MANDT == TCURC.MANDT` `P_PROJPMOCOSTLINEITMS.FREEDEFINEDCURRENCY7 == TCURC.WAERS`
Freely Defined Currency 8 Freely Defined Currency 8 Client	`P_PROJPMOCOSTLINEITMS.FREEDEFINEDCURRENCY8 == TCURC.WAERS` `P_PROJPMOCOSTLINEITMS.MANDT == TCURC.MANDT`
Functional Area Functional Area Client	`P_PROJPMOCOSTLINEITMS.FUNCTIONALAREA == TFKB.FKBER` `P_PROJPMOCOSTLINEITMS.MANDT == TFKB.MANDT`
G/L Account Company Code G/L Account Client	`P_PROJPMOCOSTLINEITMS.COMPANYCODE == SKB1.BUKRS` `P_PROJPMOCOSTLINEITMS.GLACCOUNT == SKB1.SAKNR` `P_PROJPMOCOSTLINEITMS.MANDT == SKB1.MANDT`
Global Currency Global Currency Client	`P_PROJPMOCOSTLINEITMS.GLOBALCURRENCY == TCURC.WAERS` `P_PROJPMOCOSTLINEITMS.MANDT == TCURC.MANDT`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting Source Ledger	`P_PROJPMOCOSTLINEITMS.MANDT == FINSC_LEDGER.MANDT` `P_PROJPMOCOSTLINEITMS.LEDGER == FINSC_LEDGER.RLDNR` `P_PROJPMOCOSTLINEITMS.SOURCELEDGER == FINSC_LEDGER.RLDNR`
Order Number Order ID Order Number Client	`P_PROJPMOCOSTLINEITMS.ORDERID == AUFK.AUFNR` `P_PROJPMOCOSTLINEITMS.MAINTENANCEORDER == AUFK.AUFNR` `P_PROJPMOCOSTLINEITMS.MANDT == AUFK.MANDT`
Order ID Order ID Order Number Client	`P_PROJPMOCOSTLINEITMS.ORDERID == AUFK.AUFNR` `P_PROJPMOCOSTLINEITMS.MAINTENANCEORDER == AUFK.AUFNR` `P_PROJPMOCOSTLINEITMS.MANDT == AUFK.MANDT`
Partner Order Partner Order Client	`P_PROJPMOCOSTLINEITMS.PARTNERORDER == AUFK.AUFNR` `P_PROJPMOCOSTLINEITMS.MANDT == AUFK.MANDT`
Profit Center ? Controlling Area Profit Center Client	`P_PROJPMOCOSTLINEITMS.[column in domain "DATBI"] == CEPC.DATBI` `P_PROJPMOCOSTLINEITMS.CONTROLLINGAREA == CEPC.KOKRS` `P_PROJPMOCOSTLINEITMS.PROFITCENTER == CEPC.PRCTR` `P_PROJPMOCOSTLINEITMS.MANDT == CEPC.MANDT`
Project Internal ID Project Internal ID Client	`P_PROJPMOCOSTLINEITMS.PROJECTINTERNALID == PROJ.PSPNR` `P_PROJPMOCOSTLINEITMS.MANDT == PROJ.MANDT`
Semantic Tag of a Hierarchy Node Semantic Tag of a Hierarchy Node Client	`P_PROJPMOCOSTLINEITMS.SEMANTICTAG == FINSC_SEM_TAG.FINS_SEM_TAG` `P_PROJPMOCOSTLINEITMS.MANDT == FINSC_SEM_TAG.MANDT`
Source Ledger Client Ledger in General Ledger Accounting Source Ledger	`P_PROJPMOCOSTLINEITMS.MANDT == FINSC_LEDGER.MANDT` `P_PROJPMOCOSTLINEITMS.LEDGER == FINSC_LEDGER.RLDNR` `P_PROJPMOCOSTLINEITMS.SOURCELEDGER == FINSC_LEDGER.RLDNR`
Source Logical System	`P_PROJPMOCOSTLINEITMS.SOURCELOGICALSYSTEM == TBDLS.LOGSYS`
Source Reference Document Type	`P_PROJPMOCOSTLINEITMS.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP`
Transaction Currency Transaction Currency Client	`P_PROJPMOCOSTLINEITMS.TRANSACTIONCURRENCY == TCURC.WAERS` `P_PROJPMOCOSTLINEITMS.MANDT == TCURC.MANDT`