P_SubcontrgOrdsSchedLines

DDL: P_SUBCONTRGORDSSCHEDLINES SQL: PSUBSCHEDLINE Type: view COMPOSITE
10 Fields 2 Data Sources

P_SubcontrgOrdsSchedLines is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_SubcontractingComponent, I_SubcontractingComponent) and exposes 10 fields with key fields PurchasingDocument, PurchasingDocumentItem, ScheduleLine, Material, Plant.

Data Sources (2)

SourceAliasJoin Type
I_SubcontractingComponent PurgDocScheduleLine1 from
I_SubcontractingComponent PurgDocScheduleLine2 inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSUBSCHEDLINE 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 I_SubcontractingComponent PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem I_SubcontractingComponent PurchasingDocumentItem Purchasing Doc. Item
KEY ScheduleLine I_SubcontractingComponent ScheduleLine Schedule Line
KEY Material I_SubcontractingComponent Material Vehicle Model
KEY Plant I_SubcontractingComponent Plant Valuation Area
KEY Supplier I_SubcontractingComponent Supplier Supplier
KEY RequirementDate I_SubcontractingComponent RequirementDate Requirement Date
KEY Reservation I_SubcontractingComponent Reservation Reservation
KEY ReservationItem I_SubcontractingComponent ReservationItem Reservation Item
RequiredQuantity I_SubcontractingComponent RequiredQuantity Requirement qty

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_SubcontrgOrdsSchedLines.
-- 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: PSUBSCHEDLINE

CREATE VIEW P_SubcontrgOrdsSchedLines AS
SELECT
  PurgDocScheduleLine1.PurchasingDocument AS PurchasingDocument,
  PurgDocScheduleLine1.PurchasingDocumentItem AS PurchasingDocumentItem,
  PurgDocScheduleLine1.ScheduleLine AS ScheduleLine,
  PurgDocScheduleLine1.Material AS Material,
  PurgDocScheduleLine1.Plant AS Plant,
  PurgDocScheduleLine1.Supplier AS Supplier,
  PurgDocScheduleLine1.RequirementDate AS RequirementDate,
  PurgDocScheduleLine1.Reservation AS Reservation,
  PurgDocScheduleLine1.ReservationItem AS ReservationItem,
  PurgDocScheduleLine1.RequiredQuantity AS RequiredQuantity
FROM I_SubcontractingComponent AS PurgDocScheduleLine1
INNER JOIN I_SubcontractingComponent AS PurgDocScheduleLine2 ON /* join condition not captured in parsed metadata */
;

Learn More