| 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 | FIXEDUNPRICEGUID | GUID (RAW16) | varbinary | 16 | 0 | RAW | | No | | RECAGUID | |
| 3 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVSCSCKEY | RESCSCKEY | Allow NULL? |
| 4 | OBJTYPE | Object Type for Maintaining Fixed Unit Prices | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | REXCJPOBJTYPE | Allow NULL? |
| 5 | IDENTKEY | ID Part Key, for example "1000/123" | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | RECAIDENTKEY | Allow NULL? |
| 6 | OBJNR | Object Number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RECAOBJNR | Allow NULL? |
| 7 | VALIDTO | End Date of Validity Interval | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REXCJPVALIDTO | Allow NULL? |
| 8 | CONSRNGSEQNO | Sequential Number for Consumption Range | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | REXCJPCONSRNGSEQNO | Allow NULL? |
| 9 | VALIDFROM | Start Date of Validity Interval | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REXCJPVALIDFROM | Allow NULL? |
| 10 | CONSSHAREMETHOD | Consumption Sharing Method | char | 1 | 0 | CHAR | (N' ') | Yes | | REXCJPCONSSHAREMETHOD | Allow NULL? |
| 11 | PRICECALCMETHOD | Price Calculation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | REXCJPPRICECALCMETHOD | Allow NULL? |
| 12 | CONS_RANGE_LOW | Consumption Range - Lower Limit | decimal | 12 | 4 | QUAN | ((0)) | Yes | | REXCJPCONSUMPTION | |
| 13 | FIXED_UNIT_PRICE | Fixed Unit Price for Service Charge Settlement | decimal | 19 | 6 | DEC | ((0)) | Yes | | REXCJPFIXEDUNITPRICE | |
| 14 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 15 | KMEIN | Condition unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | KMEIN | Allow NULL? |
| 16 | COUNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND1 | Allow NULL? |
| 17 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | RERATAXTYPE | Allow NULL? |
| 18 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | RERATAXGROUP | Allow NULL? |
| 19 | TAXCALC | Tax Calculation Mode: Net or Gross | char | 1 | 0 | CHAR | (N' ') | Yes | | REXCJPTAXCALC | Allow NULL? |
| 20 | CEOBJTYPE | Cost Element Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | REXCJPCEOBJTYPE | Allow NULL? |
| 21 | CEID | Cost Element ID | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | REXCJPCOSTELEMENTID | Allow NULL? |
| 22 | CENAME | Cost Element Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | REXCJPCENAME | Allow NULL? |
| 23 | CEOBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | J_OBJNR | Allow NULL? |
| 24 | XOBJTYPE | Partial Object Type ID, for example "BE" | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | RECAXOBJTYPE | Allow NULL? |
| 25 | XCEOBJTYPE | Partial Object Type ID, for example "BE" | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | RECAXOBJTYPE | Allow NULL? |
