P_ENTERPRISEPROJECTCOSTS

CDS View

Project Cost Line Items

P_ENTERPRISEPROJECTCOSTS is a CDS View in S/4HANA. Project Cost Line Items. It contains 80 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 80 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_EnterpriseProjectCosts view from COMPOSITE Costs for Enterprise Projects
P_EntProjCostDates view from COMPOSITE Project Cost Start and End Dates
P_ProjectActualCostDates view from COMPOSITE Dates based on Project Actual Costs
P_ProjectCostSum view from COMPOSITE Project Total Actual Costs
P_PROJECTFINBUDGETSMMRY view from COMPOSITE Project Financial Budget Summary
P_ProjectPlanCostDates view from COMPOSITE Dates based on Project Actual Costs

Fields (80)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY ActualPlanJournalEntryItem ActualPlanJournalEntryItem 2
KEY CompanyCode CompanyCode 2
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket 2
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc 2
KEY FiscalYear FiscalYear 4
KEY Ledger Ledger 2
KEY ProjectInternalID ProjectInternalID 6
KEY ProjectUUID ProjectUUID 2
KEY SourceLedger SourceLedger 2
AccountingDocCreatedByUser AccountingDocCreatedByUser 1
ActlCostInProjCrcy ActlCostInProjCrcy 2
ActualAmountInGlobalCurrency ActualAmountInGlobalCurrency 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInGlobalCurrency AmountInGlobalCurrency 2
AmountInObjectCurrency AmountInObjectCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
AvailabilityControlIsActive AvailabilityControlIsActive 2
AvailabilityControlProfile AvailabilityControlProfile 2
AvailyCtrlTimeRangeType AvailyCtrlTimeRangeType 2
BudgetCurrencyRole BudgetCurrencyRole 2
BusinessArea BusinessArea 1
BusinessTransactionType BusinessTransactionType 1
ChartOfAccounts ChartOfAccounts 1
CmtmtCostInGlobalCurrency CmtmtCostInGlobalCurrency 1
CmtmtCostInProjCrcy CmtmtCostInProjCrcy 1
CompanyCodeCurrency CompanyCodeCurrency 1
ControllingArea ControllingArea 2
ControllingDebitCreditCode ControllingDebitCreditCode 1
ControllingObjectCurrency ControllingObjectCurrency 1
CostCenter CostCenter 1
CostCtrActivityType CostCtrActivityType 1
CreationDate CreationDate 2
DebitCreditCode DebitCreditCode 1
FinancialPlanningEntryItem FinancialPlanningEntryItem 1
FiscalPeriod FiscalPeriod 3
FiscalYearPeriod FiscalYearPeriod 1
FiscalYearVariant FiscalYearVariant 1
FunctionalArea FunctionalArea 2
GLAccount GLAccount 1
GlobalCurrency GlobalCurrency 2
IsCommitment IsCommitment 1
IsSettled IsSettled 2
LedgerFiscalYear LedgerFiscalYear 1
LedgerGLLineItem LedgerGLLineItem 1
PartnerOrder PartnerOrder 1
PartnerOrderCategory PartnerOrderCategory 1
PartnerProject PartnerProject 1
PartnerWBSElement PartnerWBSElement 1
PlanAmountInGlobalCurrency BaselineAmtInGlobalCrcy,PlanAmountInGlobalCurrency 1
PlannedEndDate PlannedEndDate 2
PlannedStartDate PlannedStartDate 2
PlanningCategory PlanningCategory 2
Plant Plant 2
PlndCostAmtInProjCrcy PlndCostAmtInProjCrcy 1
PostingDate PostingDate 2
ProcessingStatus ProcessingStatus 2
ProfitCenter ProfitCenter 2
Project Project 5
ProjectCategory ProjectCategory 2
ProjectDescription ProjectDescription 2
ProjectObject ProjectObject 2
ProjectObjectNode ProjectObjectNode 1
ProjectProfileCode ProjectProfileCode 2
ProjectSummaryTaskUUID ProjectSummaryTaskUUID 2
ProjectType ProjectType 2
ResponsibleCostCenter ResponsibleCostCenter 2
SemanticTag SemanticTag 2
SourceLogicalSystem SourceLogicalSystem 1
SourceReferenceDocSubitem SourceReferenceDocSubitem 1
SourceReferenceDocument SourceReferenceDocument 1
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt 1
SourceReferenceDocumentItem SourceReferenceDocumentItem 1
SourceReferenceDocumentType SourceReferenceDocumentType 1
TaskUUID TaskUUID 1
TransactionCurrency TransactionCurrency 1
WBSDescription WBSDescription 1
WBSElement WBSElement 1
WBSElementInternalID WBSElementInternalID 1
WBSElementProfitCenter WBSElementProfitCenter 1 
@AbapCatalog.sqlViewName: 'PENTPRJCOST'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
define view P_EnterpriseProjectCosts
  as select from P_EnterpriseProjectCostsUnion as ProjCstLineItm
  association [0..1] to I_FiscalPeriodForVariant   as _FiscalPeriod on  _FiscalPeriod.FiscalYear        = $projection.LedgerFiscalYear
                                                                    and _FiscalPeriod.FiscalPeriod      = $projection.FiscalPeriod
                                                                    and _FiscalPeriod.FiscalYearVariant = $projection.FiscalYearVariant

  association [0..1] to I_EnterpriseProjectElement as _PPMTask      on  _PPMTask.WBSElementInternalID = $projection.WBSElementInternalID
{
  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.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.ProjectType,
      ProjCstLineItm.SemanticTag,
      ProjCstLineItm.ProjectSummaryTaskUUID,
      ProjCstLineItm.ProjectUUID,
      ProjCstLineItm.ControllingArea,

      ProjCstLineItm.ProcessingStatus,
      ProjCstLineItm.Project,
      ProjCstLineItm.ProjectInternalID,
      ProjCstLineItm.WBSElement,
      ProjCstLineItm.ResponsibleCostCenter,
      ProjCstLineItm.ProjectDescription,
      ProjCstLineItm.ProjectProfileCode,

      ProjCstLineItm.ProjectObject,
      ProjCstLineItm.AvailabilityControlProfile,
      ProjCstLineItm.AvailabilityControlIsActive,
      ProjCstLineItm.AvailyCtrlTimeRangeType,
      ProjCstLineItm.BudgetCurrencyRole,

      ProjCstLineItm.WBSElementInternalID, //CE1908

      // CE2402: Required Fields for AO /s4ppm/pr1:- start

      ProjCstLineItm.Plant,
      // CE2402: Required Fields for AO /s4ppm/pr1:- end

      _PPMTask.ProjectElementUUID                as TaskUUID, //CE1908


      //'' as TaskUUID,

      ProjCstLineItm.CreationDate,
      ProjCstLineItm.FunctionalArea,
      ProjCstLineItm.CostCtrActivityType,

      @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,

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

 
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
  // Begin of Change For EPPM Release 25O2    

      case
         when  PlanningCategory <> 'PREDICT01'
           and PlanningCategory <> 'PREDICT02'
           and PlanningCategory <> 'PREDICT03'
             then ProjCstLineItm.PlndCostAmtInProjCrcy
         else 0
      end    as PlndCostAmtInProjCrcy,    
      //ProjCstLineItm.PlndCostAmtInProjCrcy,

// End of Change For EPPM Release 25O2  


      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      // Begin of Change For EPPM Release 25O2

      case
        when  PlanningCategory <> 'PREDICT01'
          and PlanningCategory <> 'PREDICT02'
          and PlanningCategory <> 'PREDICT03'
            then ProjCstLineItm.PlanAmountInGlobalCurrency
        else 0
      end  as PlanAmountInGlobalCurrency,       
      //ProjCstLineItm.PlanAmountInGlobalCurrency,

// End of Change For EPPM Release 25O2    


      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
// Begin of Change For EPPM Release 25O2      

      case
        when  PlanningCategory <> 'PREDICT01'
          and PlanningCategory <> 'PREDICT02'
          and PlanningCategory <> 'PREDICT03'
            then ProjCstLineItm.PlanAmountInGlobalCurrency
        else 0
      end    as BaselineAmtInGlobalCrcy,
     
      //ProjCstLineItm.PlanAmountInGlobalCurrency as BaselineAmtInGlobalCrcy,

// End of Change For EPPM Release 25O2 

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

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
      ProjCstLineItm.CmtmtCostInProjCrcy,

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

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }

