C_AR_StRpVATPrintTaxDetailC

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_StRpVATPrintTaxDetailC.
-- 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: CARVATPRNTTXDETC

CREATE VIEW C_AR_StRpVATPrintTaxDetailC AS
SELECT
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  StRpJournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  StRpJournalEntryLog.StatryRptCategory AS StatryRptCategory,
  StRpJournalEntryLog.StatryRptRunID AS StatryRptRunID,
  TaxItem.TaxItem AS TaxItem,
  JournalEntry.FiscalPeriod AS FiscalPeriod,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.ReportingDate AS ReportingDate,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntry.AR_Branch AS AR_Branch,
  JournalEntry.AR_PrintCharacter AS AR_PrintCharacter,
  JournalEntry.AR_OfficialDocumentNumber AS AR_OfficialDocumentNumber,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  AccountKey.AccountKeyName AS AccountKeyName,
  TaxItem.TaxRate AS TaxRate,
  cast ( cast (TaxItem.TaxRate as char32) as figen_taxrateinpercentastext ) AS TaxRateInPercentAsText,
  TaxItem.StRpTaxClassification AS StRpTaxClassification,
  TaxItem.ZeroVATRsn AS ZeroVATRsn,
  TaxItem.GLAccount AS GLAccount,
  JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  TaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  JournalEntry.TransactionCurrency AS TransactionCurrency,
  TaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  TaxItem.TaxAmountInTransCrcy AS TaxAmountInTransCrcy
FROM P_AR_JournalEntry AS JournalEntry
INNER JOIN P_AR_TaxItem AS TaxItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_StRpJournalEntryLog AS StRpJournalEntryLog ON /* join condition not captured in parsed metadata */
;