P_PurContrMassValidityStatus

DDL: P_PURCONTRMASSVALIDITYSTATUS SQL: PPCVALSTS Type: view CONSUMPTION Package: ODATA_MM_PUR_CTRMASS_UPDATE
6 Fields 1 Data Sources

Contract Status

P_PurContrMassValidityStatus is a Consumption CDS View that provides data about "Contract Status" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContract) and exposes 6 fields with key field PurchaseContract. Part of development package ODATA_MM_PUR_CTRMASS_UPDATE.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContract Contract from

Parameters (1)

NameTypeDefault
P_Date sydatum

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPCVALSTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Contract Status view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContract PurchaseContract Purchasing Doc.
ValidityEndDate I_PurchaseContract ValidityEndDate ValidTo
ValidityStartDate I_PurchaseContract ValidityStartDate Validity Start Date
PurchaseContractType PurchaseContractType Order Type
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_PurContrMassValidityStatus.
-- 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: PPCVALSTS
-- Parameters: P_Date : sydatum

CREATE VIEW P_PurContrMassValidityStatus AS
SELECT
  Contract.PurchaseContract AS PurchaseContract,
  Contract.ValidityEndDate AS ValidityEndDate,
  Contract.ValidityStartDate AS ValidityStartDate,
  PurchaseContractType,
  PurchasingOrganization,
  PurchasingGroup
FROM I_PurchaseContract AS Contract
;

Learn More