I_ChmlSuplrMatlNames

DDL: I_CHMLSUPLRMATLNAMES Type: view COMPOSITE Package: EHFND_BO_CSM

Names of Supplier Material

I_ChmlSuplrMatlNames is a Composite CDS View that provides data about "Names of Supplier Material" in SAP S/4HANA. It reads from 1 data source (I_ChmlSuplrMatl) and exposes 8 fields. Part of development package EHFND_BO_CSM.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlSuplrMatl SupplierMaterial from

Annotations (12)

NameValueLevelField
EndUserText.label Names of Supplier Material view
AbapCatalog.sqlViewName ICSMNAME view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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 #C view
ObjectModel.representativeKey ChmlSuplrMatlUUID view

Fields (8)

KeyFieldSource TableSource FieldDescription
ChmlSuplrMatlUUID
BusinessPartnerSupplier
SupplierMaterialNumber
ChmlSuplrMatlName
ResponsibleUnit
AuthorizationGroup
_ResponsibleUnit I_ChmlSuplrMatl _ResponsibleUnit
_BusinessPartner I_ChmlSuplrMatl _BusinessPartner 
@EndUserText.label: 'Names of Supplier Material'

@AbapCatalog:
{
  sqlViewName: 'ICSMNAME',
  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

@VDM.viewType: #COMPOSITE

@ObjectModel:
{
  semanticKey:  [ 'ChmlSuplrMatlUUID' ],
  --Performance Annotations
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #C
  },
  representativeKey: 'ChmlSuplrMatlUUID'
}

define view I_ChmlSuplrMatlNames
  --Select data from basic view of Supplier Material
  as select from           I_ChmlSuplrMatl             as SupplierMaterial

  --join supplier material data
    left outer to one join I_ChmlCmplncSuplrMatlAssgmt as SuplrMatlAssignment on SupplierMaterial.ChmlSuplrMatlUUID = SuplrMatlAssignment.ChmlSuplrMatlUUID

  --join data of raw material
    left outer to one join C_ChmlCmplncPrimMatl        as RawMaterialData     on SuplrMatlAssignment.ChmlCmplncInfoUUID = RawMaterialData.ChmlCmplncInfoUUID

{
      --UUID of Supplier Material
  key SupplierMaterial.ChmlSuplrMatlUUID,

      ---- Supplier name ----
      SupplierMaterial.BusinessPartnerSupplier,

      ---- Supplier (external) material nummber  ----
      SupplierMaterial.SupplierMaterialNumber,

      ---- Supplier (external) material name ----
      SupplierMaterial.ChmlSuplrMatlName,

      --Concatenate the name of supplier material: "Supplier - Raw Material Name"
      cast( concat_with_space(SupplierMaterial._BusinessPartner.BusinessPartnerFullName,
        concat_with_space('-', RawMaterialData.ChmlCmplncInfoCombinedName, 1), 1) as ehfnd_csm_supplier_raw_matl )                 as SupplierMaterialCombinedName,
        
      // needed for DCL

      --Responsible Unit
      @Consumption.hidden: true
      SupplierMaterial.ResponsibleUnit,
      
      // Needed for DCL

      @Consumption.hidden: true
      SupplierMaterial._BusinessPartnerSupplier.AuthorizationGroup,
      
      // Associations

      SupplierMaterial._ResponsibleUnit,
      SupplierMaterial._BusinessPartner

}

Learn More