P_PendingQtyPerScheduleLine

DDL: P_PENDINGQTYPERSCHEDULELINE SQL: PPENDGQTYSCHLINE Type: view COMPOSITE
11 Fields 1 Data Sources 1 Associations

P_PendingQtyPerScheduleLine is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SubcontractingComponent) and exposes 11 fields with key fields PurchasingDocument, PurchasingDocumentItem, Material, Supplier, Plant. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SubcontractingComponent I_SubcontractingComponent from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_PendingGIPerScheduleLine PendingGIPerScheduleLine PendingGIPerScheduleLine.PurchasingDocument = I_SubcontractingComponent.PurchasingDocument and PendingGIPerScheduleLine.PurchasingDocumentItem = I_SubcontractingComponent.PurchasingDocumentItem and PendingGIPerScheduleLine.ScheduleLine = I_SubcontractingComponent.ScheduleLine and PendingGIPerScheduleLine.Material = I_SubcontractingComponent.Material and PendingGIPerScheduleLine.Supplier = I_SubcontractingComponent.Supplier and PendingGIPerScheduleLine.Plant = I_SubcontractingComponent.Plant and PendingGIPerScheduleLine.RequirementDate = I_SubcontractingComponent.RequirementDate and PendingGIPerScheduleLine.Reservation = I_SubcontractingComponent.Reservation and PendingGIPerScheduleLine.ReservationItem = I_SubcontractingComponent.ReservationItem

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPENDGQTYSCHLINE 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 (11)

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

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_PendingQtyPerScheduleLine.
-- 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: PPENDGQTYSCHLINE

CREATE VIEW P_PendingQtyPerScheduleLine AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  Material,
  Supplier,
  Plant,
  ScheduleLine,
  Reservation,
  ReservationItem,
  RequirementDate,
  RequiredQuantity,
  cast(RequiredQuantity - PendingGIPerScheduleLine.CommittedQuantity as abap.quan(13,3)) AS PendingQuantity
FROM I_SubcontractingComponent
LEFT OUTER JOIN P_PendingGIPerScheduleLine AS PendingGIPerScheduleLine ON PendingGIPerScheduleLine.PurchasingDocument = I_SubcontractingComponent.PurchasingDocument AND PendingGIPerScheduleLine.PurchasingDocumentItem = I_SubcontractingComponent.PurchasingDocumentItem AND PendingGIPerScheduleLine.ScheduleLine = I_SubcontractingComponent.ScheduleLine AND PendingGIPerScheduleLine.Material = I_SubcontractingComponent.Material AND PendingGIPerScheduleLine.Supplier = I_SubcontractingComponent.Supplier AND PendingGIPerScheduleLine.Plant = I_SubcontractingComponent.Plant AND PendingGIPerScheduleLine.RequirementDate = I_SubcontractingComponent.RequirementDate AND PendingGIPerScheduleLine.Reservation = I_SubcontractingComponent.Reservation AND PendingGIPerScheduleLine.ReservationItem = I_SubcontractingComponent.ReservationItem  -- association [0..1]
;

Learn More