| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | FIXEDUNPRICEGUID | GUID (RAW16) | varbinary | 16 | 0 | | | | |
| 3 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | OBJTYPE | Object Type for Maintaining Fixed Unit Prices | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | IDENTKEY | ID Part Key, for example "1000/123" | nvarchar | 45 | 0 | | | | Allow NULL? |
| 6 | OBJNR | Object Number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 7 | VALIDTO | End Date of Validity Interval | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | CONSRNGSEQNO | Sequential Number for Consumption Range | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | VALIDFROM | Start Date of Validity Interval | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | CONSSHAREMETHOD | Consumption Sharing Method | char | 1 | 0 | | | | Allow NULL? |
| 11 | PRICECALCMETHOD | Price Calculation Method | char | 1 | 0 | | | | Allow NULL? |
| 12 | CONS_RANGE_LOW | Consumption Range - Lower Limit | decimal | 12 | 4 | | | | |
| 13 | FIXED_UNIT_PRICE | Fixed Unit Price for Service Charge Settlement | decimal | 19 | 6 | | | | |
| 14 | CURRENCY | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 15 | KMEIN | Condition unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | COUNTRY | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | | | Allow NULL? |
| 19 | TAXCALC | Tax Calculation Mode: Net or Gross | char | 1 | 0 | | | | Allow NULL? |
| 20 | CEOBJTYPE | Cost Element Object Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | CEID | Cost Element ID | nvarchar | 24 | 0 | | | | Allow NULL? |
| 22 | CENAME | Cost Element Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 23 | CEOBJNR | Object number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 24 | XOBJTYPE | Partial Object Type ID, for example "BE" | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | XCEOBJTYPE | Partial Object Type ID, for example "BE" | nvarchar | 3 | 0 | | | | Allow NULL? |