MMPUR_EXT_LFA1

Transparent Table Application Table
11 Fields 1 CDS Views

Maintain Extracted Supplier Data from Back-End System

MMPUR_EXT_LFA1 is an SAP database table in S/4HANA. Maintain Extracted Supplier Data from Back-End System. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProcmtHubSupplier view from BASIC Basic view for backend supplier

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY extsourcesystem MMPUR_D_SOURCE_SYS Connected System ID
KEY supplier LIFNR Supplier
suppliername NAME1_GP Name
cityname ORT01_GP City
postalcode PSTLZ Postal Code
country LAND1_GP Country/Region Key
supplieraccountgroup KTOKK Account group
authorizationgroup BRGRU Authorization
region REGIO Region
streetname STRAS Street/House

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.

-- Maintain Extracted Supplier Data from Back-End System
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_EXT_LFA1 (
    MANDT,                 -- Client [MANDT]
    EXTSOURCESYSTEM,       -- Connected System ID [MMPUR_D_SOURCE_SYS]
    SUPPLIER,              -- Supplier [LIFNR]
    SUPPLIERNAME,          -- Name [NAME1_GP]
    CITYNAME,              -- City [ORT01_GP]
    POSTALCODE,            -- Postal Code [PSTLZ]
    COUNTRY,               -- Country/Region Key [LAND1_GP]
    SUPPLIERACCOUNTGROUP,  -- Account group [KTOKK]
    AUTHORIZATIONGROUP,    -- Authorization [BRGRU]
    REGION,                -- Region [REGIO]
    STREETNAME,            -- Street/House [STRAS]
    PRIMARY KEY (MANDT, EXTSOURCESYSTEM, SUPPLIER)
);

Learn More