R_PRAINTERESTDETAILSDATATP

CDS View

Interest Calculation Detail

R_PRAINTERESTDETAILSDATATP is a CDS View in S/4HANA. Interest Calculation Detail. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_PRAInterestDetailsDataTP view_entity projection CONSUMPTION Interest Calculation Detail 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Interest Calculation Detail'
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM:
{
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL 
}
@ObjectModel.sapObjectNodeType.name: 'PRAOwnerInterestDetailData'

define root view entity R_PRAInterestDetailsDataTP 
  as select from I_PRAInterestDetailsData
  

  composition [0..*] of R_PRAInterestCalcDetErrTP as _PRAInterestCalcDetErr
  {
    @Semantics.uuid: true
    key PRAInterestCalcDetailUUID,
    @ObjectModel.foreignKey.association: '_PRAIntrstRunHeaderData'
    ProcessRun,
    @ObjectModel.foreignKey.association: '_CompanyCode'
    CompanyCode,
    PRAAccountingPeriod,
    PRAAccountingPeriodText,
    AccountingDocument,
    ValnDocAcctgItem,
    @ObjectModel.foreignKey.association: '_PRAOwner'
    PRAOwner,
    @ObjectModel.foreignKey.association: '_PRAJointVenture'
    PRAJointVenture,
    @ObjectModel.foreignKey.association: '_DivisionOfInterest'
    DivisionOfInterest,
    @ObjectModel.foreignKey.association: '_Well'
    Well,
    @ObjectModel.foreignKey.association: '_WellCompletion'
    WellCompletion,
    @ObjectModel.foreignKey.association: '_OwnerInterestType'
    OwnerInterestType,
    OwnerInterestSequence,
    SalesDate,
    @ObjectModel.foreignKey.association: '_PRAProduct'
    PRAProduct,
    PRADisbursementDecimalValue,
    PRAOwnrPyblSuspenseAcctNumber,
    @ObjectModel.foreignKey.association: '_PRAPaytRecordType'
    RecordType,
    Currency,
    @ObjectModel.foreignKey.association: '_PRAInterestStatus'
    PRAInterestCalculationStatus,
    @Semantics.amount.currencyCode: 'Currency'
    //@Aggregation.default: #SUM     

    PRANetIntrstCalcdAmount,
    //sum(PRANetIntrstCalcdAmount) as PRANetIntrstCalcdAmount,//Added for totals test

    @Semantics.amount.currencyCode: 'Currency'
    //@DefaultAggregation: #SUM

    PRAInterestCalcPrincipleAmount,
    PRAInterestCalcDays,
    PRAInterestRateDateSelection,
    PRAInterestOption,
    PRAInterestCalcPayableDueDate,
    PRAIsIntrst1stProdnPayDue,
    PRAInterestCheckDate,
    PRAIntrstCalcIsMnllyOvrrde,
    PRAIntrstCalcCommentText,
    PRAInterestRate,
    @ObjectModel.foreignKey.association: '_Country'
    CountryOrRegion,
    @ObjectModel.foreignKey.association: '_PrimaryGeogrlLocation'
    PrimaryGeogrlLocation,
    PRAIntrstCalcIsOwnrTransfRecd,
    Cheque,
    PRAPaymentCheckDate,
    @Semantics.uuid: true
    @ObjectModel.foreignKey.association: '_PRAIntrstDetRevnAcctgDoc'
    PRAIntrstRevnAcctgDocLinkUUID,
    @ObjectModel.foreignKey.association: '_PRAIntrstCalcRunType'
    PRAIntrstCalcRunType,
    
    case
      when PRAInterestCalculationStatus = 'ER' or PRAInterestCalculationStatus = 'OB' then 1 
      when PRAInterestCalculationStatus = 'NW' or PRAInterestCalculationStatus = 'RV' then 2  
      when PRAInterestCalculationStatus = 'PO' or PRAInterestCalculationStatus = 'CL' or PRAInterestCalculationStatus = 'CG' or PRAInterestCalculationStatus = 'CV' then 3
      else 0 end as PRAIntrstCalcStatusCriticality,
    cast('' as abap.char(1)) as PRAIntrstCalcStatusDescription,
    _PRAAcctgDocDetail.CostCenter as CostCenter,
    
    /* Associations */
    _PRAIntrstRunHeaderData,
    _CompanyCode,
    _Country,
    _DivisionOfInterest,
    _OwnerInterestType,
    _PRAInterestStatus,
    _PRAJointVenture,
    _PRAOwner,
    _PRAPaytRecordType,
    _PRAProduct,
    _PrimaryGeogrlLocation,
    _Well,
    _WellCompletion,
    _PRAInterestCalcDetErr,
    _PRAIntrstDetRevnAcctgDoc,
    _PRAIntrstCalcRunType,
    _PRAAcctgDocDetail,
    _PRAIntrstDetAcctgDoc
}
/*group by //Added for totals test

    PRAInterestCalcDetailUUID,
    ProcessRun,
    CompanyCode,
    PRAAccountingPeriod,
    PRAAccountingPeriodText,
    AccountingDocument,
    ValnDocAcctgItem,
    PRAOwner,
    PRAJointVenture,
    DivisionOfInterest,
    Well,
    WellCompletion,
    OwnerInterestType,
    OwnerInterestSequence,
    SalesDate,
    PRAProduct,
    PRADisbursementDecimalValue,
    PRAOwnrPyblSuspenseAcctNumber,
    RecordType,
    Currency,
    PRAInterestCalculationStatus,
    PRAInterestCalcPrincipleAmount,
    PRAInterestCalcDays,
    PRAInterestRateDateSelection,
    PRAInterestOption,
    PRAInterestCalcPayableDueDate,
    PRAIsIntrst1stProdnPayDue,
    PRAInterestCheckDate,
    PRAIntrstCalcIsMnllyOvrrde,
    PRAIntrstCalcCommentText,
    PRAInterestRate,
    CountryOrRegion,
    PrimaryGeogrlLocation,
    PRAIntrstCalcIsOwnrTransfRecd,
    Cheque,
    PRAPaymentCheckDate,
    PRAIntrstRevnAcctgDocLinkUUID,
    PRAIntrstCalcRunType,
  _PRAAcctgDocDetail.CostCenter*/

Learn More