I_ChmlCmplncReqStatus

DDL: I_CHMLCMPLNCREQSTATUS Type: view_entity BASIC Package: EHFND_BO_CRQ

Chemical Compliance Request Status Name

I_ChmlCmplncReqStatus is a Basic CDS View that provides data about "Chemical Compliance Request Status Name" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields. It has 1 association to related views. Part of development package EHFND_BO_CRQ.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
dd07l ComplianceRequestStatus from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ChmlCmplncReqStatusTxt _Text $projection.ChmlCmplncReqStatus = _Text.ChmlCmplncReqStatus

Annotations (8)

NameValueLevelField
EndUserText.label Chemical Compliance Request Status Name view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.representativeKey ChmlCmplncReqStatus view

Fields (2)

KeyFieldSource TableSource FieldDescription
domvalue_l110asChmlCmplncReqStatus
_Text _Text 
@EndUserText.label: 'Chemical Compliance Request Status Name'

// authorization check not required as view only reads domain values

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.viewType: #BASIC

@ObjectModel:
{
  --Performance annotation
  usageType:
  {
    dataClass: #META,
    serviceQuality: #A,
    sizeCategory: #S
  },
  resultSet.sizeCategory: #XS,
  --Representative Key
  representativeKey: 'ChmlCmplncReqStatus'
}

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK", "KEY_CHECK" ]  } */
define view entity I_ChmlCmplncReqStatus
  --Select data from domain value description table
  as select from dd07l as ComplianceRequestStatus

  --association to I_Language
  association [0..*] to I_ChmlCmplncReqStatusTxt as _Text on $projection.ChmlCmplncReqStatus = _Text.ChmlCmplncReqStatus
{
      --Domain Value of Basic Data Status
      @ObjectModel.text.association: '_Text'
  key substring(ComplianceRequestStatus.domvalue_l, 1, 10)   as ChmlCmplncReqStatus,
      
      /* Associations */
      _Text
}
where
      ComplianceRequestStatus.domname  = 'EHFND_CRQ_STATUS'
  and ComplianceRequestStatus.as4local = 'A'

Learn More