C_ChmlCmplncUse

DDL: C_CHMLCMPLNCUSE Type: view CONSUMPTION Package: EHFND_CNS_CCI

Chemical Compliance Use

C_ChmlCmplncUse is a Consumption CDS View that provides data about "Chemical Compliance Use" in SAP S/4HANA. It reads from 1 data source (P_ChmlCmplncUse) and exposes 10 fields with key fields ChmlCmplncInfoUUID, ProdCmplncLegalArea. It has 1 association to related views. Part of development package EHFND_CNS_CCI.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
P_ChmlCmplncUse ChmlCmplncUse from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ChmlCmplncInfo _ChmlCmplncInfo $projection.ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID --Join data from Use Draft

Annotations (11)

NameValueLevelField
EndUserText.label Chemical Compliance Use view
AbapCatalog.sqlViewName CCCUSE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey ProdCmplncLegalArea view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
Metadata.allowExtensions true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID P_ChmlCmplncUse ChmlCmplncInfoUUID
KEY ProdCmplncLegalArea ProdCmplncLegalArea
ProdCmplncLegalAreaName
ProdCmplncUseUUID ProdCmplncUseUUID
ProdCmplncUseProcgSts ProdCmplncUseProcgSts
ProdCmplncUseProcgStsCritlty ProdCmplncUseProcgStsCritlty
ProdCmplncSpcfcUsePhraseText
ProdCmplncRstrcdUsePhraseText
ProdCmplncWayOfApplPhraseText
_ChmlCmplncInfo _ChmlCmplncInfo 
@EndUserText.label: 'Chemical Compliance Use'

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

@AccessControl:
{
  authorizationCheck: #MANDATORY
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION

@ObjectModel:
{
  representativeKey: 'ProdCmplncLegalArea',
  semanticKey:  [ 'ChmlCmplncInfoUUID', 'ProdCmplncLegalArea' ],
  usageType:
  {
    /*Service Quality - reflects the quality of service with respect to the expected performance of the CDS view:
      #A: may be consumed within business logic for high volume transactions or background processing
      #B: may be consumed within business logic for transactions or background processing
    */
    dataClass: #MIXED,
    sizeCategory: #M,
    serviceQuality: #C
  }
}

@Metadata.allowExtensions: true

define view C_ChmlCmplncUse
  as select from P_ChmlCmplncUse as ChmlCmplncUse

  -- needed for DCL
  association [0..1] to I_ChmlCmplncInfo as _ChmlCmplncInfo on $projection.ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID --Join data from Use Draft

{
      @UI.hidden: true
  key ChmlCmplncUse.ChmlCmplncInfoUUID                                                          as ChmlCmplncInfoUUID,

      @ObjectModel.text.element: ['ProdCmplncLegalAreaName']
  key ProdCmplncLegalArea                                                                       as ProdCmplncLegalArea,

      @Semantics.text: true
      _ProdCmplncLegalArea._Text[1: Language= $session.system_language].ProdCmplncLegalAreaName as ProdCmplncLegalAreaName,

      ProdCmplncUseUUID                                                                         as ProdCmplncUseUUID,

      @ObjectModel.text.element: ['ProdCmplncUseProcgStsText']
      ProdCmplncUseProcgSts                                                                     as ProdCmplncUseProcgSts,

      coalesce(
        _ProcessingStatus._Text[ 1: Language = $session.system_language ].PCPrptyProcgStsText,
        _ProcessingStatus._Text[ 1: Language = 'E' ].PCPrptyProcgStsText
      )                                                                                         as ProdCmplncUseProcgStsText,

      ProdCmplncUseProcgStsCritlty                                                              as ProdCmplncUseProcgStsCritlty,

      --Navigation Link UUID
      ProdCmplncUseUUID                                                                         as ProdCmplncUseNavgnLinkUUID,

      --Delete allowed?
      @Semantics.booleanIndicator: true
      ProdCmplncUseDeleteIsAllwd                                                                as ProdCmplncUseDeleteIsAllwd,

      --Release allowed?
      @Semantics.booleanIndicator: true
      ProdCmplncUseReleaseIsAllwd                                                               as ProdCmplncUseReleaseIsAllwd,

      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHFND_USE_MLTVALUE_CALC_EXT'
      @ObjectModel.readOnly: true
      cast('' as ehfnd_spcfc_uses_ph_text )                                                     as ProdCmplncSpcfcUsePhraseText,

      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHFND_USE_MLTVALUE_CALC_EXT'
      @ObjectModel.readOnly: true
      cast('' as ehfnd_restr_uses_ph_text )                                                     as ProdCmplncRstrcdUsePhraseText,

      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHFND_USE_MLTVALUE_CALC_EXT'
      @ObjectModel.readOnly: true
      cast('' as ehfnd_way_of_appl_ph_text )                                                    as ProdCmplncWayOfApplPhraseText,

      _ChmlCmplncInfo

}
where
  ProdCmplncUseProcgSts is not initial

Learn More