P_PendingGIPerScheduleLine

DDL: P_PENDINGGIPERSCHEDULELINE SQL: PPENDINGGISC Type: view COMPOSITE Package: ODATA_MM_PUR_SUBCONTRG_COCKPIT
10 Fields 1 Data Sources

Pending GI Qty Per Schedule Line

P_PendingGIPerScheduleLine is a Composite CDS View that provides data about "Pending GI Qty Per Schedule Line" in SAP S/4HANA. It reads from 1 data source (P_PendingGIQty) and exposes 10 fields with key fields PurchasingDocument, PurchasingDocumentItem, Material, Supplier, Plant. Part of development package ODATA_MM_PUR_SUBCONTRG_COCKPIT.

Data Sources (1)

SourceAliasJoin Type
P_PendingGIQty PendingGIQty from

Annotations (6)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument P_PendingGIQty PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem P_PendingGIQty PurchasingDocumentItem Purchasing Doc. Item
KEY Material Material Vehicle Model
KEY Supplier Supplier Supplier
KEY Plant Plant Valuation Area
KEY ScheduleLine P_PendingGIQty ScheduleLine Schedule Line
KEY RequirementDate RequirementDate Requirement Date
KEY Reservation Reservation Reservation
KEY ReservationItem ReservationItem Reservation Item
PendingQuantityendasCommittedQuantity

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_PendingGIPerScheduleLine.
-- 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: PPENDINGGISC

CREATE VIEW P_PendingGIPerScheduleLine AS
SELECT
  PendingGIQty.PurchasingDocument AS PurchasingDocument,
  PendingGIQty.PurchasingDocumentItem AS PurchasingDocumentItem,
  Material,
  Supplier,
  Plant,
  PendingGIQty.ScheduleLine AS ScheduleLine,
  RequirementDate,
  Reservation,
  ReservationItem,
  case when PendingGIQty.PendingQuantity <= 0 then cast (0 as abap.quan(13)) else PendingGIQty.PendingQuantity end as CommittedQuantity AS PendingQuantityendasCommittedQuantity
FROM P_PendingGIQty AS PendingGIQty
;

Learn More