I_CntrlPurContrExprgValidity

DDL: I_CNTRLPURCONTREXPRGVALIDITY SQL: ICNTRLPCONEXPVAL Type: view COMPOSITE
9 Fields 1 Data Sources

Central Purchase Contract Expiration

I_CntrlPurContrExprgValidity is a Composite CDS View that provides data about "Central Purchase Contract Expiration" in SAP S/4HANA. It reads from 1 data source (I_CentralPurchaseContract) and exposes 9 fields.

Data Sources (1)

SourceAliasJoin Type
I_CentralPurchaseContract Document from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICNTRLPCONEXPVAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Central Purchase Contract Expiration view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ObjectModel.uniqueIdField CentralPurchaseContract view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (9)

KeyFieldSource TableSource FieldDescription
CentralPurchaseContract I_CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
ActivePurchasingDocument I_CentralPurchaseContract ActivePurchasingDocument Active Purchasing Document
PurchaseContractType I_CentralPurchaseContract PurchaseContractType Order Type
CompanyCode I_CentralPurchaseContract CompanyCode Receiver Company Code
PurchasingOrganization I_CentralPurchaseContract PurchasingOrganization Purchasing Organization
PurchasingGroup I_CentralPurchaseContract PurchasingGroup Purchasing Group
Supplier I_CentralPurchaseContract Supplier Supplier
IsEndOfPurposeBlocked I_CentralPurchaseContract IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
ValidityEndDate I_CentralPurchaseContract ValidityEndDate Expiration Period

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 I_CntrlPurContrExprgValidity.
-- 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: ICNTRLPCONEXPVAL

CREATE VIEW I_CntrlPurContrExprgValidity AS
SELECT
  Document.CentralPurchaseContract AS CentralPurchaseContract,
  Document.ActivePurchasingDocument AS ActivePurchasingDocument,
  Document.PurchaseContractType AS PurchaseContractType,
  Document.CompanyCode AS CompanyCode,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.Supplier AS Supplier,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  Document.ValidityEndDate AS ValidityEndDate
FROM I_CentralPurchaseContract AS Document
;

Learn More