P_PPM_ProjectCostLineItem

togetCostLineItems | view: PPRJCSTLINEITEMN | Extraction: Not supported | Component: Virtual Data Model for Portfolio and Project Mgmnt
Tables used: AFIH, AFKO, ACDOCA, ACDOCP, FINSC_AVC_PROF, T001, TKA02, TKA01, /S4PPM/HIERARCHY, /S4PPM/TASK, PRPS, AUFK, FINSC_LEDGER, AUFK, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, T000, FINSC_SEM_TAG, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, PSORDERCATMAP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
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
💲 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
PlanAmountInGlobalCurrency Amount in Global Currency
PredictedAmtInGlobalCurrency Amount in Global Currency
BaselineAmtInGlobalCrcy Amount in Global Currency
Column Name Description
Column Name Description
Column Name Description
ProjectProcessingStatus Object Processing Status 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
IsCommitment Indicator: Is Commitment Show values
PartnerOrderCategory Partner Order Category Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
FinancialPlanningEntryItem Financial Planning Entry Item RSNUMRECORD
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
SemanticTag Semantic Tag of a Hierarchy Node FINS_SEM_TAG
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
LedgerFiscalYear Ledger Fiscal Year GJAHR
Project Project Number (External) Edited PS_PSPID_EDIT
ProjectInternalID Project (internal) PS_S4_PROJ_PSPNR
ProjectDescription Project Name TEXT40
ProjectObjectNode Object number J_OBJNR
ProjectUUID Entity Guid /S4PPM/GUID
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
WBSElement Identification of Entities /S4PPM/EXTERNAL_ID
WBSDescription WBS Element Name TEXT40
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
ProjectType null
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
PartnerWBSElement Partner WBS Element FIS_WBS_NO_CONV
PartnerProject Partner Project FIS_PROJECT_NO_CONV
FiscalPeriod Fiscal Period POPER
PlanningCategory Plan Category FCOM_CATEGORY
Master Data Relations Join Conditions
Availability profile for project
  • Client
  • Budget Availability Control: Profile
Business Area
  • Business Area
  • Client
  • P_PPM_PROJECTCOSTLINEITEM.BUSINESSAREA == TGSB.GSBER
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == TGSB.MANDT
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_PPM_PROJECTCOSTLINEITEM.CHARTOFACCOUNTS == T004.KTOPL
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_PPM_PROJECTCOSTLINEITEM.COMPANYCODE == T001.BUKRS
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_PPM_PROJECTCOSTLINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_PPM_PROJECTCOSTLINEITEM.CONTROLLINGAREA == TKA01.KOKRS
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == TKA01.MANDT
CO Object Currency
  • CO Object Currency
  • Client
  • P_PPM_PROJECTCOSTLINEITEM.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == TCURC.MANDT
Cost Center
  • Controlling Area
  • Cost Center
  • ?
  • Client
  • P_PPM_PROJECTCOSTLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • P_PPM_PROJECTCOSTLINEITEM.COSTCENTER == CSKS.KOSTL
  • P_PPM_PROJECTCOSTLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == CSKS.MANDT
Activity Type
  • Controlling Area
  • Activity Type
  • ?
  • Client
  • P_PPM_PROJECTCOSTLINEITEM.CONTROLLINGAREA == CSLA.KOKRS
  • P_PPM_PROJECTCOSTLINEITEM.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_PPM_PROJECTCOSTLINEITEM.[column in domain "DATBI"] == CSLA.DATBI
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == CSLA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_PPM_PROJECTCOSTLINEITEM.FISCALYEARVARIANT == T009.PERIV
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == T009.MANDT
Functional Area
  • Client
  • Functional Area
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == TFKB.MANDT
  • P_PPM_PROJECTCOSTLINEITEM.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Company Code
  • G/L Account
  • Client
  • P_PPM_PROJECTCOSTLINEITEM.COMPANYCODE == SKB1.BUKRS
  • P_PPM_PROJECTCOSTLINEITEM.GLACCOUNT == SKB1.SAKNR
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == TCURC.MANDT
  • P_PPM_PROJECTCOSTLINEITEM.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Partner Order
  • Partner Order
  • Client
  • P_PPM_PROJECTCOSTLINEITEM.PARTNERORDER == AUFK.AUFNR
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == AUFK.MANDT
Profit Center
  • Controlling Area
  • ?
  • Client
  • Profit Center
  • Profit Center
  • P_PPM_PROJECTCOSTLINEITEM.CONTROLLINGAREA == CEPC.KOKRS
  • P_PPM_PROJECTCOSTLINEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == CEPC.MANDT
  • P_PPM_PROJECTCOSTLINEITEM.PROFITCENTER == CEPC.PRCTR
  • P_PPM_PROJECTCOSTLINEITEM.WBSELEMENTPROFITCENTER == CEPC.PRCTR
Project Category
  • Project Category
  • Client
Profile ID for project structure
  • Client
  • Project Profile
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == TCJ41.MANDT
  • P_PPM_PROJECTCOSTLINEITEM.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Responsible cost center
  • ?
  • Responsible Cost Center
  • Client
  • ?
  • P_PPM_PROJECTCOSTLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • P_PPM_PROJECTCOSTLINEITEM.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == CSKS.MANDT
  • P_PPM_PROJECTCOSTLINEITEM.[column in domain "KOKRS"] == CSKS.KOKRS
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Source Logical System P_PPM_PROJECTCOSTLINEITEM.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type P_PPM_PROJECTCOSTLINEITEM.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Transaction Currency
  • Client
  • P_PPM_PROJECTCOSTLINEITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == TCURC.MANDT
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • Profit Center
  • P_PPM_PROJECTCOSTLINEITEM.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PPM_PROJECTCOSTLINEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • P_PPM_PROJECTCOSTLINEITEM.MANDT == CEPC.MANDT
  • P_PPM_PROJECTCOSTLINEITEM.PROFITCENTER == CEPC.PRCTR
  • P_PPM_PROJECTCOSTLINEITEM.WBSELEMENTPROFITCENTER == CEPC.PRCTR