CMM_ROBJ_ITEM

Transparent Table Application Table
53 Fields 2 CDS Views

Risk Object Item

CMM_ROBJ_ITEM is an SAP database table in S/4HANA. Risk Object Item. It contains 53 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CmmdtyRiskObjectItem view from EXTENSION Extension of Risk Object item
I_CmmdtyRiskObjectItem view from BASIC Basic View for Risk Object Item

Fields (53)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY commodityriskobjectitemnode /BOBF/CONF_KEY NodeID
commodityriskobjectparentnode /BOBF/CONF_KEY NodeID
cmmdtyrskobjitemstatus CMM_STATUS Risk Obj. Status
cmmdtyrskobjitemrevalstatus CMM_ITEM_REVAL Item Reval Status
pricingdocumentitem KPOSN Item
material MATNR Material
plant WERKS_D Plant
storagelocation LGORT_D Location
materialgroup MATKL Material Group
netpriceamount NETPR Net Price
documentcurrency WAERK Doc. Currency
quantityinbaseunit MENGE_D Quantity
baseunit LAGME Base Unit
quantity MENGE_D Quantity
orderquantityunit VRKME Sales Unit
pricingreferencematerial PMATN Pr. Ref. Matl
businesspartner SPART Division
pdummy DUMMY Dummy function in length 1
category_id CACS_COM_CATEGORY_ID Category ID
industry CACS_CRM_INDUSTRY Industry Sector
ssparte CACSINS_SPARTE Division
ttarif CACSINS_TARIF Tariff
name CACSINS_NAME Name
vorname CACSINS_VORNAME First Name
vsnr CACSINS_VSNR Insur. No.
laufzeit CACSINS_LAUFZEIT Cover.Per.
annual_premium CACSINS_ANNUALPREMIUM AnnualCont.
ctrtst_id CACS_CTRTST_ID Standard Ctrct
bucagr_id CACS_CTRTBU_ID Contract Number
ctrtst CACS_CTRTST_ID Standard Ctrct
rem_buscase_typ CACSREMBUSCASTYP RemunBusTranCat
p_version CACS_COND_VERSION Version
p_ctrt_xl CACS_COND_CTRTID_XL AgreemntNo
p_cacsappl CACSAPPL Commission Appl
p_state CACSCONDSTATE Status
materialexternalgroup EXTWG Ext. Matl Group
paymentdate CMM_MTM_DATE_PYMNT Payment Date
quantitysign CMM_VLOGP_SIGNAGE_QTY Sign of Quantity
deliverydate CMM_VLOGP_DELIVERY_DATE Delivery Date
originreferencedocument CMM_VLOGP_ROOT Root Document
originreferencedocbusobjtype CMM_VLOGP_ROOT_DOCTYP Root (BOR) Obj. Type
originreferencedocumentitem CMM_VLOGP_ROOT_ITEM Root Document Item
referencedocument CMM_VLOGP_PREDECESSOR Predecessor Doc.
referencedocbusobjtype CMM_VLOGP_PREDECESSOR_DOCTYP Pred(BOR) Object Typ
referencedocumentitem CMM_VLOGP_PREDECESSOR_ITEM Predec. Doc. Item
lastupdatedcmmdtyqtyinbaseuom MENGE_D Quantity
lastupdatedbaseunitofmeasure LAGME Base Unit
lastupdatedquantitysign CMM_VLOGP_SIGNAGE_QTY Sign of Quantity
cmmdtyriskobjitemfuncstrucextn abap.char
cmmdtyintrastodocumentitem EBELP Item
stktransferorderitemisdeleted ELOEK Del. Indicator
stktransferorditemdeliverydate EINDT Delivery Date

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.

