TX_ITEM

TX_ITEM is an SAP database table in S/4HANA. It contains 7 fields.

Fields (7)

KeyField CDS FieldsUsed in Views
CAAmountInLocalCurrency TaxAmountInCoCodeCrcy 3
CAReconciliationKey CAReconciliationKey 2
CATaxBaseAmount TaxBaseAmountInTransCrcy 3
CATaxBaseAmountInLocalCurrency TaxAmountInCountryCrcy,TaxBaseAmountInCoCodeCrcy,TaxBaseAmountInCountryCrcy 3
CATransactionKeyAccountDetn TransactionTypeDetermination 3
Currency DocumentCurrency 3
TaxCode TaxCode 3

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 TX_ITEM (
    CAAMOUNTINLOCALCURRENCY,
    CARECONCILIATIONKEY,
    CATAXBASEAMOUNT,
    CATAXBASEAMOUNTINLOCALCURRENCY,
    CATRANSACTIONKEYACCOUNTDETN,
    CURRENCY,
    TAXCODE
);