I_ChmlCmplncIdfrValue

DDL: I_CHMLCMPLNCIDFRVALUE Type: view_entity BASIC Package: EHFND_RAP_CCIDFR

Chemical Compliance Identifier Value

I_ChmlCmplncIdfrValue is a Basic CDS View that provides data about "Chemical Compliance Identifier Value" in SAP S/4HANA. It reads from 1 data source (ehfndd_ccidfrval) and exposes 17 fields with key field ChmlCmplncIdfrValueUUID. It has 3 associations to related views. Part of development package EHFND_RAP_CCIDFR.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
ehfndd_ccidfrval ehfndd_ccidfrval from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (8)

NameValueLevelField
EndUserText.label Chemical Compliance Identifier Value view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncIdfrValueUUID chmlcmplncidfrvalueuuid
ChmlCmplncIdfrUUID chmlcmplncidfruuid
CreationUTCDateTime creationutcdatetime
CreatedByUser createdbyuser
LastChangeUTCDateTime lastchangeutcdatetime
LastChangedByUser lastchangedbyuser
ChmlCmplncIdfrParentType chmlcmplncidfrparenttype
ChmlCmplncIdfrType chmlcmplncidfrtype
ChmlCmplncIdfrCategory chmlcmplncidfrcategory
Language language
ProdCmplncLegalArea prodcmplnclegalarea
ChmlCmplncIdfrSequenceNumber chmlcmplncidfrsequencenumber
ChmlCmplncIdfrValue chmlcmplncidfrvalue
_ChmlCmplncIdfr _ChmlCmplncIdfr
_Language _Language
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser 
@EndUserText.label: 'Chemical Compliance Identifier Value'
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY

@VDM.viewType: #BASIC

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  semanticKey: ['ChmlCmplncIdfrValueUUID'],
  usageType: {
    serviceQuality: #A,
    sizeCategory: #XL,
    dataClass: #TRANSACTIONAL
  }
}
@Search.searchable: true
define view entity I_ChmlCmplncIdfrValue
  as select from ehfndd_ccidfrval
  association        to parent I_ChmlCmplncIdfr as _ChmlCmplncIdfr    on $projection.ChmlCmplncIdfrUUID = _ChmlCmplncIdfr.ChmlCmplncIdfrUUID

  association [0..1] to I_Language              as _Language          on $projection.Language           = _Language.Language
  association [0..1] to I_User                  as _CreatedByUser     on $projection.CreatedByUser      = _CreatedByUser.UserID 
  association [0..1] to I_User                  as _LastChangedByUser on $projection.LastChangedByUser  = _LastChangedByUser.UserID 

{
  key chmlcmplncidfrvalueuuid      as ChmlCmplncIdfrValueUUID,

      chmlcmplncidfruuid           as ChmlCmplncIdfrUUID,

      @Semantics.systemDateTime.createdAt: true
      creationutcdatetime          as CreationUTCDateTime,

      @Semantics.user.createdBy: true
      createdbyuser                as CreatedByUser,

      @Semantics.systemDateTime.lastChangedAt: true
      lastchangeutcdatetime        as LastChangeUTCDateTime,

      @Semantics.user.lastChangedBy: true
      lastchangedbyuser            as LastChangedByUser,

      chmlcmplncidfrparenttype     as ChmlCmplncIdfrParentType,
      chmlcmplncidfrtype           as ChmlCmplncIdfrType,
      chmlcmplncidfrcategory       as ChmlCmplncIdfrCategory,
      language                     as Language,
      prodcmplnclegalarea          as ProdCmplncLegalArea,
      chmlcmplncidfrsequencenumber as ChmlCmplncIdfrSequenceNumber,
      
      @Search: {
        defaultSearchElement : true,
//        fuzzinessThreshold: 1,

        fuzzinessThreshold: 0.8,
        ranking: #MEDIUM
      }
      @Consumption.filter.hidden: true
      chmlcmplncidfrvalue          as ChmlCmplncIdfrValue,

      /* Associations */
      _ChmlCmplncIdfr,
      _Language,
      _CreatedByUser,
      _LastChangedByUser
}

Learn More