DEMO_CDS_CLIENT_HANDLING

DDL: DEMO_CDS_CLIENT_HANDLING Type: view_entity

CDS View entity_client handling

DEMO_CDS_CLIENT_HANDLING is a CDS View that provides data about "CDS View entity_client handling" in SAP S/4HANA. It reads from 4 data sources (demo_sales_order, demo_sales_order, demo_sales_order, t000) and exposes 6 fields with key field so_key.

Data Sources (4)

SourceAliasJoin Type
demo_sales_order _Inner inner
demo_sales_order _LeftOuter left_outer
demo_sales_order _RightOuter right_outer
t000 client_independent from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View entity_client handling view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY so_key _Assoc so_key
id _Assoc id
id_inner demo_sales_order id
id_LeftOuter demo_sales_order id
id_RightOuter demo_sales_order id
cccategory t000 cccategory
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS View entity_client handling'
define view entity DEMO_CDS_CLIENT_HANDLING
  as select from
                       t000             as client_independent
      left outer join  demo_sales_order as _LeftOuter
        on _LeftOuter.id = client_independent.cccategory
      inner join       demo_sales_order as _Inner
        on _Inner.id = client_independent.cccategory
      right outer join demo_sales_order as _RightOuter
        on _RightOuter.id = client_independent.cccategory
    association to one demo_sales_order as _Assoc
      on _Assoc.id = client_independent.cccategory
    {
      key _Assoc.so_key,
          _Assoc.id,
          _Inner.id      as id_inner,
          _LeftOuter.id  as id_LeftOuter,
          _RightOuter.id as id_RightOuter,
          client_independent.cccategory
    }
    where client_independent.mtext = abap.char'SAP AG Konzern'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DEMO_SALES_ORDER",
"T000"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/