| 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 | ERGBZ | Selection rule | nvarchar | 8 | 0 | CHAR | (N' ') | No | | ERGBZ | Allow NULL? |
| 3 | SVPEB | Planned independent requirement selection | char | 1 | 0 | CHAR | (N' ') | Yes | | SVPEB | Allow NULL? |
| 4 | SANGB | Selection of quotations | char | 1 | 0 | CHAR | (N' ') | Yes | | SANGB | Allow NULL? |
| 5 | SKDAU | Sales document selection | char | 1 | 0 | CHAR | (N' ') | Yes | | SLKDA | Allow NULL? |
| 6 | SLIEF | Delivery selection | char | 1 | 0 | CHAR | (N' ') | Yes | | SLIEF | Allow NULL? |
| 7 | SSKBD | Dependent requirement selection | char | 1 | 0 | CHAR | (N' ') | Yes | | SSKBD | Allow NULL? |
| 8 | SMRES | Selection of manual reservations | char | 1 | 0 | CHAR | (N' ') | Yes | | SIRES | Allow NULL? |
| 9 | SLBED | Selection of subcontractor requirements of material provided | char | 1 | 0 | CHAR | (N' ') | Yes | | SLBED | Allow NULL? |
| 10 | SARES | Selection of dependent reservations | char | 1 | 0 | CHAR | (N' ') | Yes | | SARES | Allow NULL? |
| 11 | SAPLF | Selection of delivery schedules for planned orders | char | 1 | 0 | CHAR | (N' ') | Yes | | SAPLF | Allow NULL? |
| 12 | SABES | Selection of delivery schedules for stock transfer orders | char | 1 | 0 | CHAR | (N' ') | Yes | | SABES | Allow NULL? |
| 13 | SABAN | Sel. of delivery schedules for stock transfer requisitions | char | 1 | 0 | CHAR | (N' ') | Yes | | SABAN | Allow NULL? |
| 14 | SALPE | Sel. of delivery schedules for stock transfer schedule lines | char | 1 | 0 | CHAR | (N' ') | Yes | | SALPE | Allow NULL? |
| 15 | SURES | Stock transfer reservation selection | char | 1 | 0 | CHAR | (N' ') | Yes | | SURES | Allow NULL? |
| 16 | SFERT | Selection of production orders | char | 1 | 0 | CHAR | (N' ') | Yes | | SFERT | Allow NULL? |
| 17 | SPLAF | Planned order selection | char | 1 | 0 | CHAR | (N' ') | Yes | | SPLAF | Allow NULL? |
| 18 | SBEST | Selection of purchase orders | char | 1 | 0 | CHAR | (N' ') | Yes | | SBEST | Allow NULL? |
| 19 | SBANF | Selection of Purchase Requisitions | char | 1 | 0 | CHAR | (N' ') | Yes | | SBANF | Allow NULL? |
| 20 | SLPET | Selection of schedule lines | char | 1 | 0 | CHAR | (N' ') | Yes | | SLPET | Allow NULL? |
| 21 | SAVIS | Selection of shipping notifications | char | 1 | 0 | CHAR | (N' ') | Yes | | SAVIS | Allow NULL? |
| 22 | SQMPR | Selection of QM inspection lots | char | 1 | 0 | CHAR | (N' ') | Yes | | SQMPR | Allow NULL? |
| 23 | SBWRK | Selection of unrestricted-use stock | char | 1 | 0 | CHAR | (N' ') | Yes | | SBWRK | Allow NULL? |
| 24 | SBSIC | Safety stock selection | char | 1 | 0 | CHAR | (N' ') | Yes | | SBSIC | Allow NULL? |
| 25 | SBNFR | Selection of restricted-use stock | char | 1 | 0 | CHAR | (N' ') | Yes | | SBNFR | Allow NULL? |
| 26 | SBGSP | Blocked stock selection | char | 1 | 0 | CHAR | (N' ') | Yes | | SBGSP | Allow NULL? |
| 27 | SBUML | Selection of stock in transfer | char | 1 | 0 | CHAR | (N' ') | Yes | | SBUML | Allow NULL? |
| 28 | SBKON_EDL | Selection ESP Consignment Stock | char | 1 | 0 | CHAR | (N' ') | Yes | | SBKON_EDL | Allow NULL? |
| 29 | SRABR | Replace schedule lines by delivery schedules | char | 1 | 0 | CHAR | (N' ') | Yes | | SRABR | Allow NULL? |
| 30 | SSGUT | Dependent requirements for bulk goods | char | 1 | 0 | CHAR | (N' ') | Yes | | SSGUT | Allow NULL? |
| 31 | DTALL | Display without time limit | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_DTALL | Allow NULL? |
| 32 | DTAPP | Horizon can be selected by user | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_DTAPP | Allow NULL? |
| 33 | DTCUS | Horizon using default value in Customizing | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_DTCUS | Allow NULL? |
| 34 | STADT | Start date of the import transaction | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_STOPT_ER | Allow NULL? |
| 35 | SSPAN | Time interval before todays date | int | 10 | 0 | INT4 | ((0)) | Yes | | MD_SSPAN_ER | Allow NULL? |
| 36 | ENDDT | End date of the selection process | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_ENDDT_ER | Allow NULL? |
| 37 | ESPAN | Period After Today's Date | int | 10 | 0 | INT4 | ((0)) | Yes | | MD_ESPAN_ER | Allow NULL? |