| 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 | | |
TOPLocalization |
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 | | |
TOPSpecial 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 | | |
TOPTraders 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 | | |