I_CHMLCMPLNCINFODRAFT

CDS View

Chemical Compliance Information Draft Data

I_CHMLCMPLNCINFODRAFT is a CDS View in S/4HANA. Chemical Compliance Information Draft Data. It contains 7 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 7 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_ChmlCmplncProductParamVH view inner CONSUMPTION Chml Cmplnc Material val help with Param
I_ChmlCmplncMktCvrgProdAssgmt view left_outer COMPOSITE Marketability Coverages for PP and UP

Fields (7)

KeyField CDS FieldsUsed in Views
MaterialIsDisposed MaterialIsDisposed 1
MaterialIsEmissionRelevant MaterialIsEmissionRelevant 1
MaterialIsProduced MaterialIsProduced 1
MaterialIsSold MaterialIsSold 1
MaterialIsSourced MaterialIsSourced 1
MaterialIsTransported MaterialIsTransported 1
ProdStewardshipRespUnit ProdStewardshipRespUnit 1 
--Label of view
@EndUserText.label: 'Chemical Compliance Information Draft Data'

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

  --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_ChmlCmplncInfoDraft
  --Select data from draft table of chemical compliance information
  as select from ehfndw_cci
{
      --UUID of draft
  key chmlcmplncinfouuid         as ChmlCmplncInfoUUID,

      --UUID of chemical compliance information (active document)
      activechmlcmplncinfouuid   as ActiveChmlCmplncInfoUUID,

      lastchangedbyuser          as LastChangedByUser,

      // needed for DCL

      materialissold             as MaterialIsSold,
      materialistransported      as MaterialIsTransported,
      materialissourced          as MaterialIsSourced,
      materialisproduced         as MaterialIsProduced,
      materialisdisposed         as MaterialIsDisposed,
      materialisemissionrelevant as MaterialIsEmissionRelevant,
      prodstewardshiprespunit    as ProdStewardshipRespUnit
      //  specification

}

Learn More