P_PurOrdGRSchedLineDetails

DDL: P_PURORDGRSCHEDLINEDETAILS SQL: PMMPOGRSCHEDDET Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
28 Fields 2 Data Sources

Goods Receipt to Schedule Line Mapping

P_PurOrdGRSchedLineDetails is a Consumption CDS View that provides data about "Goods Receipt to Schedule Line Mapping" in SAP S/4HANA. It reads from 2 data sources (P_SuplrEvalTimeVarBaseVal, P_PurOrdGRSchedLineDetails1) and exposes 28 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine, MaterialDocument, MaterialDocumentItem. Part of development package ODATA_MM_ANALYTICS.

Data Sources (2)

SourceAliasJoin Type
P_SuplrEvalTimeVarBaseVal _standardScore inner
P_PurOrdGRSchedLineDetails1 P_PurOrdGRSchedLineDetails1 from

Parameters (2)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMMPOGRSCHEDDET view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
EndUserText.label Goods Receipt to Schedule Line Mapping view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY ScheduleLine ScheduleLine Schedule Line
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchaseOrderDate PurchaseOrderDate PO Date
NetAmount NetAmount Stated Amount
DocumentCurrency DocumentCurrency Document Currency
SchedLineStscDeliveryDate SchedLineStscDeliveryDate Stat. Del. Date
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
PostingDate PostingDate Posting Date for GR
PurchasingOrganization GRScheduleLine PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
Supplier Supplier Supplier
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
Material Material Vehicle Model
MaterialGroup GRScheduleLine MaterialGroup Product Group
Plant Plant Valuation Area
PurchasingCategory GRScheduleLine PurchasingCategory Purchasing Category
PurgCatName PurgCatName Purchasing Cat. Name
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
Quantity Quantity Value
TimeVariance TimeVariance
TimeVarianceByDelieveryDate TimeVarianceByDelieveryDate
TimeVarianceInPctWithSign
TimeVarcInPctWithSignByDD

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_PurOrdGRSchedLineDetails.
-- 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: PMMPOGRSCHEDDET
-- Parameters: P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_PurOrdGRSchedLineDetails AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  ScheduleLine,
  MaterialDocument,
  MaterialDocumentItem,
  PurchasingDocumentCategory,
  PurchaseOrderDate,
  NetAmount,
  DocumentCurrency,
  SchedLineStscDeliveryDate,
  ScheduleLineDeliveryDate,
  PostingDate,
  GRScheduleLine.PurchasingOrganization AS PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  Supplier,
  PurchaseOrderQuantityUnit,
  Material,
  GRScheduleLine.MaterialGroup AS MaterialGroup,
  Plant,
  GRScheduleLine.PurchasingCategory AS PurchasingCategory,
  PurgCatName,
  ScheduleLineOrderQuantity,
  Quantity,
  TimeVariance,
  TimeVarianceByDelieveryDate,
  (DIVISION(TimeVariance, cast( _standardScore.BaseValueForTimeVariance as abap.int4), 3) * cast ( 100 as abap.dec(15,3))) + cast ( 100 as abap.dec(15,3)) AS TimeVarianceInPctWithSign,
  (DIVISION(TimeVarianceByDelieveryDate, cast( _standardScore.BaseValueForTimeVariance as abap.int4), 3) * cast ( 100 as abap.dec(15,3))) + cast ( 100 as abap.dec(15,3)) AS TimeVarcInPctWithSignByDD
FROM P_PurOrdGRSchedLineDetails1
INNER JOIN P_SuplrEvalTimeVarBaseVal AS _standardScore ON /* join condition not captured in parsed metadata */
;

Learn More