C_PRAIntrstDetAcctgDoc

DDL: C_PRAINTRSTDETACCTGDOC Type: view CONSUMPTION Package: OIU_ODATA_REV_INTEREST
45 Fields 1 Data Sources

PRA Interest Calc detail RAD documents

C_PRAIntrstDetAcctgDoc is a Consumption CDS View that provides data about "PRA Interest Calc detail RAD documents" in SAP S/4HANA. It reads from 1 data source (I_PRAIntrstDetAcctgDoc) and exposes 45 fields with key field PRAIntrstRevnAcctgDocLinkUUID. Part of development package OIU_ODATA_REV_INTEREST.

Data Sources (1)

SourceAliasJoin Type
I_PRAIntrstDetAcctgDoc I_PRAIntrstDetAcctgDoc from

Annotations (12)

NameValueLevelField
EndUserText.label PRA Interest Calc detail RAD documents view
AbapCatalog.sqlViewName CINTCALRADLNK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.representativeKey PRAIntrstRevnAcctgDocLinkUUID view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY PRAIntrstRevnAcctgDocLinkUUID PRAIntrstRevnAcctgDocLinkUUID ReferenceDocLink
PRAInterestCalcDetailUUID PRAInterestCalcDetailUUID InterestDetailsGUID
ProcessRun ProcessRun UUID
CompanyCode CompanyCode Receiver Company Code
PRAAccountingPeriod PRAAccountingPeriod
AccountingDocument AccountingDocument Journal Entry
ValnDocAcctgItem ValnDocAcctgItem Parameter line
PRAInterestCalculationStatus PRAInterestCalculationStatus Workflow Status
GLAccountType
GLAccount _PRAAcctgDocDetail GLAccount General Ledger
JointVenture _PRAAcctgDocDetail JointVenture Joint venture
DivisionOfInterest _PRAAcctgDocDetail DivisionOfInterest Venture/DOI
PRAProduct _PRAAcctgDocDetail Product Product Sold
Well _PRAAcctgDocDetail Well Well
WellCompletion _PRAAcctgDocDetail WellCompletion Well Completion
SalesDate _PRAAcctgDocDetail SalesDate Sales Date
PRAOwner _PRAAcctgDocDetail PRAOwner
OwnerInterestType _PRAAcctgDocDetail OwnerInterestType
OwnerInterestSequence _PRAAcctgDocDetail OwnerInterestSequence
OwnerNetAmount _PRAAcctgDocDetail OwnerNetAmount
OtherDeductionAmount _PRAAcctgDocDetail OtherDeductionAmount
CompanyCodeCurrency _PRAAcctgDocDetail CompanyCodeCurrency Local Currency
CostCenter _PRAAcctgDocDetail CostCenter Cost Center
SuspenseReason _PRAAcctgDocDetail SuspenseReason
PriorPeriodAdjustmentReason _PRAAcctgDocDetail PriorPeriodAdjustmentReason
Country _PRAAcctgDocDetail Country Venue: Ctry/Reg
PrimaryGeogrlLocation _PRAAcctgDocDetail PrimaryGeogrlLocation
County _PRAAcctgDocDetail County Wyoming 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 C_PRAIntrstDetAcctgDoc.
-- 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_PRAIntrstDetAcctgDoc AS
SELECT
  PRAIntrstRevnAcctgDocLinkUUID,
  PRAInterestCalcDetailUUID,
  ProcessRun,
  CompanyCode,
  PRAAccountingPeriod,
  AccountingDocument,
  ValnDocAcctgItem,
  PRAInterestCalculationStatus,
  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_PRAIntrstDetAcctgDoc
;

Learn More