I_ChmlCmplncWasteCodeSts

DDL: I_CHMLCMPLNCWASTECODESTS Type: view BASIC

Chml Cmplnc Waste Code Status

I_ChmlCmplncWasteCodeSts is a Basic CDS View that provides data about "Chml Cmplnc Waste Code Status" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field ChmlCmplncWasteCodeStatus. It has 1 association to related views.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ChmlCmplncWasteCodeStsText _Text $projection.ChmlCmplncWasteCodeStatus = _Text.ChmlCmplncWasteCodeStatus

Annotations (12)

NameValueLevelField
EndUserText.label Chml Cmplnc Waste Code Status view
AbapCatalog.sqlViewName ICCWSTCDSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey ChmlCmplncWasteCodeStatus view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncWasteCodeStatus
_Text _Text 
@EndUserText.label: 'Chml Cmplnc Waste Code Status'
@AbapCatalog:
{
  sqlViewName: 'ICCWSTCDSTS',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC


@ObjectModel:
{
  resultSet.sizeCategory: #XS,

  --Performance Annotations
  usageType:
  {
    dataClass: #META,
    sizeCategory: #S,
    serviceQuality: #B
  },
  representativeKey: 'ChmlCmplncWasteCodeStatus'
}

define view I_ChmlCmplncWasteCodeSts as select from dd07l
association [0..*] to I_ChmlCmplncWasteCodeStsText as _Text on $projection.ChmlCmplncWasteCodeStatus = _Text.ChmlCmplncWasteCodeStatus
{

  @ObjectModel.text.association: '_Text'
  key cast( domvalue_l as ehfnd_ccw_wastecode_status ) as ChmlCmplncWasteCodeStatus,
  
  _Text

}
where
      domname  = 'EHFND_CCW_WASTECODE_STATUS'
  and as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCWASTECODESTSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More