| 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 | T000 | MANDT | Allow NULL? |
| 2 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TKA01 | KOKRS | Allow NULL? |
| 3 | AWVRS | Target Cost Version | nvarchar | 3 | 0 | CHAR | (N' ') | No | | AWVRS | Allow NULL? |
| 4 | AWWTB | Variances: Reference Value Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | | AWWTB | Allow NULL? |
| 5 | AWVSB | Variances: Reference Version | nvarchar | 3 | 0 | CHAR | (N' ') | No | TKA09 | AWVSB | Allow NULL? |
| 6 | AWVAS | Variance Variant for Cost Center Accounting | nvarchar | 3 | 0 | CHAR | (N' ') | No | TKV05 | AWVAS | Allow NULL? |
| 7 | AWVAO | Variance Variant for Order | nvarchar | 3 | 0 | CHAR | (N' ') | No | TKV05 | AWVAO | Allow NULL? |
| 8 | AWVAT | Variance Variant for Cost Object Controlling | nvarchar | 3 | 0 | CHAR | (N' ') | No | TKV05 | AWVAT | Allow NULL? |
| 9 | AWKBT | Variances: Reference Costing Variant Type | char | 1 | 0 | CHAR | (N' ') | No | | AWKBT | Allow NULL? |
| 10 | AWKAB | Variances: Reference Costing Variant | nvarchar | 4 | 0 | CHAR | (N' ') | No | TCK03 | AWKAB | Allow NULL? |
| 11 | AWKVB | Variances: Reference Costing Version | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | AWKVB | Allow NULL? |
| 12 | AWWTV | Variances: Comparison Value Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | | AWWTV | Allow NULL? |
| 13 | AWVSV | Variances: Comparison Version | nvarchar | 3 | 0 | CHAR | (N' ') | No | TKA09 | AWVSV | Allow NULL? |
| 14 | AWKVT | Variances: Comparison Costing Variant Type | char | 1 | 0 | CHAR | (N' ') | No | | AWKVT | Allow NULL? |
| 15 | AWKAV | Variances: Comparison Costing Variant | nvarchar | 4 | 0 | CHAR | (N' ') | No | TCK03 | AWKAV | Allow NULL? |
| 16 | AWKVV | Variances: Comparison Costing Version | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | AWKVV | Allow NULL? |
| 17 | AWBVA | Valuation Variant for Scrap | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TKV13 | AWBVA | Allow NULL? |