SADL_RS_SO_QUERY_PROV_SELECTOR

DDL: SADL_RS_SO_QUERY_PROV_SELECTOR SQL: SRSQUERYSELECTOR Type: view

Sales Order with custom query and selector

SADL_RS_SO_QUERY_PROV_SELECTOR is a CDS View that provides data about "Sales Order with custom query and selector" in SAP S/4HANA. It reads from 1 data source (sadl_rs_so_root) and exposes 5 fields with key field id. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
sadl_rs_so_root Document from

Associations (1)

CardinalityTargetAliasCondition
[1] SADL_RS_SO_QUERY_PROV_SELECTOR _myself Document.id = _myself.id

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName SRSQUERYSELECTOR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Order with custom query and selector view
ObjectModel.query.implementedBy ABAP:CL_SADL_SRS_QUERY_PRV_SELECTOR view
Search.searchable true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY id sadl_rs_so_root id
seller_id sadl_rs_so_root seller_id
buyer_id sadl_rs_so_root buyer_id
type_code sadl_rs_so_root type_code
_myself _myself 
@AbapCatalog.sqlViewName: 'SRSQUERYSELECTOR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Sales Order with custom query and selector'

@ObjectModel.query.implementedBy: 'ABAP:CL_SADL_SRS_QUERY_PRV_SELECTOR'
@Search.searchable: true

define view SADL_RS_SO_QUERY_PROV_SELECTOR
  as select from sadl_rs_so_root as Document
  association [1] to SADL_RS_SO_QUERY_PROV_SELECTOR as _myself on Document.id = _myself.id
  //  association [*] to SADL_RS_SO_QUERY_PROV_SELECTOR as _otherTypeCode on Document.type_code <> _otherTypeCode.type_code

{
  key Document.id,
      @Search.defaultSearchElement: true
      Document.seller_id,
      Document.buyer_id,
      cast ( Document.act_indicator as boole_d preserving type ) as act_indicator,
      Document.type_code,
      @ObjectModel.filter.enabled: false
      @ObjectModel.sort.enabled: false
      _myself
      //      _otherTypeCode

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SADL_RS_SO_ROOT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More