P_EngmtProjBillingItems

DDL: P_ENGMTPROJBILLINGITEMS SQL: PEPBILLING Type: view BASIC Package: CPD_CDS

Engagement Project Billing Items

P_EngmtProjBillingItems is a Basic CDS View that provides data about "Engagement Project Billing Items" in SAP S/4HANA. It reads from 2 data sources (I_EngagementProject, I_WorkPackage) and exposes 12 fields. Part of development package CPD_CDS.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_EngagementProject A from
I_WorkPackage C left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PEPBILLING view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (12)

KeyFieldSource TableSource FieldDescription
EngagementProject I_EngagementProject EngagementProject
EngagementProjectName I_EngagementProject EngagementProjectName
EngagementProjectCategory I_EngagementProject EngagementProjectCategory
EngagementProjectUUID I_EngagementProject EngagementProjectUUID
EngagementProjectStage I_EngagementProject EngagementProjectStage
EngagementProjectType I_EngagementProject EngagementProjectType
EngagementProjectServiceOrg I_EngagementProject EngagementProjectServiceOrg
Customer I_EngagementProject Customer
CustomerName
EngagementProjFinPlanUUID I_WorkPackage EngagementProjFinPlanUUID
SalesOrder I_WorkPackage SalesOrder
SalesOrderItem I_WorkPackage SalesOrderItem 
@AbapCatalog.sqlViewName: 'PEPBILLING'
@VDM.viewType: #BASIC
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_EngmtProjBillingItems
  as select from           I_EngagementProject           as A
    left outer to one join I_EngagementProjFinancialPlan as B on A.EngagementProjectUUID = B.EngagementProjectUUID
    left outer join        I_WorkPackage                 as C on B.EngagementProjFinPlanUUID = C.EngagementProjFinPlanUUID
{

  A.EngagementProject           as EngagementProject,
  A.EngagementProjectName       as EngagementProjectName,
  A.EngagementProjectCategory   as EngagementProjectCategory,
  A.EngagementProjectUUID       as EngagementProjectUUID,
  A.EngagementProjectStage      as EngagementProjectStage,
  A.EngagementProjectType       as EngagementProjectType,
  A.EngagementProjectServiceOrg as EngagementProjectServiceOrg,
  A.Customer                    as Customer,
  A._Customer.CustomerName      as CustomerName,
  C.EngagementProjFinPlanUUID   as EngagementProjFinPlanUUID,
  C.SalesOrder                  as SalesOrder,
  C.SalesOrderItem              as SalesOrderItem
}

Learn More