SAP Table TINSO
Failed Payment Transactions and Charges
TINSO (Failed Payment Transactions and Charges) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TINSO to other SAP tables.
TINSO table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
| REPID | ABAP Program Name | REPID | CHAR | 40 | 0 | |||||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||
| BELNR | Accounting document number | BELNO | CHAR | 10 | 0 | |||||||||||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | 0 | |||||||||||
| IDPOS | Identification Flag for Document Type | IDPOS | NUMC | 1 | 0 |
Possible values
|
||||||||||
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 | 0 | ||||||||||
| INBTR | Amount in Document Currency | INBTR | CURR | 13 | 2 | |||||||||||
| BKVAL | Value Date | BKVAL | DATS | 8 | 0 | |||||||||||
| BKKON | Bank Account for Debit Memo | BKKON | SKA1 | CHAR | 10 | 0 | ||||||||||
| SPKON | Revenue account for on-debited bank charges | SPKON | SKA1 | CHAR | 10 | 0 | ||||||||||
| SPESE | Bank charges | SPESE | CURR | 13 | 2 | |||||||||||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||
| SPTAX | Tax Amount on Charges in Document Currency | SPTAX | CURR | 13 | 2 | |||||||||||
| SPSKZ | Tax Code for Taxes on Bank Charges | SPSKZ | T007A | CHAR | 2 | 0 | ||||||||||
| INSTA | Processing status | INSTA | CHAR | 1 | 0 |
Possible values
|
||||||||||
| TXT40 | Document text | BELTX | CHAR | 40 | 0 | |||||||||||
| BKTXT | Document Header Text | BKTXT | CHAR | 25 | 0 | |||||||||||
| ISBTR | Amount not paid | ISBTR | CURR | 13 | 2 | |||||||||||
| HBKID | Presenting Bank | HBKID_FBWE | T012 | CHAR | 5 | 0 | ||||||||||
| MOTIF | Bouncing Reason | MOTIF_TINSO | CHAR | 5 | 0 | |||||||||||
TINSO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TINSO | BKKON | T001 | KTOPL | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| TINSO | BKKON | TINSO | BKKON | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| TINSO | BKKON | TINSO | MANDT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| TINSO | BUKRS | TINSO | MANDT | T001 | Company Codes | MANDT |
| TINSO | BUKRS | TINSO | BUKRS | T001 | Company Codes | BUKRS |
| TINSO | HBKID | TINSO | MANDT | T012 | House Banks | MANDT |
| TINSO | HBKID | TINSO | BUKRS | T012 | House Banks | BUKRS |
| TINSO | HBKID | TINSO | HBKID | T012 | House Banks | HBKID |
| TINSO | KUNNR | TINSO | MANDT | KNA1 | General Data in Customer Master | MANDT |
| TINSO | KUNNR | TINSO | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| TINSO | MANDT | TINSO | MANDT | T000 | Clients | MANDT |
| TINSO | SPKON | TINSO | MANDT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| TINSO | SPKON | T001 | KTOPL | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| TINSO | SPKON | TINSO | SPKON | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| TINSO | SPSKZ | TINSO | MANDT | T007A | Tax Keys | MANDT |
| TINSO | SPSKZ | T005 | KALSM | T007A | Tax Keys | KALSM |
| TINSO | SPSKZ | TINSO | SPSKZ | T007A | Tax Keys | MWSKZ |
| TINSO | WAERS | TINSO | MANDT | TCURC | Currency Codes | MANDT |
| TINSO | WAERS | TINSO | WAERS | TCURC | Currency Codes | WAERS |
