C_PRAInterestDetailsDataTP

DDL: C_PRAINTERESTDETAILSDATATP Type: view_entity CONSUMPTION
59 Fields 1 Data Sources 1 OData Services

Interest Calculation Detail

C_PRAInterestDetailsDataTP is a Consumption CDS View that provides data about "Interest Calculation Detail" in SAP S/4HANA. It reads from 1 data source (R_PRAInterestDetailsDataTP) and exposes 59 fields with key field PRAInterestCalcDetailUUID. It is exposed through 1 OData service (UI_INTERESTDETAILSDATAMANAGE).

Data Sources (1)

SourceAliasJoin Type
R_PRAInterestDetailsDataTP R_PRAInterestDetailsDataTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Interest Calculation Detail view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view
Search.searchable false view

OData Services (1)

ServiceBindingVersionContractRelease
UI_INTERESTDETAILSDATAMANAGE UI_INTRSTDETAILSDATAMANAGE V2 C1 NOT_RELEASED

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY PRAInterestCalcDetailUUID PRAInterestCalcDetailUUID
ProcessRun ProcessRun
CompanyCode CompanyCode Receiver Company Code
PRAAccountingPeriod PRAAccountingPeriod
PRAAccountingPeriodText PRAAccountingPeriodText
AccountingDocument AccountingDocument Journal Entry
ValnDocAcctgItem ValnDocAcctgItem
PRAOwner PRAOwner
PRAJointVenture PRAJointVenture Ext vent name
DivisionOfInterest DivisionOfInterest Venture/DOI
Well Well Well
WellCompletion WellCompletion Well Completion
OwnerInterestType OwnerInterestType
OwnerInterestSequence OwnerInterestSequence
SalesDate SalesDate Sales Date
PRAProduct PRAProduct Full Product
PRADisbursementDecimalValue PRADisbursementDecimalValue
PRAOwnrPyblSuspenseAcctNumber PRAOwnrPyblSuspenseAcctNumber
RecordType RecordType Reservation Record Type
Currency Currency Valuation Crcy
PRAInterestCalculationStatus PRAInterestCalculationStatus
PRANetIntrstCalcdAmount PRANetIntrstCalcdAmount
PRAInterestCalcPrincipleAmount PRAInterestCalcPrincipleAmount
PRAInterestCalcDays PRAInterestCalcDays
PRAInterestRateDateSelection PRAInterestRateDateSelection
PRAInterestOption PRAInterestOption
PRAInterestCalcPayableDueDate PRAInterestCalcPayableDueDate
PRAIsIntrst1stProdnPayDue PRAIsIntrst1stProdnPayDue
PRAInterestCheckDate PRAInterestCheckDate
PRAIntrstCalcIsMnllyOvrrde PRAIntrstCalcIsMnllyOvrrde
PRAIntrstCalcCommentText PRAIntrstCalcCommentText
PRAInterestRate PRAInterestRate
CountryOrRegion CountryOrRegion Country/Reg.
PrimaryGeogrlLocation PrimaryGeogrlLocation
PRAIntrstCalcIsOwnrTransfRecd PRAIntrstCalcIsOwnrTransfRecd
Cheque Cheque Cheque No
PRAPaymentCheckDate PRAPaymentCheckDate
PRAIntrstRevnAcctgDocLinkUUID PRAIntrstRevnAcctgDocLinkUUID
PRAIntrstCalcRunType PRAIntrstCalcRunType
PRAIntrstCalcStatusCriticality PRAIntrstCalcStatusCriticality
PRAIntrstCalcStatusDescription PRAIntrstCalcStatusDescription
CostCenter CostCenter Cost Center
_PRAIntrstRunHeaderData _PRAIntrstRunHeaderData
_CompanyCode _CompanyCode
_Country _Country
_DivisionOfInterest _DivisionOfInterest
_OwnerInterestType _OwnerInterestType
_PRAInterestStatus _PRAInterestStatus
_PRAJointVenture _PRAJointVenture
_PRAOwner _PRAOwner
_PRAPaytRecordType _PRAPaytRecordType
_PRAProduct _PRAProduct
_PrimaryGeogrlLocation _PrimaryGeogrlLocation
_Well _Well
_WellCompletion _WellCompletion
_PRAIntrstDetRevnAcctgDoc _PRAIntrstDetRevnAcctgDoc
_PRAIntrstCalcRunType _PRAIntrstCalcRunType
_PRAAcctgDocDetail _PRAAcctgDocDetail
_PRAIntrstDetAcctgDoc _PRAIntrstDetAcctgDoc

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_PRAInterestDetailsDataTP.
-- 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_PRAInterestDetailsDataTP AS
SELECT
  PRAInterestCalcDetailUUID,
  ProcessRun,
  CompanyCode,
  PRAAccountingPeriod,
  PRAAccountingPeriodText,
  AccountingDocument,
  ValnDocAcctgItem,
  PRAOwner,
  PRAJointVenture,
  DivisionOfInterest,
  Well,
  WellCompletion,
  OwnerInterestType,
  OwnerInterestSequence,
  SalesDate,
  PRAProduct,
  PRADisbursementDecimalValue,
  PRAOwnrPyblSuspenseAcctNumber,
  RecordType,
  Currency,
  PRAInterestCalculationStatus,
  PRANetIntrstCalcdAmount,
  PRAInterestCalcPrincipleAmount,
  PRAInterestCalcDays,
  PRAInterestRateDateSelection,
  PRAInterestOption,
  PRAInterestCalcPayableDueDate,
  PRAIsIntrst1stProdnPayDue,
  PRAInterestCheckDate,
  PRAIntrstCalcIsMnllyOvrrde,
  PRAIntrstCalcCommentText,
  PRAInterestRate,
  CountryOrRegion,
  PrimaryGeogrlLocation,
  PRAIntrstCalcIsOwnrTransfRecd,
  Cheque,
  PRAPaymentCheckDate,
  PRAIntrstRevnAcctgDocLinkUUID,
  PRAIntrstCalcRunType,
  PRAIntrstCalcStatusCriticality,
  PRAIntrstCalcStatusDescription,
  CostCenter
FROM R_PRAInterestDetailsDataTP
;

Learn More