C_Projectcostlineitems

Project Cost Line Items | view: CPROJCSTLINITEM | Extraction: Not supported | Component: VDM views for Costs
Tables used: AFIH, AFKO, ACDOCA, ACDOCP, FINSC_AVC_PROF, T001, TKA02, TKA01, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, PRPS, /S4PPM/HIERARCHY, AUFK, FINSC_LEDGER, FCOMC_CATEGORY, FCOMC_CATEGORY_T, T000, FINSC_SEM_TAG, FINSC_SEM_TAG_N, USR21, ADCP, ADR2, ADR3, ADR6, ADRP, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_PERIOD, T009C, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, PSORDERCATMAP, FINSC_FISC_DATE
Column Name Description
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
FinancialPlanningDataPacket Financial Planning Data Packet Number
FinancialPlanningEntryItem Financial Planning Entry Item
Project Project Number (External) Edited
WBSElement Work Breakdown Structure Element (WBS Element) Edited
Column Name Description
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
ActualAmountInGlobalCurrency Amount in Global Currency
CmtmtCostInGlobalCurrency Amount in Global Currency
PlanAmountInGlobalCurrency Amount in Global Currency
BaselineAmtInGlobalCrcy Amount in Global Currency
ActualCumltvAmtInCoCodeCrcy Amount in Global Currency
CmtmtCumltvAmtInGlobCrcy Amount in Global Currency
ActlCmtmtCumltvAmtInGlobCrcy Amount in Global Currency
PlanCumltvAmtInCoCodeCrcy Amount in Global Currency
BaselineCumltvAmtInCoCodeCrcy Amount in Global Currency
💲 Company Code Currency (CompanyCodeCurrency):
ActualAmountInCompanyCodeCrcy Amount in Company Code Currency
CmtmtCostInCCCrcy Amount in Company Code Currency
PlanAmountInCompanyCodeCrcy Amount in Company Code Currency
BaselineAmtInCompanyCodeCrcy Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
ActualAmountInTransactionCrcy Amount in Transaction Currency
CmtmtCostInTransacCrcy Amount in Transaction Currency
PlanAmountInTransactionCrcy Amount in Transaction Currency
BaselineAmtInFreeDefinedCrcy4 Amount in Transaction Currency
💲 Functional Currency (FunctionalCurrency):
ActualAmountInFunctionalCrcy Amount in Functional Currency
CmtmtAmountInFunctionalCrcy Amount in Functional Currency
PlanAmountInFunctionalCurrency Amount in Functional Currency
BaselineAmtInFunctionalCrcy Amount in Functional Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
ActualAmountInFreeDfndCrcy1 Amount in Freely Defined Currency 1
CmtmtCostInFreeDefinedCrcy1 Amount in Freely Defined Currency 1
PlanAmountInFreeDefinedCrcy1 Amount in Freely Defined Currency 1
BaselineAmtInFreeDefinedCrcy1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
ActualAmountInFreeDfndCrcy2 Amount in Freely Defined Currency 2
CmtmtCostInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
PlanAmountInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
BaselineAmtInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
ActualAmountInFreeDfndCrcy3 Amount in Freely Defined Currency 3
CmtmtCostInFreeDefinedCrcy3 Amount in Freely Defined Currency 3
PlanAmountInFreeDefinedCrcy3 Amount in Freely Defined Currency 3
BaselineAmtInFreeDefinedCrcy3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
ActualAmountInFreeDfndCrcy4 Amount in Freely Defined Currency 4
CmtmtCostInFreeDefinedCrcy4 Amount in Freely Defined Currency 4
PlanAmountInFreeDefinedCrcy4 Amount in Freely Defined Currency 4
BaselinePlndRevnAmt Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
ActualAmountInFreeDfndCrcy5 Amount in Freely Defined Currency 5
CmtmtCostInFreeDefinedCrcy5 Amount in Freely Defined Currency 5
PlanAmountInFreeDefinedCrcy5 Amount in Freely Defined Currency 5
BaselineAmtInFreeDefinedCrcy5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
ActualAmountInFreeDfndCrcy6 Amount in Freely Defined Currency 6
CmtmtCostInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
PlanAmountInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
BaselineAmtInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
ActualAmountInFreeDfndCrcy7 Amount in Freely Defined Currency 7
CmtmtCostInFreeDefinedCrcy7 Amount in Freely Defined Currency 7
PlanAmountInFreeDefinedCrcy7 Amount in Freely Defined Currency 7
BaselineAmtInFreeDefinedCrcy7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
ActualAmountInFreeDfndCrcy8 Amount in Freely Defined Currency 8
CmtmtCostInFreeDefinedCrcy8 Amount in Freely Defined Currency 8
PlanAmountInFreeDefinedCrcy8 Amount in Freely Defined Currency 8
BaseAmtWithoutTxInCCCrcy Amount in Freely Defined Currency 8
💲 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
BslnAmtInProjCrcy Amount in CO Object Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
MaintenanceOrderIsSelected Boolean Variable (X = True, - = False, Space = Unknown)
ProjectInternalID Project (internal) PS_S4_PROJ_PSPNR
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
ProjectUUID Entity Guid /S4PPM/GUID
TaskUUID Entity Guid /S4PPM/GUID
WBSDescription WBS Element Name
PlanningCategory Plan Category
PlanningCategoryName Planning Category
GLAccount G/L Account
CreatedByUserFullName Full Name of Person
FiscalPeriod Fiscal Period POPER
FiscalPeriodName Period name long text TEXT20_GJV
SemanticTagName Name of Semantic Tag of Hierarchy Node
SemanticTag Semantic Tag of a Hierarchy Node
IsSettled PS Cost Consider Settlements
PartnerOrderCategory Partner Order Category
PartnerWBSElement Partner WBS Element FIS_WBS_NO_CONV
PartnerProject Partner Project FIS_PROJECT_NO_CONV
SourceReferenceDocument Source Reference Document
SourceReferenceDocumentItem Source Reference Document Item
Master Data Relations Join Conditions
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_PROJECTCOSTLINEITEMS.MANDT == T004.MANDT
  • C_PROJECTCOSTLINEITEMS.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_PROJECTCOSTLINEITEMS.MANDT == T001.MANDT
  • C_PROJECTCOSTLINEITEMS.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • C_PROJECTCOSTLINEITEMS.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PROJECTCOSTLINEITEMS.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_PROJECTCOSTLINEITEMS.CONTROLLINGAREA == TKA01.KOKRS
  • C_PROJECTCOSTLINEITEMS.MANDT == TKA01.MANDT
