P_RblsItmForKeyDteDuePerd3A

@AbapCatalog.sqlViewName: 'PRBLSKDATDUE3A'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RblsItmForKeyDteDuePerd3A
//  with parameters

//    P_KeyDate : sydate,

//    P_CompanyCode: fis_bukrs, 

//    P_DisplayCurrencyType: far_disp_currency_common_type,

//    P_ReportingPeriodStartDate: fis_rep_period_start_date,

//    P_ReportingPeriodEndDate: fis_rep_period_end_date,

//    P_PeriodType               : fis_period_type


  as select from I_GLAccountLineItemRawData
  
//    association [0..1] to I_PostingKey                 as _PostingKey               on _PostingKey.PostingKey = $projection.PostingKey   

    
{
  key CompanyCode
//  key AccountingDocument,

//  key AccountingDocumentItem,

//  key FiscalYear,

//      

//      FinancialAccountType,      

//      Customer,      

//      SpecialGLCode,

//      GLAccount,

//      CompanyCodeCurrency,

//      FunctionalCurrency,

//      TransactionCurrency,

//      AmountInCompanyCodeCurrency,

//      AmountInGlobalCurrency,

//      AmountInFunctionalCurrency,

//      AmountInTransactionCurrency,

//      PostingKey, 

//      BusinessArea,  

//      

//      @Semantics.amount.currencyCode: 'DisplayCurrency'

//      case $parameters.P_DisplayCurrencyType

//           when 'COCD' then AmountInCompanyCodeCurrency

//           when 'GLOB' then AmountInGlobalCurrency

//           when 'FUNC' then AmountInFunctionalCurrency

//           when 'TRAN' then AmountInTransactionCurrency

//      end as PartialPaymentAmtInDspCrcy,    

//      

//      @Semantics.currencyCode:true

//      case $parameters.P_DisplayCurrencyType

//           when 'COCD' then CompanyCodeCurrency

//           when 'GLOB' then GlobalCurrency

//           when 'FUNC' then FunctionalCurrency

//           when 'TRAN' then TransactionCurrency

//      end as DisplayCurrency,

//      

//      $parameters.P_ReportingPeriodStartDate as ReportingPeriodStartDate,

//      $parameters.P_ReportingPeriodEndDate as ReportingPeriodEndDate


}
//where

//    FinancialAccountType = 'D'

//    and AccountingDocumentCategory =  '' 

//    and _PostingKey.IsUsedInPaymentTransaction = 'X'  

//    and PostingDate >= $parameters.P_ReportingPeriodStartDate

//    and PostingDate <= $parameters.P_ReportingPeriodEndDate

//    and PostingDate <= :P_KeyDate

//    and CompanyCode = $parameters.P_CompanyCode

 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEMRAWDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/