C_RawChmlCmplncPrimMatl

DDL: C_RAWCHMLCMPLNCPRIMMATL Type: view CONSUMPTION

Primary Material of Raw Material

C_RawChmlCmplncPrimMatl is a Consumption CDS View that provides data about "Primary Material of Raw Material" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfo) and exposes 6 fields. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfo ChemicalComplianceInfo from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ChmlCmplncInfo _ChmlCmplncInfo _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID -- provide additional product data via exposed
[1..1] I_Product _MaterialData PrimaryMaterial.Material = _MaterialData.Product

Annotations (10)

NameValueLevelField
EndUserText.label Primary Material of Raw Material view
AbapCatalog.sqlViewName CCCRMATLPRIM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (6)

KeyFieldSource TableSource FieldDescription
ChmlCmplncInfoUUID
MaterialasMaterial
ProductNameasMaterialName
SpecificationasChmlCmplncInfoCombinedID
_ChmlCmplncInfo _ChmlCmplncInfo
_MaterialData _MaterialData 
@EndUserText.label: 'Primary Material of Raw Material'

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

@AccessControl:
{
  authorizationCheck: #CHECK,
  // blocking of personal data not required (no personal data fields exposed for material)

  personalData.blocking: #NOT_REQUIRED  
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION

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

define view C_RawChmlCmplncPrimMatl
  --Select data from master table 'Chemical Compliance Info'
  as select from           I_ChmlCmplncInfo       as ChemicalComplianceInfo

  --Join data from primary material assignment
    left outer to one join I_ChmlCmplncMatlAssgmt as PrimaryMaterial on  ChemicalComplianceInfo.ChmlCmplncInfoUUID = PrimaryMaterial.ChmlCmplncInfoUUID
                                                                     and PrimaryMaterial.MatlAssgmtIsPrimary       = 'X'
  --Join data from product name
    left outer to one join I_ProductText          as MaterialData    on  PrimaryMaterial.Material = MaterialData.Product
                                                                     and Language                 = $session.system_language

  association [1..1] to I_ChmlCmplncInfo       as _ChmlCmplncInfo       on  _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

  -- provide additional product data via exposed association
  association [1..1] to I_Product              as _MaterialData         on  PrimaryMaterial.Material = _MaterialData.Product
{
      --UUID of Chemical Compliance Info
  key ChemicalComplianceInfo.ChmlCmplncInfoUUID,

      --Material
      PrimaryMaterial.Material                                                                                     as Material,

      --Material Name
      MaterialData.ProductName                                                                                     as MaterialName,

      -- Needed in PCE monitor app like Initiating object ID 
      coalesce( PrimaryMaterial.Material, ChemicalComplianceInfo.Specification ) as ChmlCmplncInfoCombinedID,  

      --Material or Internal Name
      cast( coalesce( MaterialData.ProductName,
                ChemicalComplianceInfo.ChmlCmplncInternalName ) as ehfnd_cci_product_name preserving type )        as ChmlCmplncInfoCombinedName,

      /* Associations */
      _ChmlCmplncInfo,
      _MaterialData
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCINFO",
"I_CHMLCMPLNCMATLASSGMT",
"I_PRODUCTTEXT"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO",
"I_PRODUCT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More