I_Sadl_DraftItem2Core

DDL: I_SADL_DRAFT_ITEM2_CORE SQL: SADL_DRFT_ITM2_C Type: view BASIC

Item core view

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

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
snwd_so header inner
snwd_so_i item from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Sadl_DraftRootCore _Sadl_DraftRootCore $projection.SalesOrder = _Sadl_DraftRootCore.SalesOrder

Annotations (4)

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

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder snwd_so so_id
KEY ItemPosition snwd_so_i so_item_pos
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 
@AbapCatalog.sqlViewName: 'SADL_DRFT_ITM2_C'
@ClientDependent: false
@EndUserText.label: 'Item core view'
@VDM.viewType:#BASIC

define view I_Sadl_DraftItem2Core as 
    select from snwd_so_i as item 
        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

{
    key header.so_id as SalesOrder,
    key item.so_item_pos   as ItemPosition,
    
    @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_PARENT, #TO_COMPOSITION_ROOT ]
    _Sadl_DraftRootCore
}            
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"SNWD_SO",
"SNWD_SO_I"
],
"ASSOCIATED":
[
"I_SADL_DRAFTROOTCORE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More