C_EntProjSrvcOrgCntctCard

DDL: C_ENTPROJSRVCORGCNTCTCARD Type: view_entity CONSUMPTION

Contact Card for Ent Proj Service Org

C_EntProjSrvcOrgCntctCard is a Consumption CDS View that provides data about "Contact Card for Ent Proj Service Org" in SAP S/4HANA. It reads from 1 data source (I_EngagementProjectSrvcOrg) and exposes 16 fields with key field EnterpriseProjectServiceOrg. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_EngagementProjectSrvcOrg I_EngagementProjectSrvcOrg from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCodeText $projection.CompanyCode = _CompanyCodeText.CompanyCode
[0..1] I_CostCenterText _DefaultCostCenterText $projection.ServiceOrgDefaultCostCenter = _DefaultCostCenterText.CostCenter and _DefaultCostCenterText.ValidityEndDate >= $session.system_date and _DefaultCostCenterText.ValidityStartDate <= $session.system_date
[0..1] I_SalesOrganizationText _SalesOrgText $projection.SalesOrganization = _SalesOrgText.SalesOrganization
[0..1] I_PurchasingOrganization _PurchaseOrgText $projection.PurchasingOrganization = _PurchaseOrgText.PurchasingOrganization
[0..1] I_Plant _PlantText $projection.Plant = _PlantText.Plant

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Contact Card for Ent Proj Service Org view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey EnterpriseProjectServiceOrg view
VDM.viewType #CONSUMPTION view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY EnterpriseProjectServiceOrg EngagementProjectServiceOrg
EnterpriseProjectSrvcOrgName
EngmtProjServiceOrgIsSales EngmtProjServiceOrgIsSales
EngmtProjServiceOrgIsDelivery EngmtProjServiceOrgIsDelivery
CompanyCode
ServiceOrgDefaultCostCenter
SalesOrganization
PurchasingOrganization
Plant
_CompanyCodeAuth _CompanyCodeAuth
_EngagementProjectSrvcOrgDets _EngagementProjectSrvcOrgDets
_CompanyCodeText _CompanyCodeText
_DefaultCostCenterText _DefaultCostCenterText
_SalesOrgText _SalesOrgText
_PurchaseOrgText _PurchaseOrgText
_PlantText _PlantText
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Contact Card for Ent Proj Service Org'

@Metadata : {
  ignorePropagatedAnnotations: true,
  allowExtensions: true
}
@ObjectModel : {
  usageType:{
    serviceQuality: #C,
    sizeCategory: #S,
    dataClass: #MIXED
  },
  representativeKey: 'EnterpriseProjectServiceOrg'
}

@VDM.viewType: #CONSUMPTION
define view entity C_EntProjSrvcOrgCntctCard
  as select from I_EngagementProjectSrvcOrg
  association [0..1] to I_CompanyCode            as _CompanyCodeText       on  $projection.CompanyCode = _CompanyCodeText.CompanyCode
  association [0..1] to I_CostCenterText         as _DefaultCostCenterText on  $projection.ServiceOrgDefaultCostCenter  = _DefaultCostCenterText.CostCenter
                                                                           and _DefaultCostCenterText.ValidityEndDate   >= $session.system_date
                                                                           and _DefaultCostCenterText.ValidityStartDate <= $session.system_date
  association [0..1] to I_SalesOrganizationText  as _SalesOrgText          on  $projection.SalesOrganization = _SalesOrgText.SalesOrganization
  association [0..1] to I_PurchasingOrganization as _PurchaseOrgText       on  $projection.PurchasingOrganization = _PurchaseOrgText.PurchasingOrganization
  association [0..1] to I_Plant                  as _PlantText             on  $projection.Plant = _PlantText.Plant

{
      @ObjectModel :{
        text : {element: ['EnterpriseProjectSrvcOrgName']}
      }
      @Semantics : {
        contact : {type:#ORGANIZATION},
        name: { givenName: true }
      }
  key EngagementProjectServiceOrg                                                                                                                        as EnterpriseProjectServiceOrg,
      @Semantics.text: true
      _Text[1:Language = $session.system_language].EngmtProjectServiceOrgName                                                                            as EnterpriseProjectSrvcOrgName,
      @Semantics.booleanIndicator: true
      EngmtProjServiceOrgIsSales,
      @Semantics.booleanIndicator: true
      EngmtProjServiceOrgIsDelivery,
      @ObjectModel.text.association: '_CompanyCodeText'
      cast( _EngagementProjectSrvcOrgDets[1:AssignedOrganisationIsDefault = 'X' and AssignedOrganisationType = 'CC'].AssignedOrganisation as fis_bukrs ) as CompanyCode,
      @ObjectModel.text.association: '_DefaultCostCenterText'
      _EngagementProjectSrvcOrgDets[1:AssignedOrganisationIsDefault = 'X' and AssignedOrganisationType = 'CS'].AssignedOrganisation                      as ServiceOrgDefaultCostCenter,
      @ObjectModel.text.association: '_SalesOrgText'
      cast( _EngagementProjectSrvcOrgDets[1:AssignedOrganisationIsDefault = 'X' and AssignedOrganisationType = 'SO'].AssignedOrganisation   as vkorg )   as SalesOrganization,
      @ObjectModel.text.association: '_PurchaseOrgText'
      cast( _EngagementProjectSrvcOrgDets[1:AssignedOrganisationIsDefault = 'X' and AssignedOrganisationType = 'PO'].AssignedOrganisation   as ekorg )   as PurchasingOrganization,
      @ObjectModel.text.association: '_PlantText'
      cast( _EngagementProjectSrvcOrgDets[1:AssignedOrganisationIsDefault = 'X' and AssignedOrganisationType = 'PL'].AssignedOrganisation as werks_d )   as Plant,
      /* Associations */
      _CompanyCodeAuth,
      _EngagementProjectSrvcOrgDets,
      _CompanyCodeText,
      _DefaultCostCenterText,
      _SalesOrgText,
      _PurchaseOrgText,
      _PlantText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGAGEMENTPROJECTSRVCORG",
"I_ENGAGEMENTPROJECTSRVCORGDETS",
"I_ENGAGEMENTPROJECTSRVCORGTEXT"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_COSTCENTERTEXT",
"I_ENGAGEMENTPROJECTSRVCORGDETS",
"I_ENGMNTPROJSERVICEORGDETAILS",
"I_PLANT",
"I_PURCHASINGORGANIZATION",
"I_SALESORGANIZATIONTEXT"
],
"BASE":
[
"I_ENGAGEMENTPROJECTSRVCORG"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/