AGR_TEXTS

Transparent Table Control Table (SAP+Cust)
5 Fields 3 CDS Views

Ablagestruktur für hierarchisches Menü - Kunde

AGR_TEXTS is an SAP database table in S/4HANA. Ablagestruktur für hierarchisches Menü - Kunde. It contains 5 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_PFCG_AGR_TEXTS_MAX view from Max Line of AGR_TEXTS
P_USER_ROLE view left_outer Get roles for users with reference user
P_USR_AUTH_ROLE view inner User with Roles or Authorizations

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt symandt Client ID
KEY agr_name agr_name Role
KEY spras menu_spras Language
KEY line menu_num_5 ID
text agr_title Short Description

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.

-- Ablagestruktur für hierarchisches Menü - Kunde
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AGR_TEXTS (
    MANDT,     -- Client ID [symandt]
    AGR_NAME,  -- Role [agr_name]
    SPRAS,     -- Language [menu_spras]
    LINE,      -- ID [menu_num_5]
    TEXT,      -- Short Description [agr_title]
    PRIMARY KEY (MANDT, AGR_NAME, SPRAS, LINE)
);

Learn More