I_PRAIntrstDetRevnAcctgDocUI

DDL: I_PRAINTRSTDETREVNACCTGDOCUI SQL: CPRAIDRADUI Type: view BASIC
43 Fields 1 Data Sources 2 OData Services

PRA Interest Calc detail RAD Link

I_PRAIntrstDetRevnAcctgDocUI is a Basic CDS View that provides data about "PRA Interest Calc detail RAD Link" in SAP S/4HANA. It reads from 1 data source (I_PRAIntrstDetRevnAcctgDoc) and exposes 43 fields with key field PRAIntrstRevnAcctgDocLinkUUID. It is exposed through 2 OData services (UI_INTERESTDETAILSDATAMANAGE, UI_INTRSTOWNRDETSDATAMANAGE).

Data Sources (1)

SourceAliasJoin Type
I_PRAIntrstDetRevnAcctgDoc I_PRAIntrstDetRevnAcctgDoc from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPRAIDRADUI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label PRA Interest Calc detail RAD Link view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view
ObjectModel.representativeKey PRAIntrstRevnAcctgDocLinkUUID view

OData Services (2)

ServiceBindingVersionContractRelease
UI_INTERESTDETAILSDATAMANAGE UI_INTRSTDETAILSDATAMANAGE V2 C1 NOT_RELEASED
UI_INTRSTOWNRDETSDATAMANAGE UI_INTRSTOWNRDETSMANAGE V2 C1 NOT_RELEASED

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY PRAIntrstRevnAcctgDocLinkUUID PRAIntrstRevnAcctgDocLinkUUID ReferenceRADLink
ProcessRun ProcessRun UUID
CompanyCode CompanyCode Company Code
PRAAccountingPeriod PRAAccountingPeriod Accounting Period
AccountingDocument AccountingDocument Accounting Document
ValnDocAcctgItem ValnDocAcctgItem Accounting Document Line
GLAccountType Account Type
GLAccount _PRAAcctgDocDetail GLAccount Account Number
JointVenture _PRAAcctgDocDetail JointVenture Venture
DivisionOfInterest _PRAAcctgDocDetail DivisionOfInterest DOI Name
PRAProduct _PRAAcctgDocDetail Product Product
Well _PRAAcctgDocDetail Well Well
WellCompletion _PRAAcctgDocDetail WellCompletion Well Completion
SalesDate _PRAAcctgDocDetail SalesDate Sales Date
PRAOwner _PRAAcctgDocDetail PRAOwner Owner
OwnerInterestType _PRAAcctgDocDetail OwnerInterestType Interest Type
OwnerInterestSequence _PRAAcctgDocDetail OwnerInterestSequence Interest Sequence
OwnerNetAmount _PRAAcctgDocDetail OwnerNetAmount Owner Net Value
OtherDeductionAmount _PRAAcctgDocDetail OtherDeductionAmount Line Other Deducts Amount
CompanyCodeCurrency _PRAAcctgDocDetail CompanyCodeCurrency Local Currency
CostCenter _PRAAcctgDocDetail CostCenter Cost Center
SuspenseReason _PRAAcctgDocDetail SuspenseReason Suspense Reason Code
PriorPeriodAdjustmentReason _PRAAcctgDocDetail PriorPeriodAdjustmentReason Adjustment Reason Code
Country _PRAAcctgDocDetail Country Country
PrimaryGeogrlLocation _PRAAcctgDocDetail PrimaryGeogrlLocation Primary Geographical Location
County _PRAAcctgDocDetail County County
Region _PRAAcctgDocDetail Region Venue Region
_PRAAcctgDocDetail _PRAAcctgDocDetail
_CompanyCode _CompanyCode
_GLAccountType _GLAccountType
_GLAccount _GLAccount
_PRAJointVenture _PRAJointVenture
_DivisionOfInterest _DivisionOfInterest
_Product _Product
_Well _Well
_WellCompletion _WellCompletion
_PRAOwner _PRAOwner
_OwnerInterestType _OwnerInterestType
_SuspenseReason _SuspenseReason
_PriorPeriodAdjustmentReason _PriorPeriodAdjustmentReason
_Country _Country
_PrimaryGeogrlLocation _PrimaryGeogrlLocation
_County _County

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_PRAIntrstDetRevnAcctgDocUI.
-- 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: CPRAIDRADUI

CREATE VIEW I_PRAIntrstDetRevnAcctgDocUI AS
SELECT
  PRAIntrstRevnAcctgDocLinkUUID,
  ProcessRun,
  CompanyCode,
  PRAAccountingPeriod,
  AccountingDocument,
  ValnDocAcctgItem,
  cast(_PRAAcctgDocDetail.GLAccountType as abap.char(1)) AS GLAccountType,
  _PRAAcctgDocDetail.GLAccount AS GLAccount,
  _PRAAcctgDocDetail.JointVenture AS JointVenture,
  _PRAAcctgDocDetail.DivisionOfInterest AS DivisionOfInterest,
  _PRAAcctgDocDetail.Product AS PRAProduct,
  _PRAAcctgDocDetail.Well AS Well,
  _PRAAcctgDocDetail.WellCompletion AS WellCompletion,
  _PRAAcctgDocDetail.SalesDate AS SalesDate,
  _PRAAcctgDocDetail.PRAOwner AS PRAOwner,
  _PRAAcctgDocDetail.OwnerInterestType AS OwnerInterestType,
  _PRAAcctgDocDetail.OwnerInterestSequence AS OwnerInterestSequence,
  _PRAAcctgDocDetail.OwnerNetAmount AS OwnerNetAmount,
  _PRAAcctgDocDetail.OtherDeductionAmount AS OtherDeductionAmount,
  _PRAAcctgDocDetail.CompanyCodeCurrency AS CompanyCodeCurrency,
  _PRAAcctgDocDetail.CostCenter AS CostCenter,
  _PRAAcctgDocDetail.SuspenseReason AS SuspenseReason,
  _PRAAcctgDocDetail.PriorPeriodAdjustmentReason AS PriorPeriodAdjustmentReason,
  _PRAAcctgDocDetail.Country AS Country,
  _PRAAcctgDocDetail.PrimaryGeogrlLocation AS PrimaryGeogrlLocation,
  _PRAAcctgDocDetail.County AS County,
  _PRAAcctgDocDetail.Region AS Region
FROM I_PRAIntrstDetRevnAcctgDoc
;

Learn More