C_PRAStateInterestOptionTP

DDL: C_PRASTATEINTERESTOPTIONTP Type: view_entity CONSUMPTION Package: OIU_ODATA_REV_INTEREST
18 Fields 1 Data Sources 2 OData Services

PRA State Interest Option

C_PRAStateInterestOptionTP is a Consumption CDS View that provides data about "PRA State Interest Option" in SAP S/4HANA. It reads from 1 data source (R_PRAStateInterestOptionTP) and exposes 18 fields with key fields Country, PrimaryGeogrlLocation, PRAInterestOption, PRAStateIntrstOptnEffctvFrmDte. It is exposed through 2 OData services (UI_STATEINTERESTOPTIONMANAGE, UI_STATEINTERESTOPTIONMANAGE). Part of development package OIU_ODATA_REV_INTEREST.

Data Sources (1)

SourceAliasJoin Type
R_PRAStateInterestOptionTP R_PRAStateInterestOptionTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label PRA State Interest Option view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
UI_STATEINTERESTOPTIONMANAGE UI_STATEINTERESTOPTIONMANAGE V4 NOT_RELEASED
UI_STATEINTERESTOPTIONMANAGE UI_STATEINTOPTIONMANAGE V2 C1 NOT_RELEASED

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Country Country Venue: Ctry/Reg
KEY PrimaryGeogrlLocation PrimaryGeogrlLocation
KEY PRAInterestOption PRAInterestOption
KEY PRAStateIntrstOptnEffctvFrmDte PRAStateIntrstOptnEffctvFrmDte
PRAStateIntrstOptnEffctvToDate PRAStateIntrstOptnEffctvToDate
PRAInterestFormulaNumber PRAInterestFormulaNumber
PRAInterestOptionDesc PRAInterestOptionDesc
PRAInterestRateDateSelection PRAInterestRateDateSelection
PRAInterestCalculationType PRAInterestCalculationType
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
PrimaryGeogrlLocationName
_Country _Country
_CreatedByUser _CreatedByUser
_PRAInterestFormulaNumberVH _PRAInterestFormulaNumberVH
_PrimaryGeogrlLocation _PrimaryGeogrlLocation
_PRAInterestRateDateSel _PRAInterestRateDateSel
_PRAInterestCalcType _PRAInterestCalcType

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 C_PRAStateInterestOptionTP.
-- 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 C_PRAStateInterestOptionTP AS
SELECT
  Country,
  PrimaryGeogrlLocation,
  PRAInterestOption,
  PRAStateIntrstOptnEffctvFrmDte,
  PRAStateIntrstOptnEffctvToDate,
  PRAInterestFormulaNumber,
  PRAInterestOptionDesc,
  PRAInterestRateDateSelection,
  PRAInterestCalculationType,
  CreatedByUser,
  CreationDateTime,
  _PrimaryGeogrlLocation._Text[ 1: Language = $session.system_language ].PrimaryGeogrlLocationName AS PrimaryGeogrlLocationName
FROM R_PRAStateInterestOptionTP
;

Learn More