SAP ABAP Table TINV_INV_DOC (Billing Doc. Data)

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_DOC	Table Relationship Diagram
Short Description	Billing Doc. Data

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_NO	☐	INV_INT_INV_NO	INV_INT_INV_NO	NUMC	18	0	Internal Bill/Payment Advice Number
4	DOC_NR	☐	INV_DOC_NR		INT4	10	0	Consecutive Number of Document for a Document Header
5	EXT_PARTNER	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
6	INT_IDENT_TYPE	☐	INV_INT_IDENT_TYPE	INV_INT_IDENT_TYPE	NUMC	2	0	Type of Internal Identifier
7	INT_IDENT	☐	INV_INT_IDENT	INV_INT_IDENT	CHAR	50	0	Internal Document Identification
8	INT_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
9	INVOICE_DATE	☐	INV_INVOICE_DATE		DATS	8	0	Bill/Payment Advice Note Date
10	INVPERIOD_START	☐	INV_PERIOD_START		DATS	8	0	Start of Validity Period for Bill/PAN
11	INVPERIOD_END	☐	INV_PERIOD_END		DATS	8	0	End fo Validity Period for Bill/PAN
12	EXT_INVOICE_NO	☐	INV_EXT_INVOICE_NO	TEXT40	CHAR	40	0	External Bill/Payment Advice Note Number
13	DOC_TYPE	☐	INV_DOC_TYPE		NUMC	3	0	Document Type	TINV_C_DOCTYPE
14	DATE_OF_PAYMENT	☐	INV_DATE_OF_PAYMENT		DATS	8	0	Due Date
15	PAYMENTDATE	☐	INV_PAYMENTDATE		DATS	8	0	Payment Date
16	VTREF	☐	VTREF_KK	VTREF_KK	CHAR	20	0	Reference Specifications from Contract
17	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
18	INV_DOC_STATUS	☐	INV_DOC_STATUS	INV_DOC_STATUS	NUMC	2	0	Document Status
19	INT_INV_BKID	☐	INV_INT_INV_BKID	SYSUUID_22	CHAR	22	0	Internal Bank Details Key
20	INV_BVT	☐	INV_BVT		CHAR	4	0	Bank Details ID for Sender
21	INT_INV_BKID_R	☐	INV_INT_INV_BKID	SYSUUID_22	CHAR	22	0	Internal Bank Details Key
22	INV_BVT_R	☐	INV_BVT_R		CHAR	4	0	Bank Details ID for Recipient
23	INV_CANCEL_RSN	☐	INV_CANCEL_RSN	INV_CANCEL_RSN	CHAR	2	0	Reversal Reason	*
24	INV_CANCEL_DOC	☐	INV_INT_INV_CANCEL_DOC_NO	INV_INT_INV_DOC_NO	NUMC	18	0	Number of Document Reversed by Current Document
25	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
26	CREATED_ON	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
27	CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
28	CHANGED_ON	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
29	INVOICE_TYPE	☐	INV_INVOICE_TYPE	INV_INVOICE_TYPE	NUMC	3	0	Type of Bill / Type of Payment Advice Note	*
30	RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	TINV_C_ADJ_RSN
31	.INCLUDE	☐				0	0
32	INV_BULK_REF	☐	INV_BULK_REF	TEXT22	CHAR	22	0	Data Exchange Group Reference Number
33	EXT_INV_NO_ORIG	☐	INV_EXT_INVOICE_NO_ORIG	TEXT40	CHAR	40	0	Original External Bill/PAN Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TINV_INV_DOC	DOC_TYPE	TINV_C_DOCTYPE	DOC_TYPE	KEY	C	CN
2	TINV_INV_DOC	RSTGR	TINV_C_ADJ_RSN	RSTGR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in