I_PRAContractVH

DDL: I_PRACONTRACTVH SQL: IPVCONTRACTVH Type: view BASIC
17 Fields 1 Data Sources

PRA Contract

I_PRAContractVH is a Basic CDS View that provides data about "PRA Contract" in SAP S/4HANA. It reads from 1 data source (I_PRAContract) and exposes 17 fields with key field PRAContract.

Data Sources (1)

SourceAliasJoin Type
I_PRAContract I_PRAContract from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPVCONTRACTVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label PRA Contract view
VDM.viewType #BASIC view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey PRAContract view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PRAContract PRAContract Contract
PRAContractDesc PRAContractDesc
PRAContractDate PRAContractDate Trans. Period End
SoldToParty SoldToParty Sold-to Party
CompanyCode CompanyCode Receiver Company Code
PRAContractType PRAContractType Contract Type
IsApproved IsApproved Checkbox
PreviousPRAContract PreviousPRAContract Old Contract
CustomerOrSupplierType CustomerOrSupplierType CustVend Ind
MarketingRep MarketingRep Marketing Rep
MarketingRepIntrstSequNmbr MarketingRepIntrstSequNmbr Mkt. Rep. ISQ
MarketingRepName MarketingRepName
MarketingRepCustomer MarketingRepCustomer
MarketingRepSupplier MarketingRepSupplier
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change

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_PRAContractVH.
-- 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: IPVCONTRACTVH

CREATE VIEW I_PRAContractVH AS
SELECT
  PRAContract,
  PRAContractDesc,
  PRAContractDate,
  SoldToParty,
  CompanyCode,
  PRAContractType,
  IsApproved,
  PreviousPRAContract,
  CustomerOrSupplierType,
  MarketingRep,
  MarketingRepIntrstSequNmbr,
  MarketingRepName,
  MarketingRepCustomer,
  MarketingRepSupplier,
  CreatedByUser,
  CreationDate,
  CreationTime
FROM I_PRAContract
;

Learn More