P_PurContrCalcValidityStatus

DDL: P_PURCONTRCALCVALIDITYSTATUS SQL: PPCCALTVALSTS Type: view COMPOSITE Package: ODATA_MM_CTR_MAINTAIN
8 Fields 1 Data Sources

Calculate Validity Status fields for Purchase Contract

P_PurContrCalcValidityStatus is a Composite CDS View that provides data about "Calculate Validity Status fields for Purchase Contract" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContract) and exposes 8 fields with key field PurchaseContract. Part of development package ODATA_MM_CTR_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContract _PurchaseContract from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPCCALTVALSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
ValidityStartDate I_PurchaseContract ValidityStartDate Validity Start Date
ValidityEndDateendasValidityEndDate
ValidityEndDateendasTimeVarianceInDays
ActivePurchasingDocument ActivePurchasingDocument Active Purchase Doc
Supplier Supplier Supplier
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_PurContrCalcValidityStatus.
-- 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: PPCCALTVALSTS

CREATE VIEW P_PurContrCalcValidityStatus AS
SELECT
  PurchaseContract,
  _PurchaseContract.ValidityStartDate AS ValidityStartDate,
  case when _PurchaseContract.ValidityEndDate is initial then '99991231' else _PurchaseContract.ValidityEndDate end as ValidityEndDate AS ValidityEndDateendasValidityEndDate,
  case when _PurchaseContract.ValidityEndDate is initial then dats_days_between(cast( substring( cast( tstmp_current_utctimestamp() as abap.char(17) ), 1, 8 ) as abap.dats), cast ('99991231' as abap.dats)) else dats_days_between(cast( substring( cast( tstmp_current_utctimestamp() as abap.char(17) ), 1, 8 ) as abap.dats), _PurchaseContract.ValidityEndDate) end as TimeVarianceInDays AS ValidityEndDateendasTimeVarianceInDays,
  ActivePurchasingDocument,
  Supplier,
  PurchasingOrganization,
  PurchasingGroup
FROM I_PurchaseContract AS _PurchaseContract
;

Learn More