P_ProjPlnCostLineItms

Project Cost Line Items with Planning Category Costs | view: PPRJBYPLNCST | Extraction: Not supported | Component: VDM views for Costs
Column Name Description
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 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
PlanAmountInGlobalCurrency Amount in Global Currency
💲 Functional Currency (FunctionalCurrency):
PlanAmountInFunctionalCurrency Amount in Functional Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 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
PlanAmountInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 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
PlanAmountInFreeDefinedCrcy4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 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
PlanAmountInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 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
PlanAmountInFreeDefinedCrcy8 Amount in Freely Defined Currency 8
Column Name Description
Column Name Description
CreationDate Posting Date
PostingDate Posting Date
DocumentDate Document Date in Document
Column Name Description
ActualPlanCode Actual Plan Code Show values
PartnerOrderCategory Partner Order Category Show values
DebitCreditCode Debit/Credit Code Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
IsCommitment Indicator: 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
SourceLedger Source Ledger FINS_LEDGER
FiscalYear Fiscal Year GJAHR
AccountingDocument Journal Entry BELNR
LedgerFiscalYear Ledger Fiscal Year GJAHR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
FinancialPlanningEntryItem Financial Planning Entry Item FIS_INT4_UNSIGNED
AccountingDocCreatedByUser User Name XUBNAME
OrderOperation null
OperationDescription null
PartnerWBSElement Partner WBS Element PS_POSID
PartnerProject Partner Project PS_PSPID
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
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
IsSettled null
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalYearVariant Fiscal Year Variant PERIV
SemanticTag Semantic Tag of a Hierarchy Node FINS_SEM_TAG
WBSDescription WBS Element Name TEXT40
ProjectObjectNode Object number J_OBJNR
ProjectDescription Project Name TEXT40
Master Data Relations Join Conditions
Availability profile for project
  • Client
  • Budget Availability Control: Profile
Business Area
  • Client
  • Business Area
  • P_PROJPLNCOSTLINEITMS.MANDT == TGSB.MANDT
  • P_PROJPLNCOSTLINEITMS.BUSINESSAREA == TGSB.GSBER
Business Transaction Category
  • Business Transaction Category
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_PROJPLNCOSTLINEITMS.CHARTOFACCOUNTS == T004.KTOPL
  • P_PROJPLNCOSTLINEITMS.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_PROJPLNCOSTLINEITMS.COMPANYCODE == T001.BUKRS
  • P_PROJPLNCOSTLINEITMS.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_PROJPLNCOSTLINEITMS.CONTROLLINGAREA == TKA01.KOKRS
  • P_PROJPLNCOSTLINEITMS.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • P_PROJPLNCOSTLINEITMS.[column in domain "DATBI"] == CSKS.DATBI
  • P_PROJPLNCOSTLINEITMS.CONTROLLINGAREA == CSKS.KOKRS
  • P_PROJPLNCOSTLINEITMS.MANDT == CSKS.MANDT
  • P_PROJPLNCOSTLINEITMS.COSTCENTER == CSKS.KOSTL
Functional Area
  • Client
  • Functional Area
  • P_PROJPLNCOSTLINEITMS.MANDT == TFKB.MANDT
  • P_PROJPLNCOSTLINEITMS.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Chart of Accounts
  • Client
  • G/L Account
  • P_PROJPLNCOSTLINEITMS.CHARTOFACCOUNTS == SKA1.KTOPL
  • P_PROJPLNCOSTLINEITMS.MANDT == SKA1.MANDT
  • P_PROJPLNCOSTLINEITMS.GLACCOUNT == SKA1.SAKNR
Ledger
  • Ledger
  • Client
Plan Category
  • Plan Category
  • Client
Plan Category
  • Client
  • Plan Category
Plan Category
  • Plan Category
  • Client
Profit Center
  • Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • P_PROJPLNCOSTLINEITMS.WBSELEMENTPROFITCENTER == CEPC.PRCTR
  • P_PROJPLNCOSTLINEITMS.PROFITCENTER == CEPC.PRCTR
  • P_PROJPLNCOSTLINEITMS.[column in domain "DATBI"] == CEPC.DATBI
  • P_PROJPLNCOSTLINEITMS.CONTROLLINGAREA == CEPC.KOKRS
  • P_PROJPLNCOSTLINEITMS.MANDT == CEPC.MANDT
Profile ID for project structure
  • Client
  • Project Profile
  • P_PROJPLNCOSTLINEITMS.MANDT == TCJ41.MANDT
  • P_PROJPLNCOSTLINEITMS.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Responsible cost center
  • Responsible Cost Center
  • ?
  • Client
  • ?
  • P_PROJPLNCOSTLINEITMS.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • P_PROJPLNCOSTLINEITMS.[column in domain "DATBI"] == CSKS.DATBI
  • P_PROJPLNCOSTLINEITMS.MANDT == CSKS.MANDT
  • P_PROJPLNCOSTLINEITMS.[column in domain "KOKRS"] == CSKS.KOKRS
Profit Center
  • Profit Center
  • Profit Center
  • ?
  • ?
  • Client
  • P_PROJPLNCOSTLINEITMS.WBSELEMENTPROFITCENTER == CEPC.PRCTR
  • P_PROJPLNCOSTLINEITMS.PROFITCENTER == CEPC.PRCTR
  • P_PROJPLNCOSTLINEITMS.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PROJPLNCOSTLINEITMS.[column in domain "DATBI"] == CEPC.DATBI
  • P_PROJPLNCOSTLINEITMS.MANDT == CEPC.MANDT