-- Risk Object Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMM_ROBJ_ITEM (
    MANDT,                           -- Client [MANDT]
    COMMODITYRISKOBJECTITEMNODE,     -- NodeID [/BOBF/CONF_KEY]
    COMMODITYRISKOBJECTPARENTNODE,   -- NodeID [/BOBF/CONF_KEY]
    CMMDTYRSKOBJITEMSTATUS,          -- Risk Obj. Status [CMM_STATUS]
    CMMDTYRSKOBJITEMREVALSTATUS,     -- Item Reval Status [CMM_ITEM_REVAL]
    PRICINGDOCUMENTITEM,             -- Item [KPOSN]
    MATERIAL,                        -- Material [MATNR]
    PLANT,                           -- Plant [WERKS_D]
    STORAGELOCATION,                 -- Location [LGORT_D]
    MATERIALGROUP,                   -- Material Group [MATKL]
    NETPRICEAMOUNT,                  -- Net Price [NETPR]
    DOCUMENTCURRENCY,                -- Doc. Currency [WAERK]
    QUANTITYINBASEUNIT,              -- Quantity [MENGE_D]
    BASEUNIT,                        -- Base Unit [LAGME]
    QUANTITY,                        -- Quantity [MENGE_D]
    ORDERQUANTITYUNIT,               -- Sales Unit [VRKME]
    PRICINGREFERENCEMATERIAL,        -- Pr. Ref. Matl [PMATN]
    BUSINESSPARTNER,                 -- Division [SPART]
    PDUMMY,                          -- Dummy function in length 1 [DUMMY]
    CATEGORY_ID,                     -- Category ID [CACS_COM_CATEGORY_ID]
    INDUSTRY,                        -- Industry Sector [CACS_CRM_INDUSTRY]
    SSPARTE,                         -- Division [CACSINS_SPARTE]
    TTARIF,                          -- Tariff [CACSINS_TARIF]
    NAME,                            -- Name [CACSINS_NAME]
    VORNAME,                         -- First Name [CACSINS_VORNAME]
    VSNR,                            -- Insur. No. [CACSINS_VSNR]
    LAUFZEIT,                        -- Cover.Per. [CACSINS_LAUFZEIT]
    ANNUAL_PREMIUM,                  -- AnnualCont. [CACSINS_ANNUALPREMIUM]
    CTRTST_ID,                       -- Standard Ctrct [CACS_CTRTST_ID]
    BUCAGR_ID,                       -- Contract Number [CACS_CTRTBU_ID]
    CTRTST,                          -- Standard Ctrct [CACS_CTRTST_ID]
    REM_BUSCASE_TYP,                 -- RemunBusTranCat [CACSREMBUSCASTYP]
    P_VERSION,                       -- Version [CACS_COND_VERSION]
    P_CTRT_XL,                       -- AgreemntNo [CACS_COND_CTRTID_XL]
    P_CACSAPPL,                      -- Commission Appl [CACSAPPL]
    P_STATE,                         -- Status [CACSCONDSTATE]
    MATERIALEXTERNALGROUP,           -- Ext. Matl Group [EXTWG]
    PAYMENTDATE,                     -- Payment Date [CMM_MTM_DATE_PYMNT]
    QUANTITYSIGN,                    -- Sign of Quantity [CMM_VLOGP_SIGNAGE_QTY]
    DELIVERYDATE,                    -- Delivery Date [CMM_VLOGP_DELIVERY_DATE]
    ORIGINREFERENCEDOCUMENT,         -- Root Document [CMM_VLOGP_ROOT]
    ORIGINREFERENCEDOCBUSOBJTYPE,    -- Root (BOR) Obj. Type [CMM_VLOGP_ROOT_DOCTYP]
    ORIGINREFERENCEDOCUMENTITEM,     -- Root Document Item [CMM_VLOGP_ROOT_ITEM]
    REFERENCEDOCUMENT,               -- Predecessor Doc. [CMM_VLOGP_PREDECESSOR]
    REFERENCEDOCBUSOBJTYPE,          -- Pred(BOR) Object Typ [CMM_VLOGP_PREDECESSOR_DOCTYP]
    REFERENCEDOCUMENTITEM,           -- Predec. Doc. Item [CMM_VLOGP_PREDECESSOR_ITEM]
    LASTUPDATEDCMMDTYQTYINBASEUOM,   -- Quantity [MENGE_D]
    LASTUPDATEDBASEUNITOFMEASURE,    -- Base Unit [LAGME]
    LASTUPDATEDQUANTITYSIGN,         -- Sign of Quantity [CMM_VLOGP_SIGNAGE_QTY]
    CMMDTYRISKOBJITEMFUNCSTRUCEXTN,  -- abap.char
    CMMDTYINTRASTODOCUMENTITEM,      -- Item [EBELP]
    STKTRANSFERORDERITEMISDELETED,   -- Del. Indicator [ELOEK]
    STKTRANSFERORDITEMDELIVERYDATE,  -- Delivery Date [EINDT]
    PRIMARY KEY (MANDT, COMMODITYRISKOBJECTITEMNODE)
);

Learn More