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.
@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
//
defineview C_ChmlCmplncReqDelivCustCntct
--Select data from business user
asselectfrom I_DeliveryDocument as _DeliveryDocument
join I_BusinessPartner as _BusinessPartner on _DeliveryDocument.ShipToParty = _BusinessPartner.BusinessPartner
{
@ObjectModel.readOnly: truekey _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
}