P_EngmtProjDeliveryOrg

DDL: P_ENGMTPROJDELIVERYORG SQL: PEPDELIVERYORG Type: view COMPOSITE

P_EngmtProjDeliveryOrg is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_EngagementProjectSrvcOrg) and exposes 4 fields with key field EngagementProjectServiceOrg. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_EngagementProjectSrvcOrg EngmtProjDeliveryOrg from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EngagementProjectSrvcOrgDets _EngagementProjectSrvcOrgDets EngmtProjDeliveryOrg.EngagementProjectServiceOrg = _EngagementProjectSrvcOrgDets.EngagementProjectServiceOrg

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PEPDELIVERYORG view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY EngagementProjectServiceOrg I_EngagementProjectSrvcOrg EngagementProjectServiceOrg
ControllingArea
CompanyCode
CostCenter 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PEPDELIVERYORG'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_EngmtProjDeliveryOrg
  as select from I_EngagementProjectSrvcOrg as EngmtProjDeliveryOrg
  //  association [0..1] to P_DeliveryOrg2                 as delvorg                       on delvorg.EngagementProjectServiceOrg = $projection.EngagementProjectServiceOrg

  association [0..1] to I_EngagementProjectSrvcOrgDets as _EngagementProjectSrvcOrgDets on EngmtProjDeliveryOrg.EngagementProjectServiceOrg = _EngagementProjectSrvcOrgDets.EngagementProjectServiceOrg


{
  key EngmtProjDeliveryOrg.EngagementProjectServiceOrg                                               as EngagementProjectServiceOrg,

      _EngagementProjectSrvcOrgDets[1: AssignedOrganisationType = 'CA' ].AssignedOrganisation        as ControllingArea,
      _EngagementProjectSrvcOrgDets[1: AssignedOrganisationType = 'CC' ].AssignedOrganisation        as CompanyCode,
      _EngagementProjectSrvcOrgDets[1: AssignedOrganisationType = 'CS' ].AssignedOrganisation        as CostCenter

}
where
  EngmtProjDeliveryOrg.EngmtProjServiceOrgIsDelivery = 'X'

Learn More