P_PurchOrderSchedLineReqFields

DDL: P_PURCHORDERSCHEDLINEREQFIELDS Type: view_entity COMPOSITE Package: ODATA_MM_PUR_POITEMS_MONI
13 Fields 1 Data Sources

Purchase Order Schedule Line Required Fields

P_PurchOrderSchedLineReqFields is a Composite CDS View that provides data about "Purchase Order Schedule Line Required Fields" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderScheduleLine) and exposes 13 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine. Part of development package ODATA_MM_PUR_POITEMS_MONI.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderScheduleLine _PurchaseOrderScheduleLine from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderScheduleLine PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderScheduleLine PurchaseOrderItem Purchasing Document Item
KEY ScheduleLine I_PurchaseOrderScheduleLine ScheduleLine Schedule Line
ScheduleLineDeliveryDate I_PurchaseOrderScheduleLine ScheduleLineDeliveryDate Delivery Date
OpenPurchaseOrderQuantity
PurchaseOrderQuantityUnit _PurchaseOrderItem PurchaseOrderQuantityUnit Order Unit
CompanyCode _PurchaseOrderItem CompanyCode Receiver Company Code
Plant _PurchaseOrderItem Plant Valuation Area
Material _PurchaseOrderItem Material Vehicle Model
Supplier _PurchaseOrder Supplier Supplier
PurchasingOrganization _PurchaseOrder PurchasingOrganization Purchasing Organization
PurchasingGroup _PurchaseOrder PurchasingGroup Purchasing Group
_PurchaseOrderItem _PurchaseOrderItem

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_PurchOrderSchedLineReqFields.
-- 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.

CREATE VIEW P_PurchOrderSchedLineReqFields AS
SELECT
  _PurchaseOrderScheduleLine.PurchaseOrder AS PurchaseOrder,
  _PurchaseOrderScheduleLine.PurchaseOrderItem AS PurchaseOrderItem,
  _PurchaseOrderScheduleLine.ScheduleLine AS ScheduleLine,
  _PurchaseOrderScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  cast( _PurchaseOrderScheduleLine.OpenPurchaseOrderQuantity as abap.dec(13,3)) AS OpenPurchaseOrderQuantity,
  _PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _PurchaseOrderItem.CompanyCode AS CompanyCode,
  _PurchaseOrderItem.Plant AS Plant,
  _PurchaseOrderItem.Material AS Material,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup
FROM I_PurchaseOrderScheduleLine AS _PurchaseOrderScheduleLine
;

Learn More