I_Sadl_DraftLeafCore

DDL: I_SADL_DRAFT_LEAF_CORE SQL: SADL_DRFT_LEAF_C Type: view BASIC

Item core view

I_Sadl_DraftLeafCore is a Basic CDS View that provides data about "Item core view" in SAP S/4HANA. It reads from 3 data sources (snwd_so, snwd_so_i, snwd_so_sl) and exposes 11 fields with key fields SalesOrder, ItemPosition, DeliveryDate. It has 2 associations to related views.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
snwd_so header inner
snwd_so_i item inner
snwd_so_sl line from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Sadl_DraftRootCore _Sadl_DraftRootCore $projection.SalesOrder = _Sadl_DraftRootCore.SalesOrder
[1..1] I_Sadl_DraftItemCore _Sadl_DraftItemCore $projection.SalesOrder = _Sadl_DraftItemCore.SalesOrder and $projection.ItemPosition = _Sadl_DraftItemCore.ItemPosition

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SADL_DRFT_LEAF_C view
ClientDependent false view
EndUserText.label Item core view view
VDM.viewType #BASIC view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder snwd_so so_id
KEY ItemPosition snwd_so_i so_item_pos
KEY DeliveryDate snwd_so_sl delivery_date
UnitOfMeasure snwd_so_sl quantity_unit
quantity snwd_so_sl quantity
CurrencyCode snwd_so_i currency_code
GrossAmount snwd_so_i gross_amount
netAmount snwd_so_i net_amount
taxAmount snwd_so_i tax_amount
_Sadl_DraftRootCore _Sadl_DraftRootCore
_Sadl_DraftItemCore _Sadl_DraftItemCore 
@AbapCatalog.sqlViewName: 'SADL_DRFT_LEAF_C'
@ClientDependent: false
@EndUserText.label: 'Item core view'
@VDM.viewType:#BASIC

define view I_Sadl_DraftLeafCore as 
    select from snwd_so_sl as line
        inner join snwd_so_i as item on line.parent_key = item.node_key 
        inner join snwd_so as header on item.parent_key = header.node_key
        
        association [1..1] to I_Sadl_DraftRootCore as _Sadl_DraftRootCore 
            on $projection.SalesOrder  = _Sadl_DraftRootCore.SalesOrder
        
        association [1..1] to I_Sadl_DraftItemCore as _Sadl_DraftItemCore 
            on $projection.SalesOrder  = _Sadl_DraftItemCore.SalesOrder and $projection.ItemPosition = _Sadl_DraftItemCore.ItemPosition
{
    key header.so_id as SalesOrder,
    key item.so_item_pos   as ItemPosition,
    
    key line.delivery_date as DeliveryDate,
    
    @Semantics.unitOfMeasure: true
    line.quantity_unit as UnitOfMeasure,
    
    @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
    line.quantity, 
     
    
    @Semantics.currencyCode: true
    item.currency_code as CurrencyCode,
    
    @Semantics.amount.currencyCode: 'CurrencyCode'
    item.gross_amount  as GrossAmount,
    
    @Semantics.amount.currencyCode: 'CurrencyCode'
    item.net_amount    as netAmount,
    
    @Semantics.amount.currencyCode: 'CurrencyCode'
    item.tax_amount    as taxAmount,
    
    @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
    _Sadl_DraftRootCore,
    
    @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
    _Sadl_DraftItemCore
}            
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"SNWD_SO",
"SNWD_SO_I",
"SNWD_SO_SL"
],
"ASSOCIATED":
[
"I_SADL_DRAFTITEMCORE",
"I_SADL_DRAFTROOTCORE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More