PPMD_AOR_PREF

Transparent Table Temporary Data
6 Fields 2 CDS Views

Table for storing user preferences

PPMD_AOR_PREF is an SAP database table in S/4HANA. Table for storing user preferences. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MassMaintCapAreaOfRespyPref view_entity from BASIC Area Of Responsibility Preferences
I_ProdnPlngMstrDtaAORPref view_entity from BASIC AOR Preference for PP Master Data

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY aor_id pp_aor_id AOR ID
KEY uname xubname User
KEY prefpatternid pp_aor_prefpatternid AOR Preference Id
isaormaintained pp_aor_maint_status AOR is Maintained
lastchange_datetime cr_lastchange_datetime Date and Time of Last Change

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.

-- Table for storing user preferences
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPMD_AOR_PREF (
    MANDT,                -- Client [mandt]
    AOR_ID,               -- AOR ID [pp_aor_id]
    UNAME,                -- User [xubname]
    PREFPATTERNID,        -- AOR Preference Id [pp_aor_prefpatternid]
    ISAORMAINTAINED,      -- AOR is Maintained [pp_aor_maint_status]
    LASTCHANGE_DATETIME,  -- Date and Time of Last Change [cr_lastchange_datetime]
    PRIMARY KEY (MANDT, AOR_ID, UNAME, PREFPATTERNID)
);

Learn More