SAP table T399D (Control Parameters for MRP)

SAP table T399D has 2 primary key fields being MANDT,WERKS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
WERKS Plant CHAR 4 0 T001W WERKS_D
FIXPA Indicator: take firmed planned orders into account CHAR 1 0 FIXPA
FIXBA Indicator: take firmed purchase requisitions into account CHAR 1 0 FIXBA
FIXBE Ind: take firmed order item/schedule line into account CHAR 1 0 FIXBE
UMTHZ Rescheduling horizon NUMC 3 0 UMTHZ
VWVOR Tolerance value for bringing forward receipt elements NUMC 2 0 VWVOR
VWVER Tolerance value for displacement in the future NUMC 2 0 VWVER
PLAHZ Planning horizon NUMC 3 0 PLAHZ
NKPAF Number range for planned orders CHAR 2 0 NKPAF
NKBAN Number range for purchase requisitions CHAR 2 0 NKBAN
PSBAN Item number of purchase requisition NUMC 5 0 PSBAN
NKDIS Number range for MRP lists CHAR 2 0 NKDIS
NKRES Number range for stock transfer reservations CHAR 2 0 NKRES
PSRES Item number of the stock transfer reservation NUMC 4 0 PSRES
BZTEK Processing time required by purchasing department NUMC 2 0 BZTEK
EREKG Substitute purchasing group for requirements planning CHAR 3 0 T024 EREKG
ERDSG Substitute MRP contoller/group for requirements planning CHAR 3 0 T024D ERDSG
MXBST Maximum Number of Purchase Order Proposals per Date NUMC 3 0 MXBST
MXPLA Number of planned orders to be read NUMC 3 0 MXPLA
ANZLS Display material list CHAR 1 0 ANZLS
MXSTA Runtime statistics: frequency of reporting NUMC 3 0 MXSTA
CSLID Selection ID for the BOM CHAR 2 0 TCS41 STLID
KTAGE Period grouping according to days CHAR 1 0 KTAGE
KWOCH Period grouping according to weeks CHAR 1 0 KWOCH
KMONA Period grouping according to months CHAR 1 0 KMONA
KFLPR Period grouping according to posting periods CHAR 1 0 KFLPR
KMRPP Period grouping according to planning calendar CHAR 1 0 KMRPP
MRRPP PPC Planning Calendar CHAR 3 0 T439G MRPPP
KRAST Period grouping according to individual split CHAR 1 0 KRAST
PRAST Period split CHAR 5 0 T449A PRAST
FIXFA Indicator: take production orders into account CHAR 1 0 FIXFA
APLSL Selection ID for routing alternatives CHAR 2 0 APLSL
LIFKZ Automatic Schedule Lines (Scheduling Agreements) CHAR 1 0 LIFKZ
1 No schedule lines
2 Schedule lines in the opening period
3 Schedule lines
GTERM Scheduling according to purchasing info record or agreement CHAR 1 0 GTERM
KZDRB Indicator: direct procurement/production MRP CHAR 1 0 KZDRB
Direct procurement only when creating production order
1 Trigger direct procurement in requirements planning
2 Direct procurement only when creating production order
3 Trigger direct procurement in requirements planning
KNTBE Account assig.type: account for sales order, no special stck CHAR 1 0 T163K KNTBE_D
KNTBU Account assignment category: unknown account assignment CHAR 1 0 T163K KNTBU
KTDBU Accnt asgnmt cat. for direct procuremt: unknown accnt asgnmt CHAR 1 0 T163K KTDBU
KZMAL Indicator: message desired CHAR 1 0 KZMAL
KZUMB Indicator: stock in transfer available for planning CHAR 1 0 KZUMB
FIXQM Quality management inspection lot can be given priority CHAR 1 0 FIXQM
XFAN1 Indicator: blocked stock available for planning CHAR 1 0 XFAN1
XFAN2 AccAssgtCat: acc. assgt according to project, no special stk CHAR 1 0 T163K XFAN2
XFAN3 Do not initiate the extended purch.ord. rel. strategy search CHAR 1 0 XFAN3
PRREG Checking rule for the availability check CHAR 2 0 T441R PRREG
AUART Order Type CHAR 4 0 T003O AUFART
FIXLA Indicator: take shipping notification into account CHAR 1 0 FIXLA
RPRRG Checking rule for the availability check CHAR 2 0 T441R PRREG
FEDIS MRP Controller CHAR 3 0 T024D DISPO
REFWK Reference plant CHAR 4 0 T001W REFWK
SIMPL Long-term planning allowed for a plant CHAR 1 0 SIMPL
SELFE Selection of production orders / process orders CHAR 1 0 SELFA
SELBE Sel.of POs, shpg notifications, sched. lines, dely scheds CHAR 1 0 SELBE
SELQM Selection of QM inspection lots CHAR 1 0 SELQM
SELBA Selection of firmed purchase requisitions CHAR 1 0 SELBA
SELPA Selection of firmed planned orders CHAR 1 0 SELPL
SELZR Selection of receipt reservations CHAR 1 0 SELZR
NKSBD Number range for simulative dependent requirements CHAR 2 0 NKSBD
VERTR Start date of order proposals allowed in the past CHAR 1 0 VERTR
AUAR2 Order type for process order CHAR 4 0 T003O AUAR2
NKSAF Number range of simulative planned order CHAR 2 0 NKSAF
WAKHZ Period for the promotion NUMC 3 0 WAKHZ
EXSGT Do Not Explode Bulk Material Items CHAR 1 0 EXSGT
BESAL Determine Explosion Date for BOM and Routing CHAR 1 0 BESAL
BOM explosion number/order start date
1 Order start date
2 Order finish date
3 BOM explosion number/order start date
4 BOM explosion number/order finish date
KASTL Procedure with sales order BOM/WBS BOM active CHAR 1 0 KASTL
NKCRQ Number range for total requirements CHAR 2 0 NKCRQ
SEREP BOM explosion number make-to-order/engineer-to-order prod. CHAR 1 0 SEREP
IKDPL Index sales order/planned order CHAR 1 0 IKDPL
SELSB Range of coverage including/excluding safety stock CHAR 1 0 SELSB
Days' supply until safety stock shortage
1 Days' supply until physical stock shortage
NFVBC Respect restricted-use stock (only for batches) CHAR 1 0 NFVBC
COMPM Transparent storage: MRP lists CHAR 1 0 DECOMPX
DBEPL Activate MRP areas at plant level CHAR 1 0 DBEPL
SELPZ Selection of assigned planned orders CHAR 1 0 SELPZ
SELLA Selection of shipping notifications CHAR 1 0 SELLA
SBUFF BOM Buffering in Shared Buffer CHAR 1 0 MD_SBUFF
SELIW Matl ROC incl. dely note with status 'In Plant' CHAR 1 0 SELIW
DSADA Generate serial number from APO for requirements? CHAR 1 0 DSADA
EVAPR Evaluation Profile for Range-of-Coverage Data CHAR 3 0 T465 MD_EVAPR

