| 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 | * | MANDT | Allow NULL? |
| 2 | AFIBZ | Name of display filter | nvarchar | 8 | 0 | CHAR | (N' ') | No | | FILBZ | Allow NULL? |
| 3 | AVPEB | Planned independent requirement selection | char | 1 | 0 | CHAR | (N' ') | Yes | | AVPEB | Allow NULL? |
| 4 | AANGB | Selection of quotations | char | 1 | 0 | CHAR | (N' ') | Yes | | AANGB | Allow NULL? |
| 5 | AKDAU | Selection of sales documents | char | 1 | 0 | CHAR | (N' ') | Yes | | ALKDA | Allow NULL? |
| 6 | ALIEF | Selection of deliveries | char | 1 | 0 | CHAR | (N' ') | Yes | | ALIEF | Allow NULL? |
| 7 | ASKBD | Selection of dependent requirements | char | 1 | 0 | CHAR | (N' ') | Yes | | ASKBD | Allow NULL? |
| 8 | AMRES | Selection of manual reservations | char | 1 | 0 | CHAR | (N' ') | Yes | | AIRES | Allow NULL? |
| 9 | ALBED | Selection of subcontractor requirements of material provided | char | 1 | 0 | CHAR | (N' ') | Yes | | ALBED | Allow NULL? |
| 10 | AARES | Selection of dependent reservations | char | 1 | 0 | CHAR | (N' ') | Yes | | AARES | Allow NULL? |
| 11 | AAPLF | Selection of delivery schedules for planned orders | char | 1 | 0 | CHAR | (N' ') | Yes | | AAPLF | Allow NULL? |
| 12 | AABES | Selection of delivery schedules for stock transfer orders | char | 1 | 0 | CHAR | (N' ') | Yes | | AABES | Allow NULL? |
| 13 | AABAN | Sel. of delivery schedules for stock transfer requisitions | char | 1 | 0 | CHAR | (N' ') | Yes | | AABAN | Allow NULL? |
| 14 | AALPE | Sel. of delivery schedules for stock transfer schedule lines | char | 1 | 0 | CHAR | (N' ') | Yes | | AALPE | Allow NULL? |
| 15 | AURES | Stock transfer reservation selection | char | 1 | 0 | CHAR | (N' ') | Yes | | AURES | Allow NULL? |
| 16 | AFERT | Selection of production orders | char | 1 | 0 | CHAR | (N' ') | Yes | | AFERT | Allow NULL? |
| 17 | APLAF | Selection of planned orders | char | 1 | 0 | CHAR | (N' ') | Yes | | APLAF | Allow NULL? |
| 18 | ABEST | Selection of purchase orders | char | 1 | 0 | CHAR | (N' ') | Yes | | ABEST | Allow NULL? |
| 19 | ABANF | Selection of Purchase Requisitions | char | 1 | 0 | CHAR | (N' ') | Yes | | ABANF | Allow NULL? |
| 20 | ALPET | Selection of schedule lines | char | 1 | 0 | CHAR | (N' ') | Yes | | ALPET | Allow NULL? |
| 21 | AAVIS | Selection of shipping notifications | char | 1 | 0 | CHAR | (N' ') | Yes | | AAVIS | Allow NULL? |
| 22 | AQMPR | Selection of QM inspection lots | char | 1 | 0 | CHAR | (N' ') | Yes | | AQMPR | Allow NULL? |
| 23 | SWEAB | Sel. plant segment | char | 1 | 0 | CHAR | (N' ') | Yes | | SWEAB | Allow NULL? |
| 24 | SKDAB | Selection customer segments | char | 1 | 0 | CHAR | (N' ') | Yes | | SKDAB | Allow NULL? |
| 25 | SPRAB | Selection project segments | char | 1 | 0 | CHAR | (N' ') | Yes | | SPRAB | Allow NULL? |
| 26 | SBRAB | Gross segment selection | char | 1 | 0 | CHAR | (N' ') | Yes | | SBRAB | Allow NULL? |
| 27 | SDIFE | Selection of direct production/direct procurement segments | char | 1 | 0 | CHAR | (N' ') | Yes | | SDIFE | Allow NULL? |
| 28 | SLAGO | Selection of storage location segments | char | 1 | 0 | CHAR | (N' ') | Yes | | SLAGO | Allow NULL? |
| 29 | SLOHN | Subcontracting segment selection | char | 1 | 0 | CHAR | (N' ') | Yes | | SLOHB | Allow NULL? |
| 30 | SVORP | Planning segment selection | char | 1 | 0 | CHAR | (N' ') | Yes | | SVORP | Allow NULL? |
| 31 | SVDIR | Selection of segments for plng direct production/procurement | char | 1 | 0 | CHAR | (N' ') | Yes | | SVDIR | Allow NULL? |
| 32 | SDFIX | Selection of firmed procurement proposals | char | 1 | 0 | CHAR | (N' ') | Yes | | SDFIX | Allow NULL? |
| 33 | DTALL | Display without time limit | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_DTALL | Allow NULL? |
| 34 | DTAPP | Horizon can be selected by user | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_DTAPP | Allow NULL? |
| 35 | DTCUS | Horizon using default value in Customizing | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_DTCUS | Allow NULL? |
| 36 | STADT | Start date of previous period | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_STOPT | Allow NULL? |
| 37 | SSPAN | Time interval before todays date | int | 10 | 0 | INT4 | ((0)) | Yes | | MD_SSPAN | Allow NULL? |
| 38 | ENDDT | Last date of subsequent period | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_ENDDT | Allow NULL? |
| 39 | ESPAN | Period After Today's Date | int | 10 | 0 | INT4 | ((0)) | Yes | | MD_ESPAN | Allow NULL? |
| 40 | DZALL | Additional selections: none | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_DZALL | Allow NULL? |
| 41 | DZAPP | Define additional selections in the application | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_DZAPP | Allow NULL? |
| 42 | DZCUS | Define additional selections in Customizing | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_DZCUS | Allow NULL? |
| 43 | KUNNR | Customer key | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | MD_KUNNR | Allow NULL? |
| 44 | LIFNR | Vendor Key | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | MD_LIFNR | Allow NULL? |
| 45 | WRK02 | Supplying or receiving plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | MD_WRK02 | Allow NULL? |
| 46 | LGORT | Storage location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | MD_LGORT | Allow NULL? |
| 47 | VERID | Production version | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | MD_VERID | Allow NULL? |
