| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_DFKO | OI Extraction TDMS for ISU | 5 | INTNR | PERBL für TDTIM | nvarchar | 7 | 0 | | |
2 | ODTF_IDOC_LOG_PJ | Log for Project WBS Element Replication via IDOC to CfTE | 10 | INTNR | | nvarchar | 8 | 0 | | |
3 | P2NZ_LVAWE | Payroll Result: Leave Entitlement LVAWE - NZ | 9 | INTNR | Wage Type Internal Number - NZ | nvarchar | 4 | 0 | | |
4 | TNRT3 | Test no.ranges:with,w/o subobj.;indep.grp; 2 no.range fields | 2 | INTNR | Number range number | nvarchar | 2 | 0 | | |
5 | TNRT6 | Test no.ranges:with,w/o subobj.;indep.grp; 2 no.range fields | 2 | INTNR | Number range number | nvarchar | 2 | 0 | | |
6 | TNRT8 | Test no.ranges:with subobject;dep.group;2 no.range fields | 3 | INTNR | Number range number | nvarchar | 2 | 0 | | |
7 | TNRT8A | Test no.ranges:with subobject;dep.group;2 no.range fields | 3 | INTNR | Number range number | nvarchar | 2 | 0 | | |
8 | PIQDBAGM_INT | Transfer Regulations: Internal Work and Qualifications | 3 | INTNR | Sequence Number of Internal Academic Achievement | nvarchar | 3 | 0 | | |
TOPAustralia |
9 | T5QLR | Leave Accrual Rules Australia | 16 | INTNR | Internal Number for Leave Type Assignment | nvarchar | 4 | 0 | | |
TOPBasic Functions |
10 | EMMA_CASE | Clarification Case | 5 | INTNR | Number of Job Interval | int | 10 | 0 | | |
11 | EMMA_HDR | Prepared Application Logs | 14 | INTNR | Number of Job Interval | int | 10 | 0 | | |
12 | EMMA_INT | Prepared Intervals in Application Logs | 3 | INTNR | Number of Job Interval | int | 10 | 0 | | |
TOPCollectionsDisbursements |
13 | VVKKISUMIOB | Bal. Interest Calc. Acc. to Ins. Obj.: Interest Total | 4 | INTNR | Number of interval within variant | int | 10 | 0 | | |
TOPContract Accounts Receivable and Payable |
14 | DFKKCIBW | FICA: Extraction of Cleared Items | 4 | INTNR | Number of Interval within Variant (BW Extraction) | nvarchar | 7 | 0 | | |
15 | DFKKCOLLP_IM_W | Buffer: Coll. Agency Info File (Item Master Data Change) | 5 | INTNR | Interval Number | nvarchar | 10 | 0 | | |
16 | DFKKCOLLP_IP_W | Buffer: Collection Agency Info File (Item for Payments) | 5 | INTNR | Interval Number | nvarchar | 10 | 0 | | |
17 | DFKKCOLLP_IR_W | Buffer: Collection Agency Info File (Item for Callback) | 5 | INTNR | Interval Number | nvarchar | 10 | 0 | | |
18 | DFKKDOUBTD_RET_W | Buffer: Printout for Ind.Val.Ad - Return Values (User Event) | 4 | INTNR | Interval Number | nvarchar | 10 | 0 | | |
19 | DFKKDOUBTD_W | Buffer: Create Printout for Receivables Adjustment | 4 | INTNR | Interval Number | nvarchar | 10 | 0 | | |
20 | DFKKOPBW | OI Extraction | 4 | INTNR | Number of Interval within Variant (BW Extraction) | nvarchar | 7 | 0 | | |
21 | DFKKOP_REH | Exports of Open Items from FPO4 | 3 | INTNR | Number of interval within variant | int | 10 | 0 | | |
22 | DFKKOP_REP | Open Items from FPO4 | 3 | INTNR | Number of interval within variant | int | 10 | 0 | | |
23 | DFKKRPL | Link from Mass Run Interval for Application Log | 5 | INTNR | Number of interval within variant | int | 10 | 0 | | |
24 | DFKKSTAT | Table for Temporary Statistics Data, for Mass Activities | 5 | INTNR | Number of interval within variant | int | 10 | 0 | | |
25 | DFKKZWFPT | Log Table for Mass Activ. for Tfr Posting of Dbt Rec/IVAs | 4 | INTNR | Number of interval within variant | int | 10 | 0 | | |
26 | DFKKZWPT | Log Table for Mass Activ. for Tfr Posting of Dbt Rec/IVAs | 4 | INTNR | Number of interval within variant | int | 10 | 0 | | |
27 | FKKDIPOS | FI-CA: Distribution of intervals - items | 4 | INTNR | Number of interval within variant | int | 10 | 0 | | |
28 | FKKDIPOTMP | FI-CA: Distrib. of intervals - temporal copy of items | 4 | INTNR | Number of interval within variant | int | 10 | 0 | | |
29 | FKKDIPOTMPCOUNT | FI-CA: Counter for Each Entry from FKKDIPOTMP | 4 | INTNR | Number of interval within variant | int | 10 | 0 | | |
TOPContract Billing |
30 | ERCHV_GEN_PROT | Structure Log of Consumption History | 5 | INTNR | Number of interval within variant | int | 10 | 0 | | |
TOPEnergy Data Management |
31 | EFORMULAINTERVAL | ISU EDM Intervals of Hierarchy Level (DB table) | 5 | INTNR | Interval number | nvarchar | 10 | 0 | | |
TOPInvoicing |
32 | ERPL | IS-U: Link of Mass Run Interval to Application Log | 5 | INTNR | Number of interval within variant | int | 10 | 0 | | |
TOPLogistics - General |
33 | HBSAUT | Helper table for auto generation ... | 4 | INTNR | Counter | nvarchar | 8 | 0 | | |
34 | HBSCMP | Community Plan Data within Home Building Solution | 4 | INTNR | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | | |
TOPMaintenance Orders |
35 | IWOT_HEAD | Assignment of Header Data Screens for External Labels | 1 | INTNR | Screen Area | nvarchar | 3 | 0 | | |
36 | IWOT_HEADT | Assignment of Header Data Screens for External Labels: Texts | 1 | INTNR | Screen Area | nvarchar | 3 | 0 | | |
37 | IWOT_SUB | Assignment of Subscreens to External Labels | 1 | INTNR | Screen Area | nvarchar | 3 | 0 | | |
38 | IWOT_SUBT | Assignment of Subscreens to External Labels: Texts | 1 | INTNR | Screen Area | nvarchar | 3 | 0 | | |
TOPNew Zealand |
39 | T7NZLC | Leave Payment Calculation Table - NZ | 8 | INTNR | Wage Type Internal Number - NZ | nvarchar | 4 | 0 | | |
40 | T7NZLL | Leave Payment Calculation Table - NZ | 11 | INTNR | Wage Type Internal Number - NZ | nvarchar | 4 | 0 | | |
41 | T7NZLR | Leave Rule Table - NZ | 8 | INTNR | Wage Type Internal Number - NZ | nvarchar | 4 | 0 | | |
TOPPayroll General Parts |
42 | PA0165 | HR Master Record: Infotype 0165 (Limits Deductions) | 25 | INTNR | Interval for Limits | nvarchar | 4 | 0 | | |
43 | T51D1 | Limits for Deductions | 8 | INTNR | Interval for Limits | nvarchar | 4 | 0 | | |
44 | T51D6 | Interval Definitions | 3 | INTNR | Interval for Limits | nvarchar | 4 | 0 | | |
45 | T51DS | Text for Time Intervals | 4 | INTNR | Interval for Limits | nvarchar | 4 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
46 | NWATINTENS | IS-H AT: Intensivdokumentation - Patientenadministration | 5 | INTNR | IS-H AT: interne laufende Nummer für Intensivdokumentation | nvarchar | 3 | 0 | | |
47 | NWATPHYS | IS-H AT: Intensivdokumentation - Physiologische Daten | 5 | INTNR | IS-H AT: interne laufende Nummer für Intensivdokumentation | nvarchar | 3 | 0 | | |
48 | NWATTISS28 | Intensivdoku. - Pflege- u. Therapiedoku. (TISS-28 / TISS-A ) | 5 | INTNR | IS-H AT: interne laufende Nummer für Intensivdokumentation | nvarchar | 3 | 0 | | |
49 | NWATTRISS | IS-H AT: Intensivdoku. - Erfass. traumatologischer Patienten | 5 | INTNR | IS-H AT: interne laufende Nummer für Intensivdokumentation | nvarchar | 3 | 0 | | |
50 | TNA40Z | IS-H AT: Zeiten für Zuschlagsleistungen | 7 | INTNR | IS-H AT: Interne Nummer | nvarchar | 4 | 0 | | |
51 | TNNLACTIV | Sorge Aktivität kode | 3 | INTNR | IS-H: Alternative Identifikation einer Tarifposition | nvarchar | 12 | 0 | | |
52 | TNWAT_LEIKOM_HDR | IS-H AT: Leistungskombinationen umschlüsseln - Header | 15 | INTNR | Interne Nummer | nvarchar | 10 | 0 | | |
53 | TNWAT_LEIKOM_POS | IS-H AT: Leistungskombinationen umschlüsseln - Position | 5 | INTNR | Interne Nummer | nvarchar | 10 | 0 | | |
54 | TNWCHHONHEAD | Fee Header Table for Released Breakdown Data | 4 | INTNR | Internal Number | nvarchar | 10 | 0 | | |
55 | TNWCHHONHEADCD | Fee Header Table for Released Breakdown Codes | 4 | INTNR | Internal Number | nvarchar | 10 | 0 | | |
56 | TNWCHHONPOS102 | Fee Item Data for Pools | 4 | INTNR | Internal Number | nvarchar | 10 | 0 | | |
57 | TNWCHHONPOS98 | Fee Item Data for Codes - Limitations | 4 | INTNR | Internal Number | nvarchar | 10 | 0 | | |
58 | TNWCHHONPOS98S | Fee Item Data for Codes - Limit Levels | 4 | INTNR | Internal Number | nvarchar | 10 | 0 | | |
59 | TNWCHHONPOS99 | Fee Item Data for Codes - Breakdown Code | 4 | INTNR | Internal Number | nvarchar | 10 | 0 | | |
60 | TNWCHHONPOS99S | Fee Item Data for Codes - Breakdown Code | 4 | INTNR | Internal Number | nvarchar | 10 | 0 | | |
TOPSAP Utilities |
61 | ESMON_MARUNIDINT | Monitoring Mass Run: Buffer for Intervals | 6 | INTNR | Number of interval within variant | int | 10 | 0 | | |
TOPTechnical Objects |
62 | TITOBSUB | Technical Objects: Subscreens with Customizable Assignment | 2 | INTNR | Sequence Number | nvarchar | 3 | 0 | | |
63 | TITOBSUBT | Technical Objects: Texts for Subscreens from Table TITOBSUB | 2 | INTNR | Sequence Number | nvarchar | 3 | 0 | | |