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