I_EngagementProjectSrvcOrgDets

DDL: I_ENGAGEMENTPROJECTSRVCORGDETS SQL: IEPSRVCORGDET Type: view BASIC Package: CPD_CDS

Engagement Project Service Organization Details

I_EngagementProjectSrvcOrgDets is a Basic CDS View that provides data about "Engagement Project Service Organization Details" in SAP S/4HANA. It reads from 1 data source (/cpd/pwsc_orgpid) and exposes 7 fields with key fields EngagementProjectServiceOrg, AssignedOrganisation, AssignedOrganisationType. It has 2 associations to related views. Part of development package CPD_CDS.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
/cpd/pwsc_orgpid /cpd/pwsc_orgpid from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_EngagementProjectSrvcOrg _EngagementProjectServiceOrg $projection.EngagementProjectServiceOrg = _EngagementProjectServiceOrg.EngagementProjectServiceOrg
[0..1] I_CustprojsrvcOrgDetails _CompanyCode $projection.EngagementProjectServiceOrg = _CompanyCode.CustomerProjectServiceOrg and _CompanyCode.AssignedOrganisationIsDefault = 'X' and _CompanyCode.AssignedOrganisationType = 'CC'

Annotations (14)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IEPSRVCORGDET view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.numberOfKeyFields 000 view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Engagement Project Service Organization Details view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY EngagementProjectServiceOrg org_unit_id
KEY AssignedOrganisation org_unit_key
KEY AssignedOrganisationType org_unit_typ
AssignedOrganisationDesc org_unit_key_desc
AssignedOrganisationIsDefault default_val
_CompanyCode _CompanyCode
_EngagementProjectServiceOrg _EngagementProjectServiceOrg 
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IEPSRVCORGDET' 
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType : #BASIC
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@AbapCatalog.buffering.numberOfKeyFields: 000
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@AccessControl.authorizationCheck:#CHECK
@EndUserText.label: 'Engagement Project Service Organization Details'
define view I_EngagementProjectSrvcOrgDets
  as select from /cpd/pwsc_orgpid
  association [0..1] to I_EngagementProjectSrvcOrg as _EngagementProjectServiceOrg on $projection.EngagementProjectServiceOrg = _EngagementProjectServiceOrg.EngagementProjectServiceOrg
  association [0..1] to I_CustprojsrvcOrgDetails   as _CompanyCode                 on  $projection.EngagementProjectServiceOrg    = _CompanyCode.CustomerProjectServiceOrg
                                                                                   and _CompanyCode.AssignedOrganisationIsDefault = 'X'
                                                                                   and _CompanyCode.AssignedOrganisationType      = 'CC'
 {
  key org_unit_id       as EngagementProjectServiceOrg,
  key org_unit_key      as AssignedOrganisation,
  key org_unit_typ      as AssignedOrganisationType,
      org_unit_key_desc as AssignedOrganisationDesc,
      default_val       as AssignedOrganisationIsDefault,
      _CompanyCode,
      _EngagementProjectServiceOrg
}

Learn More