C_ChmlSuplrMatlSupplierContact

DDL: C_CHMLSUPLRMATLSUPPLIERCONTACT Type: view CONSUMPTION

Contact Data of Supplier

C_ChmlSuplrMatlSupplierContact is a Consumption CDS View that provides data about "Contact Data of Supplier" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 22 fields. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner BusinessPartner from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Supplier _Supplier _Supplier.Supplier = $projection.BusinessPartnerSupplier

Annotations (13)

NameValueLevelField
EndUserText.label Contact Data of Supplier view
AbapCatalog.sqlViewName CCSMSUPLRCONTACT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
Search.searchable true view

Fields (22)

KeyFieldSource TableSource FieldDescription
BusinessPartnerFullNameasSupplier
OrganizationBPName1 I_BusinessPartner OrganizationBPName1
OrganizationBPName2 I_BusinessPartner OrganizationBPName2
EmailAddress
FaxAreaCodeSubscriberNumberasFaxNumber
StreetName
HouseNumber
PostalCode
CityName
CountryName
DataControllerSet I_BusinessPartner DataControllerSet
DataController1 I_BusinessPartner DataController1
DataController2 I_BusinessPartner DataController2
DataController3 I_BusinessPartner DataController3
DataController4 I_BusinessPartner DataController4
DataController5 I_BusinessPartner DataController5
DataController6 I_BusinessPartner DataController6
DataController7 I_BusinessPartner DataController7
DataController8 I_BusinessPartner DataController8
DataController9 I_BusinessPartner DataController9
DataController10 I_BusinessPartner DataController10
_Supplier _Supplier
@EndUserText.label: 'Contact Data of Supplier'

@AbapCatalog:
{
  sqlViewName: 'CCSMSUPLRCONTACT',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl:
{
  authorizationCheck: #CHECK,
  // blocking of personal data required because of link to business partner / supplier

  personalData.blocking: #REQUIRED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata: {
  allowExtensions: true
}

@VDM.viewType: #CONSUMPTION

@ObjectModel:
{
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #XL,
    serviceQuality: #C
  },
  semanticKey: [ 'BusinessPartnerSupplier' ]
}

--Search
@Search.searchable : true

define view C_ChmlSuplrMatlSupplierContact
  --Select data from business partner
  as select from           I_BusinessPartner         as BusinessPartner

    left outer to one join I_BusinessPartnerSupplier as BusinessPartnerSupplier on BusinessPartner.BusinessPartner = BusinessPartnerSupplier.BusinessPartner

  -- association to supplier needed for DCL
  association [1..1] to I_Supplier as _Supplier on _Supplier.Supplier = $projection.BusinessPartnerSupplier
{

      --Supplier/Business Partner ID
      @ObjectModel.text.element:  [ 'Supplier' ]
      @Semantics.contact.type: #ORGANIZATION
      //@UI.textArrangement: #TEXT_FIRST

  key cast(BusinessPartner.BusinessPartner as ehfnd_bupa_supplier preserving type )                                                    as BusinessPartnerSupplier,

      --Company Name and Supplier ID
      // used via AS_CONTACT in contact popup

      @Semantics.name.fullName: true
      BusinessPartner.BusinessPartnerFullName                                                                                          as Supplier,

      --Company Name
      // used via AS_CONTACT in contact popup

      // can not be used for searching because of calculation

      @Semantics.name.fullName: true
      BusinessPartner.BusinessPartnerFullName                                                                                          as BusinessPartnerCompany,

      // part of BusinessPartnerFullName, only needed for searching

      BusinessPartner.OrganizationBPName1,

      // part of BusinessPartnerFullName, only needed for searching

      BusinessPartner.OrganizationBPName2,

      --Phone Number
      // used via AS_CONTACT in contact popup

      @Semantics.telephone.type:  [ #WORK, #PREF ]
      BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber as PhoneNumber,

      --E-Mail adress
      // used via AS_CONTACT in contact popup

      @Semantics.eMail.type:  [ #PREF, #WORK ]
      BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltEmailAddress.EmailAddress,

      --Fax number
      // used via AS_CONTACT in contact popup

      @Semantics.telephone.type:  [ #FAX ]
      BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber           as FaxNumber,

      --Address
      @Semantics.address.street: true
      BusinessPartner._CurrentDefaultAddress._StandardAddress.StreetName,

      @Semantics.address.number: true
      BusinessPartner._CurrentDefaultAddress._StandardAddress.HouseNumber,

      @Semantics.address.zipCode: true
      BusinessPartner._CurrentDefaultAddress._StandardAddress.PostalCode,

      @Semantics.address.city: true
      BusinessPartner._CurrentDefaultAddress._StandardAddress.CityName,

      @Semantics.address.country: true
      BusinessPartner._CurrentDefaultAddress._StandardAddress._Country._Text[1: Language = $session.system_language ].CountryName,
      
      // Authorization data used for DCL

      @UI.hidden: true
      @Consumption.hidden: true
      BusinessPartner.DataControllerSet                                                                                                 as DataControllerSet,
      @UI.hidden: true
      @Consumption.hidden: true
      BusinessPartner.DataController1                                                                                                   as DataController1,
      @UI.hidden: true
      @Consumption.hidden: true
      BusinessPartner.DataController2                                                                                                   as DataController2,
      @UI.hidden: true
      @Consumption.hidden: true
      BusinessPartner.DataController3                                                                                                   as DataController3,
      @UI.hidden: true
      @Consumption.hidden: true
      BusinessPartner.DataController4                                                                                                   as DataController4,
      @UI.hidden: true
      @Consumption.hidden: true
      BusinessPartner.DataController5                                                                                                   as DataController5,
      @UI.hidden: true
      @Consumption.hidden: true
      BusinessPartner.DataController6                                                                                                   as DataController6,
      @UI.hidden: true
      @Consumption.hidden: true
      BusinessPartner.DataController7                                                                                                   as DataController7,
      @UI.hidden: true
      @Consumption.hidden: true
      BusinessPartner.DataController8                                                                                                   as DataController8,
      @UI.hidden: true
      @Consumption.hidden: true
      BusinessPartner.DataController9                                                                                                   as DataController9,      
      @UI.hidden: true
      @Consumption.hidden: true
      BusinessPartner.DataController10                                                                                                  as DataController10,

      _Supplier
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRCURDEFAULTEMAILADDRESS",
"I_ADDRCURDEFAULTFAXNUMBER",
"I_ADDRCURDFLTLANDLINEPHONENMBR",
"I_ADDRESS",
"I_ADDRESS_2",
"I_BPCURRENTDEFAULTADDRESS",
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERSUPPLIER",
"I_COUNTRY",
"I_COUNTRYTEXT"
],
"ASSOCIATED":
[
"I_SUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/