In this post, I will try and describe everything you need to know about the SAP crmd_ubb_cr_i table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_UBB_CR_I what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_UBB_CR_I....Right lets get started!
Object Name: CRMD_UBB_CR_I
Dictionary Type: Transparent table
Description: Credit Overview
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| ITEM_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| PRED_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| VALID_FROM | CRMT_UBB_VALID_FROM | DEC | 15(0) | Valid from | CRM_TSTMP | CRM | ||||||
| VALID_TO | CRMT_UBB_VALID_TO | DEC | 15(0) | Valid To | CRM_TSTMP | CRM | ||||||
| QUANTITY | CRMT_UBB_CRED_QUANTITY | QUAN | 15(3) | Credit Quantity | CRM_MENGV15 | CRM | ||||||
| CURRENT_QUANTITY | CRMT_UBB_CRED_CURR_QUANTITY | QUAN | 15(3) | Current Credit Quantity | CRM_MENGV15 | CRM | ||||||
| UNIT | CRMT_UBB_CRED_UNIT | UNIT | 3(0) | * | Credit Unit | MEINS | H_T006_USAGE | MSEHI | CRM | |||
| USAGEFCTCAT | CRMT_UBB_USAGEFCT_CAT | CHAR | 4(0) | CRMC_UBB_USG_CAT | Usage Function Category | CRM_UBB_USAGEFCT_CAT | CRM | |||||
| USAGEFCT | CRMT_UBB_USAGEFCT | CHAR | 4(0) | CRMC_UBB_USG_FCT | Usage Function | CRM_UBB_USAGEFCT | CRM | |||||
| COMMENT_LANGU | CRMT_UBB_COMMENT_LANGU | LANG | 1(0) | Language of Credit Comment | SYLANGU | CRM | ||||||
| COMMENTS | CRMT_UBB_COMMENT_60 | CHAR | 60(0) | Comment | CRM_UBB_COMMENT_60 | CRM | ||||||
| CREDIT_STATUS | CRMT_UBB_CREDIT_STATUS | CHAR | 1(0) | Credit Status | CRM_UBB_CREDIT_STATUS | CRM | ||||||
| CR_TYPE | CRMT_UBB_CR_TYPE | CHAR | 1(0) | CRMC_UBB_CR_TYPE | Type of Credit | CRM_UBB_CR_TYPE | CRM | |||||
| READING_ID | CRMT_MPK_OBJECT_ID_READING | CHAR | 20(0) | Reading Number | CRM_MPK_OBJECT_ID_READING | CRM_MPK_RD_ID | CRMH_MPK_READING | OBJECT_ID | CRM | |||
| VALUE | CRMT_UBB_CRED_VALUE | CURR | 19(2) | Credit Value | PRC_COND_VALUE | CRM | ||||||
| CURRENT_VALUE | CRMT_UBB_CRED_VALUE_CURRENT | CURR | 19(2) | Current Credit Value | PRC_COND_VALUE | CRM | ||||||
| CURRENCY | CRMT_UBB_CRED_CURR | CUKY | 5(0) | * | Credit Currency | WAERS | CRM | |||||
| SOURCE | CRMT_UBB_CRED_SOURCE | CHAR | 1(0) | Credit Source | CRM_UBB_CRED_SOURCE | CRM | ||||||
| SRC_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| RELATIONID | BINRELID | CHAR | 22(0) | Object Relationship Service : GUID binary link | SYSUUID_22 | CRM | ||||||
| POSNO | CRMT_POSNO | NUMC | 6(0) | Item Number in Document Flow | NUMC6 | CRM | ||||||
| RELATIONID_CANC | BINRELID | CHAR | 22(0) | Object Relationship Service : GUID binary link | SYSUUID_22 | CRM | ||||||
| POSNO_CANC | CRMT_POSNO | NUMC | 6(0) | Item Number in Document Flow | NUMC6 | CRM | ||||||
| VALID_TIMEZONE | TZNZONE | CHAR | 6(0) | * | Time Zone | TZNZONE | CRM |