P_HandlingUnitAggrgdQty_F4674

DDL: P_HANDLINGUNITAGGRGDQTY_F4674 SQL: PHUAGGRQTYF4674 Type: view COMPOSITE Package: RFM_STORE_MY_STORE_OVERVIEW
12 Fields 1 Data Sources

Aggregated Quantities for Handling Unit

P_HandlingUnitAggrgdQty_F4674 is a Composite CDS View that provides data about "Aggregated Quantities for Handling Unit" in SAP S/4HANA. It reads from 1 data source (P_HandlingUnitItmQty_F4674) and exposes 12 fields with key fields Store, DeliveryDocument, HandlingUnitInternalID. Part of development package RFM_STORE_MY_STORE_OVERVIEW.

Data Sources (1)

SourceAliasJoin Type
P_HandlingUnitItmQty_F4674 P_HandlingUnitItmQty_F4674 from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PHUAGGRQTYF4674 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Store Store Plant
KEY DeliveryDocument DeliveryDocument Outbound Delivery
KEY HandlingUnitInternalID HandlingUnitInternalID
OverallGoodsMovementStatus OverallGoodsMovementStatus
DeliveryDate DeliveryDate Delivery Date
SupplyingSite SupplyingSite
Supplier Supplier Supplier
PurchaseOrder PurchaseOrder Purchasing Document
HandlingUnitPackingObjectType HandlingUnitPackingObjectType
PackedQuantity
PostedQuantity
MaxOpenQuantity

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 P_HandlingUnitAggrgdQty_F4674.
-- 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: PHUAGGRQTYF4674

CREATE VIEW P_HandlingUnitAggrgdQty_F4674 AS
SELECT
  Store,
  DeliveryDocument,
  HandlingUnitInternalID,
  OverallGoodsMovementStatus,
  DeliveryDate,
  SupplyingSite,
  Supplier,
  PurchaseOrder,
  HandlingUnitPackingObjectType,
  sum(PackedQuantity) AS PackedQuantity,
  sum(PostedQuantity) AS PostedQuantity,
  max(OpenQuantity) AS MaxOpenQuantity
FROM P_HandlingUnitItmQty_F4674
;

Learn More