SAP Table FDM_COLL_DISP_OVERVIEW
Dispute Cases for Customer
FDM_COLL_DISP_OVERVIEW (Dispute Cases for Customer) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link FDM_COLL_DISP_OVERVIEW to other SAP tables.
FDM_COLL_DISP_OVERVIEW table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
CASE_GUID | FSCM-DM: GUID (Internal Key of Dispute Case) | BDM_CASE_GUID | CHAR | 32 | 0 | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | 0 | |||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | 0 | |||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | 0 | |||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | 0 | |||
EXT_KEY | Case ID | FDM_EXT_KEY | CHAR | 12 | 0 | |||
EXT_REF | External Reference | FDM_EXT_REF | CHAR | 30 | 0 | |||
CASE_TYPE | Case Type | FDM_CASE_TYPE | CHAR | 4 | 0 | |||
PRIORITY | Priority of Dispute Case | FDM_PRIORITY | NUMC | 1 | 0 | |||
CATEGORY | Category | FDM_CATEGORY | CHAR | 4 | 0 | |||
CASE_TITLE | Title of Dispute Case | FDM_CASE_TITLE | CHAR | 80 | 0 | |||
REASON_CODE | Reason for Dispute Case | FDM_REASON_CODE | CHAR | 4 | 0 | |||
PROCESSOR | Processor | FDM_PROCESSOR | CHAR | 12 | 0 | |||
RESPONSIBLE | Person Responsible | FDM_RESPONSIBLE | CHAR | 12 | 0 | |||
FIN_COORDINATOR | Coordinator of Dispute Case | FDM_COORDINATOR | CHAR | 12 | 0 | |||
FIN_DUE_DATE | Process. Deadline | FDM_DUE_DATE | DATS | 8 | 0 | |||
PLAN_END_DATE | Planned Closing Date | FDM_PLAN_END_DATE | DATS | 8 | 0 | |||
FIN_DISPUTE_CURR | Currency of Dispute Case | FDM_DISPUTE_CURR | TCURC | CUKY | 5 | 0 | ||
FIN_CUSTDISP_AMT | Customer-Disputed | FDM_CUSTDISP_AMT | CURR | 15 | 2 | |||
FIN_CUSTDISP_CUR | Currency of Customer-Disputed Amount | FDM_CUSTDISP_CURR | TCURC | CUKY | 5 | 0 | ||
FIN_CONTACT_NAME_LABEL | Text (20 Characters) | TEXT20 | CHAR | 20 | 0 | |||
FIN_CONTACT_NAME | Name of Contact Person at Business Partner | FDM_CONTACT_NAME | CHAR | 40 | 0 | |||
FIN_CONTACT_MAIL | e-mail Address of Contact Person at Business Partner | FDM_CONTACT_EMAIL | CHAR | 128 | 0 | |||
FIN_CONTACT_TEL | Telephone Number of Contact Person at Business Partner | FDM_CONTACT_PHONE | CHAR | 30 | 0 | |||
FIN_CONTACT_FAX | Fax Number of Contact Person at Business Partner | FDM_CONTACT_FAX | CHAR | 30 | 0 | |||
FIN_CONTACT_FAXC | Country of Fax Number of Contact Person | FDM_CONTACT_FAXC | T005 | CHAR | 3 | 0 | ||
FIN_CONTACT_KEY | Number of contact person | PARNR | NUMC | 10 | 0 | |||
FIN_PROMISED_BY | Clerk Who Gave Promise to Pay | FDM_PROMISED_BY | CHAR | 40 | 0 | |||
CREATE_TIME | Time of Creation of Dispute Case | FDM_CREATE_TIME | DEC | 15 | 0 | |||
CHANGE_TIME | Last Changed On | FDM_CHANGE_TIME | DEC | 15 | 0 | |||
STAT_ORDERNO | Status of Dispute Case | FDM_STAT_ORDERNO | NUMC | 2 | 0 | |||
FIN_KUNNR | Customer Number | KUNNR | CHAR | 10 | 0 | |||
FIN_ORIGINAL_AMT | Original Disputed Amount | FDM_ORIGINAL_AMT | CURR | 15 | 2 | |||
FIN_DISPUTED_AMT | Disputed Amount | FDM_DISPUTED_AMOUNT | CURR | 13 | 2 | |||
FIN_PAID_AMT | Amount Paid | BDM_PAID_AMOUNT | CURR | 15 | 2 | |||
FIN_CREDITED_AMT | Amount Credited | FDM_CREDITED_AMOUNT | CURR | 13 | 2 | |||
FIN_WRT_OFF_AMT | Amount Cleared Manually | FDM_WRT_OFF_AMT | CURR | 15 | 2 | |||
FIN_NOT_SOLV_AMT | Amount Written Off Automatically | FDM_NOT_SOLV_AMT | CURR | 15 | 2 | |||
REASON_CODE_DESCRIPTION | Description of Reason | FDM_REASON_CODE_DESCRIPTION | CHAR | 40 | 0 | |||
CASE_TYPE_DESCRIPTION | FSCM-DM: Description of Case Type | FDM_CASE_TYPE_DESCRIPTION | CHAR | 40 | 0 | |||
PRIORITY_DESCRIPTION | Priority of Dispute Case | FDM_PRIORITY_TEXT | CHAR | 40 | 0 | |||
CATEGORY_DESCRIPTION | Description of Category of Dispute Case | FDM_CATEGORY_DESCRIPTION | CHAR | 40 | 0 | |||
STATUS_DESCRIPTION | Status of Dispute Case | FDM_STATUS_DESCRIPTION | CHAR | 30 | 0 | |||
PROCESSOR_NAME | Agent Name | FDM_PROCESSOR_NAME | CHAR | 80 | 0 | |||
RESPONSIBLE_NAME | Name of Person Responsible | FDM_RESPONSIBLE_NAME | CHAR | 80 | 0 | |||
COORDINATOR_NAME | Name of Coordinator | FDM_COORDINATOR_NAME | CHAR | 80 | 0 |
FDM_COLL_DISP_OVERVIEW foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
FDM_COLL_DISP_OVERVIEW | FIN_CONTACT_FAXC | SYST | MANDT | T005 | Countries | MANDT |
FDM_COLL_DISP_OVERVIEW | FIN_CONTACT_FAXC | FDM_COLL_DISP_OVERVIEW | FIN_CONTACT_FAXC | T005 | Countries | LAND1 |
FDM_COLL_DISP_OVERVIEW | FIN_CUSTDISP_CUR | SYST | MANDT | TCURC | Currency Codes | MANDT |
FDM_COLL_DISP_OVERVIEW | FIN_CUSTDISP_CUR | FDM_COLL_DISP_OVERVIEW | FIN_CUSTDISP_CUR | TCURC | Currency Codes | WAERS |
FDM_COLL_DISP_OVERVIEW | FIN_DISPUTE_CURR | SYST | MANDT | TCURC | Currency Codes | MANDT |
FDM_COLL_DISP_OVERVIEW | FIN_DISPUTE_CURR | FDM_COLL_DISP_OVERVIEW | FIN_DISPUTE_CURR | TCURC | Currency Codes | WAERS |