CMS_RBL

Transparent Table Application Table
61 Fields 1 CDS Views

Receivable Details

CMS_RBL is an SAP database table in S/4HANA. Receivable Details. It contains 61 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ReceivableData view from BASIC Receivable Details

Fields (61)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rbl_guid CMS_DTE_RBL_GUID RCVBL GUID
creditsystem CMS_DTE_RBL_CRDSYS Credit system
rbl_id CMS_DTE_RBL_ID Rbl ID
par_guid CMS_DTE_RBL_PAR_GUID Receivable Parent Guid
positionid CMS_DTE_POSID Position ID
prd_class CMS_DTE_PRD_CLASS Product class
product CMS_DTE_RBL_PROD Product
rbl_org_unit CMS_DTE_RBL_ORG_UNIT Org. unit
ind_credit CMS_DTE_IND_CREDIT Credit/Debit
otherbank CMS_DTE_RBL_OTHERBANK Bank
descr CMS_DTE_RBL_DESCRIPTION Description
admin_org_unit CMS_DTE_ADMINORG AdminOrg
status CMS_DTE_RBL_STATUS Status
ref_crdsys CMS_DTE_RBL_REFCRDSYS Ref.cred.sys.
ref_id CMS_DTE_RBL_REFID Ref. ID
valid_from CMS_DTE_RBL_VALID_FROM Valid from
valid_to CMS_DTE_RBL_VALID_TO Valid to
fixed_from CMS_DTE_RBL_FIXED_FROM Fixed from
fixed_to CMS_DTE_RBL_FIXED_TO Fixed to
cont_amount CMS_DTE_RBL_CONTAMT Contract amt
cont_currency CMS_DTE_RBL_CONTCURR Contract Curr
amt_maxrisk CMS_DTE_RBL_MAXRISK Max risk
amt_currrisk CMS_DTE_RBL_CURRRISK Current risk
curr_risk CMS_DTE_RBL_RISKCURR Currency
amt_oblig CMS_DTE_RBL_OBLIG Obligation
curr_oblig CMS_DTE_RBL_CAPCURR Currency
amt_util CMS_DTE_RBL_UTIL Utilization
curr_util CMS_DTE_RBL_CAPCURR Currency
amt_drawdown CMS_DTE_RBL_DRAWDOWN Drawdown
curr_drawdown CMS_DTE_RBL_CAPCURR Currency
amt_interest CMS_DTE_RBL_INTEREST Interest
curr_interest CMS_DTE_RBL_CAPCURR Currency
amt_fees CMS_DTE_RBL_FEES Fees
curr_fees CMS_DTE_RBL_CAPCURR Currency
amt_1 CMS_DTE_RBL_AMT Rbl Amount
curr_1 CMS_DTE_RBL_CAPCURR Currency
amt_2 CMS_DTE_RBL_AMT Rbl Amount
curr_2 CMS_DTE_RBL_CAPCURR Currency
amt_3 CMS_DTE_RBL_AMT Rbl Amount
curr_3 CMS_DTE_RBL_CAPCURR Currency
amt_4 CMS_DTE_RBL_AMT Rbl Amount
curr_4 CMS_DTE_RBL_CAPCURR Currency
amt_debt_arr CMS_DTE_RBL_DEBT_ARREARS Debt in arrears
curr_debt_arr CMS_DTE_RBL_CAPCURR Currency
org_unit1 CMS_DTE_RBL_ORG_UNIT1 Org. Unit 1
org_unit2 CMS_DTE_RBL_ORG_UNIT2 Org. Unit 2
org_unit3 CMS_DTE_RBL_ORG_UNIT3 Org. Unit 3
org_unit4 CMS_DTE_RBL_ORG_UNIT4 Org. Unit 4
org_unit5 CMS_DTE_RBL_ORG_UNIT5 Org. Unit 5
created_by CMS_DTE_USER Created by
created_at CMS_DTE_CREATED_AT Created At
changed_by CMS_DTE_LAST_CHNG_USER Last Changed by
changed_at CMS_DTE_CHANGED_AT Changed At
sourceofentry CMS_DTE_SOURCE_OF_ENTRY Source Of Entry
origination_sys CMS_DTE_RBL_ORIGINATION_SYSTEM RBL Origination Sys.
offer_id CMS_DTE_RBL_OFFER_ID Offer ID
time_stamp TIMESTAMP Time Stamp
change_type CMS_DTE_RBL_CHG_IND Change Type
bupr_id CMS_DTE_BUPR_ID Bus. Process ID
bupr_type_code CMS_DTE_BUPR_TYP_CODE BusProcess Code

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Receivable Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_RBL (
    MANDT,            -- Client [MANDT]
    RBL_GUID,         -- RCVBL GUID [CMS_DTE_RBL_GUID]
    CREDITSYSTEM,     -- Credit system [CMS_DTE_RBL_CRDSYS]
    RBL_ID,           -- Rbl ID [CMS_DTE_RBL_ID]
    PAR_GUID,         -- Receivable Parent Guid [CMS_DTE_RBL_PAR_GUID]
    POSITIONID,       -- Position ID [CMS_DTE_POSID]
    PRD_CLASS,        -- Product class [CMS_DTE_PRD_CLASS]
    PRODUCT,          -- Product [CMS_DTE_RBL_PROD]
    RBL_ORG_UNIT,     -- Org. unit [CMS_DTE_RBL_ORG_UNIT]
    IND_CREDIT,       -- Credit/Debit [CMS_DTE_IND_CREDIT]
    OTHERBANK,        -- Bank [CMS_DTE_RBL_OTHERBANK]
    DESCR,            -- Description [CMS_DTE_RBL_DESCRIPTION]
    ADMIN_ORG_UNIT,   -- AdminOrg [CMS_DTE_ADMINORG]
    STATUS,           -- Status [CMS_DTE_RBL_STATUS]
    REF_CRDSYS,       -- Ref.cred.sys. [CMS_DTE_RBL_REFCRDSYS]
    REF_ID,           -- Ref. ID [CMS_DTE_RBL_REFID]
    VALID_FROM,       -- Valid from [CMS_DTE_RBL_VALID_FROM]
    VALID_TO,         -- Valid to [CMS_DTE_RBL_VALID_TO]
    FIXED_FROM,       -- Fixed from [CMS_DTE_RBL_FIXED_FROM]
    FIXED_TO,         -- Fixed to [CMS_DTE_RBL_FIXED_TO]
    CONT_AMOUNT,      -- Contract amt [CMS_DTE_RBL_CONTAMT]
    CONT_CURRENCY,    -- Contract Curr [CMS_DTE_RBL_CONTCURR]
    AMT_MAXRISK,      -- Max risk [CMS_DTE_RBL_MAXRISK]
    AMT_CURRRISK,     -- Current risk [CMS_DTE_RBL_CURRRISK]
    CURR_RISK,        -- Currency [CMS_DTE_RBL_RISKCURR]
    AMT_OBLIG,        -- Obligation [CMS_DTE_RBL_OBLIG]
    CURR_OBLIG,       -- Currency [CMS_DTE_RBL_CAPCURR]
    AMT_UTIL,         -- Utilization [CMS_DTE_RBL_UTIL]
    CURR_UTIL,        -- Currency [CMS_DTE_RBL_CAPCURR]
    AMT_DRAWDOWN,     -- Drawdown [CMS_DTE_RBL_DRAWDOWN]
    CURR_DRAWDOWN,    -- Currency [CMS_DTE_RBL_CAPCURR]
    AMT_INTEREST,     -- Interest [CMS_DTE_RBL_INTEREST]
    CURR_INTEREST,    -- Currency [CMS_DTE_RBL_CAPCURR]
    AMT_FEES,         -- Fees [CMS_DTE_RBL_FEES]
    CURR_FEES,        -- Currency [CMS_DTE_RBL_CAPCURR]
    AMT_1,            -- Rbl Amount [CMS_DTE_RBL_AMT]
    CURR_1,           -- Currency [CMS_DTE_RBL_CAPCURR]
    AMT_2,            -- Rbl Amount [CMS_DTE_RBL_AMT]
    CURR_2,           -- Currency [CMS_DTE_RBL_CAPCURR]
    AMT_3,            -- Rbl Amount [CMS_DTE_RBL_AMT]
    CURR_3,           -- Currency [CMS_DTE_RBL_CAPCURR]
    AMT_4,            -- Rbl Amount [CMS_DTE_RBL_AMT]
    CURR_4,           -- Currency [CMS_DTE_RBL_CAPCURR]
    AMT_DEBT_ARR,     -- Debt in arrears [CMS_DTE_RBL_DEBT_ARREARS]
    CURR_DEBT_ARR,    -- Currency [CMS_DTE_RBL_CAPCURR]
    ORG_UNIT1,        -- Org. Unit 1 [CMS_DTE_RBL_ORG_UNIT1]
    ORG_UNIT2,        -- Org. Unit 2 [CMS_DTE_RBL_ORG_UNIT2]
    ORG_UNIT3,        -- Org. Unit 3 [CMS_DTE_RBL_ORG_UNIT3]
    ORG_UNIT4,        -- Org. Unit 4 [CMS_DTE_RBL_ORG_UNIT4]
    ORG_UNIT5,        -- Org. Unit 5 [CMS_DTE_RBL_ORG_UNIT5]
    CREATED_BY,       -- Created by [CMS_DTE_USER]
    CREATED_AT,       -- Created At [CMS_DTE_CREATED_AT]
    CHANGED_BY,       -- Last Changed by [CMS_DTE_LAST_CHNG_USER]
    CHANGED_AT,       -- Changed At [CMS_DTE_CHANGED_AT]
    SOURCEOFENTRY,    -- Source Of Entry [CMS_DTE_SOURCE_OF_ENTRY]
    ORIGINATION_SYS,  -- RBL Origination Sys. [CMS_DTE_RBL_ORIGINATION_SYSTEM]
    OFFER_ID,         -- Offer ID [CMS_DTE_RBL_OFFER_ID]
    TIME_STAMP,       -- Time Stamp [TIMESTAMP]
    CHANGE_TYPE,      -- Change Type [CMS_DTE_RBL_CHG_IND]
    BUPR_ID,          -- Bus. Process ID [CMS_DTE_BUPR_ID]
    BUPR_TYPE_CODE,   -- BusProcess Code [CMS_DTE_BUPR_TYP_CODE]
    PRIMARY KEY (MANDT, RBL_GUID)
);

Learn More