SAP ABAP Table SDM_MATERIAL_KPI (Material KPI)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-MRP (Application Component) Material Requirements Planning
     ⤷ PPH_GENERAL (Package) PP on HANA: General Functions

Basic Data

Table Category	INTTAB	Structure
Structure	SDM_MATERIAL_KPI	Table Relationship Diagram
Short Description	Material KPI

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
2	MATERIALNAME	☐	MAKTX	TEXT40	CHAR	40	0	Material description
3	MATERIALTYPE	☐	MTART	MTART	CHAR	4	0	Material type	*
4	MATERIALABCCLASSIFICATION	☐	MAABC	MAABC	CHAR	1	0	ABC indicator	*
5	MATERIALPROCUREMENTCATEGORY	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
6	MATERIALPROCUREMENTCATNAME	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
7	MATERIALBASEUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
8	MRPPLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
9	MRPPLANTNAME	☐	NAME1	TEXT30	CHAR	30	0	Name
10	MRPAREA	☐	BERID	BERID	CHAR	10	0	MRP Area	*
11	MRPAREATEXT	☐	BERTX	BERTX	CHAR	40	0	MRP area text
12	MRPCONTROLLER	☐	DISPO	DISPO	CHAR	3	0	MRP controller	*
13	MRPCONTROLLERNAME	☐	DSNAM	TEXT18	CHAR	18	0	Name of MRP controller
14	MRPTYPE	☐	DISMM	DISMM	CHAR	2	0	MRP Type	*
15	MRPTYPENAME	☐	DIBEZ	DIBEZ	CHAR	30	0	Material requirements planning description
16	MATERIALPROCUREMENTSUBTYPE	☐	SOBSL	SOBSL	CHAR	2	0	Special procurement type	*
17	MATERIALPROCUREMENTSUBTYPENAME	☐	MATERIALPROCUREMENTSUBTYPENAME	TEXT40	CHAR	40	0	Material Procurement Subtype Description
18	MATERIALUSABILITYPROFILE	☐	MMSTA	MMSTA	CHAR	2	0	Plant-Specific Material Status	*
19	MATERIALUSABILITYPROFILENAME	☐	MTSTB	TEXT25	CHAR	25	0	Description of material status from MM/PP view
20	MATERIALGROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
21	MATERIALGROUPNAME	☐	WGBEZ	TEXT20	CHAR	20	0	Material Group Description
22	PURCHASINGGROUP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
23	PURCHASINGGROUPNAME	☐	EKNAM	TEXT18	CHAR	18	0	Description of purchasing group
24	MRPGROUP	☐	DISGR	DISGR	CHAR	4	0	MRP Group	*
25	MRPGROUPNAME	☐	MRPGROUPNAME	TEXT40	CHAR	40	0	MRP Group Description
26	MRPPLANNINGSEGMENTTYPE	☐	PLAAB	PLAAB	NUMC	2	0	Material requirements planning segment
27	MRPPLANNINGSEGMENT	☐	PLANR	PLANR	CHAR	20	0	Planning segment number
28	MRPAVAILABLESTOCKQTY	☐	MRPAVAILABLESTOCKQTY	MENG13	QUAN	13	3	Current Stock Quantity Available for MRP
29	MRPAVAILABLESTOCKQTYAMOUNT	☐	MRPAVAILABLESTOCKQTYAMOUNT	WERT	CURR	13	2	Value of Current Stock Available for MRP
30	COMPANYCODECURRENCY	☐	KWAER	WAERS	CUKY	5	0	Controlling area currency	*
31	MATERIALSAFETYSTOCKQTY	☐	EISBE	MENG13	QUAN	13	3	Safety stock
32	MATERIALSHORTAGETAB	☐	SDM_MATERIAL_SHORTAGE_TAB		TTYP	0	0
33	MATERIALAVAILABILITYTAB	☐	SDM_MATERIAL_AVAILABILITY_TAB		TTYP	0	0
34	NUMBEROFOVERDUERECEIPTS	☐	NUMBEROFOVERDUERECEIPTS		INT4	10	0	Number Of Overdue Receipts
35	NUMBEROFPLNDORDSINOPENINGHRZN	☐	NUMBEROFPLNDORDSINOPENINGHRZN		INT4	10	0	Number of Planned Orders in Opening Horizon
36	NUMBEROFUNRELDMFGORDSINRELHRZN	☐	NUMBEROFUNRELDMFGORDSINRELHRZN		INT4	10	0	Number of Unreleased Manufacturing Orders in Release Horizon
37	MATERIALGOODSRECEIPTDURATION	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
38	MATERIALPLANNEDPRODUCTIONDURN	☐	DZEIT	DEC3	DEC	3	0	In-house production time
39	MATERIALPLANNEDDELIVERYDURN	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
40	TOTALREPLENISHMENTLEADDURATION	☐	WZEIT	DEC3	DEC	3	0	Total replenishment lead time (in workdays)
41	MRPSAFETYDURATION	☐	SHZET	NUMC2	NUMC	2	0	Safety time (in workdays)
42	PLANNINGTIMEFENCE	☐	FXHOR	FXHOR	NUMC	3	0	Planning time fence

History

Last changed by/on	SAP	20140121
SAP Release Created in	616