I_Sadl_DraftRootCore

DDL: I_SADL_DRAFT_ROOT_CORE SQL: SADL_DRFT_ROOT_C Type: view BASIC

Root core view

I_Sadl_DraftRootCore is a Basic CDS View that provides data about "Root core view" in SAP S/4HANA. It reads from 1 data source (snwd_so) and exposes 7 fields with key field SalesOrder. It has 4 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
snwd_so header from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_Sadl_DraftItemCore _Sadl_DraftItemCore $projection.SalesOrder = _Sadl_DraftItemCore.SalesOrder
[0..*] I_Sadl_DraftItem2Core _Sadl_DraftItem2Core $projection.SalesOrder = _Sadl_DraftItem2Core.SalesOrder
[0..*] I_Sadl_DraftItem0Core _Sadl_DraftItem0Core $projection.SalesOrder = _Sadl_DraftItem0Core.SalesOrder
[0..*] I_Sadl_Draft_CC_VH _Sadl_Draft_CC_VH $projection.CurrencyCode = _Sadl_Draft_CC_VH.CurrencyCode

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SADL_DRFT_ROOT_C view
ClientDependent false view
EndUserText.label Root core view view
ObjectModel.compositionRoot true view
VDM.viewType #BASIC view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder snwd_so so_id
CurrencyCode snwd_so currency_code
GrossAmount snwd_so gross_amount
_Sadl_DraftItemCore _Sadl_DraftItemCore
_Sadl_DraftItem2Core _Sadl_DraftItem2Core
_Sadl_DraftItem0Core _Sadl_DraftItem0Core
_Sadl_Draft_CC_VH _Sadl_Draft_CC_VH 
@AbapCatalog.sqlViewName: 'SADL_DRFT_ROOT_C'
@ClientDependent: false
@EndUserText.label: 'Root core view'
@ObjectModel.compositionRoot: true
@VDM.viewType: #BASIC

define view I_Sadl_DraftRootCore as 
    select from snwd_so as header
        association [0..*] to I_Sadl_DraftItemCore as _Sadl_DraftItemCore on $projection.SalesOrder = _Sadl_DraftItemCore.SalesOrder
        association [0..*] to I_Sadl_DraftItem2Core as _Sadl_DraftItem2Core on $projection.SalesOrder = _Sadl_DraftItem2Core.SalesOrder
        association [0..*] to I_Sadl_DraftItem0Core as _Sadl_DraftItem0Core on $projection.SalesOrder = _Sadl_DraftItem0Core.SalesOrder
        
        association [0..*] to I_Sadl_Draft_CC_VH as _Sadl_Draft_CC_VH on $projection.CurrencyCode = _Sadl_Draft_CC_VH.CurrencyCode                                                                           
{
    key header.so_id               as SalesOrder,
    
    @Semantics.currencyCode: true
    @ObjectModel.text.association: '_Sadl_Draft_CC_VH'
    header.currency_code       as CurrencyCode,
    
    @Semantics.amount.currencyCode: 'CurrencyCode'
    header.gross_amount        as GrossAmount,
    
    @ObjectModel.association.type: #TO_COMPOSITION_CHILD
    _Sadl_DraftItemCore,
    @ObjectModel.association.type: #TO_COMPOSITION_CHILD
    _Sadl_DraftItem2Core,
    @ObjectModel.association.type: #TO_COMPOSITION_CHILD
    _Sadl_DraftItem0Core,
    
    @Consumption.filter.hidden: true
    _Sadl_Draft_CC_VH
}
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"SNWD_SO"
],
"ASSOCIATED":
[
"I_SADL_DRAFTITEM0CORE",
"I_SADL_DRAFTITEM2CORE",
"I_SADL_DRAFTITEMCORE",
"I_SADL_DRAFT_CC_VH"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More