P_TRANSACTIONALTAXITEM

CDS View
23 Fields 2 CDS Views

Transactional tax item

P_TRANSACTIONALTAXITEM is a CDS View in S/4HANA. Transactional tax item. It contains 23 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_TxRegItemCountCheck view_entity from BASIC Used to find the missing entries in BSET
P_TxRegItemHealthCheck view_entity inner BASIC View to compare TAX_REG_ITEM and BSET

Fields (23)

KeyField CDS FieldsUsed in Views
KEY TaxItemUUID TaxitemUuid 1
ConditionType TxRegConditionType 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
DebitCreditCode TxRegDebitCreditCode 1
DocumentDate TxRegDocumentDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
PostingDate TxRegPostingDate 1
TaxAmountInCoCodeCrcy TxRegTaxAmountInCoCodeCrcy 1
TaxAmountInRptgCrcy TxRegTaxAmountInRptgCrcy 1
TaxAmountInTransCrcy TxRegTaxAmountInTransCrcy 1
TaxBaseAmountInCoCodeCrcy TxRegTaxBaseAmountInCoCodeCrcy 1
TaxBaseAmountInRptgCrcy TxRegTaxBaseAmountInRptgCrcy 1
TaxBaseAmountInTransCrcy TxRegTaxBaseAmountInTransCrcy 1
TaxCode TxRegTaxCode 1
TaxCountry TxRegTaxCountry 1
TaxFulfillmentDate TxRegTaxFulfillmentDate 1
TaxItemGroup TxRegTaxItemGroup 1
TaxRateValidityStartDate TxRegTaxRateValidityStartDate 1
TaxRegisterMigrationUUID TaxRegisterMigrationUUID 1
TaxReportingDate TxRegTaxReportingDate 1
TransactionTypeDetermination TxRegTransactionTypeDetermntn 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.

-- Transactional tax item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_TRANSACTIONALTAXITEM (
    TAXITEMUUID,
    CONDITIONTYPE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    POSTINGDATE,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINRPTGCRCY,
    TAXAMOUNTINTRANSCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCODE,
    TAXCOUNTRY,
    TAXFULFILLMENTDATE,
    TAXITEMGROUP,
    TAXRATEVALIDITYSTARTDATE,
    TAXREGISTERMIGRATIONUUID,
    TAXREPORTINGDATE,
    TRANSACTIONTYPEDETERMINATION,
    PRIMARY KEY (TAXITEMUUID)
);

Learn More