//      ProjCstLineItm.ActlCmtmtCumltvAmtInGlobCrcy,



      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
      ProjCstLineItm.AssgdValForBudgetInProjCrcy,
      
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      @DefaultAggregation: #SUM
      case
          when  PlanningCategory = 'PREDICT01' and AmountInGlobalCurrency > 0
              then AmountInGlobalCurrency
          else 0
      end                                                         as PredictedAmtInGlobalCurrency,

      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      @DefaultAggregation: #SUM
      case
          when  PlanningCategory = 'PREDICT02' and AmountInGlobalCurrency > 0
              then AmountInGlobalCurrency
          else 0
      end                                                         as LowerPredictionAmtInGlobCrcy,

      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      @DefaultAggregation: #SUM
      case
          when  PlanningCategory = 'PREDICT03'
              then AmountInGlobalCurrency
          else 0
      end                                                         as UpperPredictionAmtInGlobCrcy,
      
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      @DefaultAggregation: #SUM
      case
          when  PlanningCategory = 'CMTMT' or PlanningCategory = 'ACT01'
              then AmountInGlobalCurrency
          else 0
      end                                                         as ActlCmtmtCumltvAmtInGlobCrcy,  
      
      ProjCstLineItm.ProjectCategory,
      ProjCstLineItm.PlannedStartDate,
      ProjCstLineItm.PlannedEndDate,
      ProjCstLineItm.PlanningCategory,
      ProjCstLineItm.PostingDate,
      ProjCstLineItm.FiscalPeriod,
      ProjCstLineItm.FiscalYearPeriod,
      ProjCstLineItm.FiscalYearVariant,
      ProjCstLineItm.IsSettled,

      ProjCstLineItm.SourceReferenceDocumentType,
      ProjCstLineItm.SourceLogicalSystem,
      ProjCstLineItm.SourceReferenceDocumentCntxt,
      ProjCstLineItm.SourceReferenceDocument,
      ProjCstLineItm.SourceReferenceDocumentItem,
      ProjCstLineItm.SourceReferenceDocSubitem,
      ProjCstLineItm.IsCommitment,

      _FiscalPeriod
      //_maintorder


}

Learn More