MMPUR_EXT_T024

Transparent Table Application Table
8 Fields 2 CDS Views

Extracted backend Purchasing Groups

MMPUR_EXT_T024 is an SAP database table in S/4HANA. Extracted backend Purchasing Groups. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProcmtHubPurgGroup view from BASIC Basic view for backend Purch Grp
I_ProcmtHubPurgGroupAPI01 view from BASIC Purchasing Group in Connected System

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purchasinggroup ekgrp Purch. Group
KEY extsourcesystem mmpur_d_source_sys Connected System ID
purchasinggroupname eknam Description
purchasinggroupphonenumber ektel Tel.No.Purch.Gp
phonenumber ad_tlnmbr Telephone
phonenumberextension ad_tlxtns Extension
emailaddress ad_smtpadr E-Mail Address

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.

-- Extracted backend Purchasing Groups
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_EXT_T024 (
    MANDT,                       -- Client [mandt]
    PURCHASINGGROUP,             -- Purch. Group [ekgrp]
    EXTSOURCESYSTEM,             -- Connected System ID [mmpur_d_source_sys]
    PURCHASINGGROUPNAME,         -- Description [eknam]
    PURCHASINGGROUPPHONENUMBER,  -- Tel.No.Purch.Gp [ektel]
    PHONENUMBER,                 -- Telephone [ad_tlnmbr]
    PHONENUMBEREXTENSION,        -- Extension [ad_tlxtns]
    EMAILADDRESS,                -- E-Mail Address [ad_smtpadr]
    PRIMARY KEY (MANDT, PURCHASINGGROUP, EXTSOURCESYSTEM)
);

Learn More