C_SimulatedJournalEntryTaxItem

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_SimulatedJournalEntryTaxItem.
-- 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.

CREATE VIEW C_SimulatedJournalEntryTaxItem AS
SELECT
  cast('' as fdc_accdoc_tmp_doc_id) AS TemporaryAccountingDocument,
  cast('' as fdc_accdoc_tmp_doc_type preserving type ) AS TmpAccountingDocumentType,
  cast('' as indx_relid) AS TmpAcctgDocSpecificationArea,
  cast('' as username) AS TmpAcctgDocumentCreatedByUser,
  TaxItem,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxCode,
  GLAccount,
  TaxItemGroup,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmountInCoCodeCrcy,
  TaxAmount,
  CreditAmountInCoCodeCrcy,
  DebitAmountInCoCodeCrcy,
  CreditAmountInTransCrcy,
  DebitAmountInTransCrcy,
  CreditAmountInAddlCrcy1,
  DebitAmountInAddlCrcy1,
  CreditAmountInAddlCrcy2,
  DebitAmountInAddlCrcy2,
  TransactionTypeDetermination,
  ConditionRecord,
  DestinationCountry,
  SupplyingCountry,
  TaxJurisdiction,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  ConditionType,
  TaxReturnDate,
  TaxReportingDate,
  TaxRate,
  cast( '%' as txrgpercentageunit ) AS TaxRegisterPercentageUnit,
  TaxReturnCountry,
  TaxAmountInCountryCrcy,
  TaxBaseAmountInCountryCrcy,
  CreditAmountInReportingCrcy,
  DebitAmountInReportingCurrency,
  TaxDeterminationDate,
  BusinessPlace,
  LowestLevelTaxJurisdiction,
  TaxJurisdictionLevel,
  TaxItemAcctgDocItemRef,
  TaxResultManualModification,
  DebitCreditCode,
  TaxRateValidityStartDate,
  TaxCountry,
  CompanyCodeCurrency,
  TransactionCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  CountryCurrency,
  TaxCalculationProcedure,
  cast(_CompanyCode.CompanyCodeName as fis_butxt preserving type) AS CompanyCodeName,
  cast(_GlAccountText.GLAccountName as fco_glaccount_name preserving type) AS GLAccountName,
  cast(_TaxCodeText.TaxCodeName as fis_mwskz_name preserving type ) AS TaxCodeName
FROM R_ManageJournalEntryTaxItem
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GlAccountText ON CompanyCode = _GlAccountText.CompanyCode AND GLAccount = _GlAccountText.GLAccount AND _GlAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TaxCodeText AS _TaxCodeText ON TaxCode = _TaxCodeText.TaxCode AND TaxCalculationProcedure = _TaxCodeText.TaxCalculationProcedure AND _TaxCodeText.Language = $session.system_language  -- association [0..1]
;