I_AR_StRpTaxItem

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 I_AR_StRpTaxItem.
-- 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.
-- SQL view name: IARCALTAXITEM

CREATE VIEW I_AR_StRpTaxItem AS
SELECT
  I_StRpTaxItem.CompanyCode AS CompanyCode,
  I_StRpTaxItem.AccountingDocument AS AccountingDocument,
  I_StRpTaxItem.FiscalYear AS FiscalYear,
  I_StRpTaxItem.TaxItem AS TaxItem,
  I_StRpTaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_StRpTaxItem.TaxCode AS TaxCode,
  I_StRpTaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItem.DebitCreditCode AS DebitCreditCode,
  cast(cast(I_StRpTaxItem.TaxRate as abap.dec(11,2)) as char16) AS TaxRate,
  cast(cast(abs(I_StRpTaxItem.TaxRate) as abap.dec(11,2)) as char16) AS AR_VATRateInPercent,
  I_StRpTaxItem.GLAccount AS GLAccount,
  I_StRpTaxItem.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_StRpTaxItem.AccountingDocumentType AS AccountingDocumentType,
  I_StRpTaxItem.AdditionalCurrency1 AS AdditionalCurrency1,
  I_StRpTaxItem.AdditionalCurrency2 AS AdditionalCurrency2,
  I_StRpTaxItem.BusinessPartner AS BusinessPartner,
  I_StRpTaxItem.BusinessPartnerName AS BusinessPartnerName,
  I_StRpTaxItem.BusinessPlace AS BusinessPlace,
  I_StRpTaxItem.CompanyCodeCountry AS CompanyCodeCountry,
  I_StRpTaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_StRpTaxItem.CountryCurrency AS CountryCurrency,
  I_StRpTaxItem.CustomerSupplierAddress AS CustomerSupplierAddress,
  I_StRpTaxItem.DocumentCurrency AS DocumentCurrency,
  I_StRpTaxItem.DocumentDate AS DocumentDate,
  I_StRpTaxItem.DocumentReferenceID AS DocumentReferenceID,
  I_StRpTaxItem.FiscalPeriod AS FiscalPeriod,
  I_StRpTaxItem.IsReversal AS IsReversal,
  I_StRpTaxItem.IsReversed AS IsReversed,
  I_StRpTaxItem.Ledger AS Ledger,
  cast(I_StRpTaxItem.LedgerGroup as fagl_ldgrp) AS LedgerGroup,
  I_StRpTaxItem.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  I_StRpTaxItem.PostingDate AS PostingDate,
  I_StRpTaxItem.ReportingDate AS ReportingDate,
  I_StRpTaxItem.ReferenceDocumentType AS ReferenceDocumentType,
  I_StRpTaxItem.ReportingCountry AS ReportingCountry,
  I_StRpTaxItem.ReportingCurrency AS ReportingCurrency,
  I_StRpTaxItem.ReverseDocument AS ReverseDocument,
  I_StRpTaxItem.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  I_StRpTaxItem.TargetTaxCode AS TargetTaxCode,
  I_StRpTaxItem.TaxAmount AS TaxAmount,
  I_StRpTaxItem.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  I_StRpTaxItem.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  I_StRpTaxItem.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  I_StRpTaxItem.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  I_StRpTaxItem.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  I_StRpTaxItem.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  I_StRpTaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  I_StRpTaxItem.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  I_StRpTaxItem.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  I_StRpTaxItem.TaxIsNotDeductible AS TaxIsNotDeductible,
  I_StRpTaxItem.TaxItemGroup AS TaxItemGroup,
  I_StRpTaxItem.TaxJurisdiction AS TaxJurisdiction,
  I_StRpTaxItem.TaxNumber1 AS TaxNumber1,
  I_StRpTaxItem.TaxNumber2 AS TaxNumber2,
  I_StRpTaxItem.TaxNumber3 AS TaxNumber3,
  I_StRpTaxItem.TaxReportingDate AS TaxReportingDate,
  I_StRpTaxItem.TaxReturnCountry AS TaxReturnCountry,
  I_StRpTaxItem.TaxType AS TaxType,
  I_AR_ImportServiceDocumentType.DocumentTypeCategory AS DocumentTypeCategory,
  I_AR_ImportServiceDocumentType.IsRespForImportDeclaration AS IsRespForImportDeclaration,
  CountrySpecificDocumentType.AR_OfficialDocumentClass AS AR_OfficialDocumentClass,
  CountrySpecificDocumentType.AR_IsSelfIssuedDocument AS AR_IsSelfIssuedDocument,
  I_Altvcurrency.AlternativeCurrencyKey AS AlternativeCurrencyKey,
  cast( 'X' as abap.unit( 3 ) ) AS QuantityUnit,
  length(I_StRpTaxItem.BusinessPartnerName) AS LinearDataLength,
  case when I_Supplier.Supplier <> '' then I_Supplier.Country end as BusinessPartnerCountry AS CountryendasBusinessPartnerCountry,
  case when I_Customer.Customer <> '' then I_Customer.TaxNumberType when I_Supplier.Supplier <> '' then I_Supplier.TaxNumberType end as TaxNumberType AS TaxNumberTypeendasTaxNumberType,
  '' AS TaxClassification,
  I_AR_TaxClassIdentification.StRpTaxClassification AS TaxClassificationCategory,
  substring(I_AR_TaxClassIdentification.StRpTaxClassification,1,2) AS StRpTaxClassification,
  case I_StRpTaxItem.DocumentCurrency when 'ARS' then 1 else I_StRpTaxItem.ExchangeRate end as ExchangeRate AS ExchangeRateendasExchangeRate,
  ZeroVATRsn,
  OfclDocTypeDetnWthBlnkPrntChar.AR_OfficialDocumentType AS AR_OfficialDocumentType,
  I_StRpTaxItem._AccountingDocument AS _AccountingDocument,
  I_StRpTaxItem._GLAccount AS _GLAccount,
  I_StRpTaxItem._ReceivablesPayablesItem AS _ReceivablesPayablesItem,
  I_StRpTaxItem._ReportedItemsLog AS _ReportedItemsLog,
  I_StRpTaxItem._ReportingCurrency AS _ReportingCurrency,
  I_StRpTaxItem._TaxJurisdiction AS _TaxJurisdiction,
  I_StRpTaxItem._TaxTypeText AS _TaxTypeText,
  I_AR_TaxClassIdentification.GLBusinessTransactionType AS GLBusinessTransactionType,
  I_Supplier.ResponsibleType AS ResponsibleType
FROM I_StRpTaxItem
LEFT OUTER JOIN I_AR_TaxClassIdentification ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Altvcurrency ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AR_ImportServiceDocumentType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AccountingDocument AS _ReverseDoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnitOfMeasure ON QuantityUnit = _QuantityUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_AR_OfficialDocumentTypeDetn AS _OfficialDocumentTypeDetn ON _OfficialDocumentTypeDetn.Country = 'AR' AND _OfficialDocumentTypeDetn.AR_Report = 'RPFIGLAR_TAXREPORTING' AND _OfficialDocumentTypeDetn.AR_OfficialDocumentClass = AR_OfficialDocumentClass AND _OfficialDocumentTypeDetn.AR_PrintCharacter = AR_PrintCharacter  -- association [0..1]
;