SAP ABAP Table MDUP (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | MDUP |
|
| Short Description | Generated Table for View |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | ||
| 3 | |
PWWRK | WERKS | CHAR | 4 | 0 | Production plant in planned order | ||
| 4 | |
PLNUM | PLNUM | CHAR | 10 | 0 | Planned order number | PLAF | |
| 5 | |
OBART | OBART | CHAR | 1 | 0 | Object type | ||
| 6 | |
PLSCN | PLSCN | NUMC | 3 | 0 | Planning Scenario of Long-Term Planning | PLSC | |
| 7 | |
PLWRK | WERKS | CHAR | 4 | 0 | Planning Plant | T001W | |
| 8 | |
PAART | PAART | CHAR | 4 | 0 | Order type | ||
| 9 | |
BESKZ | BESKZ | CHAR | 1 | 0 | Procurement Type | ||
| 10 | |
SOBES | SOBES | CHAR | 1 | 0 | Special procurement type | ||
| 11 | |
GSMNG | MENG13 | QUAN | 13 | 3 | Total planned order quantity | ||
| 12 | |
AVMNG | MENG13 | QUAN | 13 | 3 | Fixed quantity of scrap from production | ||
| 13 | |
ABMNG | MENGE | QUAN | 13 | 3 | Reduced quantity in the planned order | ||
| 14 | |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
| 15 | |
PSTTR | DATUM | DATS | 8 | 0 | Order start date in planned order | ||
| 16 | |
PEDTR | DATUM | DATS | 8 | 0 | Order finish date in the planned order | ||
| 17 | |
PERTR | DATUM | DATS | 8 | 0 | Planned opening date in planned order | ||
| 18 | |
PLWEZ | DEC3 | DEC | 3 | 0 | Goods receipt processing time in days | ||
| 19 | |
DISPO | DISPO | CHAR | 3 | 0 | MRP controller | T024D | |
| 20 | |
PLUMS | XFELD | CHAR | 1 | 0 | Conversion indicator for planned order | ||
| 21 | |
PLAFX | XFELD | CHAR | 1 | 0 | Firming indicator for planned order data | ||
| 22 | |
PLSFX | XFELD | CHAR | 1 | 0 | Fixing indicator for BOM explosion | ||
| 23 | |
KNTTP | KNTTP | CHAR | 1 | 0 | Account assignment category | T163K | |
| 24 | |
KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | VBUK | |
| 25 | |
KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
| 26 | |
KDEIN | NUM04 | NUMC | 4 | 0 | Delivery schedule for sales order | ||
| 27 | |
KZVBR | KZVBR | CHAR | 1 | 0 | Consumption posting | ||
| 28 | |
SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | T148 | |
| 29 | |
PS_POSNR | PS_POSNR | NUMC | 8 | 0 | WBS Element | ||
| 30 | |
ARSNR | MDNUM | NUMC | 10 | 0 | Settlement reservation number | ||
| 31 | |
ARSPS | RSPOS | NUMC | 4 | 0 | Item number of the settlement reservation | ||
| 32 | |
LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
| 33 | |
SERNR | SERNR | CHAR | 8 | 0 | BOM explosion number | SNUM | |
| 34 | |
REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
| 35 | |
RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | ||
| 36 | |
SA_VERTO | SA_VERTL | CHAR | 4 | 0 | Distribution key for quantity produced | ||
| 37 | |
FRTHW | FRTHW | CHAR | 1 | 0 | Production note in the planned order | ||
| 38 | |
QUNUM | QUNUM | CHAR | 10 | 0 | Number of quota arrangement | ||
| 39 | |
QUPOS | NUM03 | NUMC | 3 | 0 | Quota arrangement item | ||
| 40 | |
FLIEF | LIFNR | CHAR | 10 | 0 | Fixed vendor | LFA1 | |
| 41 | |
KONNR | EBELN | CHAR | 10 | 0 | Number of principal purchase agreement | EKKO | |
| 42 | |
KTPNR | EBELP | NUMC | 5 | 0 | Item number of principal purchase agreement | EKPO | |
| 43 | |
EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
| 44 | |
PALTR | DATUM | DATS | 8 | 0 | Explosion date | ||
| 45 | |
TECHS | TECHS | CHAR | 12 | 0 | Parameter Variant/Standard Variant | ||
| 46 | |
STLAN | STLAN | CHAR | 1 | 0 | BOM Usage | ||
| 47 | |
STALT | ALTNR | CHAR | 2 | 0 | Alternative BOM | ||
| 48 | |
STLST | STLST | NUMC | 2 | 0 | BOM Statuses | T415S | |
| 49 | |
AENNR | AENNR | CHAR | 12 | 0 | Change Number | ||
| 50 | |
VERID | VERID | CHAR | 4 | 0 | Production Version | ||
| 51 | |
SA_AUFNR | SA_AUFNR | CHAR | 12 | 0 | Run schedule header number | SAFK | |
| 52 | |
TRART | CHAR1 | CHAR | 1 | 0 | Scheduling type of the planned order | ||
| 53 | |
FEVOR | FEVOR | CHAR | 3 | 0 | Production Supervisor | ||
| 54 | |
TERST | DATUM | DATS | 8 | 0 | Start date for production | ||
| 55 | |
TERED | DATUM | DATS | 8 | 0 | Finish date for production | ||
| 56 | |
BEDID | BEDID | NUMC | 12 | 0 | ID of the capacity requirements record | ||
| 57 | |
CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
| 58 | |
TRMFL | XFELD | CHAR | 1 | 0 | Scheduling indicator | ||
| 59 | |
TRMER | TRMER | CHAR | 2 | 0 | Scheduling error | ||
| 60 | |
REDKZ | REDKZ | CHAR | 1 | 0 | Reduction indicator for scheduling | ||
| 61 | |
TRMHK | TRMHK | CHAR | 1 | 0 | Scheduling source | ||
| 62 | |
PLNNR | PLNNR | CHAR | 8 | 0 | Key for Task List Group | ||
| 63 | |
PLNAL | ALTNR | CHAR | 2 | 0 | Group Counter | ||
| 64 | |
NUMVR | NUMVR | NUMC | 2 | 0 | Version number | ||
| 65 | |
PLNTY | PLNTY | CHAR | 1 | 0 | Task List Type | ||
| 66 | |
CO_RGEKZ | CO_RGEKZ | CHAR | 1 | 0 | Indicator: Backflushing for order | ||
| 67 | |
CUOBJ | CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
| 68 | |
RATID | BEDID | NUMC | 12 | 0 | Index for the results of scheduling production rates | ||
| 69 | |
GROID | BEDID | NUMC | 12 | 0 | Index for rough scheduling results | ||
| 70 | |
RATER | TRMER | CHAR | 2 | 0 | Scheduling error in scheduling production rates | ||
| 71 | |
GROER | TRMER | CHAR | 2 | 0 | Scheduling error in rough scheduling | ||
| 72 | |
SBNUM | SBNUM | NUMC | 10 | 0 | Simulation requirements number | ||
| 73 | |
KBNKZ | KBNKZ | CHAR | 1 | 0 | Kanban Indicator | ||
| 74 | |
KAPFX | XFELD | CHAR | 1 | 0 | Indicator: capacity for planned order dispatched | ||
| 75 | |
PSTTI | UZEIT | TIMS | 6 | 0 | Start Time of Planned Order | ||
| 76 | |
PEDTI | UZEIT | TIMS | 6 | 0 | End Time of Planned Order | ||
| 77 | |
MONKZ | XFELD | CHAR | 1 | 0 | Indicator: for assembly order procedures | ||
| 78 | |
PRNKZ | KREUZ | CHAR | 1 | 0 | Ind.: Leading order in collective order is planned ordre | ||
| 79 | |
MDPBV | MDPBV | CHAR | 1 | 0 | Planned order: confirmation of availability | ||
| 80 | |
VFMNG | MENG13 | QUAN | 13 | 3 | Planned order: committed quantity | ||
| 81 | |
MDACH | MDACH | CHAR | 2 | 0 | Action control: planned order processing | T46AC | |
| 82 | |
MDACC | MDACC | CHAR | 4 | 0 | Action: planned order processing | T46AS | |
| 83 | |
MDACD | DATUM | DATS | 8 | 0 | Date of action: planned order | ||
| 84 | |
MDACT | UZEIT | TIMS | 6 | 0 | Time of action: Planned order processing | ||
| 85 | |
GSBTR_PLAF | DATUM | DATS | 8 | 0 | Total commitment date of plnd ord. after ATP check f.comps. | ||
| 86 | |
PLETX | XFELD | CHAR | 1 | 0 | Planned order shift quantities exist | ||
| 87 | |
MD_PRSCHED | XFELD | CHAR | 1 | 0 | Planned order: scheduling using production dates | ||
| 88 | |
MD_LVSCHED | SCHED_TYPE | CHAR | 1 | 0 | Planned order: leading scheduling level (determines dates) | ||
| 89 | |
CY_SEQNR | CY_SEQNR | NUMC | 14 | 0 | Seq. number order | ||
| 90 | |
VRPLA | XFELD | CHAR | 1 | 0 | Indicator: planning without final assembly | ||
| 91 | |
PBDNR | CHAR10 | CHAR | 10 | 0 | Requirements Plan Number | ||
| 92 | |
KZBWS | KZBWS | CHAR | 1 | 0 | Valuation of Special Stock | ||
| 93 | |
EDGNO | EDGNO | NUMC | 17 | 0 | Internal number for edge of object dependencies tree | M60I | |
| 94 | |
BERID | BERID | CHAR | 10 | 0 | MRP Area | MDLV | |
| 95 | |
RESLO | LGORT | CHAR | 4 | 0 | Issuing Storage Location for Stock Transport Order |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | MDUP | AUFNR | |
|
REF | C | CN |
| 2 | MDUP | BERID | |
|
|||
| 3 | MDUP | DISPO | |
|
KEY | 1 | CN |
| 4 | MDUP | EDGNO | |
|
|||
| 5 | MDUP | EKORG | |
|
REF | C | CN |
| 6 | MDUP | FLIEF | |
|
REF | C | CN |
| 7 | MDUP | KDAUF | |
|
KEY | 1 | CN |
| 8 | MDUP | KNTTP | |
|
KEY | 1 | CN |
| 9 | MDUP | KONNR | |
|
REF | C | CN |
| 10 | MDUP | KTPNR | |
|
REF | C | CN |
| 11 | MDUP | LGORT | |
|
KEY | 1 | CN |
| 12 | MDUP | MANDT | |
|
KEY | 1 | CN |
| 13 | MDUP | MDACC | |
|
1 | CN | |
| 14 | MDUP | MDACH | |
|
REF | 1 | CN |
| 15 | MDUP | MEINS | |
|
REF | 1 | CN |
| 16 | MDUP | PLNUM | |
|
KEY | 1 | CN |
| 17 | MDUP | PLSCN | |
|
|||
| 18 | MDUP | PLWRK | |
|
KEY | 1 | CN |
| 19 | MDUP | SERNR | |
|
REF | C | C |
| 20 | MDUP | SOBKZ | |
|
|||
| 21 | MDUP | STSTA | |
|
REF | C | CN |
History
| Last changed by/on | SAP | 20110901 |
| SAP Release Created in |