P_MY_TxItmWithSlsDeductionProd

@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog: {sqlViewName: 'PMYTXIMWSTDPRD', preserveKey: true}
@AbapCatalog.compiler.compareFilter: true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_MY_TxItmWithSlsDeductionProd
    with parameters
    P_StatryRptgEntity      : srf_reporting_entity,
    P_StatryRptCategory     : srf_rep_cat_id,
    P_StatryRptRunID        : srf_report_run_id
  as select from P_MY_TxItmWithSlsDeductionAmt
     (
                                 P_StatryRptgEntity       : $parameters.P_StatryRptgEntity ,
                                 P_StatryRptCategory      : $parameters.P_StatryRptCategory,
                                 P_StatryRptRunID         : $parameters.P_StatryRptRunID)
    inner join   I_OperationalAcctgDocItem on  I_OperationalAcctgDocItem.CompanyCode                =  P_MY_TxItmWithSlsDeductionAmt.CompanyCode
                                           and I_OperationalAcctgDocItem.AccountingDocument         =  P_MY_TxItmWithSlsDeductionAmt.AccountingDocument
                                           and I_OperationalAcctgDocItem.FiscalYear                 =  P_MY_TxItmWithSlsDeductionAmt.FiscalYear
                                           and I_OperationalAcctgDocItem.TaxCode                    =  P_MY_TxItmWithSlsDeductionAmt.TaxCode

                                           and (I_OperationalAcctgDocItem.AccountingDocumentItemType =  '' // exclude tax item, discount line item and other BoE Items

                                                  or I_OperationalAcctgDocItem.AccountingDocumentItemType = 'W' // item from GR/IR transaction (MIRO)

                                                  or I_OperationalAcctgDocItem.AccountingDocumentItemType = 'S' // General G/L account in invoice verification

                                                  )
                                           and I_OperationalAcctgDocItem.FinancialAccountType       =  'S' // exclude vendor/customer/assets/material account

                                           and TaxDeclnAmountType                                   <> '' // exclude tax item with tax code not mapped to tax box

