PLMCROBM_D

Transparent Table Application Table
41 Fields 1 CDS Views

Draft table for entity R_ChgRecdRefOrdBOMTP

PLMCROBM_D is an SAP database table in S/4HANA. Draft table for entity R_ChgRecdRefOrdBOMTP. It contains 41 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ChgRecdRefOrdBOMDraft view_entity from BASIC Query View for Sales Order BOM Draft

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY changerecordreferenceuuid /bobf/conf_key NodeID
chgrecrefinternalkey1 /iam/internal_id Key
chgrecrefinternalkey2 /iam/internal_id Key
chgrecrefinternalkey3 /iam/internal_id Key
chgrecrefinternalkey4 /iam/internal_id Key
billofmaterial cs_stlnr BOM
billofmaterialcategory stlty BOM category
billofmaterialvariant stalt Alternative
billofmaterialvariantusage stlan Usage
material matnr Material
plant werks_d Plant
salesorder cs_vbeln Sales Order
salesorderitem cs_vbpos Item
changerecorduuid /bobf/conf_key NodeID
changerecordreferencetype /iam/type Object Type
changerecordreferencesubtype /iam/subtype Subtype
changerecordreference /iam/ref_id Ref. Object ID
parentchangerecordrefuuid /iam/conf_key Node ID
ismainreference /iam/main_ref_ind Main Reference
chgrecdreasonforchange /plmb/cc_aegru Reason for Chge
expdcompltndte /plmb/cr_expt_comp Exp Completion Date
chgrecdauthzngrptext /iam/auth_group Authoriz. Group
createdbyuser /bofu/user_id_created_by Created By
creationdatetime tzntstmps Time Stamp
lastchangedbyuser /bofu/user_id_changed_by Changed By
lastchangedatetime tzntstmps Time Stamp
changerecorditemrelevance /iam/cr_itemrel Relevance
changerecordvirtualrefind /iam/virtual_ref_ind Virtual Reference
changerecorditemprocgstatus /plmb/cr_item_proc_status Processing Status
chgrecdnextitemprocgstatus /plmb/cr_item_proc_status Processing Status
partner /plmb/cr_chg_responsible Chg Responsible
chgstatus /plmb/ecn_status Status
chgrecdnmbrchgsts /plmb/ecn_status Status
changenumber /plmi/cr_aennr Change Number
billofmaterialversion cs_versn BOM Version
changerecordtype /plmb/cr_type Record Type
changerecordlifecyclestatus /iam/issue_lcycle_stat_cd Issue Lifecycle
chgrecditmtgtsts /plmb/cr_item_tgt_proc_status Tgt Proc. Sts
chgrecditmdsgntr /plmb/cr_i_dgsign Itm. Dgt. Sign.
changerecorditemtype /plmi/chg_itm_type

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.

-- Draft table for entity R_ChgRecdRefOrdBOMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLMCROBM_D (
    MANDT,                         -- Client [mandt]
    CHANGERECORDREFERENCEUUID,     -- NodeID [/bobf/conf_key]
    CHGRECREFINTERNALKEY1,         -- Key [/iam/internal_id]
    CHGRECREFINTERNALKEY2,         -- Key [/iam/internal_id]
    CHGRECREFINTERNALKEY3,         -- Key [/iam/internal_id]
    CHGRECREFINTERNALKEY4,         -- Key [/iam/internal_id]
    BILLOFMATERIAL,                -- BOM [cs_stlnr]
    BILLOFMATERIALCATEGORY,        -- BOM category [stlty]
    BILLOFMATERIALVARIANT,         -- Alternative [stalt]
    BILLOFMATERIALVARIANTUSAGE,    -- Usage [stlan]
    MATERIAL,                      -- Material [matnr]
    PLANT,                         -- Plant [werks_d]
    SALESORDER,                    -- Sales Order [cs_vbeln]
    SALESORDERITEM,                -- Item [cs_vbpos]
    CHANGERECORDUUID,              -- NodeID [/bobf/conf_key]
    CHANGERECORDREFERENCETYPE,     -- Object Type [/iam/type]
    CHANGERECORDREFERENCESUBTYPE,  -- Subtype [/iam/subtype]
    CHANGERECORDREFERENCE,         -- Ref. Object ID [/iam/ref_id]
    PARENTCHANGERECORDREFUUID,     -- Node ID [/iam/conf_key]
    ISMAINREFERENCE,               -- Main Reference [/iam/main_ref_ind]
    CHGRECDREASONFORCHANGE,        -- Reason for Chge [/plmb/cc_aegru]
    EXPDCOMPLTNDTE,                -- Exp Completion Date [/plmb/cr_expt_comp]
    CHGRECDAUTHZNGRPTEXT,          -- Authoriz. Group [/iam/auth_group]
    CREATEDBYUSER,                 -- Created By [/bofu/user_id_created_by]
    CREATIONDATETIME,              -- Time Stamp [tzntstmps]
    LASTCHANGEDBYUSER,             -- Changed By [/bofu/user_id_changed_by]
    LASTCHANGEDATETIME,            -- Time Stamp [tzntstmps]
    CHANGERECORDITEMRELEVANCE,     -- Relevance [/iam/cr_itemrel]
    CHANGERECORDVIRTUALREFIND,     -- Virtual Reference [/iam/virtual_ref_ind]
    CHANGERECORDITEMPROCGSTATUS,   -- Processing Status [/plmb/cr_item_proc_status]
    CHGRECDNEXTITEMPROCGSTATUS,    -- Processing Status [/plmb/cr_item_proc_status]
    PARTNER,                       -- Chg Responsible [/plmb/cr_chg_responsible]
    CHGSTATUS,                     -- Status [/plmb/ecn_status]
    CHGRECDNMBRCHGSTS,             -- Status [/plmb/ecn_status]
    CHANGENUMBER,                  -- Change Number [/plmi/cr_aennr]
    BILLOFMATERIALVERSION,         -- BOM Version [cs_versn]
    CHANGERECORDTYPE,              -- Record Type [/plmb/cr_type]
    CHANGERECORDLIFECYCLESTATUS,   -- Issue Lifecycle [/iam/issue_lcycle_stat_cd]
    CHGRECDITMTGTSTS,              -- Tgt Proc. Sts [/plmb/cr_item_tgt_proc_status]
    CHGRECDITMDSGNTR,              -- Itm. Dgt. Sign. [/plmb/cr_i_dgsign]
    CHANGERECORDITEMTYPE,          -- /plmi/chg_itm_type
    PRIMARY KEY (MANDT, CHANGERECORDREFERENCEUUID)
);

Learn More