C_CADocumentTaxGLItem

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Tax Item'

@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C

@Metadata.allowExtensions: true
define view entity C_CADocumentTaxGLItem
  as select from R_CADocumentGLItemTP
{
  key CADocumentNumber,
  key CAGLItemNumber,

      CompanyCode,
      BusinessArea,
      BusinessPlace,
      Segment,
      ProfitCenter,
      PartnerCompany,
      GLAccount,
      ValueDate,
      CAExchangeRate,
      ExchRateIsIndirectQuotation,
      TransactionCurrency,
      Currency,
      CAAccountAssignmentCategory,
      CAAccountAssignment,
      CostCenter,
      SalesOrder,
      SalesOrderItem,
      CAReconciliationKey,
      CAInternalPostingReasonCode,
      CANegativePostingControlCode,
      CAGLPostingCurrency,
      LedgerGroup,
      ProfitabilitySegment_2,
      ProfitabilitySegmentChanges,
      PlanningLevel,
      CARepetitionGroup,
      CATransactionKeyAccountDetn,
      ConditionType,
      CAIsSeparateLineItemInGL,
      BaseUnit,
      TaxCode,
      CASupplementaryTaxCode,
      CAWithholdingTaxSupplement,
      CAOtherTaxCode,
      CAGroupingCodeForTaxItems,
      TaxJurisdiction,
      CAEnteredTaxJurisdictionCode,
      CATaxJurisdictionLevelCounter,
      CATaxExceptionID,
      CATaxDate,
      CAContainsNonDeductibleInptTax,
      CATaxRate,
      GrossIncomeTaxActivityCode,
      EmploymentTaxDistributionType,
      CATaxIsCalculatedExternally,
      CAAltvExchangeRateSetCode,
      CAIsCashFlowItem,
      CACashFlowAccount,
      CACashFlowCompanyCode,
      HouseBank,
      HouseBankAccount,
      QuantitySignCode,
      BankStatementShortID,
      BankStatementItem,
      CashManagementLinkType,
      CashManagementLink,
      CAItmIsCreatedByPostgInterface,
      CAStatusOfEuroConversion,
      CAProfitAnalysisUpdtIsDirect,
      CAInvcgGroupingKey,
      CACtrlFieldForAcctAssgmtDistr,
      CAUpdateMethodForFundsMgmt,
      OriginalFinancialMgmtArea,
      OriglYearForFinMgmtAcctAssgmt,
      EarmarkedFundsDocument,
      ChartOfAccounts,
      Country,
      TaxCalculationProcedure,

      //Amounts

      @Semantics.amount.currencyCode: 'Currency'
      CAAmountInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAAmountInTransactionCurrency,
      @Semantics.amount.currencyCode: 'Currency'
      CAAmountInSecondCurrency,
      @Semantics.amount.currencyCode: 'Currency'
      CAAmountInThirdCurrency,
      @Semantics.amount.currencyCode: 'Currency'
      CATaxPortionInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CATaxPortionInTransCurrency,
      @Semantics.amount.currencyCode: 'Currency'
      CATaxBaseAmountInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CATaxBaseAmount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CANonDeductibleTxAmtInDocCrcy,
      @Semantics.amount.currencyCode: 'Currency'
      CANonDeductibleTxAmtInLoclCrcy,
      
      case when ( CATaxRate > '500000' )
        then -( (cast( concat( concat( left(CATaxRate,3), '.'), right(CATaxRate,3) ) as tax_perc_kk)) - 500 )
        else cast( concat( concat( left(CATaxRate,3), '.'), right(CATaxRate,3) ) as tax_perc_kk)
      end  
      as CATaxRateInPercent,
     
      
      


      /* Associations */
      _AcctAssgmtCat,
      _BusinessArea,
      _CAAcctAssgmtDistrCode,
      _CAAcctDetnTransKey,
      _CAAltvExchangeRateSetCode,
      _CAEuroConversionStatus,
      _CAIntPostingReasonCode,
      _CANegativePostingCtrlCode,
      _CANonDcblInputTaxCode,
      _CashFlowAccount,
      _ChartOfAccounts,
      _CompCode,
      _CompCodeCashFlow,
      _Country,
      _DocHeader,
      _GLAccount,
      _GLAccountInCompanyCode,
      _GLPostingCurrency,
      _OtherTaxCode,
      _PartnerCompany,
      _ProfitCenter,
      _Segment,
      _WhldgTaxSuplmnt


}
where
  CATaxBaseAmountInLocalCurrency <> 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_CADOCUMENTGLITEMTP"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_CAACCOUNTASSIGNMENTCATEGORY",
"I_CAACCTASSGMTDISTRCODE",
"I_CAACCTDETNTRANSKEY",
"I_CAALTVEXCHANGERATESETCODE",
"I_CAEUROCONVERSIONSTATUS",
"I_CAINTPOSTINGREASONCODE",
"I_CANEGATIVEPOSTINGCTRLCODE",
"I_CANONDCBLINPUTTAXCODE",
"I_CAOTHERTAXCODE",
"I_CAWITHHOLDINGTAXSUPPLEMENT",
"I_CHARTOFACCOUNTS",
"I_COMPANYCODE",
"I_COUNTRY",
"I_CURRENCY",
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_GLACCOUNTINCOMPANYCODE",
"I_PARTNERCOMPANY",
"I_PROFITCENTER",
"I_SEGMENT",
"R_CADOCUMENTTP"
],
"BASE":
[
"R_CADOCUMENTGLITEMTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/