CO Object Currency
  • CO Object Currency
  • Client
  • C_PROJECTCOSTLINEITEMS.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
  • C_PROJECTCOSTLINEITEMS.MANDT == TCURC.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_PROJECTCOSTLINEITEMS.FISCALYEARVARIANT == T009.PERIV
  • C_PROJECTCOSTLINEITEMS.MANDT == T009.MANDT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • C_PROJECTCOSTLINEITEMS.MANDT == TCURC.MANDT
  • C_PROJECTCOSTLINEITEMS.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • C_PROJECTCOSTLINEITEMS.MANDT == TCURC.MANDT
  • C_PROJECTCOSTLINEITEMS.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • C_PROJECTCOSTLINEITEMS.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • C_PROJECTCOSTLINEITEMS.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • C_PROJECTCOSTLINEITEMS.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • C_PROJECTCOSTLINEITEMS.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • C_PROJECTCOSTLINEITEMS.MANDT == TCURC.MANDT
  • C_PROJECTCOSTLINEITEMS.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • C_PROJECTCOSTLINEITEMS.MANDT == TCURC.MANDT
  • C_PROJECTCOSTLINEITEMS.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • C_PROJECTCOSTLINEITEMS.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • C_PROJECTCOSTLINEITEMS.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • C_PROJECTCOSTLINEITEMS.FREEDEFINEDCURRENCY8 == TCURC.WAERS
  • C_PROJECTCOSTLINEITEMS.MANDT == TCURC.MANDT
Functional Currency
  • Functional Currency
  • Client
  • C_PROJECTCOSTLINEITEMS.FUNCTIONALCURRENCY == TCURC.WAERS
  • C_PROJECTCOSTLINEITEMS.MANDT == TCURC.MANDT
Global Currency
  • Client
  • Global Currency
  • C_PROJECTCOSTLINEITEMS.MANDT == TCURC.MANDT
  • C_PROJECTCOSTLINEITEMS.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Order ID
  • Client
  • Order ID
  • C_PROJECTCOSTLINEITEMS.MANDT == AUFK.MANDT
  • C_PROJECTCOSTLINEITEMS.ORDERID == AUFK.AUFNR
Partner Order
  • Partner Order
  • Client
  • C_PROJECTCOSTLINEITEMS.PARTNERORDER == AUFK.AUFNR
  • C_PROJECTCOSTLINEITEMS.MANDT == AUFK.MANDT
Profit Center
  • Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • C_PROJECTCOSTLINEITEMS.PROFITCENTER == CEPC.PRCTR
  • C_PROJECTCOSTLINEITEMS.WBSELEMENTPROFITCENTER == CEPC.PRCTR
  • C_PROJECTCOSTLINEITEMS.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROJECTCOSTLINEITEMS.CONTROLLINGAREA == CEPC.KOKRS
  • C_PROJECTCOSTLINEITEMS.MANDT == CEPC.MANDT
Project Category
  • Project Category
  • Client
Profile ID for project structure
  • Client
  • Project Profile
  • C_PROJECTCOSTLINEITEMS.MANDT == TCJ41.MANDT
  • C_PROJECTCOSTLINEITEMS.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Responsible cost center
  • ?
  • ?
  • Responsible Cost Center
  • Client
  • C_PROJECTCOSTLINEITEMS.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PROJECTCOSTLINEITEMS.[column in domain "DATBI"] == CSKS.DATBI
  • C_PROJECTCOSTLINEITEMS.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • C_PROJECTCOSTLINEITEMS.MANDT == CSKS.MANDT
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Source Reference Document Type C_PROJECTCOSTLINEITEMS.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Transaction Currency
  • Client
  • C_PROJECTCOSTLINEITEMS.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_PROJECTCOSTLINEITEMS.MANDT == TCURC.MANDT
Profit Center
  • Profit Center
  • Profit Center
  • ?
  • ?
  • Client
  • C_PROJECTCOSTLINEITEMS.PROFITCENTER == CEPC.PRCTR
  • C_PROJECTCOSTLINEITEMS.WBSELEMENTPROFITCENTER == CEPC.PRCTR
  • C_PROJECTCOSTLINEITEMS.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_PROJECTCOSTLINEITEMS.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROJECTCOSTLINEITEMS.MANDT == CEPC.MANDT