1. Home
  2. Resources
  3. SAP Tables
  4. UDM_WL_ITEM - Worklist Item

SAP Table UDM_WL_ITEM

Worklist Item

UDM_WL_ITEM (Worklist Item) 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 UDM_WL_ITEM to other SAP tables.

UDM_WL_ITEM table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
WORKITEM_ID Key of Worklist Item UDM_WORKLIST_ITEM_GUID RAW 16 0
COLL_SPECIALIST Collection Specialist BDM_COLL_SPECIALIST CHAR 12 0
COLL_GROUP Collection Group UDM_COLL_GROUP CHAR 10 0
COLL_SEGMENT Collection Segment UDM_COLL_SEGMENT CHAR 10 0
WL_ITEM_DATE Date of Worklist Item UDM_WORKLIST_ITEM_DATE DATS 8 0
RUN_ID Run ID UDM_COLL_RUN_ID CHAR 12 0
STATUS Indicator: Worklist Item Is Completed UDM_WORKLIST_ITEM_STATUS CHAR 1 0
NULL Open
X Completed
STRATEGY Collection Strategy UDM_COLL_STRATEGY CHAR 10 0
STRATEGY_VERSION Version of Collection Strategy UDM_STRATEGY_VERSION NUMC 8 0
VALUATION Valuation UDM_COLL_VALUATION INT4 10 0
PERCENTAGE Percentage Valuation UDM_VALUATION_BY_PERCENTAGE NUMC 4 0
MAX_SEQUENCE_ID Sequential Number of Strategy UDM_SEQUENCE_ID INT4 10 0
PARTNER_ID Business Partner Number BU_PARTNER CHAR 10 0
PARTNER_DESC Short name of business partner BU_DESCRIP CHAR 50 0
PARTNER_ACCNO Key of Customer in Accounts Receivable Accounting UDM_KUNNR CHAR 10 0
PARTNER_AUGRP Authorization Group BU_AUGRP CHAR 4 0
CONTACT_NAME Description of Main Contact Person UDM_LAST_CONTACT_DESC CHAR 50 0
CONTACT_PHONE Telephone Number of Contact Person at Business Partner UDM_COLL_CONTACT_PHONE CHAR 30 0
CCT_RESULT Result of Customer Contact UDM_CCT_RESULT_ID CHAR 3 0
LAST_CCT_TIME Last Customer Contact UDM_LAST_CCT_TIME DEC 15 0
CALLTIMEFROM Start of Call Time UDM_CALLTIMEFROM DEC 15 0
CALLTIMETO End of Call Time UDM_CALLTIMETO DEC 15 0
VISITINGTIMEFROM Start of Visit Time UDM_VISITINGTIMEFROM DEC 15 0
VISITINGTIMETO End of Visit Time UDM_VISITINGTIMETO DEC 15 0
TOTAL_AMT Outstanding Amounts of Business Partner in Segment UDM_AMOUNT_TOTAL CURR 15 2
DEBIT_AMT Total of All Receivables of Business Partner in Segment UDM_AMOUNT_DEBIT CURR 15 2
CREDIT_AMT Total of All Credits of Business Partner in Segment UDM_AMOUNT_CREDIT CURR 15 2
AMT_COLLECTED Amount to Be Collected UDM_AMOUNT_TO_BE_COLLECTED CURR 15 2
DUE_AMT Total of All Items Due for Key Date or in Future UDM_AMOUNT_DUE CURR 15 2
OVERDUE_AMT Total of All Overdue Items UDM_AMOUNT_OVERDUE CURR 15 2
PROMISED_AMT Outstanding Amount Promised UDM_AMOUNT_TOTAL_PROMISED CURR 15 2
DISPUTED_AMT Total of All Items Included in Dispute Cases UDM_AMOUNT_DISPUTED CURR 15 2
DUNNED_AMT Amount Dunned UDM_AMOUNT_TOTAL_DUNNED CURR 15 2
ARRANGED_AMT Amount Arranged UDM_AMOUNT_ARRANGED CURR 15 2
BROKEN_AMT Amount Promised but Not Paid UDM_AMOUNT_BROKEN CURR 15 2
CURRENCY Strategy Currency UDM_COLL_STRATEGY_CURRENCY CUKY 5 0
DUE_AMT_INT1 Total Amount in Interval UDM_AMOUNT_INTERVAL CURR 15 2
DUE_AMT_INT2 Total Amount in Interval UDM_AMOUNT_INTERVAL CURR 15 2
DUE_AMT_INT3 Total Amount in Interval UDM_AMOUNT_INTERVAL CURR 15 2
DUE_AMT_INT4 Total Amount in Interval UDM_AMOUNT_INTERVAL CURR 15 2
DUE_AMT_INT5 Total Amount in Interval UDM_AMOUNT_INTERVAL CURR 15 2
OVERDUE_AMT_INT1 Total Amount in Interval UDM_AMOUNT_INTERVAL CURR 15 2
OVERDUE_AMT_INT2 Total Amount in Interval UDM_AMOUNT_INTERVAL CURR 15 2
OVERDUE_AMT_INT3 Total Amount in Interval UDM_AMOUNT_INTERVAL CURR 15 2
OVERDUE_AMT_INT4 Total Amount in Interval UDM_AMOUNT_INTERVAL CURR 15 2
OVERDUE_AMT_INT5 Total Amount in Interval UDM_AMOUNT_INTERVAL CURR 15 2
LAST_PAY_DATE Date of Last Payment BDM_LAST_PAYMENT_DATE DATS 8 0
RSM_DATE Resubmission Date BDM_RSM_DATE DATS 8 0
RSM_TIME Resubmission Time BDM_RSM_TIME DEC 15 0
RSM_REASON Reason for Resubmission UDM_RSM_REASON_ID CHAR 4 0
MAX_DUNNLEVEL Highest Dunning Level UDM_MAX_DUNN_LEVEL NUMC 1 0
1
LAST_DUNNDATE Date of Last Dunning Notice BDM_LAST_DUNN_DATE DATS 8 0
CREDIT_SGMNT Credit Segment UKM_CREDIT_SGMNT CHAR 10 0
CREDIT_LIMIT Credit Limit UKM_CREDIT_LIMIT CURR 15 2
CREDIT_RATING Score UKM_OWN_RATING CHAR 10 0
CREDIT_EXPOSURE Credit Limit Utilization in Percent UDM_CREDLIMIT_USED DEC 9 1
CREDIT_RISK_CLS Risk Class UDM_RISK_CLASS CHAR 3 0
GRADE External Valuation UDM_GRADE CHAR 10 0
GRADE_METHOD External Valuation Procedure UDM_GRADE_METHOD CHAR 10 0
GRADE_VALID_TO External Valuation Valid To UDM_GRADE_VALID_TO DATS 8 0
CREATED_BY Created By SCMG_CREATE_USER CHAR 12 0
CREATE_TIME Created On SCMG_CREATE_TIME DEC 15 0
CHANGED_BY Last Changed by SCMG_CHANGE_USER CHAR 12 0
CHANGE_TIME Last Changed On SCMG_CHANGE_TIME DEC 15 0
HEAD_OFFICE Head Office on the Worklist UDM_WL_HEAD_OFFICE CHAR 10 0
XAMBIG_HO Worklist Entry: Other Head Offices Exist UDM_XAMBIG_HO CHAR 1 0
X Yes
NULL No
GLOBAL_EVAL Global Valuation UDM_GLOBAL_EVAL CHAR 1 0
X Yes
NULL No