I_CHEMICALMATERIAL

CDS View

Material of the Chemical

I_CHEMICALMATERIAL is a CDS View in S/4HANA. Material of the Chemical. It contains 1 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 1 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_ChemicalAmountsCube view inner COMPOSITE Chemical Amounts Cube
I_DailyChmlProductStkQty view inner COMPOSITE SARA: Daily Chemical Product Quantity
I_HzdsSubstInvtryProdQty view inner COMPOSITE HSI: Product Quantitiy
I_SaraDailyChemicalProductQty view inner COMPOSITE SARA: Daily Chemical Product Quantity
P_HzdsSubstInvtrySubstProposal view from CONSUMPTION

Fields (1)

KeyField CDS FieldsUsed in Views
KEY ChemicalUUID ChemicalUUID 3 
@EndUserText.label: 'Material of the Chemical'
@Analytics.dataCategory:#DIMENSION
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'ChemicalMaterialUUID'
@Metadata.allowExtensions:true 

@AccessControl.authorizationCheck: #CHECK

@AbapCatalog.sqlViewName: 'ICHMMAT'
@AbapCatalog.compiler.compareFilter: true

// Client handling by session 

@ClientHandling.algorithm: #SESSION_VARIABLE

// used for BOBF Master Data Object

@ObjectModel.usageType:{ serviceQuality: #B,        // < 2 msec   

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #MASTER } 
                         
                         
define view I_ChemicalMaterial
  as select from ehfndd_chm_mat
  association [0..1] to I_User     as _CreatedByUser     on $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User     as _LastChangedByUser on $projection.LastChangedByUser = _LastChangedByUser.UserID
  association [0..1] to I_Material as _Material          on $projection.Material = _Material.Material  

{
  key db_key                                                        as ChemicalMaterialUUID,
      parent_key                                                    as ChemicalRevisionUUID,
      cast( root_key as ehfnd_chm_uuid_ref preserving type )        as ChemicalUUID,

      @ObjectModel.foreignKey.association: '_Material'
      cast( material_id as ehfnd_mat_id_nc preserving type )  as Material,
      
      _Material._Text[1:Language = $session.system_language ].MaterialName,
      @ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes: true
      _Material,

      // Admin data

      datetime_cr as CreationDateTime,
      user_id_cr  as CreatedByUser,
      _CreatedByUser,

      datetime_ch as LastChangeDateTime,
      user_id_ch  as LastChangedByUser,
      _LastChangedByUser

}                                  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIAL",
"I_MATERIALTEXT",
"EHFNDD_CHM_MAT"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More