I_CHMLCMPLNCMKTCVRGDRAFT

CDS View

Chemical Compliance Market Coverage

I_CHMLCMPLNCMKTCVRGDRAFT is a CDS View in S/4HANA. Chemical Compliance Market Coverage. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_ChmlCmplncMktCountryVH view left_outer CONSUMPTION Country / Region Value Help with Filter
C_ChmlCmplncMktCvrgVH view union CONSUMPTION Value Help for Coverage with Filter 
@EndUserText.label: 'Chemical Compliance Market Coverage'

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

@AccessControl:
{
  authorizationCheck: #CHECK
}

@VDM.viewType: #BASIC

@ObjectModel:
{
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #M,
    serviceQuality: #B
  }
}

@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_ChmlCmplncMktCvrgDraft
  as select from ehfndw_cci_mcvrg
  association [1..1] to I_Country        as _Country        on $projection.Country = _Country.Country
  // needed for DCL

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

{
  key chmlcmplncmktcvrguuid                                                   as ChmlCmplncMktCvrgUUID,
      chmlcmplncinfouuid                                                      as ChmlCmplncInfoUUID,
      chmlcmplncmktrequuid                                                    as ChmlCmplncMktReqUUID,
      country                                                                 as Country,
      chmlcmplncprodnallwd                                                    as ChmlCmplncProdnAllwd,
      chmlcmplncexprtallwd                                                    as ChmlCmplncExprtAllwd,
      chmlcmplncimprtallwd                                                    as ChmlCmplncImprtAllwd,
      chmlcmplncsalesallwd                                                    as ChmlCmplncSalesAllwd,

      _Country,
      _ChmlCmplncInfo
}
where
  draftentityoperationcode <> 'D'

Learn More