TMPPF
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_Mfrpartproftemp | view | from | CONSUMPTION | Manufacture Part Profile |
| I_ManufacturerPartProfile | view | from | BASIC | Manufacturer Part Profile |
| P_Mfrpartprof | view | from | BASIC |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA