SAP CMS_RBL Receivable Details Table data and field list

CMS_RBL is a standard SAP Table which is used to store Receivable Details data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMS_RBL table consists of various fields, each holding specific information or linking keys about Receivable Details data available in SAP. These include RBL_GUID (GUID for Table CMS_RBL), CREDITSYSTEM (Credit System), RBL_ID (Receivable ID), PAR_GUID (Receivable Parent Guid)... 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. .

CMS_RBL table Technical Details:

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 CMS_RBL table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_RBL table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
RBL_GUIDGUID for Table CMS_RBL CMS_DTE_RBL_GUIDRAW16SYSUUID
CREDITSYSTEMCredit System CMS_DTE_RBL_CRDSYSCHAR3TCMS_RBL_CRDSYSCMS_RBL_CRDSYSCREDITSYSTEM
RBL_IDReceivable ID CMS_DTE_RBL_IDCHAR64ALPHACMS_RBLIDRBL_ID
PAR_GUIDReceivable Parent Guid CMS_DTE_RBL_PAR_GUIDRAW16SYSUUID
POSITIONIDReceivable Position ID CMS_DTE_POSIDNUMC4CMS_POSID
PRD_CLASSProduct Class CMS_DTE_PRD_CLASSCHAR6TCMS_PRDCMS_PRD_CLASSCMS_PRD_CLASSCMS_PRD_CLASS
PRODUCTProduct of Receivable CMS_DTE_RBL_PRODCHAR12TCMS_RBL_PRODCMS_RBL_PRODCMS_RBL_PROD
RBL_ORG_UNITOrganization Unit for a Receivable CMS_DTE_RBL_ORG_UNITCHAR10TCMS_RBL_ORGCMS_RBL_ORG_UNIT
IND_CREDITIndicator to specify if Receivable is Credit/Debit to Bank CMS_DTE_IND_CREDITCHAR1CMS_IND_CREDIT
OTHERBANKIndicates that the Receivable belongs to an External Bank CMS_DTE_RBL_OTHERBANKCHAR1CMS_OTHERBANK
DESCRDescription of Receivable CMS_DTE_RBL_DESCRIPTIONCHAR60CMS_TEXT
ADMIN_ORG_UNITAdministration Organizational Unit CMS_DTE_ADMINORGCHAR12TEXT12CMS_ADMINORG
STATUSStatus of Receivable CMS_DTE_RBL_STATUSCHAR2CMS_RBL_STATUS
REF_CRDSYSReference to Credit System CMS_DTE_RBL_REFCRDSYSCHAR3TCMS_RBL_CRDSYSCMS_RBL_CRDSYS
REF_IDReceivable Id CMS_DTE_RBL_REFIDCHAR64CHAR64
VALID_FROMDate from which the Risk stands Valid CMS_DTE_RBL_VALID_FROMNUMC15TSTPSTZNTSTMPSL
VALID_TODate until which the Risk stands Valid CMS_DTE_RBL_VALID_TONUMC15TSTPSTZNTSTMPSL
FIXED_FROMStart Date of Fixed Period of Receivable Conditions CMS_DTE_RBL_FIXED_FROMNUMC15TSTPSTZNTSTMPSL
FIXED_TOEnd Date of Fixed Period of Receivable Conditions CMS_DTE_RBL_FIXED_TONUMC15TSTPSTZNTSTMPSL
CONT_AMOUNTAmount of Receivable Contract CMS_DTE_RBL_CONTAMTCURR17(2) CMS_AMOUNT
CONT_CURRENCYReceivable Contract Currency CMS_DTE_RBL_CONTCURRCUKY5Assigned to domainWAERS
AMT_MAXRISKMaximum Risk CMS_DTE_RBL_MAXRISKCURR17(2) CMS_AMOUNT
AMT_CURRRISKCurrent Risk CMS_DTE_RBL_CURRRISKCURR17(2) CMS_AMOUNT
CURR_RISKCurrency for Receivable Risk Amounts CMS_DTE_RBL_RISKCURRCUKY5Assigned to domainWAERS
AMT_OBLIGDisbursement Obligation CMS_DTE_RBL_OBLIGCURR17(2) CMS_AMOUNT
CURR_OBLIGCurrency of Receivable Capitals CMS_DTE_RBL_CAPCURRCUKY5Assigned to domainWAERS
AMT_UTILUtilization Amount CMS_DTE_RBL_UTILCURR17(2) CMS_AMOUNT
CURR_UTILCurrency of Receivable Capitals CMS_DTE_RBL_CAPCURRCUKY5Assigned to domainWAERS
AMT_DRAWDOWNDrawdown of Receivable CMS_DTE_RBL_DRAWDOWNCURR17(2) CMS_AMOUNT
CURR_DRAWDOWNCurrency of Receivable Capitals CMS_DTE_RBL_CAPCURRCUKY5Assigned to domainWAERS
AMT_INTERESTOutstanding Interest Amount CMS_DTE_RBL_INTERESTCURR17(2) CMS_AMOUNT
CURR_INTERESTCurrency of Receivable Capitals CMS_DTE_RBL_CAPCURRCUKY5Assigned to domainWAERS
AMT_FEESFees Amount CMS_DTE_RBL_FEESCURR17(2) CMS_AMOUNT
CURR_FEESCurrency of Receivable Capitals CMS_DTE_RBL_CAPCURRCUKY5Assigned to domainWAERS
AMT_1Receivable Amount CMS_DTE_RBL_AMTCURR17(2) CMS_AMOUNT
CURR_1Currency of Receivable Capitals CMS_DTE_RBL_CAPCURRCUKY5Assigned to domainWAERS
AMT_2Receivable Amount CMS_DTE_RBL_AMTCURR17(2) CMS_AMOUNT
CURR_2Currency of Receivable Capitals CMS_DTE_RBL_CAPCURRCUKY5Assigned to domainWAERS
AMT_3Receivable Amount CMS_DTE_RBL_AMTCURR17(2) CMS_AMOUNT
CURR_3Currency of Receivable Capitals CMS_DTE_RBL_CAPCURRCUKY5Assigned to domainWAERS
AMT_4Receivable Amount CMS_DTE_RBL_AMTCURR17(2) CMS_AMOUNT
CURR_4Currency of Receivable Capitals CMS_DTE_RBL_CAPCURRCUKY5Assigned to domainWAERS
AMT_DEBT_ARRDebt in arrears CMS_DTE_RBL_DEBT_ARREARSCURR17(2) CMS_AMOUNT
CURR_DEBT_ARRCurrency of Receivable Capitals CMS_DTE_RBL_CAPCURRCUKY5TCURCWAERS
ORG_UNIT1Organizational Unit 1: Receivable CMS_DTE_RBL_ORG_UNIT1CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT2Organizational Unit 2: Receivable CMS_DTE_RBL_ORG_UNIT2CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT3Organizational Unit 3: Receivable CMS_DTE_RBL_ORG_UNIT3CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT4Organizational Unit 4: Receivable CMS_DTE_RBL_ORG_UNIT4CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT5Organizational Unit 5: Receivable CMS_DTE_RBL_ORG_UNIT5CHAR10Assigned to domainCMS_ORG_UNIT
CREATED_BYLogin ID of the User who created the Record CMS_DTE_USERCHAR12CMS_USER
CREATED_ATCreation Timestamp CMS_DTE_CREATED_ATDEC15TZNTSTMPS
CHANGED_BYLast Changed By CMS_DTE_LAST_CHNG_USERCHAR12CMS_USER
CHANGED_ATChange Timestamp CMS_DTE_CHANGED_ATDEC15TZNTSTMPS
SOURCEOFENTRYSource of Entry CMS_DTE_SOURCE_OF_ENTRYCHAR32CMS_SOURCE

Key field Non-key field



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

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

SELECT SINGLE *
FROM CMS_RBL
INTO CORRESPONDING FIELDS OF WA_CMS_RBL
WHERE...

How to access SAP table CMS_RBL

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

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