Which CDS Views use P_PROJECTCOSTLINEITEMS?

P_PROJECTCOSTLINEITEMS is used by 3 CDS view(s), including: I_ProjectCostLineItems, P_PPM_ProjectCostLineItem, P_ProjFinSmmryLnItems.

How many fields does P_PROJECTCOSTLINEITEMS have?

P_PROJECTCOSTLINEITEMS has 25 fields. Key fields: AccountingDocument, ActualPlanJournalEntryItem, FinancialPlanningDataPacket, FinancialPlanningReqTransSqnc, FiscalYear, Ledger, Project, SourceLedger.

P_PROJECTCOSTLINEITEMS

CDS View

P_PROJECTCOSTLINEITEMS is a CDS View in S/4HANA. It contains 25 fields. 3 CDS views read from this table.

CDS Views using this table (3)

View	Type	Join	VDM	Description
I_ProjectCostLineItems	view	from	COMPOSITE	Project Cost Line Items
P_PPM_ProjectCostLineItem	view	from	COMPOSITE
P_ProjFinSmmryLnItems	view	inner	COMPOSITE

Fields (25)

Key	Field	CDS Fields	Used in Views
KEY	AccountingDocument	AccountingDocument	1
KEY	ActualPlanJournalEntryItem	ActualPlanJournalEntryItem	1
KEY	FinancialPlanningDataPacket	FinancialPlanningDataPacket	1
KEY	FinancialPlanningReqTransSqnc	FinancialPlanningReqTransSqnc	1
KEY	FiscalYear	FiscalYear	1
KEY	Ledger	Ledger	1
KEY	Project	Project	2
KEY	SourceLedger	SourceLedger	1
	AmountInGlobalCurrency	AmountInGlobalCurrency	1
	AmountInObjectCurrency	AmountInObjectCurrency	1
	ControllingObjectCurrency	ControllingObjectCurrency	1
	CreationDate	CreationDate	1
	FiscalPeriod	FiscalPeriod	1
	FiscalYearPeriod	FiscalYearPeriod	1
	FiscalYearVariant	FiscalYearVariant	1
	GLAccountHierarchy	GLAccountHierarchy	1
	GlobalCurrency	GlobalCurrency	1
	IsSettled	IsSettled	1
	PartnerAccountAssignmentType	PartnerAccountAssignmentType	1
	PlanningCategory	PlanningCategory	1
	PostingDate	PostingDate	1
	ProjectInternalID	ProjectInternalID	2
	ProjectType	ProjectType	2
	SemanticTag	SemanticTag	2
	WBSElementInternalID	WBSElementInternalID	2

@AbapCatalog.sqlViewName: 'PPROJCOSTLINITM'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.preserveKey:true
define view P_ProjectCostLineItems
  as select from P_ProjCostLineItemUnion as _ProjCstLineItm
  association [0..1] to I_EnterpriseProjectElement     as _PPMTask      on  _PPMTask.WBSElementInternalID = $projection.WBSElementInternalID
  association [0..1] to I_FiscalYearPeriodForCmpnyCode as _FiscalPeriod on  $projection.FiscalYear   = _FiscalPeriod.FiscalYear
                                                                        and $projection.FiscalPeriod = _FiscalPeriod.FiscalPeriod
                                                                        and $projection.CompanyCode  = _FiscalPeriod.CompanyCode

