CMS_RE_PRT_VAL

Transparent Table Application Table
21 Fields 2 CDS Views

Real Estate Part value details

CMS_RE_PRT_VAL is an SAP database table in S/4HANA. Real Estate Part value details. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ColltrlREPartValue view from BASIC Value Details for Collateral RE Part
I_RealEstatePrtValue view from BASIC Value Details for Collateral RE Part

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prt_val_guid CMS_RE_DTE_PRT_VAL_GUID Val GUID
obj_prt_guid CMS_RE_DTE_OBJ_PRT_GUID Part GUID
part_id CMS_RE_DTE_PART_ID Part ID
val_type CMS_DTE_VAL_RESULT_ID Val Calc method
calc_amount CMS_RE_DTE_CALC_VAL_AMOUNT Calculated Val
calc_amt_curr CMS_RE_DTE_CALC_VAL_CURR Currency
entered_amount CMS_RE_DTE_ENTERED_VAL_AMOUNT Entered Value
ent_amt_curr CMS_RE_DTE_ENTERED_VAL_CURR Currency
val_valid_from CMS_RE_DTE_VAL_VALID_FROM Valid From
val_valid_to CMS_RE_DTE_VAL_VALID_TO Valid To
val_date CMS_RE_DTE_VAL_DATE Valuation Date
val_origin CMS_RE_DTE_ATT_ID_TY_REO016 Origin of Value
created_by CMS_RE_DTE_CR_BY Created By
created_date CMS_RE_DTE_CR_ON Created On
created_time CMS_RE_DTE_CR_AT Created At
entry_src CMS_RE_DTE_SRC_INIT Source Of Entry
last_chg_by CMS_RE_DTE_CHG_BY Last Changed by
last_chg_date CMS_RE_DTE_CHG_ON Last Changed On
last_chg_time CMS_RE_DTE_CHG_AT Last Changed At
processing_src CMS_RE_DTE_PRC_SRC Processing Src

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.

-- Real Estate Part value details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_RE_PRT_VAL (
    MANDT,           -- Client [MANDT]
    PRT_VAL_GUID,    -- Val GUID [CMS_RE_DTE_PRT_VAL_GUID]
    OBJ_PRT_GUID,    -- Part GUID [CMS_RE_DTE_OBJ_PRT_GUID]
    PART_ID,         -- Part ID [CMS_RE_DTE_PART_ID]
    VAL_TYPE,        -- Val Calc method [CMS_DTE_VAL_RESULT_ID]
    CALC_AMOUNT,     -- Calculated Val [CMS_RE_DTE_CALC_VAL_AMOUNT]
    CALC_AMT_CURR,   -- Currency [CMS_RE_DTE_CALC_VAL_CURR]
    ENTERED_AMOUNT,  -- Entered Value [CMS_RE_DTE_ENTERED_VAL_AMOUNT]
    ENT_AMT_CURR,    -- Currency [CMS_RE_DTE_ENTERED_VAL_CURR]
    VAL_VALID_FROM,  -- Valid From [CMS_RE_DTE_VAL_VALID_FROM]
    VAL_VALID_TO,    -- Valid To [CMS_RE_DTE_VAL_VALID_TO]
    VAL_DATE,        -- Valuation Date [CMS_RE_DTE_VAL_DATE]
    VAL_ORIGIN,      -- Origin of Value [CMS_RE_DTE_ATT_ID_TY_REO016]
    CREATED_BY,      -- Created By [CMS_RE_DTE_CR_BY]
    CREATED_DATE,    -- Created On [CMS_RE_DTE_CR_ON]
    CREATED_TIME,    -- Created At [CMS_RE_DTE_CR_AT]
    ENTRY_SRC,       -- Source Of Entry [CMS_RE_DTE_SRC_INIT]
    LAST_CHG_BY,     -- Last Changed by [CMS_RE_DTE_CHG_BY]
    LAST_CHG_DATE,   -- Last Changed On [CMS_RE_DTE_CHG_ON]
    LAST_CHG_TIME,   -- Last Changed At [CMS_RE_DTE_CHG_AT]
    PROCESSING_SRC,  -- Processing Src [CMS_RE_DTE_PRC_SRC]
    PRIMARY KEY (MANDT, PRT_VAL_GUID)
);

Learn More