SAP ABAP Table INV_DIALOG_SCREEN_TAB_ADVICE (Bill Dialog: Data for Payment Advice Note Data Tabs)

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_TAB_ADVICE	Table Relationship Diagram
Short Description	Bill Dialog: Data for Payment Advice Note Data Tabs

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	ADV_LINE_TYPE	☐	INV_LINE_TYPE	INV_LINE_TYPE	NUMC	4	0	Line Type	TINV_C_LINETYPE
2	ADV_BETRW	☐	INV_BETRW_GROSS	WRTV7	CURR	13	2	Gross Amount in Transaction Currency with +/- Sign
3	ADV_BETRW_NET	☐	INV_BETRW_NET	WRTV7	CURR	13	2	Net Amount in Transaction Currency with +/- Sign
4	ADV_BETRW_REQ	☐	INV_REQ_BETRW_GROSS	WRTV7	CURR	13	2	Requested Gross Amount in Transaction Currency
5	ADV_BETRW_SKONTO	☐	INV_BETRW_SKONTO	WRTV7	CURR	13	2	Cash Discount Amount in Transaction Currency with +/+ Sign
6	ADV_CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
7	ADV_TAXBW	☐	INV_TAXBW	WRTV7	CURR	13	2	Tax Amount in Transaction Currency
8	ADV_STPRZ	☐	STRPZ_KK_1	PRZ33_KK	DEC	6	0	Tax rate
9	ADV_MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
10	ADV_DATE_OF_PAYMENT	☐	INV_DATE_OF_PAYMENT		DATS	8	0	Due Date
11	ADV_PAYMENTDATE	☐	INV_PAYMENTDATE		DATS	8	0	Payment Date
12	ADV_DATE_FROM	☐	INV_DATE_FROM		DATS	8	0	Start of Period
13	ADV_DATE_TO	☐	INV_DATE_TO		DATS	8	0	End of Period
14	ADV_RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	TINV_C_ADJ_RSN
15	ADV_BETRW_SKONTO_GROSS	☐	INV_SKONTO_BETRW_GROSS	WRTV7	CURR	13	2	Bill - Cash Discount Amount in Trans. Crcy with +/- Sign
16	ADV_MC_NAME1	☐	INV_BUPA_NAME1	BU_MCNAME1_GK	CHAR	35	0	Last Name of Business Partner
17	ADV_MC_NAME2	☐	INV_BUPA_NAME2	BU_MCNAME2_GK	CHAR	35	0	Name 2/First Name of Business Partner
18	ADV_MC_STREET	☐	INV_BUPA_STREET	TEXT25	CHAR	25	0	Street of Business Partner
19	ADV_MC_HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
20	ADV_MC_CITY1	☐	INV_BUPA_CITY	TEXT25	CHAR	25	0	Location of Business Partner
21	ADV_MC_POSTCODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
22	ADV_EXT_INVOICE_NO	☐	INV_EXT_DOC_NO_ADVICE	TEXT40	CHAR	40	0	External Document Number
23	ADV_EXT_IDENT_TYPE	☐	INV_EXT_IDENT_TYPE	INV_EXT_IDENT_TYPE	CHAR	2	0	External Identification Type (for Example PoD)
24	ADV_EXT_IDENT	☐	INV_EXT_IDENT	INV_EXT_IDENT	CHAR	50	0	External Identification of Document (e.g. Point of Delivery)
25	ADV_INT_IDENT_TYPE	☐	INV_INT_IDENT_TYPE	INV_INT_IDENT_TYPE	NUMC	2	0	Type of Internal Identifier
26	ADV_INT_IDENT	☐	INV_INT_IDENT	INV_INT_IDENT	CHAR	50	0	Internal Document Identification
27	ADV_OWN_INVOICE_NO	☐	INV_OWN_INVOICE_NO	TEXT40	CHAR	40	0	Internal Document Number
28	ADV_BETRW_CHECK_SUM	☐	INV_BETRW_CHECK_SUM	WRTV7	CURR	13	2	Check Sum of Gross Amount in Transaction Currency with +/-
29	ADV_BETRW_GIVEN_CHECK_SUM	☐	INV_BETRW_GIVEN_CHECK_SUM	WRTV7	CURR	13	2	Preassigned Check Sum f. Gross Amt in Trans. Currency w. +/-
30	ADV_CONTRACT	☐	INV_CONTRACT	INV_CONTRACT	CHAR	10	0	Contract
31	ADV_INT_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	INV_DIALOG_SCREEN_TAB_ADVICE	ADV_CURRENCY	TCURC	WAERS	KEY	1	CN
2	INV_DIALOG_SCREEN_TAB_ADVICE	ADV_LINE_TYPE	TINV_C_LINETYPE	LINE_TYPE	KEY	1	CN
3	INV_DIALOG_SCREEN_TAB_ADVICE	ADV_RSTGR	TINV_C_ADJ_RSN	RSTGR	KEY	C	CN

History

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