P_TimeVariance_OVP

DDL: P_TIMEVARIANCE_OVP SQL: PMMTIMEVARIOVP Type: view CONSUMPTION
16 Fields 2 Data Sources

TimeVariance OVP

P_TimeVariance_OVP is a Consumption CDS View that provides data about "TimeVariance OVP" in SAP S/4HANA. It reads from 2 data sources (P_SupplierEvalByTime1, I_PurOrdScheduleLineEnhanced) and exposes 16 fields with key fields PurchaseOrder, PurchaseOrderItem, PurchaseOrderItem.

Data Sources (2)

SourceAliasJoin Type
P_SupplierEvalByTime1 P_SupplierEvalByTime1 union_all
I_PurOrdScheduleLineEnhanced PurchaseOrder from

Parameters (2)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMMTIMEVARIOVP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label TimeVariance OVP view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurgDocMigrtnIsCmpltdForAnlyts
Supplier Supplier Supplier
PurchasingOrganization PurchasingOrganization Purchasing Organization
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
P_StartDate
P_EndDateasPurchaseOrderkeyPurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurgDocMigrtnIsCmpltdForAnlyts
Supplier Supplier Supplier
PurchasingOrganization PurchasingOrganization Purchasing Organization
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
TimeVarianceScore TimeVarianceScore Time Variance Score

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_TimeVariance_OVP.
-- 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: PMMTIMEVARIOVP
-- Parameters: P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_TimeVariance_OVP AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  cast ('X' as char1) AS PurgDocMigrtnIsCmpltdForAnlyts,
  Supplier,
  PurchasingOrganization,
  Material,
  MaterialGroup,
  TimeVarianceScore AS P_StartDate,
  TimeVarianceScore
FROM I_PurOrdScheduleLineEnhanced AS PurchaseOrder
-- UNION ALL with additional select branch(es): P_SupplierEvalByTime1
;

Learn More