| 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 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 3 | BWKEY | Valuation Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001K | BWKEY | Allow NULL? |
| 4 | BWTAR | Valuation Type | nvarchar | 10 | 0 | CHAR | (N' ') | No | T149D | BWTAR_D | Allow NULL? |
| 5 | J_1AMINFCL | Material Inflation Class | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | J_1AMINFCL | J_1AMINFC | Allow NULL? |
| 6 | J_1AMPMETH | Revaluation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1AMPMETH | Allow NULL? |
| 7 | J_1AINDXP | Inflation Index | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | J_1AINFT20 | J_1AINDXP | Allow NULL? |
| 8 | J_1ATBEDEP | TBE Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | J_1AINFT04 | J_1ATBEDEP | Allow NULL? |
| 9 | J_1APRTOL | Price Tolerance | decimal | 5 | 2 | DEC | ((0)) | Yes | | J_1APRTOL | |
| 10 | J_1ARPLCPC | Replacement Cost - Current | decimal | 11 | 2 | CURR | ((0)) | Yes | | J_1ARPLCPC | |
| 11 | J_1ACURRC | Original Currency - Current | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | J_1ACURRC | Allow NULL? |
| 12 | J_1AREVDTC | Last Revaluation Date - Current | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1AREVDTC | Allow NULL? |
| 13 | J_1APRODTC | Last Processing Date - Current | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1APRODTC | Allow NULL? |
| 14 | J_1APROVXC | Last processing date inflation index reval. (curr./prov.) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1APROVXC | Allow NULL? |
| 15 | J_1APRODXC | Last processing date inflation index reval. (curr./def.) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1APRODXC | Allow NULL? |
| 16 | J_1AMPMANC | Market price set manually for current period | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1AMPMANC | Allow NULL? |
| 17 | J_1ARPLCPP | Replacement Cost - Previous | decimal | 11 | 2 | CURR | ((0)) | Yes | | J_1ARPLCPP | |
| 18 | J_1ACURRP | Original Currency - Previous | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | J_1ACURRP | Allow NULL? |
| 19 | J_1AREVDTP | Last Revaluation Date - Previous | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1AREVDTP | Allow NULL? |
| 20 | J_1APRODTP | Last Processing Date for Market Price - Previous | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1APRODTP | Allow NULL? |
| 21 | J_1APROVXP | Last Processing Date for Provisional Index Adjustment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1APROVXP | Allow NULL? |
| 22 | J_1APRODXP | Last Processing Date for Definitive Index Adjustment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1APRODXP | Allow NULL? |
| 23 | J_1AMPMANP | Market price set manually for previous period | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1AMPMANP | Allow NULL? |
| 24 | J_1AMPPU | Market price previous period updated | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1AMPPU | Allow NULL? |
| 25 | J_1AREVPFD | Replacement Cost Determined for Valuation Period | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1AREVPFD | Allow NULL? |
| 26 | J_1AREVPFE | Replacement Cost Determined for Valuation Period | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1AREVPFD | Allow NULL? |
| 27 | J_1AREVPFF | Replacement Cost Determined for Valuation Period | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1AREVPFD | Allow NULL? |
| 28 | J_1ARPLCPT | Replacement Cost Total Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1ARPLCPT | |
| 29 | J_1ALREDTP | Last Revaluation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1ALREDTP | Allow NULL? |
