| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TMCB | Update groups | 2 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
2 | TQ55 | Assign inspection lot origin for update group | 3 | STAFO | Update Group: Inspection Lots / Usage Decision | nvarchar | 6 | 0 | | |
3 | TVSFK | Update Group: Statistics (Header) | 7 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
4 | TVSFP | Update Group: Statistics (Item) | 9 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
5 | ZEIM_LIPS | SD document: Delivery: Item data | 78 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
6 | ZEIM_VBAK | Sales Document: Header Data | 50 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
7 | ZEIM_VBAP | Sales Document: Item Data | 111 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPAdvertising Management |
8 | JHAE | IS-M/AM: OPM Sub-Item Schedule Line | 32 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
9 | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | 233 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
10 | JHAK | IS-M/AM: Order-Publishing-Media (Header Data) | 22 | STAFO | IS-M: Update group for statistics update | nvarchar | 6 | 0 | | |
11 | JHAP | IS-M/AM: Order-Publishing-Media Item | 112 | STAFO | IS-M: Update group for statistics update | nvarchar | 6 | 0 | | |
12 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 81 | STAFO | IS-M: Update group for statistics update | nvarchar | 6 | 0 | | |
13 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 87 | STAFO | IS-M: Update group for statistics update | nvarchar | 6 | 0 | | |
14 | TJH05 | IS-M/AM: Billing: Document Types | 29 | STAFO | IS-M: Billing header: Update group for statistics | nvarchar | 6 | 0 | | |
15 | TJHMC1 | IS-M/AM: Update Group Determination for Order Header | 7 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
16 | TJHMC2 | IS-M/AM: Statistic Group Determination for Billing Dataset | 9 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
17 | TJHMC3 | Statistics Group Determination for Item/B.Datatset/Schd.Line | 9 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
18 | TJJMC1 | IS-M/SD: Provisional Test | 8 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPAgency Business Global Trade |
19 | WBRK | Agency business: Header | 59 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
20 | WBRP | Agency business: Item | 25 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPBasic Functions |
21 | T014 | Credit control areas | 4 | STAFO | Credit update for open order/delivery/billing document value | nvarchar | 6 | 0 | | |
22 | TVFK | Billing: Document Types | 23 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPBilling |
23 | VBRK | Billing Document: Header Data | 51 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
24 | VBRP | Billing Document: Item Data | 76 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPContract Billing |
25 | DBERCHZ | Individual Line Items | 128 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
26 | DBERCHZ1 | Individual line items | 82 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
27 | DBERCHZ5 | Individual line items (unimportant rows) | 82 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
28 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 40 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPCross-Application Components |
29 | VVBAK | Sales Document: Header Data | 50 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
30 | VVBAP | Sales Document: Item Data | 111 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPData Collection |
31 | TMC2 | LIS: Status Management - Updating | 3 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
32 | TMC2D | Key Figures (Updating) | 3 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
33 | TMC2DS | Key Figures (Updating) | 3 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
34 | TMC2F | Relevant Update Routines for Info Structures | 4 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
35 | TMC2K | Objects (Updating) | 3 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
36 | TMC2KS | Objects (Updating) | 3 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
37 | TMC2P | Table for Number Assignment of Update Reports | 3 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
38 | TMC2Q | Reference as to Which Update Uses Which Program | 3 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
39 | TMC2S | Info Structures to be Updated per Business Event | 3 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
40 | TMC5 | Business Events for Statistics Updating | 7 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
41 | TMCBT | Update Groups (LIS): Texts | 3 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPInformation System |
42 | MCVSRFK | Statistically Relevant Fields for Order + Delivery Header | 4 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
43 | MCVSRFP | Statistically Relevant Fields for Order + Billing Document | 4 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
44 | TKSFK | Update Sequence: Sales Activity Processing Statistics: Headr | 7 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPInspection Lot Completion |
45 | QAVE | Inspection processing: Usage decision | 23 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPInvoicing |
46 | DBERDZ | DB Table: Individ. Lines - Print Document | 154 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPMaintenance Notifications |
47 | TQ80 | Notification Types | 36 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPPeriodical Sales and Distribution |
48 | JFRK | IS-M/SD: Billing - Header Data | 41 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
49 | JFRP | IS-M/SD: Billing Document - Item Data | 36 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
50 | JKAK | Sales Order Header Data | 32 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
51 | JKAP | Sales Order - Item Data | 34 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
52 | JLRK | IS-M/SD: Settlement Header Data | 28 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
53 | JLRP | IS-M/SD: Item Data for Settlement | 38 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
54 | JVTLFNG | IS-M/SD: Delivery/Home Delivery | 41 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
55 | JVTZAEM2 | Sales Order Header Data | 34 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
56 | TJFK | IS-M/SD: Billing Document Types | 22 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
57 | TJKMC3 | IS-M/SD: Definition of Update Group for Sales Doc., Header | 7 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
58 | TJKMC4 | IS-M/SD: Definition of Update Group for Sales Doc., Item | 9 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
59 | TJKMC5 | IS-M/SD: Definition of Update Group for Deliveries | 6 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
60 | TJKMC6 | IS-M/SD: Def.of Update Group per Order-Delivery Assgmt | 9 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
61 | TJL11 | IS-M/SD: Object Types for Document Flow etc. | 19 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPPurchasing |
62 | EKKO | Purchasing Document Header | 53 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
63 | EKPO | Purchasing Document Item | 82 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
64 | T161 | Purchasing Document Types | 11 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
65 | T163 | Item Categories in Purchasing Document | 12 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
66 | TMSI2 | Processing Key for Sub-Items | 13 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPQuality Inspection |
67 | QALS | Inspection lot record | 52 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
68 | /BEV1/RBBO | Customer Master Data Rebate Processing | 14 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
69 | /BEV1/RBSTAFO | Define Update Groups for Virtual Documents | 2 | STAFO | Update Group for Statistics Update | nvarchar | 6 | 0 | | |
70 | /BEV1/RBTMC2F | Temporary Storage of Contents from TMC2F | 4 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
71 | /BEV1/RBVBAK | Sales Document: Header Data | 50 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
72 | /BEV1/RBVBAP | Sales Document: Item Data | 111 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPReporting |
73 | VTSFF | Updating Sequence: Statistics Shipment | 5 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPSales |
74 | VBAK | Sales Document: Header Data | 50 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
75 | VBAP | Sales Document: Item Data | 111 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPSales Activities |
76 | VBKA | Sales Activities | 52 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPShipping |
77 | LIKP | SD Document: Delivery Header Data | 50 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
78 | LIPS | SD document: Delivery: Item data | 78 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPSimulation |
79 | VSVBAK_CN | Version: Sales document: Header data | 51 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
80 | VSVBAP_CN | Version: Sales document: Item data | 112 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPStatistics |
81 | TE775 | Update Group Determination | 5 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
TOPTransportation |
82 | VTTK | Shipment Header | 70 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |
83 | VTTS | Stage of Shipment | 66 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | | |