| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RD_VBL | Payroll Result: Supplementary Pension Public Sector | 37 | VAKEY | Variable Key for Employer Table | nvarchar | 8 | 0 | | |
2 | T5FDSNPAVAL | Table des paramètres DSN | 4 | VAKEY | Clé variable - 70 octets | nvarchar | 70 | 0 | | |
3 | TNADR | Output Control: do not use, will be deleted | 3 | VAKEY | Variable key | nvarchar | 34 | 0 | | |
TOPAssortment List |
4 | WDLSO | POS outbound log: object with errors | 4 | VAKEY | Key for POS outbound object error | nvarchar | 40 | 0 | | |
TOPBasic Data for Certificates |
5 | I000 | Conditions for certificate profile | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPBasic Functions |
6 | KOND3 | Conditions: Campaign Determination - Data Part | 7 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPBatches |
7 | R000 | Condition table for derivation strategy R | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPChargeback |
8 | WB2_D_BUSVOLBASE | Rebates: Business Volume Base for Condition Contract | 5 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
9 | WB2_D_BVB_SETTL | CCS: Snapshot Business Volume Base Data used for settlement | 7 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPConditions |
10 | A000 | Condition Table for Pricing $ | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
11 | B000 | $ Sample Table for output control | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
12 | C000 | Condition Table for Acct.Determination: $ | 5 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
13 | CND_MEM_INITIAL | Conditions: Buffer for Initial Upload | 6 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
14 | D000 | Condition Table for Material Determination $ | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
15 | E000 | Condition Table for Rebate $ | 4 | VAKEY | Variable key 50 bytes | nvarchar | 50 | 0 | | |
16 | F000 | Condition Table for Secondary Indexes $ | 3 | VAKEY | Variable key | nvarchar | 100 | 0 | | |
17 | G000 | Condition Table for Material Listing/Exclusion $ | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
18 | H000 | Condition Table for Batch Search Strategy $ | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
19 | KONDN | Conditions: Free goods - Data section | 19 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
20 | KONH | Conditions (Header) | 9 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
21 | MASTER_3000 | Condition Table for Campaign Determination | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
22 | N000 | Condition table for free goods determination | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
23 | VBOX | SD Document: Billing Document: Rebate Index | 4 | VAKEY | Variable key 50 bytes | nvarchar | 50 | 0 | | |
TOPConstruction Equipment Management |
24 | J_3GJ000 | Condition Table for Price List Determination | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
25 | J_3GPRLHD | CEM Price Lists Condition Header | 9 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPCost Center Accounting |
26 | TKRSTR | Transport Resource Prices | 9 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPData Collection |
27 | MCS0 | Reference Structure for Generating Info Structures | 8 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
28 | MCS1 | Model Structure for Info Structures with Initial VAKEY | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
29 | MCS2 | Sample Structure for Structural Information - Info Structure | 3 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPDistributor-Reseller-Management |
30 | W000 | Condition Table for Rule Determination $ | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPExtended Rebate |
31 | S469 | Erweiterte Bonusabrechnung | 10 | VAKEY | Variabele keycode 100 bytes | nvarchar | 100 | 0 | | |
TOPGermany |
32 | T5D3R | HR-DEH: Entry of External Data | 6 | VAKEY | Variable Key 70 Bytes | nvarchar | 70 | 0 | | |
TOPMaster data |
33 | P000 | Conditions for Packing Object | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPOutput Determination |
34 | NACH | Detailed output data | 9 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPOverhead Cost Orders |
35 | TKZUTR | Transport Overhead Records | 9 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPPeriodical Sales and Distribution |
36 | JLTPST2 | IS-M/SD: Main Data for Batch Input Postal Charges | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPPosition Management |
37 | KONHM | Portfolio Determination - Data Part | 11 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
38 | M000 | Master Table for Portfolio Determination | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPPricing |
39 | PRCM_TABL_000 | Reference Table for Condition Tables (A000) | 3 | VAKEY | Variable Key Part of a Condition Table | nvarchar | 200 | 0 | | |
TOPProduct Safety |
40 | V000 | EHS: Conditions for Variant Matching | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPPublic Sector |
41 | PA0051 | HR Master Record Infotype 0051 (VBL/SPI Data) | 48 | VAKEY | Variable Key for Employer Table | nvarchar | 8 | 0 | | |
42 | PDPBSZVADM | Administration Table for ZVE-PBS Notification Procedure | 14 | VAKEY | Variable Key for Employer Table | nvarchar | 8 | 0 | | |
43 | PDPBSZVSUM | Totals Record (Record Type 90), SPI | 8 | VAKEY | Variable Key for Employer Table | nvarchar | 8 | 0 | | |
44 | PDPBSZV_PA0051 | ZVMP Employer to Be Overridden in IT0051 (Before ZVMP) | 7 | VAKEY | Variable Key for Employer Table | nvarchar | 8 | 0 | | |
45 | T5DPBSZVAG | Employer-Specific Settings | 4 | VAKEY | Variable Key for Employer Table | nvarchar | 8 | 0 | | |
46 | T5DPBSZVAGE | Employer-Specific Settings: Entity | 4 | VAKEY | Variable Key for Employer Table | nvarchar | 8 | 0 | | |
47 | T5DPBSZVAGT | Employer-Specific Settings: Text | 5 | VAKEY | Variable Key for Employer Table | nvarchar | 8 | 0 | | |
TOPPurchase Orders |
48 | WIND | Document Index: Conditions for Automatic Document Adjustment | 13 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
49 | /BEV1/RBWE | Itemized Proof Rebate Settlement | 15 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |
TOPRetail Enterprise Services |
50 | WESD_OUTB_STATUS | Status Table for Outbound Services | 4 | VAKEY | Variable Key | nvarchar | 50 | 0 | | |
TOPReuse Services for Country Development |
51 | T596M | Data Personnel Area Reporting | 6 | VAKEY | Variable Key 70 Bytes | nvarchar | 70 | 0 | | |
52 | T596NV | Summary Personnel Area Reporting | 6 | VAKEY | Variable Key 70 Bytes | nvarchar | 70 | 0 | | |
TOPService Station Retailing |
53 | Q000 | Condition Table for Acct.Determination: $ | 4 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | |