Sadl_V_Aunit_Prod_C

DDL: SADL_V_AUNIT_PROD_C SQL: SADLVPROD_C Type: view
25 Fields 1 Data Sources

Consumption View (Searchable)

Sadl_V_Aunit_Prod_C is a CDS View that provides data about "Consumption View (Searchable)" in SAP S/4HANA. It reads from 1 data source (SADL_V_AUnit_Prod) and exposes 25 fields with key field node_key.

Data Sources (1)

SourceAliasJoin Type
SADL_V_AUnit_Prod SADL_V_AUnit_Prod from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SADLVPROD_C view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption View (Searchable) view
Search.searchable true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY node_key node_key Tree Model: Node Key
ProductID ProductID Product ID
type_code type_code Type Code
category category Violation Category
created_by created_by Version Created By
created_at created_at Uploaded On
changed_by changed_by User Name
changed_at changed_at Timestamp
name_guid name_guid Node Key
desc_guid desc_guid Node Key
currency currency Valuation Crcy
measure_unit measure_unit Unit of Measure
UnitOfMeasure UnitOfMeasure Unit Protected Qty
weight_unit weight_unit Weight Unit
price price RVP f.PricePro.
width width Width
depth depth Draught
height height Height
dim_unit dim_unit Unit of length
_Currency _Currency
_Currency2 _Currency2
_Supplier _Supplier
_MeasureUnit _MeasureUnit
_WeightUnit _WeightUnit
_MeasureUnitSpecial _MeasureUnitSpecial

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_Prod_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: SADLVPROD_C

CREATE VIEW Sadl_V_Aunit_Prod_C AS
SELECT
  node_key,
  ProductID,
  type_code,
  category,
  created_by,
  created_at,
  changed_by,
  changed_at,
  name_guid,
  desc_guid,
  currency,
  measure_unit,
  UnitOfMeasure,
  weight_unit,
  price,
  width,
  depth,
  height,
  dim_unit
FROM SADL_V_AUnit_Prod
;

Learn More