| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P01E2_UMMELDUNG | ELStAM Procedure: Table of Change of Registration Data | 5 | GUELTIGAB | ELStAM: Key Date of Validity of Change List | nvarchar | 8 | 0 | | |
TOPAdvertising Management |
2 | JHTTBED | IS-M/AM: OPM - Rate Requirements | 6 | GUELTIGAB | IS-M: "Valid From" Date | nvarchar | 8 | 0 | | |
3 | JJTKS | IS-M/AM: Business Partner Hierarchy | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
4 | JJTVA | Incl/Exclusive Sales Agt Requirements for Entire Sales Area | 6 | GUELTIGAB | IS-M: "Valid From" Date | nvarchar | 8 | 0 | | |
5 | JJTVB | IS-M/AM: Requirement in Media Sales Agent Contract | 4 | GUELTIGAB | IS-M: "Valid From" Date | nvarchar | 8 | 0 | | |
TOPBasic Data |
6 | QMTB | Inspection method master record | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
7 | QMTT | Inspection Method Texts | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
8 | QPAC | Inspection catalog codes for selected sets | 8 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
9 | QPMK | Inspection characteristic master | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
10 | QPMT | Master Inspection Characteristics Texts | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
11 | QPMZ | Assignment table - insp. methods/master insp. characteristic | 9 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
TOPBasic Data for Certificates |
12 | QCVK | Certificate profile header | 6 | GUELTIGAB | Field Not Used Field Reserved for SAP | nvarchar | 8 | 0 | | |
TOPCatalog |
13 | QPCD | Inspection catalog codes | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
14 | QPCT | Code texts | 7 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
TOPInspection Planning |
15 | PLMK | Inspection plan characteristics | 8 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
16 | PLMW | MAPL-Dependent Charac. Specifications (Inspection Plan) | 9 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
TOPMaster Data |
17 | JSTAENDER | IS-M/SD: Change Number for Structure Maintenance | 3 | GUELTIGAB | IS-M: Date from Which Change Number is Valid | nvarchar | 8 | 0 | | |
18 | JSTALIAS | IS-M: Alias Table for Streets | 32 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
19 | JSTANDLOG | IS-M/SD: Log for Changes to JSTAENDER | 9 | GUELTIGAB | IS-M: Date from Which Change Number is Valid | nvarchar | 8 | 0 | | |
20 | JSTBEZBEZ | IS-M/SD: Assgmt Table for Carrier Route-Carrier Route Assgmt | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
21 | JSTCOUNTY | IS-M: Counties or Administrative Districts from USPS (USA) | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
22 | JSTGEOBEZ | IS-M/SD: Assignment of Carrier Routes to Geographical Units | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
23 | JSTGEOHIE | IS-M/SD: Geographical Hierarchy | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
24 | JSTGEOORG | IS-M/SD: Assignment of Geographical to Organizational Units | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
25 | JSTGEOPST | IS-M/SD: Assignments of Geographical to Postal Units | 7 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
26 | JSTKGSPRO | IS-M/SD: District Municipality File | 18 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
27 | JSTKGSUPDA | IS-M/SD: Table for Upgrade of Table JSTKGSPRO | 22 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
28 | JSTLAUF | IS-M/SD: Round Sequence | 8 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
29 | JSTORGHIE | IS-M/SD: Organizational Plan Hierarchy | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
30 | JSTORTPRO | IS-M/SD: City File (Post) | 24 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
31 | JSTORTUPDA | IS-M/SD: Table for Upgrade of Table JSTORTPRO | 27 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
32 | JSTOTLPRO | IS-M: City District File | 19 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
33 | JSTOTLUPDA | IS-M/SD: Table for Upgrade of Table JSTOTLPRO | 23 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
34 | JSTPLOUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZORT | 21 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
35 | JSTPLZORT | IS-M/SD: Assignment of Postal Codes to Cities | 16 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
36 | JSTPLZPRO | IS-M: Postal Codes | 22 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
37 | JSTPLZUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZPRO | 26 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
38 | JSTPOFPRO | IS-M/SD: PO Box Rack File | 23 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
39 | JSTPOFUPDA | IS-M/SD: Table for Upgrade of Table JSTPOFPRO | 29 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
40 | JSTROUPVA | IS-M/SD: Truck Route-Publication/Edition Assignment | 8 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
41 | JSTSTRPRO | IS-M/SD: Street File (Post) | 33 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
42 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 35 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
43 | JST_KGS_CONS | IS-M: Table for DMK Consolidation | 23 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
44 | JST_ORT_CONS | IS-M: Table for City Consolidation | 29 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
45 | JST_OTL_CONS | IS-M: Table for City District Consolidation | 27 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
46 | JST_PLZ_CONS | IS-M: Table for Postal Code Consolidation | 27 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
47 | JST_POF_CONS | IS-M: Table for PO Box Consolidation | 32 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
48 | JST_STR_CONS | IS-M: Table for Street Consolidation | 37 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
TOPPeriodical Sales and Distribution |
49 | JRTABLDBAR | IS-M/SD: Unloading Viability Set | 4 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
50 | JRTABLRGL | IS-M/SD: Unloading Rule (no longer used) | 13 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
51 | JRTABLRGLA | IS-M/SD: Unloading Rule for Unl.Point (Up to 5 Truck Routes) | 4 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
52 | JRTABLRGLB | IS-M: Unloading Rule for Carrier Route (Up to 6 Unl.Pts) | 4 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
53 | JRTROUBEA | IS-M/SD: Truck Route Unloading Point Sequence | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
54 | JRTROUHIE | IS-M/SD: Truck Route Hierarchy | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
55 | JVTBEZGP | IS-M/SD: Delivery Round - Business Partner | 8 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
56 | JVTLIEFBAR | IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets | 3 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
57 | JVTPSTFEHL | IS-M/SD: Postal Units not Delivered | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
TOPQuality Inspection |
58 | QALS | Inspection lot record | 89 | GUELTIGAB | Key Date for Selecting Records or Changing Task Lists | nvarchar | 8 | 0 | | |
TOPSample Management |
59 | QPRVK | Sample-drawing procedure | 4 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
TOPSAP Media |
60 | J_1SBOTPRO | IS-M/SD CH/S: CH Carrier Data | 8 | GUELTIGAB | IS-M: CH/S: Validity Date | nvarchar | 8 | 0 | | |
61 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 40 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
62 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 45 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
TOPTax |
63 | P01E2_ANMELDUNG | ELStAM Procedure: Table of Registration Data | 5 | GUELTIGAB | ELStAM: Key Date of Validity of Change List | nvarchar | 8 | 0 | | |
64 | P01E2_ELSTAM | ELStAM Procedure: Table of Change Lists | 4 | GUELTIGAB | ELStAM: Key Date of Validity of Change List | nvarchar | 8 | 0 | | |
65 | P01T_ELSTAM | ETStmt: ELStAM (as of 2012) | 6 | GUELTIGAB | ELStAM: Key Date of Validity of Change List | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
66 | AT200 | Rules for Determining a Tax Indicator | 2 | GUELTIGAB | Valid From | nvarchar | 8 | 0 | | |
67 | AT210 | Rules for Determining a Taxes for CFM postings | 2 | GUELTIGAB | Valid From | nvarchar | 8 | 0 | | |