1. Home
  2. Resources
  3. SAP Tables
  4. TINV_INV_LINE_A - Payment Advice Line

SAP Table TINV_INV_LINE_A

Payment Advice Line

TINV_INV_LINE_A (Payment Advice Line) 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 TINV_INV_LINE_A to other SAP tables.

TINV_INV_LINE_A table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
INT_INV_DOC_NO Internal Number of Bill Document/Payment Advice Document INV_INT_INV_DOC_NO NUMC 18 0
INT_INV_LINE_NO Line Item Number of Bill/Payment Advice Note Document INV_INT_INV_LINE_NO NUMC 8 0
BETRW Gross Amount in Transaction Currency with +/- Sign INV_BETRW_GROSS CURR 13 2
BETRW_NET Net Amount in Transaction Currency with +/- Sign INV_BETRW_NET CURR 13 2
BETRW_REQ Requested Gross Amount in Transaction Currency INV_REQ_BETRW_GROSS CURR 13 2
BETRW_SKONTO Cash Discount Amount in Transaction Currency with +/+ Sign INV_BETRW_SKONTO CURR 13 2
CURRENCY Currency Key WAERS CUKY 5 0
TAXBW Tax Amount in Transaction Currency INV_TAXBW CURR 13 2
STPRZ Tax rate STRPZ_KK_1 DEC 6 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
DATE_OF_PAYMENT Due Date INV_DATE_OF_PAYMENT DATS 8 0
PAYMENTDATE Payment Date INV_PAYMENTDATE DATS 8 0
EXT_LINE_NO External Document Line Item Number INV_EXT_LINE_NO NUMC 6 0
DATE_FROM Start of Period INV_DATE_FROM DATS 8 0
DATE_TO End of Period INV_DATE_TO DATS 8 0
LINE_TYPE Line Type INV_LINE_TYPE TINV_C_LINETYPE NUMC 4 0
TRANSF_RELEVANT Relevant to Transfer INV_KZ_TRANSF_RELEVANT CHAR 1 0
NULL Inactive
X Active
TRANSF_DONE Data Transferred INV_KZ_TRANSF_DONE CHAR 1 0
NULL Inactive
X Active
RSTGR Reason Code for Payments RSTGR TINV_C_ADJ_RSN CHAR 3 0
INT_IDENT_TYPE Type of Internal Identifier INV_INT_IDENT_TYPE NUMC 2 0
01 Point of Delivery
INT_IDENT Internal Document Identification INV_INT_IDENT CHAR 50 0
EXT_PARTNER Business Partner Number in External System BU_BPEXT CHAR 20 0
INT_PARTNER Business Partner Number BU_PARTNER CHAR 10 0
EXT_INVOICE_NO External Document Number INV_EXT_DOC_NO_ADVICE CHAR 40 0
OWN_INVOICE_NO Internal Document Number INV_OWN_INVOICE_NO CHAR 40 0
VTREF Reference Specifications from Contract VTREF_KK CHAR 20 0
CONTRACT Contract INV_CONTRACT CHAR 10 0
VKONT_PAY Contract Account for Payment INV_VKONT_PAY CHAR 12 0
BVRKO Clearing Account for Aggregation/Payment Distribution INV_BVRKO CHAR 10 0

TINV_INV_LINE_A foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TINV_INV_LINE_A LINE_TYPE TINV_INV_LINE_A MANDT TINV_C_LINETYPE Customizing: Definition of Permitted Bill Line Items MANDT
TINV_INV_LINE_A LINE_TYPE TINV_INV_LINE_A LINE_TYPE TINV_C_LINETYPE Customizing: Definition of Permitted Bill Line Items LINE_TYPE
TINV_INV_LINE_A RSTGR TINV_INV_LINE_A MANDT TINV_C_ADJ_RSN Modification Reasons MANDT
TINV_INV_LINE_A RSTGR TINV_INV_LINE_A RSTGR TINV_C_ADJ_RSN Modification Reasons RSTGR