I_WasteTransferRequestStatus

DDL: I_WASTETRANSFERREQUESTSTATUS Type: view COMPOSITE

Waste Transfer Request Status

I_WasteTransferRequestStatus is a Composite CDS View that provides data about "Waste Transfer Request Status" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field WasteTransfReqStatus.

Data Sources (1)

SourceAliasJoin Type
dd07l Domain from

Annotations (12)

NameValueLevelField
EndUserText.label Waste Transfer Request Status view
AbapCatalog.sqlViewName IWSTTRRQSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.representativeKey WasteTransfReqStatus view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY WasteTransfReqStatus
WasteTransfReqStatusName DomainText ddtext
@EndUserText.label: 'Waste Transfer Request Status'

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

@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED
}

@VDM.viewType: #COMPOSITE

@ObjectModel:
{
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #S,
    serviceQuality: #C
  },
  resultSet.sizeCategory:#XS,
  representativeKey: 'WasteTransfReqStatus'
}

@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_WasteTransferRequestStatus 
 as select from dd07l as Domain
  left outer to one join dd07t as DomainText on Domain.domname = DomainText.domname
                                             and Domain.domvalue_l = DomainText.domvalue_l 
                                             and DomainText.ddlanguage = $session.system_language
{
  
       @ObjectModel.text.element: ['WasteTransfReqStatusName']
  key  cast( Domain.domvalue_l as ehewa_wst_trf_req_status ) as WasteTransfReqStatus,
  
       @Semantics.text: true
       DomainText.ddtext as WasteTransfReqStatusName
}

where
      Domain.domname  = 'EHEWA_WST_TRF_REQ_STATUS'
  and Domain.as4local = 'A'
  and DomainText.domname  = 'EHEWA_WST_TRF_REQ_STATUS'
  and DomainText.as4local = 'A';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L",
"DD07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/