I_PRAINTRSTDETACCTGDOC

@EndUserText.label: 'PRA Interest Calc detail RAD documents'

@AbapCatalog:
{
  sqlViewName: 'IINTCALRADDOC',
  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

define view I_PRAIntrstDetAcctgDoc 
    as select from /pra/int_dtl_doc
    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_doc_link_guid                             as PRAIntrstRevnAcctgDocLinkUUID,
        int_dtl_link_guid                             as PRAInterestCalcDetailUUID,
        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,
        status                                        as PRAInterestCalculationStatus,
        
        /* Associations */
      _PRAAcctgDocDetail
}