SAP table T438M (Control Parameter for MRP -Material Level-)

SAP table T438M has 3 primary key fields being MANDT,WERKS,MTART.

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 T000 MANDT
WERKS Plant CHAR 4 0 T001W WERKS_D
MTART MRP Group CHAR 4 0 DISGR
BANER Creation Indicator for Purchase Requisitions CHAR 1 0 BANER
1 Purchase requisitions
2 Purchase requisitions in opening period
3 Planned orders
DISER Creation Indicator for MRP Lists CHAR 1 0 DISER
1 MRP list
2 Depending on the exception messages
3 No MRP list
UMTHZ Rescheduling horizon NUMC 3 0 UMTHZ
FIXHZ Planning Time Fence NUMC 3 0 FIXHZ
PLAHZ Planning horizon NUMC 3 0 PLAHZ
SBDIS Share of safety stock which can be used for planning NUMC 3 0 SBDIS
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
XFAT1 Firm Only Schedule Lines Transmitted to Vendor by Purchasing CHAR 1 0 XFAT1
XFAT2 Fant. 2 CHAR 1 0 XFAT2
VWVOR Tolerance value for bringing forward receipt elements NUMC 2 0 VWVOR
VWVER Tolerance value for displacement in the future NUMC 2 0 VWVER
PRREG Checking rule for the availability check CHAR 2 0 T441R PRREG
VRMOD Consumption mode CHAR 1 0 VRMOD
1 Backward consumption only
2 Backward/forward consumption
3 Forward consumption only
4 Forward/backward consumption
5 Period-specific consumption
VINT1 Consumption period: backward NUMC 3 0 VINT1
VINT2 Consumption period: forward NUMC 3 0 VINT2
STRGR Planning Strategy Group CHAR 2 0 T461P STRGR
RESHZ Roll forward period for the master plan DEC 2 0 RESHZ
ANDIS Number of Days After Which the Material Must Be Planned INT2 5 0 ANDIS
AUART Order Type CHAR 4 0 T003O AUFART
AUAR2 Order type for process order CHAR 4 0 T003O AUAR2
PLSEL Issue Storage Location Selection CHAR 1 0 PLSEL
1 Only components
2 Only assemblies
3 1st components / 2nd assemblies
4 1st assemblies / 2nd components
RVPKZ Adjustment of Planned Independent Requirements CHAR 1 0 RVPKZ
No adjustment
1 Adjustment in the future
2 Adjustment in the past
3 Adjustment in the future - only indep.reqmts w. consumption
4 Adjustment in the past - only indep. reqmts w. consumption
RESVP Period of adjustment for planned independent requirements DEC 3 0 RESVP
SHFLG Safety time indicator (with or without safety time) CHAR 1 0 SHFLG
Ignore safety time
1 Safety time for independent reqmts
2 Safety time for all requirements
SHZET Safety Time (in Workdays) NUMC 2 0 SHZET
MDACH Action Control: Planned Order Processing CHAR 2 0 T46AC MDACH
PRASTA Period split CHAR 5 0 T459S PRASTA
EXSGT Do not explode bulk material items CHAR 1 0 EXSGD
Setting from plant parameter
1 Generation of dependent requirements
2 No generation of dependent requirements
BESAL Determination of explosion date for BOM and routing CHAR 1 0 BESAD
Setting from plant parameter
1 Basic start date
2 Basic finish date
3 BOM explosion number/order start date
4 BOM explosion number/order finish date
BSART MRP:doc.type purchase requisitions for standard purchase ord CHAR 4 0 T161 BBSRT_NB
BARTL MRP: Document type purchase requisition for subcontracting CHAR 4 0 T161 BBSRT_LB
BARTU MRP: purchase requisition for stock transfer - document type CHAR 4 0 T161 BBSRT_UL
GRREL Relevant for requirements grouping for project stock CHAR 1 0 GRREL
VERTR Start date of order proposals allowed in the past CHAR 1 0 VERGR
Control at plant level
1 Start date in past allowed
2 Start date in past not allowed
FKOBS ATP check by full confirmation logic CHAR 1 0 FKOBS
EVAPR Evaluation Profile for Range-of-Coverage Data CHAR 3 0 T465 MD_EVAPR
PREQAPPROVAL Purchase Requisition Handover to Purchasing Required CHAR 1 0 PREQAPPROVAL

T438M foreign key relationships

Table Field Check Table Check Field
0 T438M AUAR2 T003O Order Types AUART
1 T438M AUART T003O Order Types AUART
0 T438M BARTL T161 Purchasing Document Types MANDT
1 T438M BARTU T161 Purchasing Document Types MANDT
0 T438M BSART T161 Purchasing Document Types MANDT
1 T438M EVAPR T465 Evaluation Profile Ranges of Coverage MANDT
1 T438M EVAPR T465 Evaluation Profile Ranges of Coverage EVAPR
0 T438M MDACH T46AC Action control MANDT
0 T438M MDACH T46AC Action control MDACH
0 T438M MDACH T46AC Action control ACCFM
0 T438M MDACH T46AC Action control ACCTO
1 T438M PRASTA T459S Period splitting MANDT
0 T438M PRREG T441R Values Table for Checking Rule MANDT
0 T438M PRREG T441R Values Table for Checking Rule PRREG
1 T438M STRGR T461P Planning strategy group MANDT
1 T438M STRGR T461P Planning strategy group STRGR
0 T438M WERKS T001W Plants/Branches WERKS