I_MATLBASEDCOMPOSITIONDRAFT

CDS View

Chemical Composition Draft Data

I_MATLBASEDCOMPOSITIONDRAFT is a CDS View in S/4HANA. Chemical Composition Draft Data. It contains 1 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 1 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_MatlBasedCmpstnCompVH view inner CONSUMPTION Value Help for Components of Material Based Composition
C_MatlBasedCmpstnLglDvtnVH view inner CONSUMPTION Value Help for Legal Deviation
C_MatlBasedProducedSubstanceVH view inner CONSUMPTION Value Help for Produced Substances for Matl Bsd Composition
I_MatlBasedCompositionActvDrft view union_all BASIC Chemical Composition with active and draft data

Fields (1)

KeyField CDS FieldsUsed in Views
_ChmlCmplncInfo _ChmlCmplncInfo 1 
--Label of view
@EndUserText.label: 'Chemical Composition Draft Data'

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

  --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: #MANDATORY
}

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

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

@ObjectModel:
{

  --Performance Annotations
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #M,
    serviceQuality: #B
  }
}

define view I_MatlBasedCompositionDraft
  --Select data from draft table of material-based composition
  as select from ehfndw_mcmps

  --Association for DCL
  association [0..1] to I_ChmlCmplncInfo as _ChmlCmplncInfo on $projection.ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID

{
      --UUID of draft
  key chmlcompositionuuid       as ChmlCompositionUUID,

      --UUID of chemical composition (active document)
      activechmlcompositionuuid as ActiveChmlCompositionUUID,

      --UUID of chemical compliance information (needed for DCL)
      chmlcmplncinfouuid        as ChmlCmplncInfoUUID,

      chmlcompositionstatus     as ChmlCompositionStatus,
      chmlcompositiontype       as ChmlCompositionType,
      lastchangedbyuser         as LastChangedByUser,
      lastchangeutcdatetime     as LastChangeUTCDateTime,
      validitystartdatetime     as ValidityStartDateTime,

      /*Association*/
      _ChmlCmplncInfo
}
where
  -- Filter Draft Entities with deletion flag
  draftentityoperationcode <> 'D'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHFNDW_MCMPS"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More