SAP ABAP Table TINSO (Failed Payment Transactions and Charges)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBD (Package) Customers

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TINSO	Table Relationship Diagram
Short Description	Failed Payment Transactions and Charges

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	REPID	☑	REPID	PROGNAME	CHAR	40	0	ABAP Program Name
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	BELNR	☑	BELNO	BELNR	CHAR	10	0	Accounting document number
5	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	IDPOS	☑	IDPOS	IDPOS	NUMC	1	0	Identification Flag for Document Type
7	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
8	INBTR	☐	INBTR	WERT7	CURR	13	2	Amount in Document Currency
9	BKVAL	☐	BKVAL	DATUM	DATS	8	0	Value Date
10	BKKON	☐	BKKON	SAKNR	CHAR	10	0	Bank Account for Debit Memo	SKA1
11	SPKON	☐	SPKON	SAKNR	CHAR	10	0	Revenue account for on-debited bank charges	SKA1
12	SPESE	☐	SPESE	WERT7	CURR	13	2	Bank charges
13	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
14	SPTAX	☐	SPTAX	WERT7	CURR	13	2	Tax Amount on Charges in Document Currency
15	SPSKZ	☐	SPSKZ	MWSKZ	CHAR	2	0	Tax Code for Taxes on Bank Charges	T007A
16	INSTA	☐	INSTA	INSTA	CHAR	1	0	Processing status
17	TXT40	☐	BELTX	TEXT40	CHAR	40	0	Document text
18	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
19	ISBTR	☐	ISBTR	WERT7	CURR	13	2	Amount not paid
20	HBKID	☐	HBKID_FBWE	HBKID	CHAR	5	0	Presenting Bank	T012
21	MOTIF	☐	MOTIF_TINSO	CHAR5	CHAR	5	0	Bouncing Reason

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TINSO	BKKON	SKA1	SAKNR	REF	C	CN
2	TINSO	BUKRS	T001	BUKRS	KEY	1	CN
3	TINSO	HBKID	T012	HBKID
4	TINSO	KUNNR	KNA1	KUNNR	REF	C	CN
5	TINSO	MANDT	T000	MANDT	KEY	1	CN
6	TINSO	SPKON	SKA1	SAKNR	REF	C	CN
7	TINSO	SPSKZ	T007A	MWSKZ	REF	C	CN
8	TINSO	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in