SAP Table

T438M Control Parameter for MRP -Material Level-

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

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

/ Fields

T438M columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyWERKS Plant CHAR 4 0 T001W WERKS_D
KeyMTART MRP Group CHAR 4 0 DISGR
BANER Creation Indicator for Purchase Requisitions CHAR 1 0 BANER
DISER Creation Indicator for MRP Lists CHAR 1 0 DISER
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
GTERM Scheduling according to purchasing info record or agreement CHAR 1 0 GTERM
KZDRB Indicator: direct procurement/production MRP CHAR 1 0 KZDRB
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
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
RVPKZ Adjustment of Planned Independent Requirements CHAR 1 0 RVPKZ
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
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
BESAL Determination of explosion date for BOM and routing CHAR 1 0 BESAD
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
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
/ Relationships

T438M foreign keys.

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