I_ProjectCostLineItemsCube

Project Cost Line Items Cube | view: IPROCSTLITMCB | TRAN | Extraction: Full only | Component: VDM views for Costs
Tables used: AFIH, AFKO, CGPL_HIERARCHY, PRTE, ACDOCA, ACDOCP, FINSC_AVC_PROF, USR21, T001, TKA02, TKA01, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, PRPS, /S4PPM/HIERARCHY, AUFK, FINSC_LEDGER, DPR_BUPA_LINK, DPR_ENTITY_LINK, FCOMC_CATEGORY, CNLDST_SHORTTX, T000, FINSC_SEM_TAG, PRHI, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, PSORDERCATMAP, BPU_ROLECAT_WHL, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
ProjectObjectNode Object number
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
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
OrderPlngCat1AmtInObjCrcy Amount in Object Currency
OrderPlngCat2AmtInObjCrcy Amount in Object Currency
ActlCostInProjCrcy Amount in Object Currency
PlndCostAmtInProjCrcy Amount in CO Object Currency
CmtmtCostInProjCrcy Amount in CO Object Currency
💲 Global Currency (GlobalCurrency):
OrderPlngCat1AmtInGlobCrcy Amount in Global Currency
OrderPlngCat2AmtInGlobCrcy Amount in Global Currency
AmountInGlobalCurrency Amount in Global Currency
ActualAmountInGlobalCurrency Amount in Global Currency
PlanAmountInGlobalCurrency Amount in Global Currency
CmtmtCostInGlobalCurrency Amount in Global Currency
💲 Transaction Currency (TransactionCurrency):
OrderPlngCat1AmtInTransCrcy Amount in Transaction Currency
OrderPlngCat2AmtInTransCrcy Amount in Transaction Currency
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
OrderPlngCat1AmtInCoCodeCrcy Amount in Company Code Currency
OrderPlngCat2AmtInCoCodeCrcy Amount in Company Code Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
OrderPlngCat1AmtInFDCrcy1 Amount in Freely Defined Currency 1
OrderPlngCat2AmtInFDCrcy1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
ActualAmountInFreeDfndCrcy1 Amount in Freely Defined Currency 1
PlanAmountInFreeDefinedCrcy1 Amount in Freely Defined Currency 1
CmtmtCostInFreeDefinedCrcy1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
OrderPlngCat1AmtInFDCrcy2 Amount in Freely Defined Currency 2
OrderPlngCat2AmtInFDCrcy2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
ActualAmountInFreeDfndCrcy2 Amount in Freely Defined Currency 2
PlanAmountInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
CmtmtCostInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
OrderPlngCat1AmtInFDCrcy3 Amount in Freely Defined Currency 3
OrderPlngCat2AmtInFDCrcy3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
ActualAmountInFreeDfndCrcy3 Amount in Freely Defined Currency 3
PlanAmountInFreeDefinedCrcy3 Amount in Freely Defined Currency 3
CmtmtCostInFreeDefinedCrcy3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
OrderPlngCat1AmtInFDCrcy4 Amount in Freely Defined Currency 4
OrderPlngCat2AmtInFDCrcy4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
ActualAmountInFreeDfndCrcy4 Amount in Freely Defined Currency 4
PlanAmountInFreeDefinedCrcy4 Amount in Freely Defined Currency 4
CmtmtCostInFreeDefinedCrcy4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
OrderPlngCat1AmtInFDCrcy5 Amount in Freely Defined Currency 5
OrderPlngCat2AmtInFDCrcy5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
ActualAmountInFreeDfndCrcy5 Amount in Freely Defined Currency 5
PlanAmountInFreeDefinedCrcy5 Amount in Freely Defined Currency 5
CmtmtCostInFreeDefinedCrcy5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
OrderPlngCat1AmtInFDCrcy6 Amount in Freely Defined Currency 6
OrderPlngCat2AmtInFDCrcy6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
ActualAmountInFreeDfndCrcy6 Amount in Freely Defined Currency 6
PlanAmountInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
CmtmtCostInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
OrderPlngCat1AmtInFDCrcy7 Amount in Freely Defined Currency 7
OrderPlngCat2AmtInFDCrcy7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
ActualAmountInFreeDfndCrcy7 Amount in Freely Defined Currency 7
PlanAmountInFreeDefinedCrcy7 Amount in Freely Defined Currency 7
CmtmtCostInFreeDefinedCrcy7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
OrderPlngCat1AmtInFDCrcy8 Amount in Freely Defined Currency 8
OrderPlngCat2AmtInFDCrcy8 Amount in Freely Defined Currency 8
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
ActualAmountInFreeDfndCrcy8 Amount in Freely Defined Currency 8
PlanAmountInFreeDefinedCrcy8 Amount in Freely Defined Currency 8
CmtmtCostInFreeDefinedCrcy8 Amount in Freely Defined Currency 8
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
MaintenanceOrderIsSelected Boolean Variable (X = True, - = False, Space = Unknown) Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
IsCommitment Indicator: Is Commitment Show values
IsSettled PS Cost Consider Settlements Show values
Column Name Description Domain name
FinancialPlanningEntryItem Financial Planning Entry Item RSNUMRECORD
PlanningCategory Plan Category FCOM_CATEGORY
SemanticTag Semantic Tag of a Hierarchy Node FINS_SEM_TAG
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
Project Project Number (External) Edited PS_PSPID_EDIT
ProjectUUID Entity Guid /S4PPM/GUID
ProjectDescription Project Name TEXT40
ProjectInternalID Project (internal) PS_S4_PROJ_PSPNR
WBSElement Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
WBSDescription WBS Element Name TEXT40
BusinessPartnerFullName Full Name of Person TEXT80
BusinessPartnerUUID null
UserDescription User Description
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
PlanningCategory1 Plan Category FCOM_CATEGORY
PlanningCategory2 Plan Category FCOM_CATEGORY
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.BUSINESSAREA == TGSB.GSBER
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.COMPANYCODE == T001.BUKRS
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TKA01.MANDT
CO Object Currency
  • CO Object Currency
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCURC.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.FISCALYEARVARIANT == T009.PERIV
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == T009.MANDT
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCURC.MANDT
  • I_PROJECTCOSTLINEITEMSCUBE.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.FREEDEFINEDCURRENCY5 == TCURC.WAERS
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 6
  • Freely Defined Currency 6
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.FREEDEFINEDCURRENCY6 == TCURC.WAERS
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCURC.MANDT
  • I_PROJECTCOSTLINEITEMSCUBE.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • Company Code
  • G/L Account
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.COMPANYCODE == SKB1.BUKRS
  • I_PROJECTCOSTLINEITEMSCUBE.GLACCOUNT == SKB1.SAKNR
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCURC.MANDT
  • I_PROJECTCOSTLINEITEMSCUBE.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Order ID
  • Order ID
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.ORDERID == AUFK.AUFNR
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == AUFK.MANDT
Profit Center
  • Profit Center
  • Profit Center
  • Controlling Area
  • Client
  • ?
  • I_PROJECTCOSTLINEITEMSCUBE.WBSELEMENTPROFITCENTER == CEPC.PRCTR
  • I_PROJECTCOSTLINEITEMSCUBE.PROFITCENTER == CEPC.PRCTR
  • I_PROJECTCOSTLINEITEMSCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == CEPC.MANDT
  • I_PROJECTCOSTLINEITEMSCUBE.[column in domain "DATBI"] == CEPC.DATBI
