Which tables does I_Sadl_Mk_Draft_Root_Core use?

I_Sadl_Mk_Draft_Root_Core reads from 1 data source(s): snwd_so.

How many fields does I_Sadl_Mk_Draft_Root_Core have?

I_Sadl_Mk_Draft_Root_Core has 12 fields. Key fields: SalesOrder, Version.

I_Sadl_Mk_Draft_Root_Core

DDL: I_SADL_MK_DRAFT_ROOT_CORE SQL: ISADLMKCROOT Type: view

Test scenario: multiple key fields

I_Sadl_Mk_Draft_Root_Core is a CDS View that provides data about "Test scenario: multiple key fields" in SAP S/4HANA. It reads from 1 data source (snwd_so) and exposes 12 fields with key fields SalesOrder, Version. It has 6 associations to related views.

Data Sources (1)

Source	Alias	Join Type
snwd_so	header	from

Associations (6)

Cardinality	Target	Alias	Condition
[0..*]	I_Sadl_Mk_Draft_Item_Core	_Items	`_Items.SalesOrder = $projection.SalesOrder and _Items.Version = $projection.Version`
[0..*]	I_Sadl_Mk_Draft_Item_IV_Core	_ItemsInvalidV	`_ItemsInvalidV.SalesOrder = $projection.SalesOrder and _ItemsInvalidV.Version = $projection.Version`
[0..*]	I_Sadl_Mk_Draft_Item_IW_Core	_ItemsInvalidW	`_ItemsInvalidW.SalesOrder = $projection.SalesOrder and _ItemsInvalidW.Version = $projection.Version`
[0..*]	I_Sadl_Mk_Draft_Item_IX_Core	_ItemsInvalidX	`_ItemsInvalidX.SalesOrder = $projection.SalesOrder`
[0..*]	I_Sadl_Mk_Draft_Item_IY_Core	_ItemsInvalidY	`_ItemsInvalidY.SalesOrder = $projection.SalesOrder and _ItemsInvalidY.Version = $projection.Version`
[0..*]	I_Sadl_Mk_Draft_Item_IZ_Core	_ItemsInvalidZ	`_ItemsInvalidZ.SalesOrder = $projection.SalesOrder and _ItemsInvalidZ.Version = $projection.Version`

Annotations (2)

Name	Value	Level	Field
AbapCatalog.sqlViewName	ISADLMKCROOT	view
EndUserText.label	Test scenario: multiple key fields	view

Fields (12)

Key	Field	Source Table	Source Field
KEY	SalesOrder	snwd_so	so_id
KEY	Version
	CurrencyCode	snwd_so	currency_code
	GrossAmount	snwd_so	gross_amount
	NetAmount	snwd_so	net_amount
	TaxAmount	snwd_so	tax_amount
	_Items		_Items
	_ItemsInvalidV		_ItemsInvalidV
	_ItemsInvalidW		_ItemsInvalidW
	_ItemsInvalidX		_ItemsInvalidX
	_ItemsInvalidY		_ItemsInvalidY
	_ItemsInvalidZ		_ItemsInvalidZ

@AbapCatalog.sqlViewName: 'ISADLMKCROOT'
@EndUserText.label: 'Test scenario: multiple key fields'

define view I_Sadl_Mk_Draft_Root_Core as select from snwd_so as header 
 association [0..*] to I_Sadl_Mk_Draft_Item_Core as _Items 
 on _Items.SalesOrder = $projection.SalesOrder
 and _Items.Version = $projection.Version
 
 association [0..*] to I_Sadl_Mk_Draft_Item_IV_Core as _ItemsInvalidV 
 on _ItemsInvalidV.SalesOrder = $projection.SalesOrder
 and _ItemsInvalidV.Version = $projection.Version
 
 association [0..*] to I_Sadl_Mk_Draft_Item_IW_Core as _ItemsInvalidW 
 on _ItemsInvalidW.SalesOrder = $projection.SalesOrder
 and _ItemsInvalidW.Version = $projection.Version
 
 association [0..*] to I_Sadl_Mk_Draft_Item_IX_Core as _ItemsInvalidX 
 on _ItemsInvalidX.SalesOrder = $projection.SalesOrder
 
 association [0..*] to I_Sadl_Mk_Draft_Item_IY_Core as _ItemsInvalidY 
 on _ItemsInvalidY.SalesOrder = $projection.SalesOrder
 and _ItemsInvalidY.Version = $projection.Version
 
 association [0..*] to I_Sadl_Mk_Draft_Item_IZ_Core as _ItemsInvalidZ 
 on _ItemsInvalidZ.SalesOrder = $projection.SalesOrder
 and _ItemsInvalidZ.Version = $projection.Version
{
 key header.so_id as SalesOrder, 
 
 key '0000' as Version,
 
 @Semantics.currencyCode: true
 header.currency_code as CurrencyCode, 
 
 @Semantics.amount.currencyCode: 'CurrencyCode'
 header.gross_amount as GrossAmount, 
 
 @Semantics.amount.currencyCode: 'CurrencyCode'
 header.net_amount as NetAmount, 
 
 @Semantics.amount.currencyCode: 'CurrencyCode'
 header.tax_amount as TaxAmount,
 
 @ObjectModel.association.type: #TO_COMPOSITION_CHILD 
 _Items,
 
 @ObjectModel.association.type: #TO_COMPOSITION_CHILD 
 _ItemsInvalidV,
 
 @ObjectModel.association.type: #TO_COMPOSITION_CHILD 
 _ItemsInvalidW,
 
 @ObjectModel.association.type: #TO_COMPOSITION_CHILD 
 _ItemsInvalidX,
 
 @ObjectModel.association.type: #TO_COMPOSITION_CHILD 
 _ItemsInvalidY,
 
 @ObjectModel.association.type: #TO_COMPOSITION_CHILD 
 _ItemsInvalidZ
}                      
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"SNWD_SO"
],
"ASSOCIATED":
[
"I_SADL_MK_DRAFT_ITEM_CORE",
"I_SADL_MK_DRAFT_ITEM_IV_CORE",
"I_SADL_MK_DRAFT_ITEM_IW_CORE",
"I_SADL_MK_DRAFT_ITEM_IX_CORE",
"I_SADL_MK_DRAFT_ITEM_IY_CORE",
"I_SADL_MK_DRAFT_ITEM_IZ_CORE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Depth:

I_Sadl_Mk_Draft_Root_Core view

snwd_so