| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ZZLINEA | Actual line item table | 26 | SMATNR | Material Number | nvarchar | 18 | 0 | ||
| 2 | ZZLINEP | Plan line items table | 26 | SMATNR | Material Number | nvarchar | 18 | 0 | ||
| 3 | ZZLINET | Summary table | 25 | SMATNR | Material Number | nvarchar | 18 | 0 | ||
| 4 | ZZSPECA | Actual line item table | 25 | SMATNR | Material Number | nvarchar | 18 | 0 | ||
| 5 | ZZSPECP | Plan line item table | 25 | SMATNR | Material Number | nvarchar | 18 | 0 | ||
| 6 | ZZSPECT | Summary table | 23 | SMATNR | Material Number | nvarchar | 18 | 0 | ||
| Localization | ||||||||||
| 7 | J_3RFTAXRVA | Tax Accounting: Actual line item table | 33 | SMATNR | Material Number | nvarchar | 18 | 0 | ||
| 8 | J_3RFTAXRVP | Tax Accounting: Plan line item table | 33 | SMATNR | Material Number | nvarchar | 18 | 0 | ||
| 9 | J_3RFTAXRVT | Tax Accounting: Summary table | 31 | SMATNR | Material Number | nvarchar | 18 | 0 | ||
| Special Purpose Ledger | ||||||||||
| 10 | /CCIS/PBU18A | PBU18: Actual line item table | 31 | SMATNR | Sender material | nvarchar | 18 | 0 | ||
| 11 | /CCIS/PBU18P | PBU18: Plan line item table | 31 | SMATNR | Sender material | nvarchar | 18 | 0 | ||
| 12 | /CCIS/PBU18T | PBU18: Summary table x | 30 | SMATNR | Sender material | nvarchar | 18 | 0 | ||
| Traders and Schedulers Workbench | ||||||||||
| 13 | OIJPLANWL | OIJ-TSW: Worklist entries for planning | 8 | SMATNR | Material Number | nvarchar | 18 | 0 | ||
| 14 | OIJRDPLAN | OIL-TSW: Rundown planning proposal drill-down | 8 | SMATNR | Material Number | nvarchar | 18 | 0 | ||