/SCMB/RESTMSHD

Transparent Table Application Table
41 Fields 1 CDS Views

Additional header table for TMS Resources

/SCMB/RESTMSHD is an SAP database table in S/4HANA. Additional header table for TMS Resources. It contains 41 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ResourceTransp view from BASIC Transportation Resource

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY resid /sapapo/resuid Internal Resrce
name /sapapo/cres_name Resource
restype /scmb/tmsrestype Resource Type
res_class /scmb/res_class Resource Class
tmsresuid uuid UUID
template /scmb/restmpl Res. Template
owner /scmb/resowner Owner
owneruid bupaguid Business partner
entitled /scmb/resentitled Authrzd User
entitleduid bupaguid Business partner
platenumber /scmb/resplatenr Registr. Number
platecountry /scmb/resplatectry Reg. No. C/R
minreqseals /scmb/res_minnoseal Min. No. Seals
builddate /scmb/res_build_date Build Date
inservicedate /scmb/res_insrcv_date In-Service Date
refmatid /scmb/mdl_pmatid Pack. Material
equitype /scmb/de_equi_type Equipment Group
equisztp /scmb/de_equi_code Equipment Type
equisuppl /scmb/equisupplier Equip. Supplier
valid_from /sapapo/cres_tzntstmps Time Stamp
valid_to /sapapo/cres_tzntstmps Time Stamp
orgcentre /scmb/organisationalcentre Org. Unit
em_relevance /scmb/res_em_relevance Event Mgnt
shipper_owned /scmb/shipper_owned Shipper-Owned
type_class /scmb/type_classification Type Classification
adr_limit_rel /scmb/rel_for_dg_adr_pts_limit Rlvnt for ADR Limit
pln_block /scmb/res_planning_block Planning Block
ext_ttype_flg /sapapo/tr_extttype_flg Multiresource
ext_ttype_num /sapapo/tr_extttype_num No. of Indiv. Res.
ownership_code /scmb/ownership_code Ownership
lease_contract_ref /scmb/lease_contract_ref Lease Contract
resource_condition /scmb/resource_condition Resource Condition
special_instruction /scmb/special_instruction Special Instruction
dflt_driver /scmb/default_driver Default Driver
dflt_driver_uid bupaguid Business partner
dflt_trailer /scmb/default_trailer Default Trailer
dflt_trailer_uid uuid UUID
cmprofile /sapapo/cm_profile Comp. Profile
res_spec_cmprofile /scmb/res_spec_cmprofile Res.Spec.Comp.Prof.
comb_res /scmb/comb_res_indicator Comb. Resource

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.

-- Additional header table for TMS Resources
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SCMB/RESTMSHD (
    MANDT,                -- Client [mandt]
    RESID,                -- Internal Resrce [/sapapo/resuid]
    NAME,                 -- Resource [/sapapo/cres_name]
    RESTYPE,              -- Resource Type [/scmb/tmsrestype]
    RES_CLASS,            -- Resource Class [/scmb/res_class]
    TMSRESUID,            -- UUID [uuid]
    TEMPLATE,             -- Res. Template [/scmb/restmpl]
    OWNER,                -- Owner [/scmb/resowner]
    OWNERUID,             -- Business partner [bupaguid]
    ENTITLED,             -- Authrzd User [/scmb/resentitled]
    ENTITLEDUID,          -- Business partner [bupaguid]
    PLATENUMBER,          -- Registr. Number [/scmb/resplatenr]
    PLATECOUNTRY,         -- Reg. No. C/R [/scmb/resplatectry]
    MINREQSEALS,          -- Min. No. Seals [/scmb/res_minnoseal]
    BUILDDATE,            -- Build Date [/scmb/res_build_date]
    INSERVICEDATE,        -- In-Service Date [/scmb/res_insrcv_date]
    REFMATID,             -- Pack. Material [/scmb/mdl_pmatid]
    EQUITYPE,             -- Equipment Group [/scmb/de_equi_type]
    EQUISZTP,             -- Equipment Type [/scmb/de_equi_code]
    EQUISUPPL,            -- Equip. Supplier [/scmb/equisupplier]
    VALID_FROM,           -- Time Stamp [/sapapo/cres_tzntstmps]
    VALID_TO,             -- Time Stamp [/sapapo/cres_tzntstmps]
    ORGCENTRE,            -- Org. Unit [/scmb/organisationalcentre]
    EM_RELEVANCE,         -- Event Mgnt [/scmb/res_em_relevance]
    SHIPPER_OWNED,        -- Shipper-Owned [/scmb/shipper_owned]
    TYPE_CLASS,           -- Type Classification [/scmb/type_classification]
    ADR_LIMIT_REL,        -- Rlvnt for ADR Limit [/scmb/rel_for_dg_adr_pts_limit]
    PLN_BLOCK,            -- Planning Block [/scmb/res_planning_block]
    EXT_TTYPE_FLG,        -- Multiresource [/sapapo/tr_extttype_flg]
    EXT_TTYPE_NUM,        -- No. of Indiv. Res. [/sapapo/tr_extttype_num]
    OWNERSHIP_CODE,       -- Ownership [/scmb/ownership_code]
    LEASE_CONTRACT_REF,   -- Lease Contract [/scmb/lease_contract_ref]
    RESOURCE_CONDITION,   -- Resource Condition [/scmb/resource_condition]
    SPECIAL_INSTRUCTION,  -- Special Instruction [/scmb/special_instruction]
    DFLT_DRIVER,          -- Default Driver [/scmb/default_driver]
    DFLT_DRIVER_UID,      -- Business partner [bupaguid]
    DFLT_TRAILER,         -- Default Trailer [/scmb/default_trailer]
    DFLT_TRAILER_UID,     -- UUID [uuid]
    CMPROFILE,            -- Comp. Profile [/sapapo/cm_profile]
    RES_SPEC_CMPROFILE,   -- Res.Spec.Comp.Prof. [/scmb/res_spec_cmprofile]
    COMB_RES,             -- Comb. Resource [/scmb/comb_res_indicator]
    PRIMARY KEY (MANDT, RESID)
);

Learn More