P_CapOpMaxMinDte

DDL: P_CAPOPMAXMINDTE SQL: PCAPOPMINMAXDTE Type: view COMPOSITE Package: PPH_VDM_CAP_EVAL
2 Fields 1 Data Sources

Maximum and Minimum Date for Operations of Workcenter

P_CapOpMaxMinDte is a Composite CDS View that provides data about "Maximum and Minimum Date for Operations of Workcenter" in SAP S/4HANA. It reads from 1 data source (P_WorkCenterCapPplineOp) and exposes 2 fields. Part of development package PPH_VDM_CAP_EVAL.

Data Sources (1)

SourceAliasJoin Type
P_WorkCenterCapPplineOp orders from

Parameters (3)

NameTypeDefault
p_sapclient abap.clnt
P_fromdate datum
P_todate datum

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCAPOPMINMAXDTE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
OperationMinimumDate
OperationMaximumDate

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_CapOpMaxMinDte.
-- 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: PCAPOPMINMAXDTE
-- Parameters: p_sapclient : abap.clnt, P_fromdate : datum, P_todate : datum

CREATE VIEW P_CapOpMaxMinDte AS
SELECT
  min(orders.OperationLatestStartDate) AS OperationMinimumDate,
  max(orders.OperationLatestEndDate) AS OperationMaximumDate
FROM P_WorkCenterCapPplineOp AS orders
;

Learn More