UPOV_DIM_DENSI_HVALUE

DDL: UPO_INT_V_DIM_DENSI_HVALUE SQL: UPOS_DIMOTHERS Type: view

Allocation Results -Density,HValue Units

UPOV_DIM_DENSI_HVALUE is a CDS View that provides data about "Allocation Results -Density,HValue Units" in SAP S/4HANA. It reads from 4 data sources (gho_allocres_i, gho_uom_rule_h, gho_uom_rule_i, upoc_udm_vtqt_mp) and exposes 4 fields.

Data Sources (4)

SourceAliasJoin Type
gho_allocres_i item_res inner
gho_uom_rule_h uom_hrule inner
gho_uom_rule_i uom_irule inner
upoc_udm_vtqt_mp vtqt inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_DIMOTHERS view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Allocation Results -Density,HValue Units view

Fields (4)

KeyFieldSource TableSource FieldDescription
alloc_run_id gho_allocres_i alloc_run_id Allocation Run ID
dest_node_id gho_allocres_i dest_node_id Node ID
unit gho_allocres_i unit UoM
dimension gho_uom_rule_i dimension Quantity

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 UPOV_DIM_DENSI_HVALUE.
-- 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: UPOS_DIMOTHERS

CREATE VIEW UPOV_DIM_DENSI_HVALUE AS
SELECT
  item_res.alloc_run_id AS alloc_run_id,
  item_res.dest_node_id AS dest_node_id,
  item_res.unit AS unit,
  uom_irule.dimension AS dimension
INNER JOIN gho_allocres_i AS item_res ON /* join condition not captured in parsed metadata */
INNER JOIN gho_uom_rule_h AS uom_hrule ON /* join condition not captured in parsed metadata */
INNER JOIN gho_uom_rule_i AS uom_irule ON /* join condition not captured in parsed metadata */
INNER JOIN upoc_udm_vtqt_mp AS vtqt ON /* join condition not captured in parsed metadata */
;