TINV_INV_LINE_A SAP (Payment Advice Line) Table details
Dictionary Type: Table
Description: Payment Advice Line
Description: Payment Advice Line
ABAP Code to SELECT data from TINV_INV_LINE_A
Related tables to TINV_INV_LINE_A
Access table TINV_INV_LINE_A
Related tables to TINV_INV_LINE_A
Access table TINV_INV_LINE_A
Table field list including key, data, relationships and ABAP select examples
TINV_INV_LINE_A is a standard SAP Table which is used to store Payment Advice Line data and is available within R/3 SAP systems depending on the version and release level.
The TINV_INV_LINE_A table consists of various fields, each holding specific information or linking keys about Payment Advice Line data available in SAP. These include INT_INV_DOC_NO (Internal Number of Bill Document/Payment Advice Document), INT_INV_LINE_NO (Line Item Number of Bill/Payment Advice Note Document), BETRW (Gross Amount in Transaction Currency with +/- Sign), BETRW_NET (Net Amount in Transaction Currency with +/- Sign).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TINV_INV_LINE_A table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | INV_INT_INV_DOC_NO | NUMC | 18 | INV_INT_INV_DOC_NO | TINV_INV_DOC | |||
| INT_INV_LINE_NO | Line Item Number of Bill/Payment Advice Note Document | INV_INT_INV_LINE_NO | NUMC | 8 | INV_INT_INV_LINE_NO | ||||
| BETRW | Gross Amount in Transaction Currency with +/- Sign | INV_BETRW_GROSS | CURR | 13(2) | WRTV7 | ||||
| BETRW_NET | Net Amount in Transaction Currency with +/- Sign | INV_BETRW_NET | CURR | 13(2) | WRTV7 | ||||
| BETRW_REQ | Requested Gross Amount in Transaction Currency | INV_REQ_BETRW_GROSS | CURR | 13(2) | WRTV7 | ||||
| BETRW_SKONTO | Cash Discount Amount in Transaction Currency with +/+ Sign | INV_BETRW_SKONTO | CURR | 13(2) | WRTV7 | ||||
| CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| TAXBW | Tax Amount in Transaction Currency | INV_TAXBW | CURR | 13(2) | WRTV7 | ||||
| STPRZ | Tax rate | STRPZ_KK_1 | DEC | 6 | PRZ33_KK | ||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
| DATE_OF_PAYMENT | Due Date | INV_DATE_OF_PAYMENT | DATS | 8 | |||||
| PAYMENTDATE | Payment Date | INV_PAYMENTDATE | DATS | 8 | INV_PAYMENTDATE | ||||
| EXT_LINE_NO | External Document Line Item Number | INV_EXT_LINE_NO | NUMC | 6 | |||||
| DATE_FROM | Start of Period | INV_DATE_FROM | DATS | 8 | |||||
| DATE_TO | End of Period | INV_DATE_TO | DATS | 8 | |||||
| LINE_TYPE | Line Type | INV_LINE_TYPE | NUMC | 4 | TINV_C_LINETYPE | INV_LINE_TYPE | |||
| TRANSF_RELEVANT | Relevant to Transfer | INV_KZ_TRANSF_RELEVANT | CHAR | 1 | INV_KENNZX | ||||
| TRANSF_DONE | Data Transferred | INV_KZ_TRANSF_DONE | CHAR | 1 | INV_KENNZX | ||||
| RSTGR | Reason Code for Payments | RSTGR | CHAR | 3 | TINV_C_ADJ_RSN | RSTGR | |||
| INT_IDENT_TYPE | Type of Internal Identifier | INV_INT_IDENT_TYPE | NUMC | 2 | INV_INT_IDENT_TYPE | ||||
| INT_IDENT | Internal Document Identification | INV_INT_IDENT | CHAR | 50 | INV_INT_IDENT | ||||
| EXT_PARTNER | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
| INT_PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
| EXT_INVOICE_NO | External Document Number | INV_EXT_DOC_NO_ADVICE | CHAR | 40 | TEXT40 | ||||
| OWN_INVOICE_NO | Internal Document Number | INV_OWN_INVOICE_NO | CHAR | 40 | TEXT40 | ||||
| VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | ALPHA | VTREF_KK | VTZ | ||
| CONTRACT | Contract | INV_CONTRACT | CHAR | 10 | ALPHA | INV_CONTRACT | |||
| VKONT_PAY | Contract Account for Payment | INV_VKONT_PAY | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | ||
| BVRKO | Clearing Account for Aggregation/Payment Distribution | INV_BVRKO | CHAR | 10 | Assigned to domain | ALPHA | SAKNR |
| Key field | Non-key field |
How do I retrieve data from SAP table TINV_INV_LINE_A using ABAP code
The following ABAP code Example will allow you to do a basic selection on TINV_INV_LINE_A to SELECT all data from the tableDATA: WA_TINV_INV_LINE_A TYPE TINV_INV_LINE_A.
SELECT SINGLE *
FROM TINV_INV_LINE_A
INTO CORRESPONDING FIELDS OF WA_TINV_INV_LINE_A
WHERE...
How to access SAP table TINV_INV_LINE_A
Within an ECC or HANA version of SAP you can also view further information about TINV_INV_LINE_A and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects