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
⤷ 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 |