I_TXREGINDIRECTTAXJOURNALENTRY

CDS View
44 Fields 2 CDS Views

Indirect Tax with Journal Entry

I_TXREGINDIRECTTAXJOURNALENTRY is a CDS View in S/4HANA. Indirect Tax with Journal Entry. It contains 44 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_TxRegIndrctTxJrnlEntrRefDoc view_entity from COMPOSITE Indirect Tax Item with Journal Entry Reference Document
P_TxRegItemHealthCheck view_entity from BASIC View to compare TAX_REG_ITEM and BSET

Fields (44)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY DocumentTaxItemNumber DocumentTaxItemNumber 2
KEY FiscalYear FiscalYear 2
_CompanyCodeCurrency _CompanyCodeCurrency 1
_RefDocumentLogicalSystem _RefDocumentLogicalSystem 1
_ReferenceDocumentType _ReferenceDocumentType 1
_ReportingCurrency _ReportingCurrency 1
_TransactionCurrency _TransactionCurrency 1
AccountingDocumentType AccountingDocumentType 2
CompanyCodeCurrency CompanyCodeCurrency 1
ConditionType ConditionType 2
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
DebitCreditCode DebitCreditCode 2
DocumentDate DocumentDate 2
GLAccount GLAccount 1
IsReversal IsReversal 1
IsReversed IsReversed 1
PostingDate PostingDate 2
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 1
ReferenceDocumentType ReferenceDocumentType 1
ReportingCurrency ReportingCurrency 2
ReversalReferenceDocument ReversalReferenceDocument 1
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 2
TaxAmountInRptgCrcy TaxAmountInRptgCrcy 2
TaxAmountInTransCrcy TaxAmountInTransCrcy 2
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 2
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy 2
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 2
TaxCalculationProcedure TaxCalculationProcedure 1
TaxCode TaxCode 2
TaxCountry TaxCountry 2
TaxDeterminationDate TaxDeterminationDate 1
TaxFulfillmentDate TaxFulfillmentDate 2
TaxItemAcctgDocItemRef TaxItemAcctgDocItemRef 1
TaxItemGroup TaxItemGroup 2
TaxItemIsReportingRelevant TaxItemIsReportingRelevant 1
TaxRate TaxRate 1
TaxRateValidityStartDate TaxRateValidityStartDate 2
TaxReportingDate TaxReportingDate 2
TransactionCurrency TransactionCurrency 2
TransactionTypeDetermination TransactionTypeDetermination 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Indirect Tax with Journal Entry
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TXREGINDIRECTTAXJOURNALENTRY (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    DOCUMENTTAXITEMNUMBER,
    FISCALYEAR,
    _COMPANYCODECURRENCY,
    _REFDOCUMENTLOGICALSYSTEM,
    _REFERENCEDOCUMENTTYPE,
    _REPORTINGCURRENCY,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGDOCUMENTTYPE,
    COMPANYCODECURRENCY,
    CONDITIONTYPE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    GLACCOUNT,
    ISREVERSAL,
    ISREVERSED,
    POSTINGDATE,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCURRENCY,
    REVERSALREFERENCEDOCUMENT,
    REVERSALREFERENCEDOCUMENTCNTXT,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINRPTGCRCY,
    TAXAMOUNTINTRANSCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCALCULATIONPROCEDURE,
    TAXCODE,
    TAXCOUNTRY,
    TAXDETERMINATIONDATE,
    TAXFULFILLMENTDATE,
    TAXITEMACCTGDOCITEMREF,
    TAXITEMGROUP,
    TAXITEMISREPORTINGRELEVANT,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDATE,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, DOCUMENTTAXITEMNUMBER, FISCALYEAR)
);

Learn More