SADL_V_CDS_SO_FILTER

DDL: SADL_V_CDS_SO_FILTER SQL: SADLVCDSFI Type: view

SRS SO Root with Draft

SADL_V_CDS_SO_FILTER is a CDS View that provides data about "SRS SO Root with Draft" in SAP S/4HANA. It reads from 1 data source (sadl_rs_so_root) and exposes 4 fields with key field id.

Data Sources (1)

SourceAliasJoin Type
sadl_rs_so_root Document from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName SADLVCDSFI view
EndUserText.label SRS SO Root with Draft view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence SADLCDSFI_DR view
AccessControl.authorizationCheck #CHECK view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view

Fields (4)

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
@AbapCatalog.sqlViewName: 'SADLVCDSFI'
@EndUserText.label: 'SRS SO Root with Draft'
@ObjectModel.compositionRoot: true
@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.writeDraftPersistence: 'SADLCDSFI_DR'
@AccessControl.authorizationCheck: #CHECK

@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: 'EXTERNAL_CALCULATION' // dynamically set to false

@ObjectModel.deleteEnabled: 'EXTERNAL_CALCULATION' // dynamically set to true

@ObjectModel.draftEnabled: true // indicates Draft 2.0


@ObjectModel.semanticKey:  [ 'id' ]


define view SADL_V_CDS_SO_FILTER
  as select from sadl_rs_so_root as Document
//  association [0..*] to I_Sadl_Rs_So_ItemWithD20 as _Item         on $projection.id = _Item.parent_id

//  association [1..1] to Sadl_V_Aunit_Srs_Bp      as _Seller       on $projection.seller_id = _Seller.bp_id

//  association [0..1] to Sadl_V_Rs_Type_Code      as _TypeCode     on $projection.type_code = _TypeCode.TypeCode

//  association [0..*] to Sadl_V_Rs_Type_Code_Text as _TypeCodeText on $projection.type_code = _TypeCodeText.TypeCode


{
  key Document.id,
      @ObjectModel.enabled: 'EXTERNAL_CALCULATION'
      Document.seller_id,
      Document.buyer_id,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      Document.act_indicator,
//      @ObjectModel.foreignKey.association: '_TypeCode'

//      @ObjectModel.text.association: '_TypeCodeText'  // text annotation needed to get denormalized text field.

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      Document.type_code
//      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]

//      _Item,

//      _Seller,

//      _TypeCode,

//      _TypeCodeText

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