SAP ABAP Table TINV_INV_LINE_A (Payment Advice Line)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-IDE (Application Component) Intercompany Data Exchange
     ⤷ EE_INVOICE_RECEIPT (Package) Bill Receipt Checks

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TINV_INV_LINE_A	Table Relationship Diagram
Short Description	Payment Advice Line

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	INT_INV_DOC_NO	☑	INV_INT_INV_DOC_NO	INV_INT_INV_DOC_NO	NUMC	18	0	Internal Number of Bill Document/Payment Advice Document
3	INT_INV_LINE_NO	☑	INV_INT_INV_LINE_NO	INV_INT_INV_LINE_NO	NUMC	8	0	Line Item Number of Bill/Payment Advice Note Document
4	BETRW	☐	INV_BETRW_GROSS	WRTV7	CURR	13	2	Gross Amount in Transaction Currency with +/- Sign
5	BETRW_NET	☐	INV_BETRW_NET	WRTV7	CURR	13	2	Net Amount in Transaction Currency with +/- Sign
6	BETRW_REQ	☐	INV_REQ_BETRW_GROSS	WRTV7	CURR	13	2	Requested Gross Amount in Transaction Currency
7	BETRW_SKONTO	☐	INV_BETRW_SKONTO	WRTV7	CURR	13	2	Cash Discount Amount in Transaction Currency with +/+ Sign
8	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
9	TAXBW	☐	INV_TAXBW	WRTV7	CURR	13	2	Tax Amount in Transaction Currency
10	STPRZ	☐	STRPZ_KK_1	PRZ33_KK	DEC	6	0	Tax rate
11	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
12	DATE_OF_PAYMENT	☐	INV_DATE_OF_PAYMENT		DATS	8	0	Due Date
13	PAYMENTDATE	☐	INV_PAYMENTDATE		DATS	8	0	Payment Date
14	EXT_LINE_NO	☐	INV_EXT_LINE_NO		NUMC	6	0	External Document Line Item Number
15	DATE_FROM	☐	INV_DATE_FROM		DATS	8	0	Start of Period
16	DATE_TO	☐	INV_DATE_TO		DATS	8	0	End of Period
17	LINE_TYPE	☐	INV_LINE_TYPE	INV_LINE_TYPE	NUMC	4	0	Line Type	TINV_C_LINETYPE
18	TRANSF_RELEVANT	☐	INV_KZ_TRANSF_RELEVANT	INV_KENNZX	CHAR	1	0	Relevant to Transfer
19	TRANSF_DONE	☐	INV_KZ_TRANSF_DONE	INV_KENNZX	CHAR	1	0	Data Transferred
20	RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	TINV_C_ADJ_RSN
21	INT_IDENT_TYPE	☐	INV_INT_IDENT_TYPE	INV_INT_IDENT_TYPE	NUMC	2	0	Type of Internal Identifier
22	INT_IDENT	☐	INV_INT_IDENT	INV_INT_IDENT	CHAR	50	0	Internal Document Identification
23	EXT_PARTNER	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
24	INT_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
25	EXT_INVOICE_NO	☐	INV_EXT_DOC_NO_ADVICE	TEXT40	CHAR	40	0	External Document Number
26	OWN_INVOICE_NO	☐	INV_OWN_INVOICE_NO	TEXT40	CHAR	40	0	Internal Document Number
27	VTREF	☐	VTREF_KK	VTREF_KK	CHAR	20	0	Reference Specifications from Contract
28	.INCLUDE	☐				0	0
29	CONTRACT	☐	INV_CONTRACT	INV_CONTRACT	CHAR	10	0	Contract
30	VKONT_PAY	☐	INV_VKONT_PAY	VKONT_KK	CHAR	12	0	Contract Account for Payment	*
31	BVRKO	☐	INV_BVRKO	SAKNR	CHAR	10	0	Clearing Account for Aggregation/Payment Distribution	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TINV_INV_LINE_A	LINE_TYPE	TINV_C_LINETYPE	LINE_TYPE
2	TINV_INV_LINE_A	RSTGR	TINV_C_ADJ_RSN	RSTGR	KEY	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	471