C_AR_StRpPurFrgnSrvcCube

@AbapCatalog.sqlViewName: 'CARPURFRGNSRITMC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #CONSUMPTION
@Analytics.dataCategory: #CUBE
@AccessControl.personalData.blocking:#BLOCKED_DATA_INCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Cube View For Argentina Foreign Service'
@Metadata.allowExtensions:true

define view C_AR_StRpPurFrgnSrvcCube
  with parameters
    P_AccrualCalculationMethod :fiar_vat_compcredit
  as select from    I_AR_StRpPurFrgnSrvcItem

    left outer join I_GLAccountInCompanyCode as BankGlDet   on  I_AR_StRpPurFrgnSrvcItem.CompanyCode = BankGlDet.CompanyCode
                                                            and I_AR_StRpPurFrgnSrvcItem.GLAccount   = BankGlDet.GLAccount

    inner join      I_Housebank              as BankCuitDet on  BankGlDet.CompanyCode = BankCuitDet.CompanyCode
                                                            and BankGlDet.HouseBank   = BankCuitDet.HouseBank

{

      //I_AR_StRpPurFrgnSrvcItem

  key I_AR_StRpPurFrgnSrvcItem.CompanyCode,
  key AccountingDocument,
  key FiscalYear,
  key AccountingDocumentItem,
  key TaxCode,
  key TransactionTypeDetermination,
      PostingDate,
      ReportingDate,
      StRpTaxClassification,
      DocumentDate,
      AR_OfficialDocumentNumber,
      DocumentReferenceID,
      ExchangeRate,
      TaxNumber1,
      IsRespForImportDeclaration,
      TaxNumberType,
      AlternativeCurrencyKey,
      BusinessPartnerCountry,
      CountryFreeText,
      NmbrOfVATRates,
      AR_OfficialDocumentType,
      DocumentCurrency,
      AR_CUIT,
      HierarchyNodeText,
      AR_VATRateCode,
      TaxBaseAmountInTransCrcy,
      TaxBaseAmountInCountryCrcy,
      IsValid,
      ItemIsActivated,
      TaxBaseAmountInCoCodeCrcy,
      BusinessPartnerName,
      PurchaseImportForm,
      ClearingAccountingDocument,
      TaxReportingDate,
      I_AR_StRpPurFrgnSrvcItem.GLAccount,
      DocumentTypeCategory,
      AccountingDocumentTypeName,
      BankCuitDet.TaxID1                                                        as  BankIdentification,
      CompanyCodeCurrency,
      TaxAmount,
      TaxAmountInRptgCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      case
      when AR_PrintCharacter = 'B' or AR_PrintCharacter = 'C'
      then 0
      else
      case  $parameters.P_AccrualCalculationMethod
      when 'G'
      then
      case
      when StRpTaxClassification = 'TX' or StRpTaxClassification = 'VS'
      then
      I_AR_StRpPurFrgnSrvcItem.TaxAmountInRptgCrcy - TaxExemptionAmount
      end
      when 'P'
      then 0
      when 'D'
      then I_AR_StRpPurFrgnSrvcItem.TaxAmountInRptgCrcy
      end
      end                                                                       as  CalculatedTxAmtInCoCodeCrcy,
      _ReportedItemsLog.StatryRptCategory,
      _ReportedItemsLog.StatryRptgEntity,
      _ReportedItemsLog.StatryRptRunID,
      /* Associations */
      //I_AR_StRpPurFrgnSrvcItem

      _AccountingDocument,
      _ReceivablesPayablesItem,
      _ReportedItemsLog,
     GLBusinessTransactionType,
      ResponsibleType
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_AR_STRPPURFRGNSRVCITEM",
"I_GLACCOUNTINCOMPANYCODE",
"I_HOUSEBANK",
"I_STRPJOURNALENTRYLOG"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENT",
"I_OPERATIONALACCTGDOCITEM",
"I_STRPJOURNALENTRYLOG"
],
"BASE":
[
"I_AR_STRPPURFRGNSRVCITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/