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