Sadl_V_Aunit_Soi_C

DDL: SADL_V_AUNIT_SOI_C SQL: SADLVASOIC Type: view
11 Fields 1 Data Sources

Sales Order Item Consumption View for AUTs

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

Data Sources (1)

SourceAliasJoin Type
SADL_V_AUnit_SOI Item from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SADLVASOIC view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Sales Order Item Consumption View for AUTs view

Fields (11)

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
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_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: SADLVASOIC

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

Learn More