UKMBP_CMS_SGM

Transparent Table Application Table
21 Fields 4 CDS Views

SAP Credit Management: Master Data for Credit Account

UKMBP_CMS_SGM is an SAP database table in S/4HANA. SAP Credit Management: Master Data for Credit Account. It contains 21 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_CreditMgmtAccount view from EXTENSION Extension Incl for Acct in Credit Mgmt
I_CreditManagementAccount view from BASIC Credit Management Account
R_CreditMgmtAccount view from BASIC Credit Management Account
v_ukm_credit_account_view view from Credit Account Data

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY partner BU_PARTNER Busn. Partner
KEY credit_sgmnt UKM_CREDIT_SGMNT Credit Segment
credit_limit UKM_CREDIT_LIMIT Credit Limit
xblocked UKM_XBLOCKED Block in Cr. Mgt
limit_valid_date UKM_VALID_DATE Valid To
limit_chg_date UKM_CHG_DATE Changed On
coordinator UKM_COORDINATOR Credit Analyst
cust_group UKM_CUST_GROUP Customer Group
follow_up_dt UKM_FOLLOW_UP_DT Resubmission On
cred_lim_calc UKM_CREDIT_LIMIT_CALC Calculated
xcritical UKM_CRITICAL_ACCOUNT Special Attention
x_limit_zero UKM_LIMIT_ZERO Limit Is Zero
block_reason UKM_BLOCK_REASON Block Reason
cred_lim_req UKM_CREDIT_LIMIT_REQ Requested
automatic_req UKM_AUTOMATIC_REQUEST Calculated
lim_val_date_req UKM_VALID_DATE_REQ Valid (Reque.)
req_date UKM_REQ_DATE Requested On
item_error UKM_ITEM_ERROR Error in Item
log_hndl BALLOGHNDL Handle
dummy_sgm_incl_eew_ps CFD_DUMMY Dummy

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.

-- SAP Credit Management: Master Data for Credit Account
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UKMBP_CMS_SGM (
    CLIENT,                 -- Client [MANDT]
    PARTNER,                -- Busn. Partner [BU_PARTNER]
    CREDIT_SGMNT,           -- Credit Segment [UKM_CREDIT_SGMNT]
    CREDIT_LIMIT,           -- Credit Limit [UKM_CREDIT_LIMIT]
    XBLOCKED,               -- Block in Cr. Mgt [UKM_XBLOCKED]
    LIMIT_VALID_DATE,       -- Valid To [UKM_VALID_DATE]
    LIMIT_CHG_DATE,         -- Changed On [UKM_CHG_DATE]
    COORDINATOR,            -- Credit Analyst [UKM_COORDINATOR]
    CUST_GROUP,             -- Customer Group [UKM_CUST_GROUP]
    FOLLOW_UP_DT,           -- Resubmission On [UKM_FOLLOW_UP_DT]
    CRED_LIM_CALC,          -- Calculated [UKM_CREDIT_LIMIT_CALC]
    XCRITICAL,              -- Special Attention [UKM_CRITICAL_ACCOUNT]
    X_LIMIT_ZERO,           -- Limit Is Zero [UKM_LIMIT_ZERO]
    BLOCK_REASON,           -- Block Reason [UKM_BLOCK_REASON]
    CRED_LIM_REQ,           -- Requested [UKM_CREDIT_LIMIT_REQ]
    AUTOMATIC_REQ,          -- Calculated [UKM_AUTOMATIC_REQUEST]
    LIM_VAL_DATE_REQ,       -- Valid (Reque.) [UKM_VALID_DATE_REQ]
    REQ_DATE,               -- Requested On [UKM_REQ_DATE]
    ITEM_ERROR,             -- Error in Item [UKM_ITEM_ERROR]
    LOG_HNDL,               -- Handle [BALLOGHNDL]
    DUMMY_SGM_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (CLIENT, PARTNER, CREDIT_SGMNT)
);

Learn More