P_MY_TDTTAXRATE

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_MY_TDTTAXRATE.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_TaxIsDeferredRelevant : figen_deferred_check, P_TaxIsMossRelevant : figen_moss_check, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1, P_TaxBoxConfiguration : figen_tdt_taxbox_config

CREATE VIEW P_MY_TDTTAXRATE AS
SELECT
  P_StRpCalTaxReturnBox.CompanyCode AS CompanyCode,
  P_StRpCalTaxReturnBox.AccountingDocument AS AccountingDocument,
  P_StRpCalTaxReturnBox.FiscalYear AS FiscalYear,
  P_StRpCalTaxReturnBox.TaxItem AS TaxItem,
  P_StRpCalTaxReturnBox.TransactionTypeDetermination AS TransactionTypeDetermination,
  P_StRpCalTaxReturnBox.DebitCreditCode AS DebitCreditCode,
  P_StRpCalTaxReturnBox.AccountingDocumentType AS AccountingDocumentType,
  P_StRpCalTaxReturnBox.SupplierAccountGroup AS SupplierAccountGroup,
  P_StRpCalTaxReturnBox.TaxBox AS TaxBox,
  P_StRpCalTaxReturnBox.TaxDeclnAmountType AS TaxDeclnAmountType,
  P_StRpCalTaxReturnBox.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  P_StRpCalTaxReturnBox.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  P_StRpCalTaxReturnBox.TaxGroup AS TaxGroup,
  P_StRpCalTaxReturnBox.TaxItemGrpgDebitCreditCode AS TaxItemGrpgDebitCreditCode,
  TaxItemGrpgAcctgDocumentType,
  TaxItemGrpgSupplierAcctGroup,
  P_StRpCalTaxReturnBox.TaxItemGrpgSpecialGLCode AS TaxItemGrpgSpecialGLCode,
  P_StRpCalTaxReturnBox.StatryRptgEntity AS StatryRptgEntity,
  P_StRpCalTaxReturnBox.StatryRptCategory AS StatryRptCategory,
  P_StRpCalTaxReturnBox.StatryRptRunID AS StatryRptRunID,
  P_StRpCalTaxReturnBox.StatryRptRun AS StatryRptRun,
  P_StRpCalTaxReturnBox.ValidFrom AS ValidFrom,
  P_StRpCalTaxReturnBox.Country AS Country,
  P_StRpCalTaxReturnBox.TaxCode AS TaxCode,
  P_StRpCalTaxReturnBox.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  P_StRpCalTaxReturnBox.TaxBoxStructureType AS TaxBoxStructureType,
  P_StRpCalTaxReturnBox.ValidTo AS ValidTo,
  TaxBoxStrucValidityEndDate,
  TaxCalculationProcedure,
  TaxRate,
  P_StRpCalTaxReturnBox.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  IPITaxRate,
  case when I_AdvancedTaxReportingCountry.Country is null or TaxGroupOperation = '' then P_StRpCalTaxReturnBox.TaxCodeRatePointer else division ( cast( cast (TaxGroupFreeClassification as abap.numc( 5 )) as abap.dec(5,2) ) ,100,2) end as TaxCodeRatePointer AS dec521002endasTaxCodeRatePointer,
  Customer,
  GLAccount,
  TaxItemGroup,
  BusinessPlace,
  P_StRpCalTaxReturnBox.TaxJurisdiction AS TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  ReferenceDocumentType,
  AlternativeReferenceDocument,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  ConditionRecord,
  RoundingDecimalPlaces,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  ReportingDate,
  TaxReportingDocumentDate,
  FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  AmountInReportingCurrency,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  DifferenceTaxAmtInCoCodeCrcy,
  DiffTaxBaseAmountInCoCodeCrcy,
  TotalGrossAmountInCoCodeCrcy,
  TotalGrossAmount,
  TotalGrossAmountInTransCrcy,
  TaxType,
  BPTaxNumber,
  ReportingVATRegistration,
  TaxNumber1,
  ShippingPointCountry,
  TargetTaxCode,
  TaxNumber2,
  ActiveTaxType,
  TaxNumber3,
  TaxIsDeferredRelevant,
  TaxIsMossRelevant,
  CalculatedTxAmtInCoCodeCrcy,
  CalculatedTaxAmountInTransCrcy,
  CalculatedTxBaseAmtInTransCrcy,
  AmountInTransactionCurrency,
  AmountInCompanyCodeCurrency,
  CalcdTxBaseAmtInCoCodeCrcy,
  AmountInAdditionalCurrency1,
  AmountInAdditionalCurrency2,
  BusinessPartner,
  CAReconciliationKey,
  NonDeductibleInputTaxAmount,
  DcblVATIncrdCostInRptgCrcy,
  BusinessPartnerName,
  BusinessPartnerCountry,
  TaxTypeName,
  CustomerSupplierAddress,
  P_StRpCalTaxReturnBox.TaxIsNotDeductible AS TaxIsNotDeductible,
  SenderCompanyCode,
  SenderAccountingDocument,
  SenderFiscalYear,
  BalanceAmountInTransacCurrency,
  P_StRpCalTaxReturnBox.TaxBoxStructure AS TaxBoxStructure,
  TaxBoxStructureName,
  P_StRpCalTaxReturnBox.TaxBoxName AS TaxBoxName,
  P_StRpCalTaxReturnBox.TaxBoxCondition AS TaxBoxCondition,
  P_StRpCalTaxReturnBox.TaxBoxAggregationOperation AS TaxBoxAggregationOperation,
  P_StRpCalTaxReturnBox.TaxGroupOperation AS TaxGroupOperation,
  ConditionType,
  IsVATRelevant,
  IsNegativePosting,
  P_StRpCalTaxReturnBox.TaxCountry AS TaxCountry,
  TaxCntryOrCompanyCodeCntry
FROM I_StRpTaxReturnBoxCube
;