P_EngmntProjSupEmplDelivOrg

DDL: P_ENGMNTPROJSUPEMPLDELIVORG SQL: PEPSUPEMPDELORG Type: view COMPOSITE

P_EngmntProjSupEmplDelivOrg is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_EngmntProjectPlnDataVersion) and exposes 25 fields.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
I_EngmntProjectPlnDataVersion B inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PEPSUPEMPDELORG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (25)

KeyFieldSource TableSource FieldDescription
EngagementProject I_EngmntProjectPlnDataVersion EngagementProject
WorkPackage I_EngmntProjectPlnDataVersion WorkPackage
ResourceDemandUUID I_EngmntProjectPlnDataVersion ResourceDemandUUID
ResourceDemand I_EngmntProjectPlnDataVersion ResourceDemand
EngmtProjFinPlanVersion I_EngmntProjectPlnDataVersion EngmtProjFinPlanVersion
EngagementProjectServiceOrg I_EngmntProjectPlnDataVersion EngagementProjectServiceOrg
CustomerProjectServiceOrg A EngagementProjectServiceOrg
IsMyProject A IsMyProject
EngmntProjReviewYearPeriod A EngmntProjReviewYearPeriod
EngagementProjectReviewStatus A EngagementProjectReviewStatus
ProjectManagerExternalID A ProjectManagerExternalID
ProjectAccountantExternalID A ProjectAccountantExternalID
ProjectControllerExternalID A ProjectControllerExternalID
ProjectPartnerExternalID A ProjectPartnerExternalID
EngagementProjectCategory A EngagementProjectCategory
EngagementProjectType A EngagementProjectType
Customer A Customer
ProjectVisibility A ProjectVisibility
EngagementProjectStage A EngagementProjectStage
EngagementProjectCostCenter A EngagementProjectCostCenter
EngmntProjectHeaderCompanyCode A EngmntProjectHeaderCompanyCode
ProfitCenter A ProfitCenter
ProjectProfileCode A ProjectProfileCode
ControllingArea A ControllingArea
LastChangeDateTime A LastChangeDateTime 
@AbapCatalog.sqlViewName: 'PEPSUPEMPDELORG'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
//@EndUserText.label: 'Engagement Project Supply Employee Delivery Organization'

define view P_EngmntProjSupEmplDelivOrg 
  as select distinct from I_EngmntProjAssgmtToSessionUsr as A
    inner join I_EngmntProjectPlnDataVersion as B on A.EngagementProject = B.EngagementProject {
      B.EngagementProject,
      B.WorkPackage,
      B.ResourceDemandUUID,
      B.ResourceDemand,     
      B.EngmtProjFinPlanVersion,
      B.EngagementProjectServiceOrg,
      
      A.EngagementProjectServiceOrg as CustomerProjectServiceOrg,
      A.IsMyProject,
      A.EngmntProjReviewYearPeriod,
      A.EngagementProjectReviewStatus,
      A.ProjectManagerExternalID,
      A.ProjectAccountantExternalID,
      A.ProjectControllerExternalID,
      A.ProjectPartnerExternalID,
      A.EngagementProjectCategory,
      A.EngagementProjectType,
      A.Customer,
      A.ProjectVisibility,
      A.EngagementProjectStage,
      A.EngagementProjectCostCenter,
      A.EngmntProjectHeaderCompanyCode,
      A.ProfitCenter,
      A.ProjectProfileCode,
      A.ControllingArea,
      A.LastChangeDateTime
}
where
  EngmntProjPlanLineType = 'S' and
  EngmtProjFinPlanVersion = '1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGMNTPROJASSGMTTOSESSIONUSR",
"I_ENGMNTPROJECTPLNDATAVERSION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More