| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | POPER | Posting period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | UNTPER | Value Structure Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 8 | ESTPRD_TL | Single-Level Price Differences | decimal | 15 | 2 | | | | |
| 9 | ESTKDM_TL | Single-Level Exchange Rate Differences | decimal | 15 | 2 | | | | |
| 10 | MSTPRD_TL | Multilevel Price Differences | decimal | 15 | 2 | | | | |
| 11 | MSTKDM_TL | Multilevel Exchange Rate Differences | decimal | 15 | 2 | | | | |
| 12 | ESTPRD_RM | Single-Level Price Differences | decimal | 15 | 2 | | | | |
| 13 | ESTKDM_RM | Single-Level Exchange Rate Differences | decimal | 15 | 2 | | | | |
| 14 | MSTPRD_RM | Multilevel Price Differences | decimal | 15 | 2 | | | | |
| 15 | MSTKDM_RM | Multilevel Exchange Rate Differences | decimal | 15 | 2 | | | | |