P_HndlgUnitGoodsRcptSts_F4674

DDL: P_HNDLGUNITGOODSRCPTSTS_F4674 SQL: PHUGRSTSSF4674 Type: view CONSUMPTION Package: RFM_STORE_MY_STORE_OVERVIEW
9 Fields 2 Data Sources

Goods Receipt Status of Handling Unit

P_HndlgUnitGoodsRcptSts_F4674 is a Consumption CDS View that provides data about "Goods Receipt Status of Handling Unit" in SAP S/4HANA. It reads from 2 data sources (P_HandlingUnitAggrgdQty_F4674, P_HndlgUnitWthTopLevelID_F4674) and exposes 9 fields with key fields Store, DeliveryDocument, HandlingUnitInternalID. Part of development package RFM_STORE_MY_STORE_OVERVIEW.

Data Sources (2)

SourceAliasJoin Type
P_HandlingUnitAggrgdQty_F4674 HandlingUnitAggrgdQty from
P_HndlgUnitWthTopLevelID_F4674 HandlingUnitWithTopLevelID inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PHUGRSTSSF4674 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 #CONSUMPTION view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Store P_HandlingUnitAggrgdQty_F4674 Store Plant
KEY DeliveryDocument DeliveryDocument Outbound Delivery
KEY HandlingUnitInternalID P_HandlingUnitAggrgdQty_F4674 HandlingUnitInternalID
HandlingUnitExternalID P_HndlgUnitWthTopLevelID_F4674 HandlingUnitExternalID Handling Unit
DeliveryDate DeliveryDate Delivery Date
SupplyingSite P_HandlingUnitAggrgdQty_F4674 SupplyingSite
Supplier P_HandlingUnitAggrgdQty_F4674 Supplier Supplier
NumberOfHandlingUnits
DeliveryDateOffsetInDays

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_HndlgUnitGoodsRcptSts_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: PHUGRSTSSF4674

CREATE VIEW P_HndlgUnitGoodsRcptSts_F4674 AS
SELECT
  HandlingUnitAggrgdQty.Store AS Store,
  DeliveryDocument,
  HandlingUnitAggrgdQty.HandlingUnitInternalID AS HandlingUnitInternalID,
  HandlingUnitWithTopLevelID.HandlingUnitExternalID AS HandlingUnitExternalID,
  DeliveryDate,
  HandlingUnitAggrgdQty.SupplyingSite AS SupplyingSite,
  HandlingUnitAggrgdQty.Supplier AS Supplier,
  cast(1 as abap.int4) AS NumberOfHandlingUnits,
  dats_days_between(cast( $session.system_date as abap.dats), DeliveryDate) AS DeliveryDateOffsetInDays
FROM P_HandlingUnitAggrgdQty_F4674 AS HandlingUnitAggrgdQty
INNER JOIN P_HndlgUnitWthTopLevelID_F4674 AS HandlingUnitWithTopLevelID ON /* join condition not captured in parsed metadata */
;

Learn More