Sadl_V_AUnit_P_SOI_C

DDL: SADL_V_AUNIT_P_SOI_C SQL: SADLVAPSOIC Type: view
12 Fields 1 Data Sources

Sales Order Item Consumption

Sadl_V_AUnit_P_SOI_C is a CDS View that provides data about "Sales Order Item Consumption" in SAP S/4HANA. It reads from 1 data source (SADL_V_AUnit_SOI) and exposes 12 fields with key fields SalesOrderID, SalesOrderItemPosition.

Data Sources (1)

SourceAliasJoin Type
SADL_V_AUnit_SOI Item from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SADLVAPSOIC view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Sales Order Item Consumption view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderID SalesOrderID
KEY SalesOrderItemPosition SalesOrderItemPosition Item Position
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
node_key node_key Tree Model: Node Key
parent_key parent_key UUID
_Currency _Currency
_Product _Product
_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_P_SOI_C.
-- 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: SADLVAPSOIC

CREATE VIEW Sadl_V_AUnit_P_SOI_C AS
SELECT
  SalesOrderID,
  SalesOrderItemPosition,
  product_guid,
  note_guid,
  gross_amount,
  net_amount,
  tax_amount,
  node_key,
  parent_key
FROM SADL_V_AUnit_SOI AS Item
;

Learn More