SAP ABAP Table INV_DIALOG_SCREEN (Bill Dialog: Screen Data)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	INV_DIALOG_SCREEN	Table Relationship Diagram
Short Description	Bill Dialog: Screen Data

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Bill Dialog: Screen Data Bill Header
2	INVOICE_TYPE	☐	INV_INVOICE_TYPE	INV_INVOICE_TYPE	NUMC	3	0	Type of Bill / Type of Payment Advice Note	TINV_C_INVTYPE
3	DOC_TYPE	☐	INV_DOC_TYPE		NUMC	3	0	Document Type	TINV_C_DOCTYPE
4	DATE_OF_RECEIPT	☐	INV_DATE_OF_RECEIPT		DATS	8	0	Document Date of Receipt
5	EXT_SENDER	☐	INV_EXT_SENDER	TEXT40	CHAR	40	0	External Description of Bill/PAN Sender
6	EXT_RECEIVER	☐	INV_EXT_RECEIVER	TEXT40	CHAR	40	0	External Description of Bill/PAN Recipient
7	INVOICE_STATUS	☐	INV_INVOICE_STATUS	INV_INVOICE_STATUS	NUMC	2	0	Bill/Payment Advice Note Status
8	AUTH_GRP	☐	AUTHGR	BRGRU	CHAR	4	0	Authorization group	*
9	BANK_TXT	☐	INV_BANK_TXT		CHAR	40	0	Bank Data
10	BANK_TXT_RECV	☐	INV_BANK_TXT_RECV		CHAR	40	0	Bank Data: Recipient
11	SENDER	☐	INV_SENDER_SERV_PROV	SERVICE_PROV	CHAR	10	0	Sender	ESERVPROV
12	RECEIVER	☐	INV_RECEIV_SERV_PROV	SERVICE_PROV	CHAR	10	0	Recipient	ESERVPROV
13	SENDER_TXT	☐	SERVICE_PROV_TEXT	TEXT40	CHAR	40	0	Name of service provider
14	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
15	MC_NAME1	☐	INV_BUPA_NAME1	BU_MCNAME1_GK	CHAR	35	0	Last Name of Business Partner
16	MC_NAME2	☐	INV_BUPA_NAME2	BU_MCNAME2_GK	CHAR	35	0	Name 2/First Name of Business Partner
17	MC_STREET	☐	INV_BUPA_STREET	TEXT25	CHAR	25	0	Street of Business Partner
18	MC_HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
19	MC_CITY1	☐	INV_BUPA_CITY	TEXT25	CHAR	25	0	Location of Business Partner
20	MC_POSTCODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
21	FRAME_HEAD_TEXT	☐			CHAR	80	0
22	COMP_CODE_RECV	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
23	EXT_IDENT	☐	INV_EXT_IDENT	INV_EXT_IDENT	CHAR	50	0	External Identification of Document (e.g. Point of Delivery)
24	INT_IDENT_TYPE	☐	INV_INT_IDENT_TYPE	INV_INT_IDENT_TYPE	NUMC	2	0	Type of Internal Identifier
25	INT_IDENT	☐	INV_INT_IDENT	INV_INT_IDENT	CHAR	50	0	Internal Document Identification
26	IDENT_STATUS	☐			CHAR	55	0
27	.INCLUDE	☐				0	0	Bill Dialog: Screen Data Document Header
28	DOC_STATUS	☐	INV_DOC_STATUS	INV_DOC_STATUS	NUMC	2	0	Document Status
29	INVOICE_DATE	☐	INV_INVOICE_DATE		DATS	8	0	Bill/Payment Advice Note Date
30	INVPERIOD_START	☐	INV_PERIOD_START		DATS	8	0	Start of Validity Period for Bill/PAN
31	INVPERIOD_END	☐	INV_PERIOD_END		DATS	8	0	End fo Validity Period for Bill/PAN
32	EXT_INVOICE_NO	☐	INV_EXT_INVOICE_NO	TEXT40	CHAR	40	0	External Bill/Payment Advice Note Number
33	EXT_INV_NO_ORIG	☐	INV_EXT_INVOICE_NO_ORIG	TEXT40	CHAR	40	0	Original External Bill/PAN Number
34	DATE_OF_PAYMENT	☐	INV_DATE_OF_PAYMENT		DATS	8	0	Due Date
35	EXT_PARTNER	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
36	INT_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
37	INV_BULK_REF	☐	INV_BULK_REF	TEXT22	CHAR	22	0	Data Exchange Group Reference Number
38	.INCLUDE	☐				0	0	Bill Dialog: Data of Tab with Main Data
39	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
40	STRPZ	☐	INV_TAX_PERCENT_RATE	PRZ33_KK	DEC	6	0	Tax Percentage
41	BILL_BETRW_NET	☐	INV_SUM_BETRW_NET	WRTV7	CURR	13	2	Total Net Amount in Transaction Currency with +/- Sign
42	PAYED_BETRW_NET	☐	INV_PAYED_BETRW_NET	WRTV7	CURR	13	2	Total BB Amts - Net Amts in Trans. Currency with +/- Sign
43	TOPAY_BETRW_NET	☐	INV_TOPAY_BETRW_NET	WRTV7	CURR	13	2	Bill Total - Net Amt in Transaction Currency with +/- Sign
44	TAX_BILL_BETRW	☐	INV_TAXBW	WRTV7	CURR	13	2	Tax Amount in Transaction Currency
45	TAX_PAYED_BETRW	☐	INV_TAXBW	WRTV7	CURR	13	2	Tax Amount in Transaction Currency
46	TAX_TOPAY_BETRW	☐	INV_TAXBW	WRTV7	CURR	13	2	Tax Amount in Transaction Currency
47	BILL_BETRW_GROSS	☐	INV_SUM_BETRW_GROSS	WRTV7	CURR	13	2	Total Gross Amount in Transaction Currency with +/- Sign
48	PAYED_BETRW_GROSS	☐	INV_PAYED_BETRW_GROSS	WRTV7	CURR	13	2	Total BB Amts - Gross Amts in Trans. Currency with +/- Sign
49	TOPAY_BETRW_GROSS	☐	INV_TOPAY_BETRW_GROSS	WRTV7	CURR	13	2	Bill Total - Gross Amt in Transaction Currency with +/- Sign
50	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
51	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	*
52	.INCLUDE	☐				0	0	Bill Dialog: Screen Data Bank Details
53	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
54	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
55	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
56	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
57	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
58	KOINH	☐	BU_KOINH	BU_KOINH	CHAR	60	0	Account Holder Name
59	BKEXT	☐	BU_BKEXT	CHAR20	CHAR	20	0	Bank details ID in external system
60	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
61	BANKS_RECV	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
62	BANKL_RECV	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
63	BANKN_RECV	☐	BANKN	BANKN	CHAR	18	0	Bank account number
64	BKONT_RECV	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
65	BKREF_RECV	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
66	KOINH_RECV	☐	BU_KOINH	BU_KOINH	CHAR	60	0	Account Holder Name
67	BKEXT_RECV	☐	BU_BKEXT	CHAR20	CHAR	20	0	Bank details ID in external system
68	IBAN_RECV	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
69	.INCLUDE	☐				0	0	Bill Dialog: Data for Payment Advice Note Data Tabs
70	ADV_LINE_TYPE	☐	INV_LINE_TYPE	INV_LINE_TYPE	NUMC	4	0	Line Type	TINV_C_LINETYPE
71	ADV_BETRW	☐	INV_BETRW_GROSS	WRTV7	CURR	13	2	Gross Amount in Transaction Currency with +/- Sign
72	ADV_BETRW_NET	☐	INV_BETRW_NET	WRTV7	CURR	13	2	Net Amount in Transaction Currency with +/- Sign
73	ADV_BETRW_REQ	☐	INV_REQ_BETRW_GROSS	WRTV7	CURR	13	2	Requested Gross Amount in Transaction Currency
74	ADV_BETRW_SKONTO	☐	INV_BETRW_SKONTO	WRTV7	CURR	13	2	Cash Discount Amount in Transaction Currency with +/+ Sign
75	ADV_CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
76	ADV_TAXBW	☐	INV_TAXBW	WRTV7	CURR	13	2	Tax Amount in Transaction Currency
77	ADV_STPRZ	☐	STRPZ_KK_1	PRZ33_KK	DEC	6	0	Tax rate
78	ADV_MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
79	ADV_DATE_OF_PAYMENT	☐	INV_DATE_OF_PAYMENT		DATS	8	0	Due Date
80	ADV_PAYMENTDATE	☐	INV_PAYMENTDATE		DATS	8	0	Payment Date
81	ADV_DATE_FROM	☐	INV_DATE_FROM		DATS	8	0	Start of Period
82	ADV_DATE_TO	☐	INV_DATE_TO		DATS	8	0	End of Period
83	ADV_RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	TINV_C_ADJ_RSN
84	ADV_BETRW_SKONTO_GROSS	☐	INV_SKONTO_BETRW_GROSS	WRTV7	CURR	13	2	Bill - Cash Discount Amount in Trans. Crcy with +/- Sign
85	ADV_MC_NAME1	☐	INV_BUPA_NAME1	BU_MCNAME1_GK	CHAR	35	0	Last Name of Business Partner
86	ADV_MC_NAME2	☐	INV_BUPA_NAME2	BU_MCNAME2_GK	CHAR	35	0	Name 2/First Name of Business Partner
87	ADV_MC_STREET	☐	INV_BUPA_STREET	TEXT25	CHAR	25	0	Street of Business Partner
88	ADV_MC_HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
89	ADV_MC_CITY1	☐	INV_BUPA_CITY	TEXT25	CHAR	25	0	Location of Business Partner
90	ADV_MC_POSTCODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
91	ADV_EXT_INVOICE_NO	☐	INV_EXT_DOC_NO_ADVICE	TEXT40	CHAR	40	0	External Document Number
92	ADV_EXT_IDENT_TYPE	☐	INV_EXT_IDENT_TYPE	INV_EXT_IDENT_TYPE	CHAR	2	0	External Identification Type (for Example PoD)
93	ADV_EXT_IDENT	☐	INV_EXT_IDENT	INV_EXT_IDENT	CHAR	50	0	External Identification of Document (e.g. Point of Delivery)
94	ADV_INT_IDENT_TYPE	☐	INV_INT_IDENT_TYPE	INV_INT_IDENT_TYPE	NUMC	2	0	Type of Internal Identifier
95	ADV_INT_IDENT	☐	INV_INT_IDENT	INV_INT_IDENT	CHAR	50	0	Internal Document Identification
96	ADV_OWN_INVOICE_NO	☐	INV_OWN_INVOICE_NO	TEXT40	CHAR	40	0	Internal Document Number
97	ADV_BETRW_CHECK_SUM	☐	INV_BETRW_CHECK_SUM	WRTV7	CURR	13	2	Check Sum of Gross Amount in Transaction Currency with +/-
98	ADV_BETRW_GIVEN_CHECK_SUM	☐	INV_BETRW_GIVEN_CHECK_SUM	WRTV7	CURR	13	2	Preassigned Check Sum f. Gross Amt in Trans. Currency w. +/-
99	ADV_CONTRACT	☐	INV_CONTRACT	INV_CONTRACT	CHAR	10	0	Contract
100	ADV_INT_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
101	.INCLUDE	☐				0	0	Bill Dialog: Changes - Header/Document
102	HD_CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
103	HD_CREATED_ON	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
104	HD_CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
105	HD_CHANGED_ON	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
106	DOC_CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
107	DOC_CREATED_ON	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
108	DOC_CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
109	DOC_CHANGED_ON	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
110	.INCLUDE	☐				0	0	Bill Dialog: Screen Data Complaint Data
111	ADJ_RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	TINV_C_ADJ_RSN
112	ADJ_TEXT	☐	INV_DESCRIPTION	TEXT40	CHAR	40	0	General Description
113	ADJ_FREQU	☐	ADJ_FREQU		INT1	3	0	Frequency of Occurance of Reason Code During Bill Processing
114	.INCLUDE	☐				0	0	Bill Dialog: Screen Data Reversal Data
115	REVERSAL_RSN	☐	INV_CANCEL_RSN	INV_CANCEL_RSN	CHAR	2	0	Reversal Reason	*
116	REVERSAL_RSN_TXT	☐	INV_DESCRIPTION	TEXT40	CHAR	40	0	General Description
117	.INCLUDE	☐				0	0	Bill Dialog: Screen Data Template
118	TEMPLATE	☐	INV_TEMPLATE_NO	INV_TEMPLATE_NO	NUMC	18	0	Template Number for Incoming Bill/Pay.Advice Note Processing
119	INT_INV_NO	☐	INV_INT_INV_NO	INV_INT_INV_NO	NUMC	18	0	Internal Bill/Payment Advice Number
120	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
121	OWNER	☐	INV_OWNER	UNAME	CHAR	12	0	Template Owner
122	PRIVATE_TMPLT	☐	INV_KENNZX	INV_KENNZX	CHAR	1	0	General Indicator 'X' or ' '
123	CR_DATE	☐	ANDAT	DATUM	DATS	8	0	Date Record Created on
124	CR_USER	☐	ANNAM	USNAM	CHAR	12	0	User Who Created Record
125	CH_DATE	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
126	CH_USER	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
127	SPRAS	☐	SYLANGU	SYLANGU	LANG	1	0	Language Key
128	DESCRIPTION	☐	INV_TEMPLATE_DESCRIPT	TEXT40	CHAR	40	0	Template Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	INV_DIALOG_SCREEN	ADJ_RSTGR	TINV_C_ADJ_RSN	RSTGR	KEY	C	CN
2	INV_DIALOG_SCREEN	ADV_CURRENCY	TCURC	WAERS	KEY	1	CN
3	INV_DIALOG_SCREEN	ADV_LINE_TYPE	TINV_C_LINETYPE	LINE_TYPE	KEY	1	CN
4	INV_DIALOG_SCREEN	ADV_MWSKZ	T007A	MWSKZ	KEY	1	CN
5	INV_DIALOG_SCREEN	ADV_RSTGR	TINV_C_ADJ_RSN	RSTGR	KEY	C	CN
6	INV_DIALOG_SCREEN	BANKS	T005	LAND1	REF	1	CN
7	INV_DIALOG_SCREEN	CURRENCY	TCURC	WAERS	KEY	1	CN
8	INV_DIALOG_SCREEN	DOC_TYPE	TINV_C_DOCTYPE	DOC_TYPE	KEY	1	CN
9	INV_DIALOG_SCREEN	INVOICE_TYPE	TINV_C_INVTYPE	INVOICE_TYPE
10	INV_DIALOG_SCREEN	MWSKZ	T007A	MWSKZ	KEY	1	CN
11	INV_DIALOG_SCREEN	RECEIVER	ESERVPROV	SERVICEID	KEY	1	CN
12	INV_DIALOG_SCREEN	SENDER	ESERVPROV	SERVICEID	KEY	1	CN

History

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