| 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 | AWOBA | Variances: Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | AWOBA | Allow NULL? |
| 3 | AWVAR | Variance Variant | nvarchar | 3 | 0 | CHAR | (N' ') | No | | AWVAR | Allow NULL? |
| 4 | AWRRS | Sequence for Remaining Variance | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AWRRS | Allow NULL? |
| 5 | AWRAU | Scrap Variance Sequence | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | AWRAU | Allow NULL? |
| 6 | AWRPR | Sequence for Input Price Variance | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AWRPR | Allow NULL? |
| 7 | AWRMG | Sequence for Input Quantity Variance | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AWRMG | Allow NULL? |
| 8 | AWRST | Sequence for Resource-Usage Variance | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AWRST | Allow NULL? |
| 9 | AWRFX | Not used | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AWRFX | Allow NULL? |
| 10 | AWRLG | Sequence for Fixed-Cost Variances | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AWRLG | Allow NULL? |
| 11 | AWRES | Input Variance Sequence | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AWRES | Allow NULL? |
| 12 | AWRMP | Sequence for Mixed-Price Variance | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | AWRMP | Allow NULL? |
| 13 | AWRVP | Sequence for Output Price Variance | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AWRVP | Allow NULL? |
| 14 | AWRFS | Secondary Sequence for Fixed Cost Variance | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AWRFS | Allow NULL? |
| 15 | AWRWK | Sequence for Exchange Rate Variance | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AWRWK | Allow NULL? |
| 16 | AWRVM | Sequence for Output Quantity Variance | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | AWRVM | Allow NULL? |
| 17 | AWKDF | Variances: Minor Differences Percentage | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | AWKDF | Allow NULL? |