CRMD_UBB_CR_I SAP (Credit Overview) Table details

Dictionary Type: Table
Description: Credit Overview




ABAP Code to SELECT data from CRMD_UBB_CR_I
Related tables to CRMD_UBB_CR_I
Access table CRMD_UBB_CR_I




Table field list including key, data, relationships and ABAP select examples

CRMD_UBB_CR_I is a standard SAP Table which is used to store Credit Overview data and is available within R/3 SAP systems depending on the version and release level.

The CRMD_UBB_CR_I table consists of various fields, each holding specific information or linking keys about Credit Overview data available in SAP. These include CLIENT (Client), GUID (GUID of a CRM Order Object), ITEM_GUID (GUID of a CRM Order Object), PRED_GUID (GUID of a CRM Order Object).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CRMD_UBB_CR_I table 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
ITEM_GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
PRED_GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
VALID_FROMValid from CRMT_UBB_VALID_FROMDEC15TSTLCCRM_TSTMP
VALID_TOValid To CRMT_UBB_VALID_TODEC15TSTLCCRM_TSTMP
QUANTITYCredit Quantity CRMT_UBB_CRED_QUANTITYQUAN15(3) CRM_MENGV15
CURRENT_QUANTITYCurrent Credit Quantity CRMT_UBB_CRED_CURR_QUANTITYQUAN15(3) CRM_MENGV15
UNITCredit Unit CRMT_UBB_CRED_UNITUNIT3Assigned to domainCUNITMEINSH_T006_USAGE
USAGEFCTCATUsage Function Category CRMT_UBB_USAGEFCT_CATCHAR4CRMC_UBB_USG_CATCRM_UBB_USAGEFCT_CAT
USAGEFCTUsage Function CRMT_UBB_USAGEFCTCHAR4CRMC_UBB_USG_FCTCRM_UBB_USAGEFCT
COMMENT_LANGULanguage of Credit Comment CRMT_UBB_COMMENT_LANGULANG1ISOLASYLANGU
COMMENTSComment CRMT_UBB_COMMENT_60CHAR60CRM_UBB_COMMENT_60
CREDIT_STATUSCredit Status CRMT_UBB_CREDIT_STATUSCHAR1CRM_UBB_CREDIT_STATUS
CR_TYPEType of Credit CRMT_UBB_CR_TYPECHAR1CRMC_UBB_CR_TYPECRM_UBB_CR_TYPE
READING_IDReading Number CRMT_MPK_OBJECT_ID_READINGCHAR20ALPHACRM_MPK_OBJECT_ID_READINGCRM_MPK_RD_IDCRMH_MPK_READING
VALUECredit Value CRMT_UBB_CRED_VALUECURR19(2) PRC_COND_VALUE
CURRENT_VALUECurrent Credit Value CRMT_UBB_CRED_VALUE_CURRENTCURR19(2) PRC_COND_VALUE
CURRENCYCredit Currency CRMT_UBB_CRED_CURRCUKY5Assigned to domainWAERS
SOURCECredit Source CRMT_UBB_CRED_SOURCECHAR1CRM_UBB_CRED_SOURCE
SRC_GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
RELATIONIDObject Relationship Service : GUID binary link BINRELIDCHAR22SYSUUID_22
POSNOItem Number in Document Flow CRMT_POSNONUMC6NUMC6
RELATIONID_CANCObject Relationship Service : GUID binary link BINRELIDCHAR22SYSUUID_22
POSNO_CANCItem Number in Document Flow CRMT_POSNONUMC6NUMC6
VALID_TIMEZONETime Zone TZNZONECHAR6Assigned to domainTZNZONE

Key field Non-key field



How do I retrieve data from SAP table CRMD_UBB_CR_I using ABAP code

The following ABAP code Example will allow you to do a basic selection on CRMD_UBB_CR_I to SELECT all data from the table
DATA: WA_CRMD_UBB_CR_I TYPE CRMD_UBB_CR_I.

SELECT SINGLE *
FROM CRMD_UBB_CR_I
INTO CORRESPONDING FIELDS OF WA_CRMD_UBB_CR_I
WHERE...

How to access SAP table CRMD_UBB_CR_I

Within an ECC or HANA version of SAP you can also view further information about CRMD_UBB_CR_I and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!