SAP ABAP Table MDFE (Line item for run schedule plan value display)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MD (Package) Application development R/3 requirements planning
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MD (Package) Application development R/3 requirements planning
Basic Data
Table Category | INTTAB | Structure |
Structure | MDFE | Table Relationship Diagram |
Short Description | Line item for run schedule plan value display |
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 | ZEILE | PT_ZEILE | INT4 | INT4 | 10 | 0 | Row number in planning table | ||
2 | SPALT | DZLSP1 | ZLSP1 | NUMC | 4 | 0 | Line | ||
3 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
4 | PLAAB | PLAAB | PLAAB | NUMC | 2 | 0 | Material requirements planning segment | ||
5 | PLANR | PLANR | PLANR | CHAR | 20 | 0 | Planning segment number | ||
6 | DAT00 | DAT00 | DATUM | DATS | 8 | 0 | Receipt/Requirements date | ||
7 | DELKZ | DELKZ | DELKZ | CHAR | 2 | 0 | MRP element | ||
8 | FREKZ | FREKZ | FREKZ | CHAR | 1 | 0 | Indicator in MDFEX: whether prod. order is released | ||
9 | INDEX | SA_INDEX | INT4 | INT4 | 10 | 0 | Original index | ||
10 | AEFLG | SA_AEFLG | SA_AEFLG | CHAR | 1 | 0 | Change flag | ||
11 | MNG01 | SA_MNG01 | MENGV13 | QUAN | 13 | 3 | Quantity received or quantity required | ||
12 | MNG02 | MNG02 | MENG13 | QUAN | 13 | 3 | Variable scrap quantity | ||
13 | MNG03 | SA_MNG03 | MENG13 | QUAN | 13 | 3 | Quantity of goods received | ||
14 | MNG04 | SA_MNG04 | MENG13 | QUAN | 13 | 3 | Scrap quantity | ||
15 | MNG05 | SA_MNG05 | MENG13 | QUAN | 13 | 3 | Goods receipt quantity to date | ||
16 | MNG06 | SA_MNG06 | MENG13 | QUAN | 13 | 3 | Actual scrap quantity to date | ||
17 | DAT01 | DAT01 | DATUM | DATS | 8 | 0 | Delivery/order finish date | ||
18 | DAT02 | DAT02 | DATUM | DATS | 8 | 0 | Start/release date | ||
19 | DAT03 | DAT03 | DATUM | DATS | 8 | 0 | Opening date | ||
20 | FIX01 | FIX01 | XFELD | CHAR | 1 | 0 | Indicator: Fixing of Lot Size in Planned Order | ||
21 | FIX02 | FIX02 | XFELD | CHAR | 1 | 0 | Indicator: fixing explosion in planned order | ||
22 | AUFNR | SA_AUFNR | SA_AUFNR | CHAR | 12 | 0 | Run schedule header number | * | |
23 | GMEIN | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
24 | PLWRK | PLWRK | WERKS | CHAR | 4 | 0 | Planning Plant | T001W | |
25 | PWWRK | PWWRK | WERKS | CHAR | 4 | 0 | Production plant in planned order | T001W | |
26 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
27 | VERID | VERID | VERID | CHAR | 4 | 0 | Production Version | MKAL | |
28 | PLNUM | PLNUM | PLNUM | CHAR | 10 | 0 | Planned order number | * | |
29 | LINID | SP_OPID | SP_OPID | NUMC | 15 | 0 | ID for a schedule record | ||
30 | MDV01 | MDV01 | MDVXX | CHAR | 8 | 0 | Production line | * | |
31 | MDV02 | MDV02 | MDVXX | CHAR | 8 | 0 | Planning identification 2 | * | |
32 | LINHI | LD_LINE | ARBPL | CHAR | 8 | 0 | Line hierarchy | ||
33 | VERTL | SA_VERTL | SA_VERTL | CHAR | 4 | 0 | MRP Distribution Key | * | |
34 | SELEC | SELEKT | SEL | CHAR | 1 | 0 | Selection indicator | ||
35 | FAUFN | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
36 | POSNR | CO_POSNR | CO_POSNR | NUMC | 4 | 0 | Order item number | ||
37 | ELIKZ | ELIKZ_SA | XFELD | CHAR | 1 | 0 | Final delivery indicator for repetitive manufacturing | ||
38 | RSNUM | RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | * | |
39 | ERUKZ | SA_ERUKZ | XFELD | CHAR | 1 | 0 | Final backflush indicator | ||
40 | EENKZ | SA_EENKZ | XFELD | CHAR | 1 | 0 | End withdrawal indicator | ||
41 | NFRKZ | SA_NFRKZ | XFELD | CHAR | 1 | 0 | Indicator: production order not released | ||
42 | AFGKA | AFGKA | SA_AEFLG | CHAR | 1 | 0 | Change flag for capacity planning | ||
43 | KPART | KAPART | KAPART | CHAR | 3 | 0 | Capacity category | * | |
44 | SCHIV | SCHICHTNR | NUM01 | NUMC | 1 | 0 | Shift number of the available capacity | ||
45 | ZEITV | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
46 | ZEITB | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
47 | AUFN1 | SA_AUFNR | SA_AUFNR | CHAR | 12 | 0 | Run schedule header number | * | |
48 | KAPFX | KAPFX | XFELD | CHAR | 1 | 0 | Indicator: capacity for planned order dispatched | ||
49 | ETART | ETART | ETLAR | CHAR | 1 | 0 | Planned order shift type | ||
50 | SHTNR | SHTNR | NUMC01 | NUMC | 1 | 0 | Shift number | ||
51 | ETLNR | ETLNR | NUMC04 | NUMC | 4 | 0 | Planned order shift quantity number | ||
52 | DISPO | PLDSP | DISPO | CHAR | 3 | 0 | MRP controller | * | |
53 | DAT04 | SA_DAT04 | DATUM | DATS | 8 | 0 | Start date for production | ||
54 | DAT05 | SA_DAT05 | DATUM | DATS | 8 | 0 | Finish date for production | ||
55 | DTBDV | FSSBD | DATUM | DATS | 8 | 0 | Earliest scheduled start: Processing (date) | ||
56 | DTBZV | FSSBZ | ATIME | TIMS | 6 | 0 | Earliest scheduled start: Processing (time) | ||
57 | DTBDB | FSSAD | DATUM | DATS | 8 | 0 | Earliest scheduled start: Teardown (date) | ||
58 | DTBZB | FSSAZ | ATIME | TIMS | 6 | 0 | Earliest scheduled start: Teardown (time) | ||
59 | ANVER | XFLAG | XFLAG | CHAR | 1 | 0 | New Input Values | ||
60 | PLUMI | PLUMI | CHAR1 | CHAR | 1 | 0 | Receipt/issue indicator | ||
61 | ZLART | DELKZ | DELKZ | CHAR | 2 | 0 | MRP element | ||
62 | VRFKZ | VRFKZ | VRFKZ | CHAR | 1 | 0 | Availability indicator | ||
63 | KDAUF | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
64 | KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
65 | DELPS | DELPS | DELPS | NUMC | 6 | 0 | MRP element item | ||
66 | DELET | DELET | DELET | NUMC | 4 | 0 | Scheduling number planning element | ||
67 | PSPEL | PS_POSNR | PS_POSNR | NUMC | 8 | 0 | WBS Element | * | |
68 | WEBAZ | WEBAZ | DEC3 | DEC | 3 | 0 | Goods receipt processing time in days | ||
69 | BAART | BAART | BAART | CHAR | 4 | 0 | P.O./Order type | ||
70 | TRMKZ | TRMFL | XFELD | CHAR | 1 | 0 | Scheduling indicator |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MDFE | FAUFN | AUFK | AUFNR | |||
2 | MDFE | LGORT | T001L | LGORT | |||
3 | MDFE | MATNR | MARA | MATNR | |||
4 | MDFE | PLWRK | T001W | WERKS | |||
5 | MDFE | PWWRK | T001W | WERKS | |||
6 | MDFE | VERID | MKAL | VERID |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |