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