CMS_RE_PRT_BP

Transparent Table Application Table
18 Fields 2 CDS Views

Real Estate Part BP details

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ColltrlREPartPartner view from BASIC Business Partner for Collateral RE Part
I_RealEstatePrtPartner view from BASIC Business Partner for Collateral RE Part

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prt_bp_guid CMS_RE_DTE_PRT_BP_GUID BP GUID
obj_prt_guid CMS_RE_DTE_OBJ_PRT_GUID Part GUID
part_id CMS_RE_DTE_PART_ID Part ID
bupa_id CMS_RE_DTE_BUPA_ID BuPa ID
bpf CMS_DTE_BPF PartnerFunction
bupa_share_nr CMS_RE_DTE_BUPA_NR Share Num
bupa_share_dr CMS_RE_DTE_BUPA_DR Share Den
bp_valid_from CMS_RE_DTE_VAL_VALID_FROM Valid From
bp_valid_to CMS_RE_DTE_VAL_VALID_TO Valid To
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 BP details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_RE_PRT_BP (
    MANDT,           -- Client [MANDT]
    PRT_BP_GUID,     -- BP GUID [CMS_RE_DTE_PRT_BP_GUID]
    OBJ_PRT_GUID,    -- Part GUID [CMS_RE_DTE_OBJ_PRT_GUID]
    PART_ID,         -- Part ID [CMS_RE_DTE_PART_ID]
    BUPA_ID,         -- BuPa ID [CMS_RE_DTE_BUPA_ID]
    BPF,             -- PartnerFunction [CMS_DTE_BPF]
    BUPA_SHARE_NR,   -- Share Num [CMS_RE_DTE_BUPA_NR]
    BUPA_SHARE_DR,   -- Share Den [CMS_RE_DTE_BUPA_DR]
    BP_VALID_FROM,   -- Valid From [CMS_RE_DTE_VAL_VALID_FROM]
    BP_VALID_TO,     -- Valid To [CMS_RE_DTE_VAL_VALID_TO]
    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_BP_GUID)
);

Learn More