SAP table TINSO (Failed Payment Transactions and Charges)

SAP table TINSO has 6 primary key fields being MANDT,REPID,BUKRS,BELNR,GJAHR,IDPOS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
REPID ABAP Program Name CHAR 40 0 REPID
BUKRS Company Code CHAR 4 0 T001 BUKRS
BELNR Accounting Document Number CHAR 10 0 BELNO
GJAHR Fiscal Year NUMC 4 0 GJAHR
IDPOS Identification Flag for Document Type NUMC 1 0 IDPOS
1 Bill of exchange
2 Check
3 Bank collection
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
INBTR Amount in Document Currency CURR 23 2 INBTR
BKVAL Value Date DATS 8 0 BKVAL
BKKON Bank Account for Debit Memo CHAR 10 0 SKA1 BKKON
SPKON Revenue Account for On-Debited Bank Charges CHAR 10 0 SKA1 SPKON
SPESE Bank Charges CURR 23 2 SPESE
WAERS Currency Key CUKY 5 0 TCURC WAERS
SPTAX Tax Amount on Charges in Document Currency CURR 23 2 SPTAX
SPSKZ Tax Code for Taxes on Bank Charges CHAR 2 0 T007A SPSKZ
INSTA Processing Status CHAR 1 0 INSTA
New - still to be updated
1 Receivable updated
2 Entered in batch input session
3 The specifications are incorrect
TXT40 Document Text CHAR 40 0 BELTX
BKTXT Document Header Text CHAR 25 0 BKTXT
ISBTR Amount not paid CURR 23 2 ISBTR
HBKID Presenting Bank CHAR 5 0 T012 HBKID_FBWE
MOTIF Bouncing Reason CHAR 5 0 MOTIF_TINSO

TINSO foreign key relationships

Table Field Check Table Check Field
0 TINSO BKKON SKA1 G/L Account Master (Chart of Accounts) MANDT
0 TINSO BKKON SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 TINSO BKKON SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 TINSO BUKRS T001 Company Codes BUKRS
0 TINSO HBKID T012 House Banks BUKRS
1 TINSO KUNNR KNA1 General Data in Customer Master MANDT
1 TINSO KUNNR KNA1 General Data in Customer Master KUNNR
0 TINSO SPKON SKA1 G/L Account Master (Chart of Accounts) MANDT
0 TINSO SPKON SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 TINSO SPKON SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 TINSO SPSKZ T007A Tax Keys KALSM
1 TINSO SPSKZ T007A Tax Keys MWSKZ
0 TINSO WAERS TCURC Currency Codes MANDT
0 TINSO WAERS TCURC Currency Codes WAERS