SAP ABAP Table INV_DIALOG_ALV_TAB_ADVICE (Bill Dialog: Data of ALV with Payment Advice Note 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_ALV_TAB_ADVICE	Table Relationship Diagram
Short Description	Bill Dialog: Data of ALV with Payment Advice Note 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	LINE_TYPE_DESC	☐	INV_LINE_TYPE_DESC	TEXT47	CHAR	47	0	Description of Line Type
2	LINE_TYPE	☐	INV_LINE_TYPE	INV_LINE_TYPE	NUMC	4	0	Line Type	TINV_C_LINETYPE
3	STATUS	☐	INV_ADV_LINE_STATUS	SYCHAR132	CHAR	132	0	Payment Advice Line Status
4	EXT_INVOICE_NO	☐	INV_EXT_DOC_NO_ADVICE	TEXT40	CHAR	40	0	External Document Number
5	OWN_INVOICE_NO	☐	INV_OWN_INVOICE_NO	TEXT40	CHAR	40	0	Internal Document Number
6	BETRW	☐	INV_BETRW_GROSS	WRTV7	CURR	13	2	Gross Amount in Transaction Currency with +/- Sign
7	BETRW_NET	☐	INV_BETRW_NET	WRTV7	CURR	13	2	Net Amount in Transaction Currency with +/- Sign
8	BETRW_REQ	☐	INV_REQ_BETRW_GROSS	WRTV7	CURR	13	2	Requested Gross Amount in Transaction Currency
9	BETRW_SKONTO	☐	INV_BETRW_SKONTO	WRTV7	CURR	13	2	Cash Discount Amount in Transaction Currency with +/+ Sign
10	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
11	TAXBW	☐	INV_TAXBW	WRTV7	CURR	13	2	Tax Amount in Transaction Currency
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	RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	TINV_C_ADJ_RSN
18	EXT_PARTNER	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
19	INT_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
20	MC_NAME1	☐	INV_BUPA_NAME1	BU_MCNAME1_GK	CHAR	35	0	Last Name of Business Partner
21	MC_NAME2	☐	INV_BUPA_NAME2	BU_MCNAME2_GK	CHAR	35	0	Name 2/First Name of Business Partner
22	MC_STREET	☐	INV_BUPA_STREET	TEXT25	CHAR	25	0	Street of Business Partner
23	MC_HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
24	MC_CITY1	☐	INV_BUPA_CITY	TEXT25	CHAR	25	0	Location of Business Partner
25	MC_POSTCODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
26	INT_IDENT_TYPE	☐	INV_INT_IDENT_TYPE	INV_INT_IDENT_TYPE	NUMC	2	0	Type of Internal Identifier
27	INT_IDENT	☐	INV_INT_IDENT	INV_INT_IDENT	CHAR	50	0	Internal Document Identification
28	EXT_IDENT_TYPE	☐	INV_EXT_IDENT_TYPE	INV_EXT_IDENT_TYPE	CHAR	2	0	External Identification Type (for Example PoD)
29	EXT_IDENT	☐	INV_EXT_IDENT	INV_EXT_IDENT	CHAR	50	0	External Identification of Document (e.g. Point of Delivery)
30	CONTRACT	☐	INV_CONTRACT	INV_CONTRACT	CHAR	10	0	Contract
31	DISPLAY_LINE_NO	☐			INT4	10	0
32	DROPDOWN	☐	INT4	INT4	INT4	10	0	Natural number

Foreign Keys

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

History

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