I_CHMLCOMPOSITIONDRAFT

CDS View

Chemical Composition Draft Data

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

Used by 4 CDS view(s) 3 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_ChmlCmpstnSubstanceVH view inner CONSUMPTION Value Help for Substance in Composition
C_PCTrdScrtSubstVH view inner CONSUMPTION Substance Indicated as CBI
P_SubstanceAssgdCmpstn view union CONSUMPTION Substance assigned compositions
P_SubstPlmrCmpstnUnique view union_all COMPOSITE Silent Data Migration for ChmlCmplncInfo

Fields (3)

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

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

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

--Access Control: Authorizations Checks
@AccessControl:
{
  authorizationCheck: #CHECK
}

--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_ChmlCompositionDraft
  --Select data from draft table of chemical composition
  as select from ehfndw_ccmps

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

{
      --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,
      substanceuuid             as SubstanceUUID,

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

      prodcmplnclegalarea       as ProdCmplncLegalArea,
      prodcmplnclegalarearef    as ProdCmplncLegalAreaRef,

      polymercompositionintid   as PolymerCompositionIntID,
      polymercompositionname    as PolymerCompositionName,

      hasactiveentity           as HasActiveEntity,

      /*Association*/
      _ChmlCmplncInfo,
      _Substance
}
where
  -- Filter Draft Entities with deletion flag
  draftentityoperationcode <> 'D'

Learn More