P_EngmtProjBillingItems

DDL: P_ENGMTPROJBILLINGITEMS SQL: PEPBILLING Type: view BASIC

P_EngmtProjBillingItems is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_EngagementProject, I_WorkPackage) and exposes 12 fields.

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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_ENGAGEMENTPROJECT",
"I_ENGAGEMENTPROJFINANCIALPLAN",
"I_WORKPACKAGE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More