I_PRAINTRSTDETREVNACCTGDOC

CDS View

PRA Interest Calc detail RAD Link

I_PRAINTRSTDETREVNACCTGDOC is a CDS View in S/4HANA. PRA Interest Calc detail RAD Link. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PRAIntrstDetRevnAcctgDoc view from CONSUMPTION PRA Interest Calc detail RAD Link
I_PRAIntrstDetRevnAcctgDocUI view from BASIC PRA Interest Calc detail RAD Link
@EndUserText.label: 'PRA Interest Calc detail RAD Link'

@AbapCatalog:
{
  sqlViewName: 'IINTCALRADLNK',
  viewEnhancementCategory: [#NONE],
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl.authorizationCheck: #MANDATORY

@VDM.viewType: #BASIC

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:
{
  serviceQuality: #B,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}

@ClientHandling.algorithm: #SESSION_VARIABLE
//@Metadata.allowExtensions: true

//@ObjectModel.representativeKey: 'PRAIntrstRevnAcctgDocLinkUUID'


define view I_PRAIntrstDetRevnAcctgDoc

  as select from /pra/int_dtl_lnk
  association [0..1] to I_PRAAcctgDocDetail as _PRAAcctgDocDetail on $projection.CompanyCode            = _PRAAcctgDocDetail.CompanyCode 
                                                                 and $projection.PRAAccountingPeriod    = _PRAAcctgDocDetail.FiscalPeriod
                                                                 and $projection.AccountingDocument     = _PRAAcctgDocDetail.AccountingDocument
                                                                 and $projection.ValnDocAcctgItem       = _PRAAcctgDocDetail.AccountingDocumentItem                                                            
{
  key int_rad_link_guid                             as PRAIntrstRevnAcctgDocLinkUUID,
      run_id                                        as ProcessRun,
      cast( bukrs as fis_bukrs preserving type )    as CompanyCode,
      cast (acct_period as oiu_vdm_acct_period )    as PRAAccountingPeriod,
      doc_no                                        as AccountingDocument,
      line_no                                       as ValnDocAcctgItem,
      
      /* Associations */
      _PRAAcctgDocDetail
}