SAP ABAP Table FDM_COLL_INVOICE_BW (BI Extract Structure: Invoice)

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_BW	Table Relationship Diagram
Short Description	BI Extract Structure: Invoice

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	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	INVOICE_NO	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
3	FISCAL_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	DOC_ITEM	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
5	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
6	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
7	FISCAL_VAR	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
8	BILLING_DOC	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
9	INVOICE_STATUS	☐	FDM_BW_INVOICE_STATUS	FDM_BW_INVOICE_STATUS	NUMC	1	0	Invoice Status
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	PAYMENT_DATE	☐	FDM_LAST_PAYMENT_DATE	DATUM	DATS	8	0	Date of Last Incoming Payment for Invoice
14	DUNNING_DATE	☐	FDM_LAST_DUNNING_DATE	DATUM	DATS	8	0	Date of Last Dunning Notice 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	DUNNING_AMOUNT	☐	FDM_DUNNING_AMOUNT	WERTV8	CURR	15	2	Dunned Amount
21	PAYMENT_ARRANGED	☐	FDM_PAYMENT_ARRANGED	WERT7	CURR	13	2	Amount Arranged for Payment
22	TIME_STAMP	☐	FDM_BW_TIME_STAMP	FDM_BW_TIME_STAMP	DEC	15	0	Time Stamp for Upload of BI Delta
23	COLL_DEBITOR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*

History

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