I_PRAINTRSTDETACCTGDOC

CDS View

PRA Interest Calc detail RAD documents

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

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PRAIntrstDetAcctgDoc view from CONSUMPTION PRA Interest Calc detail RAD documents
I_PRAIntrstDetAcctgDocUI view from BASIC PRA Interest Calc detail RAD documents 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/PRA/INT_DTL_DOC"
],
"ASSOCIATED":
[
"I_PRAACCTGDOCDETAIL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More