I_ProviderContractVH

DDL: I_PROVIDERCONTRACTVH Type: view_entity COMPOSITE
15 Fields 1 Data Sources

Provider Contract

I_ProviderContractVH is a Composite CDS View that provides data about "Provider Contract" in SAP S/4HANA. It reads from 1 data source (I_ProviderContract) and exposes 15 fields with key field ProviderContract.

Data Sources (1)

SourceAliasJoin Type
I_ProviderContract I_ProviderContract from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Provider Contract view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey ProviderContract view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
Consumption.ranked true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ProviderContract ProviderContract Contract
CAProviderContractName CAProviderContractName Description
CAProviderContractExtReference CAProviderContractExtReference External Key
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName _BusinessPartner BusinessPartnerName Business Partner Name
CAProviderContractCategory CAProviderContractCategory Contract Cat.
CAProviderContractCategoryText Contract Category Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
AuthorizationGroup AuthorizationGroup AuthorizGroup
CompanyCode CompanyCode Receiver Company Code
_BusinessPartner _BusinessPartner
_ProviderContractCategory _ProviderContractCategory

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_ProviderContractVH.
-- 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.

CREATE VIEW I_ProviderContractVH AS
SELECT
  ProviderContract,
  CAProviderContractName,
  CAProviderContractExtReference,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  CAProviderContractCategory,
  _ProviderContractCategory._Text[1:Language = $session.system_language].CAProviderContractCategoryText AS CAProviderContractCategoryText,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeTime,
  AuthorizationGroup,
  CompanyCode
FROM I_ProviderContract
;

Learn More