MDTB is an SAP table in package MD (Application development R/3 requirements planning), used in PP (Production Planning), PP-MRP (Material Requirements Planning). View details, fields & related tables of MDTB in SAP.
- Table description : MRP Table
- Module : PP (Production Planning)
- Component : PP-MRP (Material Requirements Planning)
- Package : MD
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP MDTB Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| DTNUM | Number of material requirements planning table | DTNUM | NUM10 |
| DTPOS | Item number of MRP list | DTPOS | NUM06 |
| PLAKZ | Indicator for planning segment | PLAKZ | PLAKZ |
| PLANR | Planning segment number | PLANR | PLANR |
| DAT00 | Receipt/Requirements date | DAT00 | DATUM |
| SORT1 | Sort indicator 01 | SORT1 | SORT1 |
| SORT2 | Sort indicator 02 | SORT2 | SORT2 |
| DELKZ | MRP element | DELKZ | DELKZ |
| VSTAT | Processing Status | VSTAT_D | VSTAT |
| VRFKZ | Availability indicator | VRFKZ | VRFKZ |
| PLUMI | Receipt/issue indicator | PLUMI | CHAR1 |
| MNG01 | Quantity received or quantity required | MNG01 | MENGV13 |
| MNG02 | Variable scrap quantity | MNG02 | MENG13 |
| MNG03 | Shortage Quantity | MNG03 | MENG13 |
| DAT01 | Delivery/order finish date | DAT01 | DATUM |
| DAT02 | Start/release date | DAT02 | DATUM |
| DAT03 | Opening date | DAT03 | DATUM |
| PERKZ | Period indicator | PERKZ | PERKZ |
| PRPER | Forecast period | PRPER | PRPER |
| WEBAZ | Goods receipt processing time in days | WEBAZ | DEC3 |
| FIX01 | Indicator: Fixing of Lot Size in Planned Order | FIX01 | XFELD |
| FIX02 | Indicator: fixing explosion in planned order | FIX02 | XFELD |
| BAART | P.O./Order type | BAART | BAART |
| BESKZ | Procurement Type | BESKZ | BESKZ |
| SOBES | Special procurement type | SOBES | SOBES |
| UMSKZ | Special G/L Indicator | UMSKZ | UMSKZ |
| PLART | Planning type | PLART | PLART |
| AUSSL | Exception message key | AUSSL | AUSSL |
| WRK02 | Planning/production plant | WRK02 | WERKS |
| LGORT | Storage location | LGORT_D | LGORT |
| DELNR | MRP element number | DELNR | DELNR |
| DELPS | MRP element item | DELPS | DELPS |
| DELET | Scheduling number planning element | DELET | DELET |
| AUFVR | Source number for order | AUFVR | CHAR10 |
| POSVR | Source item number | POSVR | NUM06 |
| EINVR | Source schedule line number | EINVR | NUM04 |
| UKZ01 | Indicator: MRP element can be brought forward | UKZ01 | XFELD |
| UMDAT | Rescheduling date | UMDAT | DATUM |
| DEL12 | MRP element number | DEL12 | DEL12 |
| BAUGR | Material number of higher-level assembly | BAUGR | MATNR |
| DELVR | MRP element | DELKZ | DELKZ |
| VERSB | Version number for independent requirements | VERSB | VERSB |
| OLDSL | Key of the second exception message | OLDSL | AUSSL |
| RDMNG | Excess stock quantity | RDMNG | MENG13 |
| PLAAB | Material requirements planning segment | PLAAB | PLAAB |
| TAG00 | Daily shift (sort indicator 0) | TAG00 | TAG00 |
| ABEKZ | Exception indicator | ABEKZ | CHAR1 |
| MDFST | Production order status: internal ind. for MRP | MDFST | CHAR1 |
| MDMNG | MRP: quantity field (stock in transit, receipt qty, ...) | MDMNG | MENGV13 |
| VERID | Production Version | VERID | VERID |
| WRK01 | Planning Plant | PLWRK | WERKS |
| SERNR | BOM explosion number | SERNR | SERNR |
| REVLV | Revision level | REVLV | REVLV |
| DBSKZ | Direct procurement indicator | DBSKZ | DBSKZ |
| EXTNL | Indicator for External Procurement | EXTNL | XFELD |
| ADINF | Field for Additional Information | MD_ADINF | MD_ADINF |
| RESLO | Issuing Storage Location for Stock Transport Order | RESLO | LGORT |
| PRIO_URG | Requirement Urgency | PRIO_URG | PRIO_URG |
| PRIO_REQ | Requirement Priority | PRIO_REQ | PRIO_REQ |
MDTB related tables
| Table | Note |
|---|---|
| CIF_TMRPDS | MRP DS: Customizing to Activate MRP based DS |
| MDFDDB | Firming Data of MRP - MRP Area |
| MPNSET | MPN-MRP Set: Group of Interchangeable MPNs in MRP |
| T000MD | MRP at MRP Area Level |
| CIF_IMMRPA | Integration Model Reference Table for MRP Areas |
| MDDMAP | Mapping Table for External User for MRP Evaluations |
| MDTAB | Cluster Table Initial Screen SRList/MRP List (Shared Buffer) |
| MDTB | MRP Table |
| MDTC | Aggregated MRP table items |
| PPH_MRP_PERIODS | Period table for lot-sizing in MRP |
| T440B | Control table for creating MRP record |
| T457S | Block table for MRP and forecast run |
| B033 | MRP Controller |
| B065 | MRP Controller |
| CIFMDVR | Version Management for MRP Area Changes |
Related tcodes for MDTB
Transaction codes in the same SAP package (MD) as the MDTB table.
| Tcode | Description |
|---|---|
| MD00 | MRP : external procurement |
| MD01 | MRP Run |
| MD03 | MRP-Individual Planning-Single Level |
| MD04 | Display Stock/Requirements Situation |
| MD05 | Individual Display Of MRP List |
| MD06 | Collective Display Of MRP List |
| MD11 | Create Planned Order |
| MD12 | Change Planned Order |
| MD13 | Display Planned Order |
| MD14 | Individual Conversion of Plnned Ord. |
| MD15 | Collective Conversion Of Plnd Ordrs. |
| MD16 | Collective Display of Planned Orders |
Latest Table Searches
Handling units sap table in SAPHow to display handling unit table in SAP
Sap handling unit zuordnung löschen table in SAP
Where to find handling unit table in SAP
Handling unit management configuration wm table in SAP
Handling unit wm table in SAP
What is sap handling unit table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP