P_STOItmSchdlnAnlyts

DDL: P_STOITMSCHDLNANLYTS SQL: PSDSTOSCHDLANLY Type: view COMPOSITE Package: ODATA_LE_SHP_DLV_PERF
8 Fields 1 Data Sources

Schedule Line Analytics for STO

P_STOItmSchdlnAnlyts is a Composite CDS View that provides data about "Schedule Line Analytics for STO" in SAP S/4HANA. It reads from 1 data source (I_StockTransptOrdScheduleLine) and exposes 8 fields. Part of development package ODATA_LE_SHP_DLV_PERF.

Data Sources (1)

SourceAliasJoin Type
I_StockTransptOrdScheduleLine SL from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSDSTOSCHDLANLY view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
SchdLnSTODoc PurchaseOrder Purchasing Document
SchdLnSTODocItm PurchaseOrderItem Purchasing Document Item
_SchdLnSTODoc _StockTransportOrder
_SchdLnSTODocItem _StockTransportOrderItem
LatestDelivDate
LatestPossibleGRDate
LatestPlndGIDate
STODeliveredQuantity

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_STOItmSchdlnAnlyts.
-- 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: PSDSTOSCHDLANLY

CREATE VIEW P_STOItmSchdlnAnlyts AS
SELECT
  PurchaseOrder AS SchdLnSTODoc,
  PurchaseOrderItem AS SchdLnSTODocItm,
  max (SL.SchedLineStscDeliveryDate) AS LatestDelivDate,
  cast ( max (SL.STOLatestPossibleGRDate) as eldat ) AS LatestPossibleGRDate,
  cast ( max (SL.GoodsIssueDate) as earliest_plnd_gi_date ) AS LatestPlndGIDate,
  max(StockTransferDeliveredQuantity) AS STODeliveredQuantity
FROM I_StockTransptOrdScheduleLine AS SL
;

Learn More