P_SubcontrgOrdsSchedLinesCuml

DDL: P_SUBCONTRGORDSSCHEDLINESCUML Type: view_entity CONSUMPTION Package: ODATA_MM_PUR_SUBCONTRG_COCKPIT
12 Fields 1 Data Sources 1 Associations

Subcontracting Order Schedule Lines cumulative quantity

P_SubcontrgOrdsSchedLinesCuml is a Consumption CDS View that provides data about "Subcontracting Order Schedule Lines cumulative quantity" in SAP S/4HANA. It reads from 1 data source (P_SubcontrgOrdsSchedLinesTF) and exposes 12 fields with key fields PurchasingDocument, PurchasingDocumentItem, Material, Plant, Supplier. It has 1 association to related views. Part of development package ODATA_MM_PUR_SUBCONTRG_COCKPIT.

Data Sources (1)

SourceAliasJoin Type
P_SubcontrgOrdsSchedLinesTF P_SubcontrgOrdsSchedLinesTF from

Parameters (6)

NameTypeDefault
p_clnt abap.clnt
p_material matnr
p_plant werks_d
p_supplier lifnr
P_ReqdDelivDteRngeFrmDte vdm_shippingdate
P_ReqdDelivDteRngeToDte vdm_shippingdate

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ProcmtShippingStatus _ShippingStatusVH $projection.ShippingStatus = _ShippingStatusVH.DeliveryStatus

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY Supplier Supplier Supplier
KEY RequirementDate RequirementDate Requirement Date
KEY Reservation Reservation Reservation
KEY ReservationItem ReservationItem Reservation Item
StillToBeDeliveredQuantity StillToBeDeliveredQuantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
ShippingStatus ShippingStatus
ShippingStatusText

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_SubcontrgOrdsSchedLinesCuml.
-- 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.
-- Parameters: p_clnt : abap.clnt, p_material : matnr, p_plant : werks_d, p_supplier : lifnr, P_ReqdDelivDteRngeFrmDte : vdm_shippingdate, P_ReqdDelivDteRngeToDte : vdm_shippingdate

CREATE VIEW P_SubcontrgOrdsSchedLinesCuml AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  Material,
  Plant,
  Supplier,
  RequirementDate,
  Reservation,
  ReservationItem,
  StillToBeDeliveredQuantity,
  OrderQuantityUnit,
  ShippingStatus,
  _ShippingStatusVH._Text[1: Language = $session.system_language].DomainText AS ShippingStatusText
FROM P_SubcontrgOrdsSchedLinesTF
LEFT OUTER JOIN I_ProcmtShippingStatus AS _ShippingStatusVH ON ShippingStatus = _ShippingStatusVH.DeliveryStatus  -- association [0..1]
;

Learn More