SADL_V_AUnit_SOI_ConsumHidden

DDL: SADL_V_AUNIT_SOI_CONSUM_HIDDEN SQL: SADLVASOICONHIDD Type: view Package: SADL_CDS_EXPOSURE
11 Fields 1 Data Sources

Sales Order Item for local unit tests

SADL_V_AUnit_SOI_ConsumHidden is a CDS View that provides data about "Sales Order Item for local unit tests" in SAP S/4HANA. It reads from 1 data source (snwd_so_i) and exposes 11 fields with key field node_key. Part of development package SADL_CDS_EXPOSURE.

Data Sources (1)

SourceAliasJoin Type
snwd_so_i SalesOrderItems from

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName SADLVASOICONHIDD view
EndUserText.label Sales Order Item for local unit tests view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY node_key node_key Tree Model: Node Key
SalesOrderID _SalesOrder SalesOrderID
SalesOrderItemPosition so_item_pos Item Position
parent_key parent_key UUID
product_guid product_guid Product
note_guid note_guid Node Key
gross_amount gross_amount Tax-Inclusive Amount
net_amount net_amount Tax-Exclusive Amount
tax_amount tax_amount VAT Amount Type
op_item_pos op_item_pos Item Position
_SalesOrder _SalesOrder

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view SADL_V_AUnit_SOI_ConsumHidden.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: SADLVASOICONHIDD

CREATE VIEW SADL_V_AUnit_SOI_ConsumHidden AS
SELECT
  node_key,
  _SalesOrder.SalesOrderID AS SalesOrderID,
  so_item_pos AS SalesOrderItemPosition,
  parent_key,
  product_guid,
  note_guid,
  gross_amount,
  net_amount,
  tax_amount,
  op_item_pos
FROM snwd_so_i AS SalesOrderItems
;

Learn More