SAP Table V_TINSO
Generated Table for View
V_TINSO (Generated Table for View) 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 V_TINSO to other SAP tables.
V_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 | |||||||||||
| HBKID | Presenting Bank | HBKID_FBWE | T012 | CHAR | 5 | 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 | |||||||||||
| MOTIF | Bouncing Reason | MOTIF_TINSO | CHAR | 5 | 0 | |||||||||||
| BUTXT | Name of Company Code or Company | BUTXT | CHAR | 25 | 0 | |||||||||||
| NAME1 | Name 1 | NAME1_GP | CHAR | 35 | 0 | |||||||||||
V_TINSO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| V_TINSO | BKKON | V_TINSO | BKKON | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| V_TINSO | BKKON | V_TINSO | MANDT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| V_TINSO | BKKON | T001 | KTOPL | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| V_TINSO | BUKRS | V_TINSO | MANDT | T001 | Company Codes | MANDT |
| V_TINSO | BUKRS | V_TINSO | BUKRS | T001 | Company Codes | BUKRS |
| V_TINSO | HBKID | V_TINSO | MANDT | T012 | House Banks | MANDT |
| V_TINSO | HBKID | V_TINSO | BUKRS | T012 | House Banks | BUKRS |
| V_TINSO | HBKID | V_TINSO | HBKID | T012 | House Banks | HBKID |
| V_TINSO | KUNNR | V_TINSO | MANDT | KNA1 | General Data in Customer Master | MANDT |
| V_TINSO | KUNNR | V_TINSO | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| V_TINSO | MANDT | V_TINSO | MANDT | T000 | Clients | MANDT |
| V_TINSO | SPKON | V_TINSO | MANDT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| V_TINSO | SPKON | T001 | KTOPL | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| V_TINSO | SPKON | V_TINSO | SPKON | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| V_TINSO | SPSKZ | V_TINSO | MANDT | T007A | Tax Keys | MANDT |
| V_TINSO | SPSKZ | T005 | KALSM | T007A | Tax Keys | KALSM |
| V_TINSO | SPSKZ | V_TINSO | SPSKZ | T007A | Tax Keys | MWSKZ |
| V_TINSO | WAERS | V_TINSO | MANDT | TCURC | Currency Codes | MANDT |
| V_TINSO | WAERS | V_TINSO | WAERS | TCURC | Currency Codes | WAERS |
