I_SrvcEntrShtPurgContrItmVH

DDL: I_SRVCENTRSHTPURGCONTRITMVH SQL: ISESPCIVH Type: view COMPOSITE Package: APPL_MM_PUR_SES_TR
11 Fields 1 Data Sources

Purchase Contract Item

I_SrvcEntrShtPurgContrItmVH is a Composite CDS View that provides data about "Purchase Contract Item" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractItem) and exposes 11 fields with key fields PurchaseContractItem, PurchaseContract. Part of development package APPL_MM_PUR_SES_TR.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractItem Item from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ISESPCIVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
Search.searchable true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey PurchaseContractItem view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Purchase Contract Item view
Consumption.ranked true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContractItem I_PurchaseContractItem PurchaseContractItem Item
KEY PurchaseContract I_PurchaseContractItem PurchaseContract Purchasing Doc.
Service I_PurchaseContractItem Material Service
PurchaseContractItemText I_PurchaseContractItem PurchaseContractItemText Description
MaterialGroup I_PurchaseContractItem MaterialGroup Product Group
Plant I_PurchaseContractItem Plant Valuation Area
PurchasingOrganization I_PurchaseContractItem PurchasingOrganization Purchasing Organization
Supplier _PurchaseContract Supplier Supplier
ValidityStartDate _PurchaseContract ValidityStartDate Validity Start Date
ValidityEndDate _PurchaseContract ValidityEndDate ValidTo
_PurchaseContract _PurchaseContract

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_SrvcEntrShtPurgContrItmVH.
-- 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: ISESPCIVH

CREATE VIEW I_SrvcEntrShtPurgContrItmVH AS
SELECT
  Item.PurchaseContractItem AS PurchaseContractItem,
  Item.PurchaseContract AS PurchaseContract,
  Item.Material AS Service,
  Item.PurchaseContractItemText AS PurchaseContractItemText,
  Item.MaterialGroup AS MaterialGroup,
  Item.Plant AS Plant,
  Item.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseContract.Supplier AS Supplier,
  _PurchaseContract.ValidityStartDate AS ValidityStartDate,
  _PurchaseContract.ValidityEndDate AS ValidityEndDate
FROM I_PurchaseContractItem AS Item
;

Learn More