{
  key  P_MY_TxItmWithSlsDeductionAmt.CompanyCode,
  key  P_MY_TxItmWithSlsDeductionAmt.AccountingDocument,
  key  P_MY_TxItmWithSlsDeductionAmt.FiscalYear,
  key  TaxItem,
  key  P_MY_TxItmWithSlsDeductionAmt.TaxCode,
  key  P_MY_TxItmWithSlsDeductionAmt.TransactionTypeDetermination,
  key  ValidFrom,
  key  TaxBoxStructureType,
  key  TaxGroup,
  key  TaxBox,
  key  TaxDeclnAmountType,
  key  TaxBoxAggregationOperation,
  key  I_OperationalAcctgDocItem.Product as Product,

       TaxRate,
       P_MY_TxItmWithSlsDeductionAmt.TaxRateValidityStartDate,
       P_MY_TxItmWithSlsDeductionAmt.TaxType,
       P_MY_TxItmWithSlsDeductionAmt.GLAccount,
       P_MY_TxItmWithSlsDeductionAmt.BusinessPlace,
       P_MY_TxItmWithSlsDeductionAmt.TaxJurisdiction,
       LowestLevelTaxJurisdiction,
       P_MY_TxItmWithSlsDeductionAmt.AccountingDocumentType,
       P_MY_TxItmWithSlsDeductionAmt.ReferenceDocumentType,
       ReverseDocument,
       ReverseDocumentFiscalYear,
       DocumentReferenceID,
       Ledger,
       LedgerGroup,
       ReportingDate,
       P_MY_TxItmWithSlsDeductionAmt.PostingDate,
       P_MY_TxItmWithSlsDeductionAmt.DocumentDate,
       TaxReportingDate,
       P_MY_TxItmWithSlsDeductionAmt.FiscalPeriod,
       ExchangeRate,
       IsReversal,
       IsReversed,
       AccountingDocumentHeaderText,
       ReportingCountry,
       //TODO: New fields to be displayed in analytic view

       BusinessPartner,
       BusinessPartnerCountry,
       BusinessPartnerName,
       CustomerSupplierAddress,
       MY_CompanyRegistrationNumber,
       TaxNumber1,
       TaxNumber2,
       TaxNumber3,

       @Semantics.currencyCode:true
       ReportingCurrency,
       @Semantics.amount.currencyCode: 'ReportingCurrency'
 //      AmountInReportingCurrency,

       fltp_to_dec(AmountInReportingCurrency as abap.curr(23,2)) as AmountInReportingCurrency,
//       cast(AmountInReportingCurrency as glo_amount_rptg_crcy) as AmountInReportingCurrency,

       @Semantics.amount.currencyCode: 'ReportingCurrency'
       TaxBaseAmountInRptgCrcy,
       @Semantics.amount.currencyCode: 'ReportingCurrency'
       TaxAmountInRptgCrcy,

       @Semantics.currencyCode:true
       CountryCurrency,
       @Semantics.amount.currencyCode: 'CountryCurrency'
       TaxBaseAmountInCountryCrcy,
       @Semantics.amount.currencyCode: 'CountryCurrency'
       TaxAmountInCountryCrcy,

       @Semantics.currencyCode:true
       P_MY_TxItmWithSlsDeductionAmt.DocumentCurrency,
       @Semantics.amount.currencyCode: 'DocumentCurrency'
//       P_MY_TxItmWithSlsDeductionAmt.AmountInTransactionCurrency,

 //      cast(P_MY_TxItmWithSlsDeductionAmt.AmountInTransactionCurrency as fis_wsl) as AmountInTransactionCurrency,

      fltp_to_dec(P_MY_TxItmWithSlsDeductionAmt.AmountInTransactionCurrency as abap.curr(23,2)) as AmountInTransactionCurrency,
       @Semantics.amount.currencyCode: 'DocumentCurrency'
       P_MY_TxItmWithSlsDeductionAmt.TaxBaseAmountInTransCrcy,
       @Semantics.amount.currencyCode: 'DocumentCurrency'
       P_MY_TxItmWithSlsDeductionAmt.TaxAmount,

       @Semantics.currencyCode:true
       P_MY_TxItmWithSlsDeductionAmt.CompanyCodeCurrency,
       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       P_MY_TxItmWithSlsDeductionAmt.TaxBaseAmountInCoCodeCrcy,
       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       P_MY_TxItmWithSlsDeductionAmt.TaxAmountInCoCodeCrcy,

       @Semantics.currencyCode:true
       P_MY_TxItmWithSlsDeductionAmt.AdditionalCurrency1,
       @Semantics.amount.currencyCode: 'AdditionalCurrency1'
 //      P_MY_TxItmWithSlsDeductionAmt.AmountInAdditionalCurrency1,

       fltp_to_dec(P_MY_TxItmWithSlsDeductionAmt.AmountInAdditionalCurrency1 as abap.curr(23,2)) as AmountInAdditionalCurrency1,
 //      cast(P_MY_TxItmWithSlsDeductionAmt.AmountInAdditionalCurrency1 as dmbe2_farp) as AmountInAdditionalCurrency1,

       @Semantics.amount.currencyCode: 'AdditionalCurrency1'
       P_MY_TxItmWithSlsDeductionAmt.TaxBaseAmtInAdditionalCrcy1,
       @Semantics.amount.currencyCode: 'AdditionalCurrency1'
       P_MY_TxItmWithSlsDeductionAmt.TaxAmountInAdditionalCurrency1,

       @Semantics.currencyCode:true
       P_MY_TxItmWithSlsDeductionAmt.AdditionalCurrency2,
       @Semantics.amount.currencyCode: 'AdditionalCurrency2'
  //     P_MY_TxItmWithSlsDeductionAmt.AmountInAdditionalCurrency2,

      fltp_to_dec(P_MY_TxItmWithSlsDeductionAmt.AmountInAdditionalCurrency2 as abap.curr(23,2)) as AmountInAdditionalCurrency2,
 //      cast(P_MY_TxItmWithSlsDeductionAmt.AmountInAdditionalCurrency2 as dmbe3_farp) as AmountInAdditionalCurrency2,

       @Semantics.amount.currencyCode: 'AdditionalCurrency2'
       P_MY_TxItmWithSlsDeductionAmt.TaxBaseAmtInAdditionalCrcy2,
       @Semantics.amount.currencyCode: 'AdditionalCurrency2'
       P_MY_TxItmWithSlsDeductionAmt.TaxAmountInAdditionalCurrency2,

       _AccountingDocument,
       _GLAccount,
       _TaxJurisdiction,
       _ReportedItemsLog

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONALACCTGDOCITEM",
"P_MY_TXITMWITHSLSDEDUCTIONAMT"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENT",
"I_GLACCOUNT",
"I_STRPJOURNALENTRYLOG",
"I_TAXJURISDICTION"
],
"BASE":
[
"P_MY_TXITMWITHSLSDEDUCTIONAMT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/