| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T258E | Table for managing external data transfer | 5 | ZAEHLER | Counter for transfer of external data | nvarchar | 8 | 0 | | |
2 | ZTRZL | Übersetzungsrelevante Zeilen | 6 | ZAEHLER | Zähler | nvarchar | 5 | 0 | | |
TOPABAP List-Based PI Sheet |
3 | COFMA | PI Sheet: Message Assignment to Process Instruction | 6 | ZAEHLER | Count parameters | nvarchar | 4 | 0 | | |
TOPActual CostingMaterial Ledger |
4 | CKMLMV011F | Costing Run: Filter Table for Object List | 3 | ZAEHLER | 10 digit number | nvarchar | 10 | 0 | | |
TOPAdvertising Management |
5 | JHTMEMORY | IS-M/AM: Buffering Table for Order Data Transfer | 3 | ZAEHLER | IS-M: Consecutive Counter for Transfer of External Data | nvarchar | 8 | 0 | | |
6 | JHTVMEMORY | IS-M/AM: Buffering Table for Contract Data Transfer | 3 | ZAEHLER | IS-M: Consecutive Counter for Transfer of External Data | nvarchar | 8 | 0 | | |
7 | TJHVSW01 | IS-M/AM: Assign Condition Types to VSW Fields | 3 | ZAEHLER | IS-M: Counter for discount/surcharge (occurence) | nvarchar | 1 | 0 | | |
TOPBasic Data |
8 | QPMK | Inspection characteristic master | 2 | ZAEHLER | Plant for the Master Inspection Characteristic | nvarchar | 4 | 0 | | |
9 | QPMT | Master Inspection Characteristics Texts | 2 | ZAEHLER | Plant for the Master Inspection Characteristic | nvarchar | 4 | 0 | | |
10 | QPMZ | Assignment table - insp. methods/master insp. characteristic | 2 | ZAEHLER | Plant for the Master Inspection Characteristic | nvarchar | 4 | 0 | | |
TOPBasic Data for Certificates |
11 | QCVM | Certificate profile characteristic level | 10 | ZAEHLER | Plant | nvarchar | 4 | 0 | | |
TOPBasic Functions |
12 | ECCN | Legal Control: Foreign Percentages | 8 | ZAEHLER | Standard price | decimal | 11 | 2 | | |
TOPCatalog |
13 | TQ07A | QM: Function Modules for Follow-Up Action | 3 | ZAEHLER | Counter in control tables | nvarchar | 2 | 0 | | |
TOPDigital Signature |
14 | TC73 | Digital Signature for Inspection Lot | 8 | ZAEHLER | Counter for Usage Decision | nvarchar | 6 | 0 | | |
TOPEnvironment, Health and Safety |
15 | EHQMT_MAIN1 | EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation | 17 | ZAEHLER | Plant for the Master Inspection Characteristic | nvarchar | 4 | 0 | | |
16 | EHQMT_MAIN2 | EH&S-QM: Characteristics for Inspection Plan Creation | 19 | ZAEHLER | Plant for the Master Inspection Characteristic | nvarchar | 4 | 0 | | |
TOPInspection Lot Completion |
17 | QAMB | QM: Link Between Inspection Lot and Material Document | 3 | ZAEHLER | Internal Counter for DB Objects | nvarchar | 6 | 0 | | |
18 | QAVE | Inspection processing: Usage decision | 4 | ZAEHLER | Counter for Usage Decision | nvarchar | 6 | 0 | | |
TOPInspection Planning |
19 | QMSP | QM: material specification | 3 | ZAEHLER | Internal Counter for DB Objects | nvarchar | 6 | 0 | | |
TOPLoans Management |
20 | VDCHK_IOA_OI | Check Interest on Arrears - Open Items | 12 | ZAEHLER | Loop Index | int | 10 | 0 | | |
TOPMaster Data |
21 | JGTMEMORY | IS-M/SD: Buffer Table for Data Transfer | 3 | ZAEHLER | IS-M: Consecutive Counter for Transfer of External Data | nvarchar | 8 | 0 | | |
TOPMaterial Categories |
22 | /ISDFPS/MPO_PROT | Log of Data Transfers into MPO | 3 | ZAEHLER | Sequence Number | nvarchar | 6 | 0 | | |
TOPPeriodical Sales and Distribution |
23 | JKTMEMORY | IS-M/SD: Buffer Table for Order Data Transfer | 3 | ZAEHLER | IS-M: Consecutive Counter for Transfer of External Data | nvarchar | 8 | 0 | | |
24 | JKTWBZIN | IS-M/SD: Clipboard for WBZ Records for Processing | 5 | ZAEHLER | IS-M: Consecutive Counter for Transfer of External Data | nvarchar | 8 | 0 | | |
25 | JKTWBZOUT | IS-M/SD: Clipboard for Processed WBZ Records | 5 | ZAEHLER | IS-M: Consecutive Counter for Transfer of External Data | nvarchar | 8 | 0 | | |
26 | JVTNOTICE | IS-M/SD: Carrier Change Notifications | 3 | ZAEHLER | IS-M: Internal Counter for Carrier Change Notification | int | 10 | 0 | | |
27 | JVTZAEM1 | IS-M/SD: Carrier Change Notification - Order Change | 3 | ZAEHLER | IS-M: Internal Counter for Carrier Change Notification | int | 10 | 0 | | |
28 | JVTZAEM2 | Sales Order Header Data | 3 | ZAEHLER | IS-M: Internal Counter for Carrier Change Notification | int | 10 | 0 | | |
29 | JVTZAEM3 | IS-M/SD: Carrier Change Notification - Pre-Fetch Messages | 3 | ZAEHLER | IS-M: Internal Counter for Carrier Change Notification | int | 10 | 0 | | |
30 | TJY09 | IS-M: Restart Data Transfer | 3 | ZAEHLER | IS-M: Consecutive Counter for Transfer of External Data | nvarchar | 8 | 0 | | |
TOPProfitability Analysis |
31 | CEERROR | CO-PA: Incorrect records from SD | 11 | ZAEHLER | Counter for errors in SD sales orders | nvarchar | 2 | 0 | | |
TOPQuality Inspection |
32 | QLOT_DS | Digital Signature for Inspection Lots | 5 | ZAEHLER | Counter for Usage Decision | nvarchar | 6 | 0 | | |
TOPResults Recording |
33 | QEWL | QM Handheld: Worklist for Transfer | 4 | ZAEHLER | QM Handheld: Continuous Counter | nvarchar | 6 | 0 | | |
TOPRuntime WorkbenchMonitoring |
34 | SXMSALERTLOG | XI Alert Log | 4 | ZAEHLER | General Counter | int | 10 | 0 | | |
35 | SXMSALERTLOGGER | XI Alert Logs | 3 | ZAEHLER | General Counter | int | 10 | 0 | | |
TOPTime Sheet |
36 | TCATSDLIST | CATS: Profile for Reporting (List Display) | 3 | ZAEHLER | Counter | nvarchar | 2 | 0 | | |
TOPTransaction Data Pool |
37 | JBDBAEND | Position Changes | 12 | ZAEHLER | Numerator in Split, Swap and Booking Relationship | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
38 | VWKMKO | Corporate actions (header) | 33 | ZAEHLER | Numerator in split ratio etc. | nvarchar | 8 | 0 | | |