UKM_CR_KPI SAP (Values for Key Figures for Credit Managment) Structure details
Description: Values for Key Figures for Credit Managment
Structure field list including key, data, relationships and ABAP select examples
UKM_CR_KPI is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Values for Key Figures for Credit Managment" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_UKM_CR_KPI TYPE UKM_CR_KPI.
The UKM_CR_KPI table consists of various fields, each holding specific information or linking keys about Values for Key Figures for Credit Managment data available in SAP. These include DUNX01 (Start Date of Time Span of Key Figure), DUNX02 (End Date of Time Span of Key Figure), DUNX03 (Number of Dunning Notices), DUNX04 (Dunning Level of Last Dunning Notice).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP UKM_CR_KPI structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
DUNX01 | Start Date of Time Span of Key Figure | UKM_KPI_TF_DATEFR | DATS | 8 | DATUM | ||||
DUNX02 | End Date of Time Span of Key Figure | UKM_KPI_TF_DATETO | DATS | 8 | DATUM | ||||
DUNX03 | Number of Dunning Notices | UKM_KPI_DUN_NR | NUMC | 6 | NUMC6 | ||||
DUNX04 | Dunning Level of Last Dunning Notice | UKM_KPI_DUN_LEVEL | NUMC | 2 | NUMC2 | ||||
DUNX05 | Dunning Level Category of Last Dunning Notice | UKM_KPI_DUN_CAT | CHAR | 4 | CHAR4 | ||||
DUNX06 | Dunning Procedure of Last Dunning Notice | UKM_KPI_DUN_PROC | CHAR | 4 | CHAR4 | ||||
DUNX07 | Dunning Date of Last Dunning Notice | UKM_KPI_DUN_DATE | DATS | 8 | DATUM | ||||
DUNX08 | Dunning Amount of Last Dunning Notice | UKM_KPI_DUN_AMOUNT | CURR | 13(2) | WRTV7 | ||||
DUNX09 | Currency of Last Dunning Notice | UKM_KPI_DUN_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
COLX01 | Start Date of Time Span of Key Figure | UKM_KPI_TF_DATEFR | DATS | 8 | DATUM | ||||
COLX02 | End Date of Time Span of Key Figure | UKM_KPI_TF_DATETO | DATS | 8 | DATUM | ||||
COLX03 | Number of Dunning Notices | UKM_KPI_DUN_NR | NUMC | 6 | NUMC6 | ||||
COLX04 | Collection Step of Last Dunning Notice | UKM_KPI_COL_STEP | CHAR | 4 | CHAR4 | ||||
COLX05 | Collection Step Category of Last Dunning Notice | UKM_KPI_COL_STEPTYPE | CHAR | 4 | CHAR4 | ||||
COLX06 | Collection Strategy of Last Dunning Notice | UKM_KPI_COL_STRAT | CHAR | 4 | CHAR4 | ||||
COLX07 | Dunning Date of Last Dunning Notice | UKM_KPI_DUN_DATE | DATS | 8 | DATUM | ||||
COLX08 | Dunning Amount of Last Dunning Notice | UKM_KPI_DUN_AMOUNT | CURR | 13(2) | WRTV7 | ||||
COLX09 | Currency of Last Dunning Notice | UKM_KPI_DUN_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
OITS01 | Number of Open Documents with Different Due Dates | UKM_KPI_OIT_NR | NUMC | 6 | NUMC6 | ||||
OITS02 | Net Due Date | UKM_OVDUE_NET_DATE | DATS | 8 | DATS | ||||
OITS03 | Amount of Oldest Open Document | UKM_KPI_OIT_AMOUNT | CURR | 13(2) | WRTV7 | ||||
OITS04 | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
PAYX01 | Amount of Last Payment | UKM_PAY_AMOUNT | CURR | 13(2) | WRTV7 | ||||
PAYX02 | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
PAYX03 | Value Date of Last Payment | UKM_PAY_VALUT | DATS | 8 | DATUM | ||||
PAYX04 | Document Date of Last Payment | UKM_PAY_BLDAT | DATS | 8 | DATUM | ||||
DDGS01 | Amount of Open Items | UKM_KPI_DDG_AMOUNT | CURR | 13(2) | WRTV7 | ||||
DDGS02 | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
DDGS03 | Amount of Open Items with Due Date Below 30 Days | UKM_KPI_DDG_AMOUNT_LT30 | CURR | 13(2) | WRTV7 | ||||
DDGS04 | Amount of Open Items with Due Date Between 30 and 60 Days | UKM_KPI_DDG_AMOUNT_BT3060 | CURR | 13(2) | WRTV7 | ||||
DDGS05 | Amount of Open Items with Due Date Greater Than 60 Days | UKM_KPI_DDG_AMOUNT_GT60 | CURR | 13(2) | WRTV7 | ||||
DSOS01 | Days Sales Outstanding (DSO) | UKM_KPI_DSO | DEC | 8 | DEC8 | ||||
P2PX01 | Start Date of Time Span of Key Figure | UKM_KPI_TF_DATEFR | DATS | 8 | DATUM | ||||
P2PX02 | End Date of Time Span of Key Figure | UKM_KPI_TF_DATETO | DATS | 8 | DATUM | ||||
P2PX03 | Number of Kept Promises to Pay | UKM_KPI_P2P_NR_COMPLY | NUMC | 6 | NUMC6 | ||||
P2PX04 | Amount of Kept Promises to Pay | UKM_KPI_P2P_AMOUNT_COMPLY | CURR | 13(2) | WRTV7 | ||||
P2PX05 | Currency of Amount of Kept Promises to Pay | UKM_KPI_P2P_CURR_COMPLY | CUKY | 5 | Assigned to domain | WAERS | |||
P2PX06 | Number of Broken Promises to Pay | UKM_KPI_P2P_NR_BROKEN | NUMC | 6 | NUMC6 | ||||
P2PX07 | Amount of Broken Promises to Pay | UKM_KPI_P2P_AMOUNT_BROKEN | CURR | 13(2) | WRTV7 | ||||
P2PX08 | Currency of Amount of Broken Promises to Pay | UKM_KPI_P2P_CURR_BROKEN | CUKY | 5 | Assigned to domain | WAERS | |||
P2PX09 | Number of Withdrawn Promises to Pay | UKM_KPI_P2P_NR_WITHDR | NUMC | 6 | NUMC6 | ||||
P2PX10 | Amount of Withdrawn Promises to Pay | UKM_KPI_P2P_AMOUNT_WITHDR | CURR | 13(2) | WRTV7 | ||||
P2PX11 | Currency of Amount of Withdrawn Promises to Pay | UKM_KPI_P2P_CURR_WITHDR | CUKY | 5 | Assigned to domain | WAERS | |||
P2PX12 | Number of Open Kept Promises to Pay | UKM_KPI_P2P_NR_OPEN_COMPLY | NUMC | 6 | NUMC6 | ||||
P2PX13 | Amount of Open Kept Promises to Pay | UKM_KPI_P2P_AMOUNT_OPEN_COMP | CURR | 13(2) | WRTV7 | ||||
P2PX14 | Currency of Amount of Open Kept Promises to Pay | UKM_KPI_P2P_CURR_OPEN_COMP | CUKY | 5 | Assigned to domain | WAERS | |||
P2PX15 | Number of Open Broken Promises to Pay | UKM_KPI_P2P_NR_OPEN_BROKEN | NUMC | 6 | NUMC6 | ||||
P2PX16 | Amount of Open Broken Promises to Pay | UKM_KPI_P2P_AMOUNT_OPEN_BROK | CURR | 13(2) | WRTV7 | ||||
P2PX17 | Currency of Amount of Open Broken Promises to Pay | UKM_KPI_P2P_CURR_OPEN_BROK | CUKY | 5 | Assigned to domain | WAERS | |||
PYMX01 | Direct Debit Active | UKM_KPI_PYM_DD | CHAR | 1 | XFELD | ||||
PYMX02 | Credit Card Active | UKM_KPI_PYM_CC | CHAR | 1 | XFELD | ||||
RETX01 | Start Date of Time Span of Key Figure | UKM_KPI_TF_DATEFR | DATS | 8 | DATUM | ||||
RETX02 | End Date of Time Span of Key Figure | UKM_KPI_TF_DATETO | DATS | 8 | DATUM | ||||
RETX03 | Number of Returns | UKM_KPI_RET_NR | NUMC | 6 | NUMC6 | ||||
RETX04 | Returns Amount | UKM_KPI_RET_AMOUNT | CURR | 13(2) | WRTV7 | ||||
RETX05 | Currency of Return Amount | UKM_KPI_RET_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
WROS01 | Start Date of Time Span of Key Figure | UKM_KPI_TF_DATEFR | DATS | 8 | DATUM | ||||
WROS02 | End Date of Time Span of Key Figure | UKM_KPI_TF_DATETO | DATS | 8 | DATUM | ||||
WROS03 | Number of Write-Offs | UKM_KPI_WRO_NR | NUMC | 6 | NUMC6 | ||||
WROS04 | Write-Off Amount | UKM_KPI_WRO_AMOUNT | CURR | 13(2) | WRTV7 | ||||
WROS05 | Currency of Write-Off Amount | UKM_KPI_WRO_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
DEFS01 | Number of Documents in Deferral | UKM_KPI_DEF_NR | NUMC | 6 | NUMC6 | ||||
DEFS02 | Deferral Amount | UKM_KPI_DEF_AMOUNT | CURR | 13(2) | WRTV7 | ||||
DEFS03 | Values for Deferral Key Figure | UKM_KPI_DEF_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
TIPX01 | Start Date of Time Span of Key Figure | KPI_TF_DATEFR | DATS | 8 | DATUM | ||||
TIPX02 | End Date of Time Span of Key Figure | KPI_TF_DATETO | DATS | 8 | DATUM | ||||
TIPX03 | Number of Active Installment Plans | KPI_TIP_NR_ACT | NUMC | 6 | NUMC6 | ||||
TIPX04 | Amount of Active Installment Plans | KPI_TIP_AMOUNT_ACT | CURR | 13(2) | WRTV7 | ||||
TIPX05 | Currency of Amount of Active Installment Plans | KPI_TIP_CURR_ACT | CUKY | 5 | Assigned to domain | WAERS | |||
TIPX06 | Number of Deactivated Installment Plans | KPI_TIP_NR_DEACT | NUMC | 6 | NUMC6 | ||||
TIPX07 | Amount of Deactivated Installment Plans | KPI_TIP_AMOUNT_DEACT | CURR | 13(2) | WRTV7 | ||||
TIPX08 | Currency of Amount of Deactivated Installment Plans | KPI_TIP_CURR_DEACT | CUKY | 5 | Assigned to domain | WAERS | |||
TIPX09 | Number of Overdue Installment Plans | KPI_TIP_NR_OVERDUE | NUMC | 6 | NUMC6 | ||||
TIPX10 | Amount of Overdue Installment Plans | KPI_TIP_AMOUNT_OVERDUE | CURR | 13(2) | WRTV7 | ||||
TIPX11 | Currency of Amount of Overdue Installment Plans | KPI_TIP_CURR_OVERDUE | CUKY | 5 | Assigned to domain | WAERS |
Key field | Non-key field |
How do I retrieve data from SAP structure UKM_CR_KPI using ABAP code?
As UKM_CR_KPI is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on UKM_CR_KPI as there is no data to select.How to access SAP table UKM_CR_KPI
Within an ECC or HANA version of SAP you can also view further information about UKM_CR_KPI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects