LMD_VR_VSTNG_RL

Transparent Table Application Table
9 Fields 2 CDS Views

LMD Visiting Rule

LMD_VR_VSTNG_RL is an SAP database table in S/4HANA. LMD Visiting Rule. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_LastMileVisitingRule view_entity from EXTENSION LMD Visiting Rule - Extension
I_LastMileVisitingRule view_entity from BASIC LMD Visiting Rule

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY visiting_rule_uuid LMD_VR_UUID Visiting Rule UUID
visiting_rule_id LMD_VR_ID Visiting Rule ID
reference_uuid LMD_VR_REFERENCE_UUID Reference UUID
reference_type LMD_VR_REFERENCE_TYPE Reference Type
factory_calendar LMD_VR_FACTORY_CALENDAR Factory Calendar for Visiting Rule
last_change_on LMD_COM_TIMESTAMP Timestamp
lifecycle_status LMD_VR_LIFECYCLE_STATUS Lifecycle Status of Visiting Rule
dummy_lmd_vr_rule_incl_eew_ps DUMMY Dummy function in length 1

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.

-- LMD Visiting Rule
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LMD_VR_VSTNG_RL (
    CLIENT,                         -- Client [MANDT]
    VISITING_RULE_UUID,             -- Visiting Rule UUID [LMD_VR_UUID]
    VISITING_RULE_ID,               -- Visiting Rule ID [LMD_VR_ID]
    REFERENCE_UUID,                 -- Reference UUID [LMD_VR_REFERENCE_UUID]
    REFERENCE_TYPE,                 -- Reference Type [LMD_VR_REFERENCE_TYPE]
    FACTORY_CALENDAR,               -- Factory Calendar for Visiting Rule [LMD_VR_FACTORY_CALENDAR]
    LAST_CHANGE_ON,                 -- Timestamp [LMD_COM_TIMESTAMP]
    LIFECYCLE_STATUS,               -- Lifecycle Status of Visiting Rule [LMD_VR_LIFECYCLE_STATUS]
    DUMMY_LMD_VR_RULE_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (CLIENT, VISITING_RULE_UUID)
);

Learn More