Project Category
  • Client
  • Project Category
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == DPR_PRO_CATEG.CLIENT
  • I_PROJECTCOSTLINEITEMSCUBE.PROJECTCATEGORY == DPR_PRO_CATEG.PRO_CATEGORY
Profile ID for project structure
  • Client
  • Project Profile
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCJ41.MANDT
  • I_PROJECTCOSTLINEITEMSCUBE.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Project type
  • Project Type
  • Client
  • I_PROJECTCOSTLINEITEMSCUBE.PROJECTTYPE == TCJ1.PRART
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCJ1.MANDT
Responsible cost center
  • Responsible Cost Center
  • Client
  • ?
  • ?
  • I_PROJECTCOSTLINEITEMSCUBE.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == CSKS.MANDT
  • I_PROJECTCOSTLINEITEMSCUBE.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_PROJECTCOSTLINEITEMSCUBE.[column in domain "DATBI"] == CSKS.DATBI
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Transaction Currency
  • Client
  • Transaction Currency
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == TCURC.MANDT
  • I_PROJECTCOSTLINEITEMSCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
Profit Center
  • Profit Center
  • Profit Center
  • Client
  • ?
  • ?
  • I_PROJECTCOSTLINEITEMSCUBE.WBSELEMENTPROFITCENTER == CEPC.PRCTR
  • I_PROJECTCOSTLINEITEMSCUBE.PROFITCENTER == CEPC.PRCTR
  • I_PROJECTCOSTLINEITEMSCUBE.MANDT == CEPC.MANDT
  • I_PROJECTCOSTLINEITEMSCUBE.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_PROJECTCOSTLINEITEMSCUBE.[column in domain "DATBI"] == CEPC.DATBI