TCMS_PRD

Transparent Table Customizing Table
10 Fields 1 CDS Views

Product description

TCMS_PRD is an SAP database table in S/4HANA. Product description. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CollateralRblProductClass view from BASIC Receivable Product Class

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prd_class CMS_DTE_PRD_CLASS Product class
categoryid CMS_DTE_PRD_CAT Category
def_cov_ratio CMS_DTE_COV_RATIO Reqd Cvrg Ratio
creditsystem CMS_DTE_RBL_CRDSYS Credit system
ind_org_role CMS_DTE_PRD_IND_ORG_RL Role
accessmode CMS_DTE_RBL_ACCESS access
flg_group CMS_DTE_RBL_GROUPFLG Group flag
fstat_var CMS_DTE_FSTAT_VAR Object Screen
bpf_set CMS_DTE_BPF_SET BPF set

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.

-- Product description
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCMS_PRD (
    MANDT,          -- Client [MANDT]
    PRD_CLASS,      -- Product class [CMS_DTE_PRD_CLASS]
    CATEGORYID,     -- Category [CMS_DTE_PRD_CAT]
    DEF_COV_RATIO,  -- Reqd Cvrg Ratio [CMS_DTE_COV_RATIO]
    CREDITSYSTEM,   -- Credit system [CMS_DTE_RBL_CRDSYS]
    IND_ORG_ROLE,   -- Role [CMS_DTE_PRD_IND_ORG_RL]
    ACCESSMODE,     -- access [CMS_DTE_RBL_ACCESS]
    FLG_GROUP,      -- Group flag [CMS_DTE_RBL_GROUPFLG]
    FSTAT_VAR,      -- Object Screen [CMS_DTE_FSTAT_VAR]
    BPF_SET,        -- BPF set [CMS_DTE_BPF_SET]
    PRIMARY KEY (MANDT, PRD_CLASS)
);

Learn More