P_TAXREGISTERINDIRECTTAXITEM

CDS View
18 Fields 1 CDS Views

P_TAXREGISTERINDIRECTTAXITEM is a CDS View in S/4HANA. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TxRegIndirectTaxJournalEntry view_entity from BASIC Indirect Tax with Journal Entry

Fields (18)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY DocumentTaxItemNumber DocumentTaxItemNumber 1
KEY FiscalYear FiscalYear 1
ConditionType ConditionType 1
DebitCreditCode DebitCreditCode 1
GLAccount GLAccount 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 1
TaxAmountInTransCrcy TaxAmountInTransCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 1
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 1
TaxCode TaxCode 1
TaxDeterminationDate TaxDeterminationDate 1
TaxItemAcctgDocItemRef TaxItemAcctgDocItemRef 1
TaxItemGroup TaxItemGroup 1
TaxJurisdiction TaxJurisdiction 1
TaxRateValidityStartDate TaxRateValidityStartDate 1
TransactionTypeDetermination TransactionTypeDetermination 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_TAXREGISTERINDIRECTTAXITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    DOCUMENTTAXITEMNUMBER,
    FISCALYEAR,
    CONDITIONTYPE,
    DEBITCREDITCODE,
    GLACCOUNT,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINTRANSCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCODE,
    TAXDETERMINATIONDATE,
    TAXITEMACCTGDOCITEMREF,
    TAXITEMGROUP,
    TAXJURISDICTION,
    TAXRATEVALIDITYSTARTDATE,
    TRANSACTIONTYPEDETERMINATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, DOCUMENTTAXITEMNUMBER, FISCALYEAR)
);

Learn More