P_PurOrdSchedLineEnhdDocCat

DDL: P_PURORDSCHEDLINEENHDDOCCAT SQL: PPURORDSCHENH Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
89 Fields 3 Data Sources

Time Variance details for various document categoty

P_PurOrdSchedLineEnhdDocCat is a Consumption CDS View that provides data about "Time Variance details for various document categoty" in SAP S/4HANA. It reads from 3 data sources (I_PurOrdScheduleLineEnhanced, I_SchedgAgrmtSchedLineEnhcd, I_PurgDocScheduleLineEnhanced) and exposes 89 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine, PurchaseOrderItem, ScheduleLine. Part of development package ODATA_MM_ANALYTICS.

Data Sources (3)

SourceAliasJoin Type
I_PurOrdScheduleLineEnhanced PurchaseOrder from
I_SchedgAgrmtSchedLineEnhcd PurchaseOrder union_all
I_PurgDocScheduleLineEnhanced PurchaseOrder union_all

Parameters (2)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPURORDSCHENH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
EndUserText.label Time Variance details for various document categoty view

Fields (89)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Doc. Item
KEY ScheduleLine ScheduleLine Schedule Line
PurchaseOrderItemUniqueID
PurchaseOrderDate PurchaseOrderDate PO Date
NetAmount NetAmount Stated Amount
DocumentCurrency DocumentCurrency Document Currency
SchedLineStscDeliveryDate SchedLineStscDeliveryDate Stat. Del. Date
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
OriglPOSchdLnDelivDte OriglPOSchdLnDelivDte Original Dlv Dte
OriglPOSchedLineStstclDelivDte OriglPOSchedLineStstclDelivDte Origl Ststcl Dlv Dte
SuplrEvalRelevantDocCategory
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
Supplier Supplier Supplier
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Purchasing Document Order Qty Unit
PurOrdItmFirstGRPostingDate PurOrdItmFirstGRPostingDate First GR Date
PurOrdItmFinalGRPostingDate PurOrdItmFinalGRPostingDate Final GR Date
OriglPurOrdItm1stGRPostgDte OriglPurOrdItm1stGRPostgDte Original First GR Dt
OriglPurOrdItmFnlGRPostgDte OriglPurOrdItmFnlGRPostgDte Original Final GR Dt
TimeVarianceInDays TimeVarianceInDays Overdue Days
TimeVarianceInPct TimeVarianceInPct Stat. Delivery Var
TimeVarianceInPctByDelivDate TimeVarianceInPctByDelivDate Delivery Date Var
TimeVarianceScore TimeVarianceScore Time Variance Score
TimeVarianceScoreByDelivDate TimeVarianceScoreByDelivDate Delivery Date Score
KEY PurchaseOrderItem SchedulingAgreementItem Purchasing Doc. Item
KEY ScheduleLine ScheduleLine Schedule Line
PurchaseOrderItemUniqueID
PurchaseOrderDate PurchaseOrderDate PO Date
NetAmount NetAmount Stated Amount
DocumentCurrency DocumentCurrency Document Currency
SchedLineStscDeliveryDate SchedLineStscDeliveryDate Stat. Del. Date
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
OriglPOSchdLnDelivDte OriglPurgDocSchedLineDelivDte Original Dlv Dte
OriglPOSchedLineStstclDelivDte OriglPurgDocItemStstclDelivDte Origl Ststcl Dlv Dte
SuplrEvalRelevantDocCategory
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
Supplier Supplier Supplier
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
PurchaseOrderQuantityUnit PurgDocOrderQuantityUnit Purchasing Document Order Qty Unit
PurOrdItmFirstGRPostingDate PurDocItmFirstGRPostingDate First GR Date
PurOrdItmFinalGRPostingDate PurDocItmFinalGRPostingDate Final GR Date
OriglPurOrdItm1stGRPostgDte OriglPurgDocItm1stGRPostgDte Original First GR Dt
OriglPurOrdItmFnlGRPostgDte OriglPurgDocItmFnlGRPostgDte Original Final GR Dt
TimeVarianceInDays TimeVarianceInDays Overdue Days
TimeVarianceInPct TimeVarianceInPct Stat. Delivery Var
TimeVarianceInPctByDelivDate TimeVarianceInPctByDelivDate Delivery Date Var
TimeVarianceScore TimeVarianceScore Time Variance Score
TimeVarianceScoreByDelivDate TimeVarianceScoreByDelivDate Delivery Date Score
KEY PurchaseOrderItem PurchasingDocumentItem Purchasing Doc. Item
KEY ScheduleLine ScheduleLine Schedule Line
PurchaseOrderItemUniqueID
PurchaseOrderDate PurchaseOrderDate PO Date
NetAmount NetAmount Stated Amount
DocumentCurrency DocumentCurrency Document Currency
SchedLineStscDeliveryDate SchedLineStscDeliveryDate Stat. Del. Date
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
OriglPOSchdLnDelivDte OriglPurgDocSchedLineDelivDte Original Dlv Dte
OriglPOSchedLineStstclDelivDte OriglPurgDocItemStstclDelivDte Origl Ststcl Dlv Dte
SuplrEvalRelevantDocCategory
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
Supplier Supplier Supplier
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
PurchaseOrderQuantityUnit PurgDocOrderQuantityUnit Purchasing Document Order Qty Unit
PurOrdItmFirstGRPostingDate PurDocItmFirstGRPostingDate First GR Date
PurOrdItmFinalGRPostingDate PurDocItmFinalGRPostingDate Final GR Date
OriglPurOrdItm1stGRPostgDte OriglPurgDocItm1stGRPostgDte Original First GR Dt
OriglPurOrdItmFnlGRPostgDte OriglPurgDocItmFnlGRPostgDte Original Final GR Dt
TimeVarianceInDays TimeVarianceInDays Overdue Days
TimeVarianceInPct TimeVarianceInPct Stat. Delivery Var
TimeVarianceInPctByDelivDate TimeVarianceInPctByDelivDate Delivery Date Var
TimeVarianceScore TimeVarianceScore Time Variance Score
TimeVarianceScoreByDelivDate TimeVarianceScoreByDelivDate Delivery Date Score
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category

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_PurOrdSchedLineEnhdDocCat.
-- 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: PPURORDSCHENH
-- Parameters: P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_PurOrdSchedLineEnhdDocCat AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  ScheduleLine,
  cast(concat(PurchaseOrder , PurchaseOrderItem ) as char14 ) AS PurchaseOrderItemUniqueID,
  PurchaseOrderDate,
  NetAmount,
  DocumentCurrency,
  SchedLineStscDeliveryDate,
  ScheduleLineDeliveryDate,
  OriglPOSchdLnDelivDte,
  OriglPOSchedLineStstclDelivDte,
  cast ( '1' as mmpur_ana_de_se_doc_config ) AS SuplrEvalRelevantDocCategory,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  Supplier,
  Material,
  MaterialGroup,
  Plant,
  ScheduleLineOrderQuantity,
  PurchaseOrderQuantityUnit,
  PurOrdItmFirstGRPostingDate,
  PurOrdItmFinalGRPostingDate,
  OriglPurOrdItm1stGRPostgDte,
  OriglPurOrdItmFnlGRPostgDte,
  TimeVarianceInDays,
  TimeVarianceInPct,
  TimeVarianceInPctByDelivDate,
  TimeVarianceScore,
  TimeVarianceScoreByDelivDate,
  PurchasingDocumentCategory
FROM I_PurOrdScheduleLineEnhanced AS PurchaseOrder
-- UNION ALL with additional select branch(es): I_SchedgAgrmtSchedLineEnhcd, I_PurgDocScheduleLineEnhanced
;

Learn More