TMPPF

Transparent Table Customizing Table
15 Fields 3 CDS Views

Control Profile for Manufacturer Part Number Management

TMPPF is an SAP database table in S/4HANA. Control Profile for Manufacturer Part Number Management. It contains 15 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_Mfrpartproftemp view from CONSUMPTION Manufacture Part Profile
I_ManufacturerPartProfile view from BASIC Manufacturer Part Profile
P_Mfrpartprof view from BASIC

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY mprof mprof Mfr Part Profile
mpnpf mpnpf MPN Mandatory
mpnch mpnch MPN Change
mpinf mpinf Info Records f. MPN
mpqin mpqin QM Processing f. MPN
mppri mppri New Pricing
mpamp mpamp AMPL Management
mplis mplis Updating of LIS
mpbtx mpbtx PO Text for MPN Mat.
mprev mprev MPN rev. level
ckamp ckamp Checkg. Rule: Manuf.
nwquot nwquot Any Exch. in Quot
mpnim mpnim IM Manufacturer Part
resfff resfff IC FFF Classes

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.

-- Control Profile for Manufacturer Part Number Management
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TMPPF (
    MANDT,   -- Client [mandt]
    MPROF,   -- Mfr Part Profile [mprof]
    MPNPF,   -- MPN Mandatory [mpnpf]
    MPNCH,   -- MPN Change [mpnch]
    MPINF,   -- Info Records f. MPN [mpinf]
    MPQIN,   -- QM Processing f. MPN [mpqin]
    MPPRI,   -- New Pricing [mppri]
    MPAMP,   -- AMPL Management [mpamp]
    MPLIS,   -- Updating of LIS [mplis]
    MPBTX,   -- PO Text for MPN Mat. [mpbtx]
    MPREV,   -- MPN rev. level [mprev]
    CKAMP,   -- Checkg. Rule: Manuf. [ckamp]
    NWQUOT,  -- Any Exch. in Quot [nwquot]
    MPNIM,   -- IM Manufacturer Part [mpnim]
    RESFFF,  -- IC FFF Classes [resfff]
    PRIMARY KEY (MANDT, MPROF)
);

Learn More