P_HandlingUnitItmQty_F4674

DDL: P_HANDLINGUNITITMQTY_F4674 SQL: PHUITMQTYF4674 Type: view COMPOSITE Package: RFM_STORE_MY_STORE_OVERVIEW
13 Fields 2 Data Sources

Quantities per Handling Unit Item

P_HandlingUnitItmQty_F4674 is a Composite CDS View that provides data about "Quantities per Handling Unit Item" in SAP S/4HANA. It reads from 2 data sources (P_HndlgUnitItmCmptblty_F4674, P_DelivHndlgUnitForStore_F4674) and exposes 13 fields with key fields Store, DeliveryDocument, HandlingUnitInternalID, HandlingUnitItem. Part of development package RFM_STORE_MY_STORE_OVERVIEW.

Data Sources (2)

SourceAliasJoin Type
P_HndlgUnitItmCmptblty_F4674 HuItemCompat inner
P_DelivHndlgUnitForStore_F4674 IncomingHandlingUnit from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PHUITMQTYF4674 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 (13)

KeyFieldSource TableSource FieldDescription
KEY Store P_DelivHndlgUnitForStore_F4674 Store Plant
KEY DeliveryDocument P_DelivHndlgUnitForStore_F4674 DeliveryDocument Outbound Delivery
KEY HandlingUnitInternalID P_DelivHndlgUnitForStore_F4674 HandlingUnitInternalID
KEY HandlingUnitItem HandlingUnitItem
DeliveryDate P_DelivHndlgUnitForStore_F4674 DeliveryDate Delivery Date
OverallGoodsMovementStatus P_DelivHndlgUnitForStore_F4674 OverallGoodsMovementStatus
SupplyingSite P_DelivHndlgUnitForStore_F4674 SupplyingSite
Supplier P_DelivHndlgUnitForStore_F4674 Supplier Supplier
PurchaseOrder P_DelivHndlgUnitForStore_F4674 PurchaseOrder Purchasing Document
HandlingUnitPackingObjectType P_DelivHndlgUnitForStore_F4674 HandlingUnitPackingObjectType
PackedQuantity P_HndlgUnitItmCmptblty_F4674 HandlingUnitQuantity Packed Quantity
PostedQuantity
PostedQuantity0asvemngendasOpenQuantity

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_HandlingUnitItmQty_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: PHUITMQTYF4674

CREATE VIEW P_HandlingUnitItmQty_F4674 AS
SELECT
  IncomingHandlingUnit.Store AS Store,
  IncomingHandlingUnit.DeliveryDocument AS DeliveryDocument,
  IncomingHandlingUnit.HandlingUnitInternalID AS HandlingUnitInternalID,
  HandlingUnitItem,
  IncomingHandlingUnit.DeliveryDate AS DeliveryDate,
  IncomingHandlingUnit.OverallGoodsMovementStatus AS OverallGoodsMovementStatus,
  IncomingHandlingUnit.SupplyingSite AS SupplyingSite,
  IncomingHandlingUnit.Supplier AS Supplier,
  IncomingHandlingUnit.PurchaseOrder AS PurchaseOrder,
  IncomingHandlingUnit.HandlingUnitPackingObjectType AS HandlingUnitPackingObjectType,
  HuItemCompat.HandlingUnitQuantity AS PackedQuantity,
  cast(coalesce(PostHandlingUnitItem.PostedQuantity, 0) as vemng) AS PostedQuantity,
  case PurchaseOrderItem.IsCompletelyDelivered when 'X' then cast(0 as vemng) else cast(HuItemCompat.HandlingUnitQuantity - coalesce( PostHandlingUnitItem.PostedQuantity, 0) as vemng) end as OpenQuantity AS PostedQuantity0asvemngendasOpenQuantity
FROM P_DelivHndlgUnitForStore_F4674 AS IncomingHandlingUnit
INNER JOIN P_HndlgUnitItmCmptblty_F4674 AS HuItemCompat ON /* join condition not captured in parsed metadata */
;

Learn More