AMPL

Transparent Table Application Table
13 Fields 1 CDS Views

Table of Approved Manufacturer Parts

AMPL is an SAP database table in S/4HANA. Table of Approved Manufacturer Parts. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ApprdMfrPartsList view from BASIC

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bmatn mpmat Int. material no.
KEY ampnr ampnr Number
ematn ematn MPN: Material
mfrnr mfrnr Manufacturer
werks werks_mask Plant
datuv ampab Valid from
datub ampbi Valid to
revlv revlv Revision Level
ampsp ampsp Blocked
reoam reoam Deletion ind.
erdat erdat Created On
ernam ernam Created By

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.

-- Table of Approved Manufacturer Parts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AMPL (
    MANDT,  -- Client [mandt]
    BMATN,  -- Int. material no. [mpmat]
    AMPNR,  -- Number [ampnr]
    EMATN,  -- MPN: Material [ematn]
    MFRNR,  -- Manufacturer [mfrnr]
    WERKS,  -- Plant [werks_mask]
    DATUV,  -- Valid from [ampab]
    DATUB,  -- Valid to [ampbi]
    REVLV,  -- Revision Level [revlv]
    AMPSP,  -- Blocked [ampsp]
    REOAM,  -- Deletion ind. [reoam]
    ERDAT,  -- Created On [erdat]
    ERNAM,  -- Created By [ernam]
    PRIMARY KEY (MANDT, BMATN, AMPNR)
);

Learn More