| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SBELN | No. of allocation rule | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | SVBEZ | Description of alloc rule | nvarchar | 40 | 0 | | | | Allow NULL? |
| 4 | SVART | Allocation rule type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | GUELT | Validity date of allocation rule | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | ARAKT | Alloc. rule status | char | 1 | 0 | | | | Allow NULL? |
| 7 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | ACLIN | Internal class number, material class | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | FCLIN | Internal class number, plant | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | FIXIE | Plants fixed in AR | char | 1 | 0 | | | | Allow NULL? |
| 12 | DYFKL | Indicates generated alloc rule | char | 1 | 0 | | | | Allow NULL? |
| 13 | MSTER | Indicates that alloc rule is a model | char | 1 | 0 | | | | Allow NULL? |
| 14 | RUNDG | Rounding off in allocation table | char | 1 | 0 | | | | Allow NULL? |
| 15 | RESTV | Split remainder | char | 1 | 0 | | | | Allow NULL? |
| 16 | DIMAQ | Category of Quotas (Ratios/Quantities) | char | 1 | 0 | | | | Allow NULL? |
| 17 | KETYP | Key Figure Category | char | 1 | 0 | | | | Allow NULL? |
| 18 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 22 | SPERI | Period split: info structure | char | 1 | 0 | | | | Allow NULL? |
| 23 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | PDVON | Starting date of period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | PDBIS | End date of period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |