I_ChmlCmplncSuplrMatlEnhanced

DDL: I_CHMLCMPLNCSUPLRMATLENHANCED Type: view COMPOSITE

Chemical Compliance Supplier Material Assignment Enhanced

I_ChmlCmplncSuplrMatlEnhanced is a Composite CDS View that provides data about "Chemical Compliance Supplier Material Assignment Enhanced" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncSuplrMatlAssgmt) and exposes 6 fields.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncSuplrMatlAssgmt _SuplrMatlAssgmt from

Annotations (10)

NameValueLevelField
EndUserText.label Chemical Compliance Supplier Material Assignment Enhanced view
AbapCatalog.sqlViewName ICCSMASSENHCD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (6)

KeyFieldSource TableSource FieldDescription
UUIDofSupplierMaterialChmlSuplrMatlUUID
BusinessPartnerSupplier
BusinessPartnerUUID
_ChmlCmplncInfo _ChmlCmplncInfo
_SupplierMaterial _SupplierMaterial
_SupplierStatus _SupplierStatus 
--Label of view
-- e.g. display as filter name in the consumption
@EndUserText.label: 'Chemical Compliance Supplier Material Assignment Enhanced'

@AbapCatalog:
{
  -- SQL view name (16 characters)
  sqlViewName: 'ICCSMASSENHCD',

  --If it's true, the filter conditions are compared and, if they match, the associated join expression is evaluated only once
  compiler.compareFilter: true
}

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

  personalData.blocking: #REQUIRED
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

--VDM view type
@VDM.viewType: #COMPOSITE


@ObjectModel:
{

  --Performance Annotations
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #B
  }
}

define view I_ChmlCmplncSuplrMatlEnhanced
  --Select data from Supplier Material Assignment
  as select from I_ChmlCmplncSuplrMatlAssgmt as _SuplrMatlAssgmt 
  
//    --Select data from business partner

//  join to I_ChmlSuplrMatl as ChemicalSupplierMaterial   

//  I_BusinessPartner             as BusinessPartner

//  --join data to supplier link

//    inner join   I_Supplier_to_BusinessPartner as SupplierLink on BusinessPartner.BusinessPartnerUUID = SupplierLink.BusinessPartnerUUID  


{
      --UUID of assignment
  key ChmlCmplncSuplrMatlAssgmtUUID,

      --UUID of chemical compliance info
      ChmlCmplncInfoUUID,

      --UUID of Supplier Material
      ChmlSuplrMatlUUID,

      --Supplier Status per chemical compliance information
      ChmlSuplrMatlSuplrSts,
      
      _SuplrMatlAssgmt._SupplierMaterial.BusinessPartnerSupplier as BusinessPartnerSupplier,
      _SuplrMatlAssgmt._SupplierMaterial._BusinessPartner.BusinessPartnerUUID as BusinessPartnerUUID,
      
      /* Associations */
      _ChmlCmplncInfo,
      _SupplierMaterial,

      _SupplierStatus
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CHMLCMPLNCSUPLRMATLASSGMT",
"I_CHMLSUPLRMATL"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO",
"I_CHMLSUPLRMATL",
"I_CHMLSUPLRMATLSUPLRSTS"
],
"BASE":
[
"I_CHMLCMPLNCSUPLRMATLASSGMT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More