I_ProjectCostLineItemsByPeriod

Project Cost Line Items by Period | view: IPROCSTLITMPERD | Extraction: Not supported | Component: VDM views for Costs
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
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
FinancialPlanningEntryItem Financial Planning Entry Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
BudgetAmountInTransactionCrcy Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
BudgetAmountInCompanyCodeCrcy Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
ActualAmountInGlobalCurrency Amount in Global Currency
PlanAmountInGlobalCurrency Amount in Global Currency
CmtmtCostInGlobalCurrency Amount in Global Currency
BudgetInGlobalCrcy Amount in Global Currency
AccmltdAvailBdgtInGlobalCrcy Amount in Global Currency
💲 Functional Currency (FunctionalCurrency):
ActualAmountInFunctionalCrcy Amount in Functional Currency
CmtmtAmountInFunctionalCrcy Amount in Functional Currency
PlanAmountInFunctionalCurrency Amount in Functional Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
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):
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):
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):
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):
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):
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):
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):
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
💲 CO Object Currency (ControllingObjectCurrency):
ActlCostInProjCrcy Amount in Object Currency
PlndCostAmtInProjCrcy Amount in CO Object Currency
CmtmtCostInProjCrcy Amount in CO Object Currency
BudgetInProjCrcy Amount in Object Currency
AmountInObjectCurrency Amount in Object Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
MaintenanceOrderIsSelected Boolean Variable (X = True, - = False, Space = Unknown) Show values
AvailyCtrlTimeRangeType Budget Availability Control: Time Range Show values
BudgetCurrencyRole Budget Availability Control: Budget Currency Type Show values
PartnerOrderCategory Partner Order Category Show values
DebitCreditCode Debit/Credit Code Show values
IsSettled PS Cost Consider Settlements Show values
IsCommitment Indicator: Is Commitment Show values
Column Name Description Domain name
ProjectInternalID Project (internal) PS_S4_PROJ_PSPNR
GLAccount G/L Account SAKNR
PlanningCategory1 Plan Category FCOM_CATEGORY
PlanningCategory2 Plan Category FCOM_CATEGORY
Project Project Number (External) Edited PS_PSPID_EDIT
ProjectDescription Project Name TEXT40
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
WBSElement Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
WBSDescription WBS Element Name TEXT40
UserDescription User Description
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
PlanningCategory Plan Category FCOM_CATEGORY
PartnerWBSElement Partner WBS Element FIS_WBS_NO_CONV
PartnerProject Partner Project FIS_PROJECT_NO_CONV
SemanticTag Semantic Tag of a Hierarchy Node FINS_SEM_TAG
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
ProjectUUID Entity Guid /S4PPM/GUID
TaskUUID Entity Guid /S4PPM/GUID
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TGSB.MANDT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.BUSINESSAREA == TGSB.GSBER
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == T004.MANDT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • I_PROJECTCOSTLINEITEMSBYPERIOD.COMPANYCODE == T001.BUKRS
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCURC.MANDT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • I_PROJECTCOSTLINEITEMSBYPERIOD.CONTROLLINGAREA == TKA01.KOKRS
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TKA01.MANDT
CO Object Currency
  • Client
  • CO Object Currency
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCURC.MANDT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_PROJECTCOSTLINEITEMSBYPERIOD.FISCALYEARVARIANT == T009.PERIV
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == T009.MANDT
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • I_PROJECTCOSTLINEITEMSBYPERIOD.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCURC.MANDT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • I_PROJECTCOSTLINEITEMSBYPERIOD.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • I_PROJECTCOSTLINEITEMSBYPERIOD.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • I_PROJECTCOSTLINEITEMSBYPERIOD.FREEDEFINEDCURRENCY5 == TCURC.WAERS
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCURC.MANDT
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCURC.MANDT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCURC.MANDT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCURC.MANDT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Currency
  • Client
  • Functional Currency
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCURC.MANDT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.FUNCTIONALCURRENCY == TCURC.WAERS
Global Currency
  • Client
  • Global Currency
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCURC.MANDT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • I_PROJECTCOSTLINEITEMSBYPERIOD.LEDGER == FINSC_LEDGER.RLDNR
  • I_PROJECTCOSTLINEITEMSBYPERIOD.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == FINSC_LEDGER.MANDT
Order ID
  • Client
  • Order ID
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == AUFK.MANDT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.ORDERID == AUFK.AUFNR
Partner Order
  • Client
  • Partner Order
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == AUFK.MANDT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.PARTNERORDER == AUFK.AUFNR
Profit Center
  • Controlling Area
  • ?
  • Profit Center
  • Profit Center
  • Client
  • I_PROJECTCOSTLINEITEMSBYPERIOD.CONTROLLINGAREA == CEPC.KOKRS
  • I_PROJECTCOSTLINEITEMSBYPERIOD.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROJECTCOSTLINEITEMSBYPERIOD.WBSELEMENTPROFITCENTER == CEPC.PRCTR
  • I_PROJECTCOSTLINEITEMSBYPERIOD.PROFITCENTER == CEPC.PRCTR
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == CEPC.MANDT
Project Category
  • Client
  • Project Category
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == DPR_PRO_CATEG.CLIENT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.PROJECTCATEGORY == DPR_PRO_CATEG.PRO_CATEGORY
Profile ID for project structure
  • Project Profile
  • Client
  • I_PROJECTCOSTLINEITEMSBYPERIOD.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCJ41.MANDT
Responsible cost center
  • ?
  • Responsible Cost Center
  • ?
  • Client
  • I_PROJECTCOSTLINEITEMSBYPERIOD.[column in domain "DATBI"] == CSKS.DATBI
  • I_PROJECTCOSTLINEITEMSBYPERIOD.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_PROJECTCOSTLINEITEMSBYPERIOD.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == CSKS.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == FINSC_LEDGER.MANDT
  • I_PROJECTCOSTLINEITEMSBYPERIOD.LEDGER == FINSC_LEDGER.RLDNR
  • I_PROJECTCOSTLINEITEMSBYPERIOD.SOURCELEDGER == FINSC_LEDGER.RLDNR
Source Logical System I_PROJECTCOSTLINEITEMSBYPERIOD.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type I_PROJECTCOSTLINEITEMSBYPERIOD.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Transaction Currency
  • Client
  • I_PROJECTCOSTLINEITEMSBYPERIOD.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == TCURC.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • Profit Center
  • Client
  • I_PROJECTCOSTLINEITEMSBYPERIOD.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_PROJECTCOSTLINEITEMSBYPERIOD.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROJECTCOSTLINEITEMSBYPERIOD.WBSELEMENTPROFITCENTER == CEPC.PRCTR
  • I_PROJECTCOSTLINEITEMSBYPERIOD.PROFITCENTER == CEPC.PRCTR
  • I_PROJECTCOSTLINEITEMSBYPERIOD.MANDT == CEPC.MANDT