T399D foreign key relationships

Table Field Check Table Check Field
0 T399D AUAR2 T003O Order Types AUART
1 T399D AUART T003O Order Types AUART
0 T399D CSLID TCS41 Automatic alternative BOM determination MANDT
1 T399D ERDSG T024D MRP Controllers MANDT
1 T399D ERDSG T024D MRP Controllers WERKS
1 T399D ERDSG T024D MRP Controllers DISPO
0 T399D EREKG T024 Purchasing Groups EKGRP
1 T399D EVAPR T465 Evaluation Profile Ranges of Coverage MANDT
1 T399D EVAPR T465 Evaluation Profile Ranges of Coverage EVAPR
0 T399D FEDIS T024D MRP Controllers MANDT
0 T399D FEDIS T024D MRP Controllers WERKS
0 T399D FEDIS T024D MRP Controllers DISPO
1 T399D KNTBE T163K Account Assignment Categories in Purchasing Document MANDT
1 T399D KNTBE T163K Account Assignment Categories in Purchasing Document KNTTP
0 T399D KNTBU T163K Account Assignment Categories in Purchasing Document MANDT
0 T399D KNTBU T163K Account Assignment Categories in Purchasing Document KNTTP
1 T399D KTDBU T163K Account Assignment Categories in Purchasing Document MANDT
1 T399D KTDBU T163K Account Assignment Categories in Purchasing Document KNTTP
0 T399D MRRPP T439G PP Planning periods: header table MANDT
0 T399D MRRPP T439G PP Planning periods: header table WERKS
1 T399D PRAST T449A Period split MANDT
0 T399D PRREG T441R Values Table for Checking Rule MANDT
0 T399D PRREG T441R Values Table for Checking Rule PRREG
1 T399D REFWK T001W Plants/Branches MANDT
1 T399D REFWK T001W Plants/Branches WERKS
0 T399D RPRRG T441R Values Table for Checking Rule MANDT
0 T399D RPRRG T441R Values Table for Checking Rule PRREG
1 T399D WERKS T001W Plants/Branches WERKS
0 T399D XFAN2 T163K Account Assignment Categories in Purchasing Document MANDT
0 T399D XFAN2 T163K Account Assignment Categories in Purchasing Document KNTTP