I_TxRegIndirectTaxJournalEntry

DDL: I_TXREGINDIRECTTAXJOURNALENTRY Type: view_entity BASIC Package: FIN_TAXREG_MIGRATION_APPL
42 Fields 2 Data Sources 3 Associations

Indirect Tax with Journal Entry

I_TxRegIndirectTaxJournalEntry is a Basic CDS View that provides data about "Indirect Tax with Journal Entry" in SAP S/4HANA. It reads from 2 data sources (P_TaxRegisterIndirectTaxItem, I_JournalEntry) and exposes 42 fields with key fields CompanyCode, AccountingDocument, FiscalYear, DocumentTaxItemNumber. It has 3 associations to related views. Part of development package FIN_TAXREG_MIGRATION_APPL.

Data Sources (2)

SourceAliasJoin Type
P_TaxRegisterIndirectTaxItem IndirectTax from
I_JournalEntry JournalEntry inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Currency _ReportingCurrency $projection.ReportingCurrency = _ReportingCurrency.Currency
[0..1] I_Country _TaxCountry IndirectTax.TaxCountry = _TaxCountry.Country
[0..1] I_Country _TaxReturnCountry IndirectTax.TaxReturnCountry = _TaxReturnCountry.Country

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Indirect Tax with Journal Entry view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_TaxRegisterIndirectTaxItem CompanyCode Receiver Company Code
KEY AccountingDocument P_TaxRegisterIndirectTaxItem AccountingDocument Journal Entry
KEY FiscalYear P_TaxRegisterIndirectTaxItem FiscalYear G/L Fiscal Year
KEY DocumentTaxItemNumber P_TaxRegisterIndirectTaxItem DocumentTaxItemNumber
CountryendasTaxCountry
ReferenceDocumentType I_JournalEntry ReferenceDocumentType Reference Document Type
ReferenceDocumentLogicalSystem I_JournalEntry ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
IsReversal I_JournalEntry IsReversal Reversal doc.
IsReversed I_JournalEntry IsReversed Reversed?
ReversalReferenceDocument I_JournalEntry ReversalReferenceDocument Reversal Reference Document
ReversalReferenceDocumentCntxt I_JournalEntry ReversalReferenceDocumentCntxt Reversal Reference Document Context
GLAccount P_TaxRegisterIndirectTaxItem GLAccount General Ledger
TransactionTypeDetermination P_TaxRegisterIndirectTaxItem TransactionTypeDetermination Transaction Key
ConditionType P_TaxRegisterIndirectTaxItem ConditionType Condition type
TaxRateValidityStartDate P_TaxRegisterIndirectTaxItem TaxRateValidityStartDate Tax Rate Validity Start Date
TaxRate
TaxItemIsReportingRelevant
PostingDate I_JournalEntry PostingDate Posting Date for GR
DocumentDate I_JournalEntry DocumentDate Journal Entry Date
TaxFulfillmentDate I_JournalEntry TaxFulfillmentDate Tax Settlement Date
TaxReportingDate I_JournalEntry TaxReportingDate Tax Reporting Date
TaxItemGroup P_TaxRegisterIndirectTaxItem TaxItemGroup Tax doc. item number
DebitCreditCode P_TaxRegisterIndirectTaxItem DebitCreditCode Single-Character Flag
AccountingDocumentType I_JournalEntry AccountingDocumentType Journal Entry Type
CompanyCodeCurrency I_JournalEntry CompanyCodeCurrency Local Currency
TransactionCurrency I_JournalEntry TransactionCurrency Transaction Currency
TaxBaseAmountInCoCodeCrcy P_TaxRegisterIndirectTaxItem TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy P_TaxRegisterIndirectTaxItem TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy P_TaxRegisterIndirectTaxItem TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmountInTransCrcy P_TaxRegisterIndirectTaxItem TaxAmountInTransCrcy TaxAmt in Tran. Crcy
TaxCode P_TaxRegisterIndirectTaxItem TaxCode Tax Code
CreationDateTime
CreatedByUser I_JournalEntry AccountingDocCreatedByUser User which created overhead document
TaxJurisdiction P_TaxRegisterIndirectTaxItem TaxJurisdiction Tax Jurisdiction
TaxItemAcctgDocItemRef P_TaxRegisterIndirectTaxItem TaxItemAcctgDocItemRef Tax doc. item number
TaxDeterminationDate P_TaxRegisterIndirectTaxItem TaxDeterminationDate Tx Determination Dte
_CompanyCodeCurrency I_JournalEntry _CompanyCodeCurrency
_TransactionCurrency I_JournalEntry _TransactionCurrency
_ReportingCurrency _ReportingCurrency
_ReferenceDocumentType I_JournalEntry _ReferenceDocumentType
_RefDocumentLogicalSystem I_JournalEntry _RefDocumentLogicalSystem
_AccountingDocumentType I_JournalEntry _AccountingDocumentType

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_TxRegIndirectTaxJournalEntry.
-- 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 I_TxRegIndirectTaxJournalEntry AS
SELECT
  IndirectTax.CompanyCode AS CompanyCode,
  IndirectTax.AccountingDocument AS AccountingDocument,
  IndirectTax.FiscalYear AS FiscalYear,
  IndirectTax.DocumentTaxItemNumber AS DocumentTaxItemNumber,
  case when IndirectTax.TaxCountry is not null and IndirectTax.TaxCountry <> '' and IndirectTax.TaxCountry <> ' ' then IndirectTax.TaxCountry when IndirectTax.TaxReturnCountry is not null and IndirectTax.TaxReturnCountry <> '' and IndirectTax.TaxReturnCountry <> ' ' then IndirectTax.TaxReturnCountry else JournalEntry._CompanyCode.Country end as TaxCountry AS CountryendasTaxCountry,
  JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntry.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  JournalEntry.IsReversal AS IsReversal,
  JournalEntry.IsReversed AS IsReversed,
  JournalEntry.ReversalReferenceDocument AS ReversalReferenceDocument,
  JournalEntry.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  IndirectTax.GLAccount AS GLAccount,
  IndirectTax.TransactionTypeDetermination AS TransactionTypeDetermination,
  IndirectTax.ConditionType AS ConditionType,
  IndirectTax.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  cast( IndirectTax.TaxRate as fitaxrate ) AS TaxRate,
  cast( 'X' as txrg_xreportable ) AS TaxItemIsReportingRelevant,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.TaxFulfillmentDate AS TaxFulfillmentDate,
  JournalEntry.TaxReportingDate AS TaxReportingDate,
  IndirectTax.TaxItemGroup AS TaxItemGroup,
  IndirectTax.DebitCreditCode AS DebitCreditCode,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntry.TransactionCurrency AS TransactionCurrency,
  IndirectTax.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  IndirectTax.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  IndirectTax.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  IndirectTax.TaxAmountInTransCrcy AS TaxAmountInTransCrcy,
  IndirectTax.TaxCode AS TaxCode,
  cast( concat(JournalEntry.AccountingDocumentCreationDate, JournalEntry.CreationTime) as txrg_tax_item_createdat ) AS CreationDateTime,
  JournalEntry.AccountingDocCreatedByUser AS CreatedByUser,
  IndirectTax.TaxJurisdiction AS TaxJurisdiction,
  IndirectTax.TaxItemAcctgDocItemRef AS TaxItemAcctgDocItemRef,
  IndirectTax.TaxDeterminationDate AS TaxDeterminationDate,
  JournalEntry._CompanyCodeCurrency AS _CompanyCodeCurrency,
  JournalEntry._TransactionCurrency AS _TransactionCurrency,
  JournalEntry._ReferenceDocumentType AS _ReferenceDocumentType,
  JournalEntry._RefDocumentLogicalSystem AS _RefDocumentLogicalSystem,
  JournalEntry._AccountingDocumentType AS _AccountingDocumentType
FROM P_TaxRegisterIndirectTaxItem AS IndirectTax
INNER JOIN I_JournalEntry AS JournalEntry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON ReportingCurrency = _ReportingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Country AS _TaxCountry ON IndirectTax.TaxCountry = _TaxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _TaxReturnCountry ON IndirectTax.TaxReturnCountry = _TaxReturnCountry.Country  -- association [0..1]
;

Learn More