P_PurReqMonitorScheduleDate

DDL: P_PURREQMONITORSCHEDULEDATE SQL: PPRMNTRSCHEDDATE Type: view CONSUMPTION
10 Fields 1 Data Sources

Private view for PR Delivery Date

P_PurReqMonitorScheduleDate is a Consumption CDS View that provides data about "Private view for PR Delivery Date" in SAP S/4HANA. It reads from 1 data source (P_CalcDeliveryDate) and exposes 10 fields with key fields PurchaseRequisition, PurchaseRequisitionItem.

Data Sources (1)

SourceAliasJoin Type
P_CalcDeliveryDate P_CalcDeliveryDate from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPRMNTRSCHEDDATE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Private view for PR Delivery Date view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
DeliveryDate DeliveryDate Delivery Date
FirstDayOfWeekDate _calendardate1 FirstDayOfWeekDate First day of week date
char10asDurationToNextStatusInDays
syatemdate
PurchaseRequisitionType PurchaseRequisitionType Order Type
Plant Plant Valuation Area
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group

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_PurReqMonitorScheduleDate.
-- 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: PPRMNTRSCHEDDATE

CREATE VIEW P_PurReqMonitorScheduleDate AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  DeliveryDate,
  _calendardate1.FirstDayOfWeekDate AS FirstDayOfWeekDate,
  cast(case when DeliveryDate>=weekstart and DeliveryDate<=weekend then '1' when DeliveryDate>weekend and DeliveryDate<=secweekend then '2' when DeliveryDate > secweekend and DeliveryDate <= fourthweekend then '3' when DeliveryDate > fourthweekend then '4' end as abap.char( 10 ))as DurationToNextStatusInDays AS char10asDurationToNextStatusInDays,
  $session.system_date AS syatemdate,
  PurchaseRequisitionType,
  Plant,
  PurchasingOrganization,
  PurchasingGroup
FROM P_CalcDeliveryDate
;

Learn More