| 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 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TKA01 | KOKRS | Allow NULL? |
| 3 | KALNR | Cost Estimate Number (Unit Costing) | nvarchar | 8 | 0 | CHAR | (N' ') | No | | KALNR | Allow NULL? |
| 4 | WTTYP | Unit costing value type | nvarchar | 2 | 0 | NUMC | (N'00') | No | | WTTYP | Allow NULL? |
| 5 | VERSN | Version Number of the Value Type of a Unit Cost Estimate | nvarchar | 2 | 0 | NUMC | (N'00') | No | CKKS | VERS2 | Allow NULL? |
| 6 | POSNR | Unit Costing Item Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | PSNUM | Allow NULL? |
| 7 | STATP | Item Status | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | STATP_D | Allow NULL? |
| 8 | STRGP | Item Control (for Internal Use) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | STRGP | Allow NULL? |
| 9 | TYPPS | Item Category | char | 1 | 0 | CHAR | (N' ') | Yes | | TYPPS | Allow NULL? |
| 10 | KSTAR | Cost Element | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KSTAR | Allow NULL? |
| 11 | FVFLG | Fixed/Variable Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FVFLG | Allow NULL? |
| 12 | OPCOD | Formula field for calculations at item level | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | OPCOD | Allow NULL? |
| 13 | FRLNR | Unit Costing Formula Number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | FORML_EK | Allow NULL? |
| 14 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 15 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 16 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 17 | PSCHL | Pricing Key | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | PSCHL | Allow NULL? |
| 18 | KOKRS_HRK | Origin Controlling Area Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TKA01 | KOKRS_HRK | Allow NULL? |
| 19 | EXTNR | Base Planning Object (External Number) | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | CKBS | EXTNR | Allow NULL? |
| 20 | GPREIS | Total Price for Costing Item | decimal | 15 | 2 | CURR | ((0)) | Yes | | GPREIS | |
| 21 | WERTB | Item Gross Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | WERTB | |
| 22 | WERTN | Net Value of Item | decimal | 15 | 2 | CURR | ((0)) | Yes | | WERTN | |
| 23 | WERTF | Gross Value in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WERTF | |
| 24 | FWAER | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 25 | MKURS | Average rate | nvarchar | 9 | 0 | NUMC | (N'000000000') | Yes | | MKURS | Allow NULL? |
| 26 | FWEHT | Currency unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | EINHT_CUR | Allow NULL? |
| 27 | MENGE | Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MENGE_POS | |
| 28 | MEEHT | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 29 | SUMM1 | Quantities total for item category S | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SUMME_MNG | |
| 30 | SUMM2 | Capital Spending Total for Item Category S | decimal | 15 | 2 | CURR | ((0)) | Yes | | SUMME_INV | |
| 31 | SUMM3 | Total of two or more items | decimal | 15 | 2 | CURR | ((0)) | Yes | | SUMME_POS | |
| 32 | DPREIS | Average price for periods | decimal | 15 | 2 | CURR | ((0)) | Yes | | DPREIS | |
| 33 | PREIS1 | Value of Delta Profit in CO Area Currency - Legal View | decimal | 15 | 2 | CURR | ((0)) | Yes | | PREIS1 | |
| 34 | PREIS2 | Value of Delta Profit in Object Currency - Legal View | decimal | 15 | 2 | CURR | ((0)) | Yes | | PREIS2 | |
| 35 | PREIS3 | Value of Delta Profit in CO Area Currency - Profit Ctr View | decimal | 15 | 2 | CURR | ((0)) | Yes | | PREIS3 | |
| 36 | PREIS4 | Value of Delta Profit in Object Currency - Profit Ctr View | decimal | 15 | 2 | CURR | ((0)) | Yes | | PREIS4 | |
| 37 | PREIS5 | Price Component 5 | decimal | 15 | 2 | CURR | ((0)) | Yes | | PREIS5 | |
| 38 | PFKT1 | Price Component Factor | decimal | 5 | 2 | DEC | ((0)) | Yes | | PFKTX | |
| 39 | PFKT2 | Price Component Factor | decimal | 5 | 2 | DEC | ((0)) | Yes | | PFKTX | |
| 40 | PFKT3 | Price Component Factor | decimal | 5 | 2 | DEC | ((0)) | Yes | | PFKTX | |
| 41 | PFKT4 | Price Component Factor | decimal | 5 | 2 | DEC | ((0)) | Yes | | PFKTX | |
| 42 | PFKT5 | Price Component Factor | decimal | 5 | 2 | DEC | ((0)) | Yes | | PFKTX | |
| 43 | ZUABS | Overhead as absolute figure | decimal | 15 | 2 | CURR | ((0)) | Yes | | DZUABS | |
| 44 | ZUFKT | Overhead factor | decimal | 5 | 4 | DEC | ((0)) | Yes | | DZUFKT | |
| 45 | PSKNZ | Lot-Size-Independent Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PSKNZ | Allow NULL? |
| 46 | VTKNZ | Distribution Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VTKNZ | Allow NULL? |
