MDTB is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of MDTB in SAP.
- Table description : MRP Table
- Module : CRM
- Parent Module : CRM
- Package : MD
- Software Component : BBPCRM
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 |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output 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