SAP ABAP Table FDM_COLL_INVOICE (Data for Invoice Status)

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	Table Relationship Diagram
Short Description	Data for Invoice Status

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

History

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