SADL_RAP_RS_SO

DDL: SADL_RAP_RS_SO SQL: SADLRAPSOROOT Type: view

RAP: Sales Order Root View with BDEF

SADL_RAP_RS_SO is a CDS View that provides data about "RAP: Sales Order Root View with BDEF" in SAP S/4HANA. It reads from 1 data source (sadl_rs_so_root) and exposes 5 fields with key field id. It has 2 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
sadl_rs_so_root root from

Associations (2)

CardinalityTargetAliasCondition
[0..1] SADL_RAP_RS_SO _self_if_active $projection.id = _self_if_active.id and _self_if_active.act_indicator = 'X'
[0..*] SADL_RAP_RS_SO_ITEM _Items

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SADLRAPSOROOT view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
EndUserText.label RAP: Sales Order Root View with BDEF view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY id id
buyer_id buyer_id
seller_id seller_id
type_code type_code
_Items _Items 
@AbapCatalog.sqlViewName: 'SADLRAPSOROOT'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey: true
@EndUserText.label: 'RAP: Sales Order Root View with BDEF'

define root view SADL_RAP_RS_SO as select from sadl_rs_so_root as root
  composition [0..*] of SADL_RAP_RS_SO_ITEM as _Items
  association [0..1] to SADL_RAP_RS_SO as _self_if_active on  $projection.id = _self_if_active.id and _self_if_active.act_indicator = 'X'  
{
  key id,
      act_indicator,
      buyer_id,
      seller_id,
      type_code,

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

Learn More