C_AR_JournalEntryTaxItemDetail

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 C_AR_JournalEntryTaxItemDetail.
-- 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: CARJRNLENTTXIDET

CREATE VIEW C_AR_JournalEntryTaxItemDetail AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  TaxItem,
  Supplier,
  Customer,
  TaxType,
  CompanyCodeCountry,
  AR_JournalEntryTaxDetail.AccountingDocumentType AS AccountingDocumentType,
  FinancialAccountType,
  ExchangeRateDate,
  ExchangeRate,
  FiscalPeriod,
  PostingDate,
  DocumentDate,
  ReportingDate,
  ClearingDate,
  ClearingAccountingDocument,
  CountrySpecificDocumentType.AR_OfficialDocumentClass AS AR_OfficialDocumentClass,
  IsReversal,
  IsReversed,
  ReverseDocument,
  ReversalReferenceDocument,
  OriginalReferenceDocument,
  ReferenceDocumentType,
  DocumentReferenceID,
  AR_Branch,
  AR_PrintCharacter,
  AR_OfficialDocumentNumber,
  AR_IsSelfIssuedDocument,
  TaxCalculationProcedure,
  TaxCode,
  TaxCodeName,
  TransactionTypeDetermination,
  TaxRate,
  StRpTaxClassification,
  ZeroVATRsn,
  TransactionCurrency,
  CompanyCodeCurrency,
  AmountInTransactionCurrency,
  AmountInCompanyCodeCurrency,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxedAmountInCoCoCrcy,
  NotTaxedAmount,
  TaxExemptionAmount,
  ExportOperationTaxAmount,
  ImportAmountInCompanyCodeCrcy
FROM P_AR_JournalEntryTaxDetail AS AR_JournalEntryTaxDetail
LEFT OUTER JOIN I_CountrySpecificDocumentType AS CountrySpecificDocumentType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AR_OfficialDocumentTypeDetn AS _AR_OfficialDocumentTypeDetn ON _AR_OfficialDocumentTypeDetn.Country = CompanyCodeCountry AND _AR_OfficialDocumentTypeDetn.AR_OfficialDocumentClass = CountrySpecificDocumentType.AR_OfficialDocumentClass AND _AR_OfficialDocumentTypeDetn.AR_PrintCharacter = AR_PrintCharacter AND _AR_OfficialDocumentTypeDetn.AR_Report = 'RPFIGLAR_TAXREPORTING'  -- association [1..1]
LEFT OUTER JOIN I_OneTimeAccountBP AS _OneTimeAccountBP ON CompanyCode = _OneTimeAccountBP.CompanyCode AND AccountingDocument = _OneTimeAccountBP.AccountingDocument AND FiscalYear = _OneTimeAccountBP.FiscalYear  -- association [0..*]
LEFT OUTER JOIN I_StRpJournalEntryLog AS _StRpJournalEntryLog ON CompanyCode = _StRpJournalEntryLog.CompanyCode AND AccountingDocument = _StRpJournalEntryLog.AccountingDocument AND FiscalYear = _StRpJournalEntryLog.FiscalYear  -- association [0..*]
LEFT OUTER JOIN I_Altvcurrency AS _AltvCurrency ON _AltvCurrency.Currency = CompanyCodeCurrency AND _AltvCurrency.CurrencyAlternativeCodeGroup = 'DAILYVAT'  -- association [1..1]
;