| 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 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | * | CK_KALNR | Allow NULL? |
| 3 | UNTPER | Value Structure Type | nvarchar | 3 | 0 | NUMC | (N'000') | No | | CK_UNTPER | Allow NULL? |
| 4 | PRICETYPE | Price Type for Material Prices | nvarchar | 3 | 0 | CHAR | (N' ') | No | /FMP/C_MP_PTYP | /FMP/MP_PRICE_TYPE | Allow NULL? |
| 5 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CURTP | Allow NULL? |
| 6 | MEINH | Unit of Measure for Display | nvarchar | 3 | 0 | UNIT | (N' ') | No | * | MEINH | Allow NULL? |
| 7 | FROMYEARPER | Valid from Period | nvarchar | 7 | 0 | NUMC | (N'0000000') | No | | /FMP/MP_FROMYEARPER | Allow NULL? |
| 8 | TIMESTAMPL | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | DEC | ((0)) | No | | TIMESTAMPL | |
| 9 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 10 | PRICE | Price for Ending Inventory Valuation | decimal | 11 | 2 | CURR | ((0)) | Yes | | CK_EIPRICE | |
| 11 | PEINH | Price Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | PEINH | |
| 12 | TOYEARPER | Valid to period | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | /FMP/MP_TOYEARPER | Allow NULL? |
| 13 | FROMDAT | Valid-from Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /FMP/MP_FROMDAT | Allow NULL? |
| 14 | TODAT | Valid to Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /FMP/MP_TODAT | Allow NULL? |
| 15 | USED | Price Has Been Used for Price Change | char | 1 | 0 | CHAR | (N' ') | Yes | | /FMP/MP_PRCCHGIND | Allow NULL? |
| 16 | BZOBJ | Reference Object | char | 1 | 0 | CHAR | (N' ') | Yes | * | CK_OBJ | Allow NULL? |
| 17 | KALKA | Costing Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | CK_KALKA | Allow NULL? |
| 18 | KADKY | Costing Date (Key) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CK_KADKY | Allow NULL? |
| 19 | TVERS | Costing Version | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CK_TVERS | Allow NULL? |
| 20 | BWVAR | Valuation Variant in Costing | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | CK_BWVAR | Allow NULL? |
| 21 | KKZMA | Costs Entered Manually in Additive or Automatic Cost Est. | char | 1 | 0 | CHAR | (N' ') | Yes | | CK_KKZMA | Allow NULL? |
| 22 | ERZKA | Cost Estimate Created with Product Costing | char | 1 | 0 | CHAR | (N' ') | Yes | | CK_ERZKA | Allow NULL? |
| 23 | UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UNAME | Allow NULL? |
| 24 | FUNCTION | Function of BAPI | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | BAPIFN | Allow NULL? |
