SAP ABAP Table FDM_COLL_INVOICE_ALV (ALV Output Structure for Collections Management)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FIN-FSCM-COL-AR (Application Component) Accounts Receivable Accounting Process Integration
     ⤷ FDM_AR_COLLECTION (Package) FSCM Collections Management FI-AR

Basic Data

Table Category	INTTAB	Structure
Structure	FDM_COLL_INVOICE_ALV	Table Relationship Diagram
Short Description	ALV Output Structure for Collections Management

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	ITEM_STATE_ICON	☐	FDM_ITEM_STATE_ICON	SYCHAR132	CHAR	132	0	Symbol: Status of Item
2	.INCLUDE	☐				0	0	Data for Invoice Status
3	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
4	COLL_DEBITOR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
5	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
6	INVOICE_NO	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
7	DOC_ITEM	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
8	FISCAL_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
9	BILLING_DOC	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
10	POSTING_DATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
11	INV_DATE	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
12	DUE_DATE	☐	FAEDT_FPOS	DATUM	DATS	8	0	Net Due Date
13	OVERDUE_BY	☐	VERZN	WRTV3	DEC	5	0	Days in Arrears by Net Due Date
14	PAYMENT_DATE	☐	FDM_LAST_PAYMENT_DATE	DATUM	DATS	8	0	Date of Last Incoming Payment for Invoice
15	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
16	INVOICE_AMOUNT	☐	FDM_INVOICE_AMOUNT	WERTV8	CURR	15	2	Original Amount of Invoice or Credit
17	PAID_AMOUNT	☐	BDM_PAID_AMOUNT	WERT8	CURR	15	2	Amount Paid
18	OPEN_AMOUNT	☐	FDM_OPEN_AMOUNT	WERTV8	CURR	15	2	Open Amount
19	CREDITED_AMOUNT	☐	FDM_CREDIT_AMOUNT	WERT7	CURR	13	2	Total of All Credits for Selected Invoice
20	DISPUTED_AMOUNT	☐	FDM_DISPUTED_AMOUNT	WERT7	CURR	13	2	Disputed Amount
21	DUNNING_AMOUNT	☐	FDM_DUNNING_AMOUNT	WERTV8	CURR	15	2	Dunned Amount
22	DUNNING_LEVEL	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
23	DUNNING_DATE	☐	FDM_LAST_DUNNING_DATE	DATUM	DATS	8	0	Date of Last Dunning Notice for Invoice
24	PROMISED_AMOUNT	☐	FDM_CURRENT_P2P_AMOUNT	WERT8	CURR	15	2	Outstanding Amount Promised
25	P2P_LEVEL	☐	BDM_PROMISE_LEVEL	INT1	INT1	3	0	Level of Promise to Pay
26	P2P_STATE	☐	BDM_PROMISE_STATE	BDM_PROMISE_STATE	CHAR	1	0	State of Promise to Pay
27	P2P_DUE_DATE	☐	BDM_PROMISE_DUE_DATE	DATUM	DATS	8	0	Date for Which Payment Is Promised
28	INST_IS_OVERDUE	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
29	PAYMENT_ARRANGED	☐	FDM_PAYMENT_ARRANGED	WERT7	CURR	13	2	Amount Arranged for Payment
30	DISCOUNT_AMOUNT	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
31	.INCLUDE	☐				0	0	Attributes of Invoice (from APAREBPP_ITEM)
32	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
33	.INCLUDE	☐				0	0	Dispute Case for Invoice (from FDM_COLL_DISP_OVERVIEW)
34	EXT_KEY	☐	FDM_EXT_KEY	FDM_EXT_KEY	CHAR	12	0	Case ID
35	STATUS_DESCRIPTION	☐	FDM_STATUS_DESCRIPTION	TEXT30	CHAR	30	0	Status of Dispute Case
36	REASON_CODE_DESCRIPTION	☐	FDM_REASON_CODE_DESCRIPTION	TEXT40	CHAR	40	0	Description of Reason
37	CREATE_TIME	☐	FDM_CREATE_TIME	FDM_TIMESTAMP	DEC	15	0	Time of Creation of Dispute Case
38	NO_OF_RSM	☐	FDM_INV_NO_OF_RSM	INT4	INT4	10	0	Number of Resubmissions
39	NO_OF_NTS	☐	FDM_INV_NO_OF_NTS	INT4	INT4	10	0	Number of Notes
40	SPGL_IND	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
41	COLOR	☐	CHAR04	CHAR4	CHAR	4	0	Data Type 4 Characters
42	STATE_ICON	☐	FDM_PROMISE_STATE_ICON	SYCHAR132	CHAR	132	0	Icon: State of Promise to Pay
43	P2P_STATE_TXT	☐	FDM_PROMISE_STATE_TXT	TEXT60	CHAR	60	0	State of Promise to Pay: Text

History

Last changed by/on	SAP	20130529
SAP Release Created in	2004_1_470