C_ChmlCmplncReqDelivCustCntct

DDL: C_CHMLCMPLNCREQDELIVCUSTCNTCT Type: view CONSUMPTION Package: EHPMA_CNS_CRQ

Chemical Compliance Request Delivery Customer Contact Card

C_ChmlCmplncReqDelivCustCntct is a Consumption CDS View that provides data about "Chemical Compliance Request Delivery Customer Contact Card" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 19 fields with key field DeliveryDocument. Part of development package EHPMA_CNS_CRQ.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument _DeliveryDocument from

Annotations (10)

NameValueLevelField
EndUserText.label Chemical Compliance Request Delivery Customer Contact Card view
AbapCatalog.sqlViewName CCREQDCUSTCNTCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument I_DeliveryDocument DeliveryDocument
BusinessPartner _BusinessPartner BusinessPartner
BusinessPartnerFullName
PostalCode
CityName
Country
AuthorizationGroup _BusinessPartner AuthorizationGroup
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted
DataControllerSet _BusinessPartner DataControllerSet
DataController1 _BusinessPartner DataController1
DataController2 _BusinessPartner DataController2
DataController3 _BusinessPartner DataController3
DataController4 _BusinessPartner DataController4
DataController5 _BusinessPartner DataController5
DataController6 _BusinessPartner DataController6
DataController7 _BusinessPartner DataController7
DataController8 _BusinessPartner DataController8
DataController9 _BusinessPartner DataController9
DataController10 _BusinessPartner DataController10
@EndUserText.label: 'Chemical Compliance Request Delivery Customer Contact Card'

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

@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

@AccessControl:
{
  authorizationCheck: #MANDATORY,
  // blocking of personal data required because of link to business user

  personalData.blocking: #REQUIRED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION

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

// Determine the ship to party of the delivery document

//

define view C_ChmlCmplncReqDelivCustCntct
  --Select data from business user
  as select from I_DeliveryDocument as _DeliveryDocument
    join         I_BusinessPartner  as _BusinessPartner on _DeliveryDocument.ShipToParty = _BusinessPartner.BusinessPartner
{


      @ObjectModel.readOnly: true
  key _DeliveryDocument.DeliveryDocument,

      // just needed for DCL

      @ObjectModel:
       {
         readOnly: true,
         text.element:  [ 'BusinessPartnerFullName' ]
       }
      _BusinessPartner.BusinessPartner, 

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

      // can not be used for searching because of calculation

      @Semantics.name.fullName: true
      _BusinessPartner.BusinessPartnerFullName,
      --Postal Code
      // used via AS_CONTACT in contact popup

      @Semantics.address.zipCode: true
      _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode,
      --City Name
      // used via AS_CONTACT in contact popup

      @Semantics.address.city: true
      _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName,
      --Country Code
      // used via AS_CONTACT in contact popup

      @Semantics.address.country: true
      _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country,

      @Consumption.hidden: true
      _BusinessPartner.AuthorizationGroup         as AuthorizationGroup,

      @Consumption.hidden: true
      _BusinessPartner.IsBusinessPurposeCompleted as IsBusinessPurposeCompleted,

      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController1,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController2,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController3,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController4,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController6,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController7,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController8,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController9,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController10

}