| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SPEC_NO | Number of a Set of Model Service Specifications | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | DEL | Deletion Indicator | char | 1 | 0 | | | | Allow NULL? |
| 4 | BLOCK | Use of model service specifications blocked | char | 1 | 0 | | | | Allow NULL? |
| 5 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | MATKL | Material Group | nvarchar | 9 | 0 | | | | Allow NULL? |
| 9 | SORT1 | Search term | nvarchar | 20 | 0 | | | | Allow NULL? |
| 10 | TXZ01 | Short description of model specifications | nvarchar | 40 | 0 | | | | Allow NULL? |
| 11 | PACKNO | Package number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | BEGRU | Authorization Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | MSTAE | General Purchasing Status for Service | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | MSTDE | Validity Date for "Purchasing" Status | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | KNTTP | Account Assignment Category | char | 1 | 0 | | | | Allow NULL? |
| 21 | NETWR | Net Value in Document Currency | decimal | 15 | 2 | | | | |
| 22 | FLIEF | Fixed Vendor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | KTPNR | Item Number of Principal Purchase Agreement | nvarchar | 5 | 0 | | | | Allow NULL? |
| 25 | ASTYP | Service Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | USE_KONF | Configuration at time of service selection | char | 1 | 0 | | | | Allow NULL? |