{
  key _ProjCstLineItm.SourceLedger,
  key _ProjCstLineItm.Ledger,
  key _ProjCstLineItm.CompanyCode,
  key _ProjCstLineItm.FiscalYear,
  key _ProjCstLineItm.AccountingDocument,
  key _ProjCstLineItm.FinancialPlanningReqTransSqnc,
  key _ProjCstLineItm.FinancialPlanningDataPacket,
  key _ProjCstLineItm.ActualPlanJournalEntryItem,
      _ProjCstLineItm.GLAccountHierarchy,
      _ProjCstLineItm.LedgerFiscalYear,
      _ProjCstLineItm.LedgerGLLineItem,
      _ProjCstLineItm.FinancialPlanningEntryItem,
      _ProjCstLineItm.GLAccount,
      _ProjCstLineItm.ChartOfAccounts,
      _ProjCstLineItm.AccountingDocCreatedByUser,
      _ProjCstLineItm.BusinessArea,
      _ProjCstLineItm.CostCenter,
      //Sending Partner fields

      _ProjCstLineItm.PartnerOrder,
      _ProjCstLineItm.PartnerOrderCategory,
      _ProjCstLineItm.PartnerWBSElement,
      _ProjCstLineItm.PartnerProject,
      _ProjCstLineItm.BusinessTransactionType,
      _ProjCstLineItm.DebitCreditCode,
      _ProjCstLineItm.ControllingDebitCreditCode,

      _ProjCstLineItm.ProfitCenter,
      _ProjCstLineItm.WBSElementProfitCenter,
      _ProjCstLineItm.WBSDescription,
      _ProjCstLineItm.ProjectObjectNode,

      _ProjCstLineItm.ControllingArea,
      _ProjCstLineItm.Project,
      _ProjCstLineItm.ProjectInternalID,
      _ProjCstLineItm.WBSElement,
      _ProjCstLineItm.ResponsibleCostCenter,
// S/4HANA CE2202: Project Type normalization - Begin        

      _ProjCstLineItm.ProjectType,
// S/4HANA CE2202: Project Type normalization - End      

      _ProjCstLineItm.ProjectDescription,
      _ProjCstLineItm.ProjectProfileCode,

      _ProjCstLineItm.ProjectObject,
      _ProjCstLineItm.AvailabilityControlProfile,
      _ProjCstLineItm.AvailabilityControlIsActive,
      _ProjCstLineItm.AvailyCtrlTimeRangeType,
      _ProjCstLineItm.BudgetCurrencyRole,

      _ProjCstLineItm.WBSElementInternalID, //CE1908

      _PPMTask.ProjectElementUUID                as TaskUUID, //CE1908


      //'' as TaskUUID,

      _ProjCstLineItm.CreationDate,
      _ProjCstLineItm.FunctionalArea,
      _ProjCstLineItm.CostCtrActivityType,

      OrderID,
      //2008:fields Specific to PMO integration to cost report-start

      ''                                         as OrderOperation,
      cast( ''  as auftext )                     as MaintenanceOrderDesc,
      cast( ''  as ltxa1 )                       as OperationDescription,
      //S/4HANA CE2108 - Maintenance Order enablement-Begin

      //      cast('' as fcom_category )                 as PlanningCategory1,

      //      cast('' as fcom_category )                 as PlanningCategory2,

      //S/4HANA CE2108 - Maintenance Order enablement-End

      //        OrderOperation,

      //        MaintenanceOrderDesc,

      //        OperationDescription,

      //S/4HANA CE2108 - Maintenance Order enablement-Begin

      _ProjCstLineItm.PlanningCategory1,
      _ProjCstLineItm.PlanningCategory2,
      //S/4HANA CE2108 - Maintenance Order enablement-End

      //2008:fields Specific to PMO integration to cost report-end


      //S/4HANA CE2108 - Maintenance Order enablement-Begin

      _ProjCstLineItm.MaintenanceOrderIsSelected,
      _ProjCstLineItm.PartnerAccountAssignmentType,
      //S/4HANA CE2108 - Maintenance Order enablement-End


      @Semantics.currencyCode: true
      _ProjCstLineItm.ControllingObjectCurrency,
      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'ControllingObjectCurrency'
      _ProjCstLineItm.AmountInObjectCurrency,

      @Semantics.currencyCode:true
      _ProjCstLineItm.TransactionCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      _ProjCstLineItm.AmountInTransactionCurrency,

      @Semantics.currencyCode:true
      _ProjCstLineItm.CompanyCodeCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      _ProjCstLineItm.AmountInCompanyCodeCurrency,

      @Semantics.currencyCode:true
      _ProjCstLineItm.GlobalCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      _ProjCstLineItm.AmountInGlobalCurrency,
/*
      // S/4HANA CE2308: Project stock costs enablement - Begin

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      _ProjCstLineItm.PrjStockAmountInGlobalCurrency,
      // S/4HANA CE2308: Project stock costs enablement - End

*/            
      //S/4HANA CE2108 - Inclusion of Functional Currency -Begin

      @Semantics.currencyCode: true
      _ProjCstLineItm.FunctionalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
      _ProjCstLineItm.ActualAmountInFunctionalCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
      _ProjCstLineItm.CmtmtAmountInFunctionalCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
      _ProjCstLineItm.PlanAmountInFunctionalCurrency,

      //S/4HANA CE2108 - Inclusion of Functional Currency -End


      @Semantics.currencyCode:true
      _ProjCstLineItm.FreeDefinedCurrency1,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      _ProjCstLineItm.AmountInFreeDefinedCurrency1,

      @Semantics.currencyCode:true
      _ProjCstLineItm.FreeDefinedCurrency2,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      _ProjCstLineItm.AmountInFreeDefinedCurrency2,

      @Semantics.currencyCode:true
      _ProjCstLineItm.FreeDefinedCurrency3,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      _ProjCstLineItm.AmountInFreeDefinedCurrency3,

      @Semantics.currencyCode:true
      _ProjCstLineItm.FreeDefinedCurrency4,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      _ProjCstLineItm.AmountInFreeDefinedCurrency4,

      @Semantics.currencyCode:true
      _ProjCstLineItm.FreeDefinedCurrency5,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      _ProjCstLineItm.AmountInFreeDefinedCurrency5,

      @Semantics.currencyCode:true
      _ProjCstLineItm.FreeDefinedCurrency6,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      _ProjCstLineItm.AmountInFreeDefinedCurrency6,

      @Semantics.currencyCode:true
      _ProjCstLineItm.FreeDefinedCurrency7,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      _ProjCstLineItm.AmountInFreeDefinedCurrency7,

      @Semantics.currencyCode:true
      _ProjCstLineItm.FreeDefinedCurrency8,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      _ProjCstLineItm.AmountInFreeDefinedCurrency8,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      _ProjCstLineItm.ActualAmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
      _ProjCstLineItm.ActlCostInProjCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      _ProjCstLineItm.ActualAmountInFreeDfndCrcy1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      _ProjCstLineItm.ActualAmountInFreeDfndCrcy2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      _ProjCstLineItm.ActualAmountInFreeDfndCrcy3,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      _ProjCstLineItm.ActualAmountInFreeDfndCrcy4,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      _ProjCstLineItm.ActualAmountInFreeDfndCrcy5,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      _ProjCstLineItm.ActualAmountInFreeDfndCrcy6,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      _ProjCstLineItm.ActualAmountInFreeDfndCrcy7,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      _ProjCstLineItm.ActualAmountInFreeDfndCrcy8,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
      _ProjCstLineItm.PlndCostAmtInProjCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      _ProjCstLineItm.PlanAmountInGlobalCurrency,


      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      _ProjCstLineItm.PlanAmountInFreeDefinedCrcy1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      _ProjCstLineItm.PlanAmountInFreeDefinedCrcy2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      _ProjCstLineItm.PlanAmountInFreeDefinedCrcy3,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      _ProjCstLineItm.PlanAmountInFreeDefinedCrcy4,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      _ProjCstLineItm.PlanAmountInFreeDefinedCrcy5,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      _ProjCstLineItm.PlanAmountInFreeDefinedCrcy6,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      _ProjCstLineItm.PlanAmountInFreeDefinedCrcy7,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      _ProjCstLineItm.PlanAmountInFreeDefinedCrcy8,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      _ProjCstLineItm.PlanAmountInGlobalCurrency as BaselineAmtInGlobalCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      _ProjCstLineItm.CmtmtCostInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      _ProjCstLineItm.CmtmtCostInProjCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      _ProjCstLineItm.CmtmtCostInFreeDefinedCrcy1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      _ProjCstLineItm.CmtmtCostInFreeDefinedCrcy2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      _ProjCstLineItm.CmtmtCostInFreeDefinedCrcy3,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      _ProjCstLineItm.CmtmtCostInFreeDefinedCrcy4,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      _ProjCstLineItm.CmtmtCostInFreeDefinedCrcy5,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      _ProjCstLineItm.CmtmtCostInFreeDefinedCrcy6,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      _ProjCstLineItm.CmtmtCostInFreeDefinedCrcy7,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      _ProjCstLineItm.CmtmtCostInFreeDefinedCrcy8,

      _ProjCstLineItm.PlanningCategory,

      _ProjCstLineItm.PostingDate,
      _ProjCstLineItm.DocumentDate,
      _ProjCstLineItm.FiscalPeriod,
      _ProjCstLineItm.FiscalYearPeriod,
      _ProjCstLineItm.FiscalYearVariant,
      _ProjCstLineItm.IsSettled,

      _ProjCstLineItm.SourceReferenceDocumentType,
      _ProjCstLineItm.SourceLogicalSystem,
      _ProjCstLineItm.SourceReferenceDocumentCntxt,
      _ProjCstLineItm.SourceReferenceDocument,
      _ProjCstLineItm.SourceReferenceDocumentItem,
      _ProjCstLineItm.SourceReferenceDocSubitem,
      _ProjCstLineItm.IsCommitment,
      _FiscalPeriod,
      _ProjCstLineItm.SemanticTag
      //_maintorder


}

Depth:

P_PROJECTCOSTLINEITEMS

CDS Views using this table (3)

Fields (25)

Learn More