| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SYUNAME | Allow NULL? |
| 3 | MDAKT | Activity types in materials planning | char | 1 | 0 | CHAR | (N' ') | No | | MDAKT | Allow NULL? |
| 4 | NETPL | Net requirements segment in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | NETPL | Allow NULL? |
| 5 | BRTPL | Gross requirements planning in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | BRTPL | Allow NULL? |
| 6 | LGOR1 | Storage location MRP in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | LGOR1 | Allow NULL? |
| 7 | LGOR2 | Excluded storage locations in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | LGOR2 | Allow NULL? |
| 8 | KNDPL | Make-to-order planning in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | KNDPL | Allow NULL? |
| 9 | PROPL | Planning individual projects in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | PROPL | Allow NULL? |
| 10 | MSTPL | Direct Production in Planning Table | char | 1 | 0 | CHAR | (N' ') | Yes | | MSTPL | Allow NULL? |
| 11 | VORPL | Planning without final assembly in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | VORPL | Allow NULL? |
| 12 | LELIW | Only select materials with production | char | 1 | 0 | CHAR | (N' ') | Yes | | LELIW | Allow NULL? |
| 13 | ONLRQ | Only select materials with requirements | char | 1 | 0 | CHAR | (N' ') | Yes | | ONLRQ | Allow NULL? |
| 14 | ANZKA | Only display capacity categories relevant to scheduling | char | 1 | 0 | CHAR | (N' ') | Yes | | ANZKA | Allow NULL? |
| 15 | KPFLG | Indicator: Capacity planning active | char | 1 | 0 | CHAR | (N' ') | Yes | | KPFLG | Allow NULL? |
| 16 | ERWMD | Disable extended material data in REM planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | ERWMD | Allow NULL? |
| 17 | SELH1 | Selection period for the planning table | decimal | 3 | 0 | DEC | ((0)) | Yes | | SA_SELH1 | |
| 18 | SELH2 | Selection period for the planning table | decimal | 3 | 0 | DEC | ((0)) | Yes | | SA_SELH1 | |
| 19 | SKBED | Row sort ID for requirements in the planning table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKBED | Allow NULL? |
| 20 | SKVER | Row Sort ID for 'Available Quantity' in Planning Table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKVER | Allow NULL? |
| 21 | SKREI | Row sort ID for coverage in the planning table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKREI | Allow NULL? |
| 22 | SKAND | Row sort ID for other versions in the planning table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKAND | Allow NULL? |
| 23 | SKNZU | Row sort ID for 'to be assigned' in the planning table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKNZU | Allow NULL? |
| 24 | SKVPB | Row sort ID for planned indep. reqmts in the planning table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKVPB | Allow NULL? |
| 25 | SKSUZ | Row sort ID for 'total receipts' in the planning table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKSUZ | Allow NULL? |
| 26 | SKSUB | Row sort ID for 'total requirements' in the planning table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKSUB | Allow NULL? |
| 27 | SKPRD | Row sort ID for production in the planning table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKPRD | Allow NULL? |
| 28 | SKSZU | Row sort ID for 'other receipts' in the planning table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKSZU | Allow NULL? |
| 29 | SKLFP | Row sort IS for long-term planning in the planning table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKLFP | Allow NULL? |
| 30 | SKREW | Row Sort ID for Range of Coverage in Planning Table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SKREW | Allow NULL? |
| 31 | MATSK | Material selection appears when accessing the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | SA_MATSK | Allow NULL? |
| 32 | LINSK | Line selection appears when accessing the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | SA_LINSK | Allow NULL? |
| 33 | PERIO | Time bucket | char | 1 | 0 | CHAR | (N' ') | Yes | | SA_PERIO | Allow NULL? |
| 34 | PRDPL | Production dates or basic dates ? | char | 1 | 0 | CHAR | (N' ') | Yes | | PRDPL | Allow NULL? |
| 35 | PATVR | Scheduling strategy in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | PATVR | Allow NULL? |
| 36 | ABBED | Display requirements rows | char | 1 | 0 | CHAR | (N' ') | Yes | | ABBED | Allow NULL? |
| 37 | ABVER | Display availability | char | 1 | 0 | CHAR | (N' ') | Yes | | ABVER | Allow NULL? |
| 38 | ABREI | Display coverage | char | 1 | 0 | CHAR | (N' ') | Yes | | ABREI | Allow NULL? |
| 39 | ABAND | Display other versions | char | 1 | 0 | CHAR | (N' ') | Yes | | ABAND | Allow NULL? |
| 40 | ABNZU | Display quantities still to be assigned | char | 1 | 0 | CHAR | (N' ') | Yes | | ABNZU | Allow NULL? |
| 41 | ABVPB | Display planned independent reqmts in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | ABVPB | Allow NULL? |
| 42 | ABSUZ | Display total production in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | ABSUZ | Allow NULL? |
| 43 | ABSUB | Display total requirments in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | ABSBE | Allow NULL? |
| 44 | ABUEZ | Display the user exit row in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | ABUEZ | Allow NULL? |
| 45 | ABSZU | Display other receipts | char | 1 | 0 | CHAR | (N' ') | Yes | | ABSZU | Allow NULL? |
| 46 | ABLFP | Display information from long-term planning | char | 1 | 0 | CHAR | (N' ') | Yes | | ABLFP | Allow NULL? |
| 47 | SKTPT | Sort in the planning table: By material - by line | char | 1 | 0 | CHAR | (N' ') | Yes | | SKZPT | Allow NULL? |
| 48 | SVIEW | View selection for the repetitive mfg planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | SVIEW | Allow NULL? |
| 49 | PFEXL | Path for accessing EXCEL in the planning table (MF50) | nvarchar | 100 | 0 | CHAR | (N' ') | Yes | | PFEXL | Allow NULL? |
| 50 | TEEKZ | Determines the scheduling level in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | TEEKZ | Allow NULL? |
| 51 | SMEKZ | Standard unit of measure | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | UNIKZ | Allow NULL? |
| 52 | DSTRI | Quantities display in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | DSTRI | Allow NULL? |
| 53 | DSPHZ | Period in days for automatically dispatching in MF50 | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | DSPHZ | Allow NULL? |
| 54 | ABKOM | REM-PT: MRP segment aggregation | char | 1 | 0 | CHAR | (N' ') | Yes | | ABKOM | Allow NULL? |
| 55 | SKUE1 | Row sort ID for user exit rows in planning table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKUEZ | Allow NULL? |
| 56 | ABUE2 | Display the user exit row in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | ABUEZ | Allow NULL? |
| 57 | SKUE2 | Row sort ID for user exit rows in planning table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKUEZ | Allow NULL? |
| 58 | ABUE3 | Display the user exit row in the planning table | char | 1 | 0 | CHAR | (N' ') | Yes | | ABUEZ | Allow NULL? |
| 59 | SKUE3 | Row sort ID for user exit rows in planning table | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SA_SKUEZ | Allow NULL? |
| 60 | JVIEW | View of dispatched orders | char | 1 | 0 | CHAR | (N' ') | Yes | | SP_GJVIEW | Allow NULL? |
| 61 | DETLI | Detailed information (restrictions) on production line | char | 1 | 0 | CHAR | (N' ') | Yes | | DETAIL_LINE | Allow NULL? |
| 62 | DETDI | Detailed information (restriction) on MRP controller | char | 1 | 0 | CHAR | (N' ') | Yes | | DETAIL_DISPONENT | Allow NULL? |
| 63 | TABST | REM PT: Active tabstrip (set in initial screen) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ACTIVE_TAB_STRIP | Allow NULL? |
| 64 | DAYDE | Indicates whether day's description displayed for periods | char | 1 | 0 | CHAR | (N' ') | Yes | | DAY_DESCRIBTION | Allow NULL? |
| 65 | COLTX | Column width | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | COLWIDTH | Allow NULL? |
| 66 | COLMA | Column width | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | COLWIDTH | Allow NULL? |
| 67 | ERGBZ | Selection rule | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ERGBZ | Allow NULL? |
