| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKK_MA_PRT | Product Texts | 7 | LGTXT | Long Text for Product | nvarchar | 100 | 0 | | |
2 | PA3326 | HR Master Record: Infotype 3326 | 31 | LGTXT | Tax Comment | nvarchar | 50 | 0 | | |
3 | T578A | Medical Doctors | 4 | LGTXT | Physician | nvarchar | 25 | 0 | | |
4 | T5FPBS1AT | Texte position administrative | 5 | LGTXT | Texte de longueur 40 | nvarchar | 40 | 0 | | |
5 | T5WRTW | Retro wagetypes configuration | 5 | LGTXT | Long text of retro code | nvarchar | 50 | 0 | | |
6 | T77REWCN_EXT_WTT | Extend Wage Type Text for Free Search | 5 | LGTXT | Wage Type Long Text | nvarchar | 25 | 0 | | |
7 | T77REWCN_WTG_T | Assign Wage Types to Wage Type Groups Text Table | 6 | LGTXT | Wage Type Long Text | nvarchar | 25 | 0 | | |
TOPBasic Data |
8 | NABG | IS-H: Employer (Business Partner) | 4 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
9 | NBAU | IS-H: Building Units | 26 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
10 | NDEB | IS-H: Business Partner/IS-H Customer Supplement | 6 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
11 | NGPA | IS-H: Business Partners | 30 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
12 | NKRH | IS-H: Hospitals (Business Partners) | 4 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
13 | NKTR | IS-H: Business Partners/Insurance Providers | 11 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
14 | NORG | IS-H: Organizational Units | 18 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
15 | NPER | IS-H: Persons | 15 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
16 | TN02T | IS-H: Text Table for Events (TN02E) | 5 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
TOPBelgium |
17 | PA3207 | Personal-Stammsatz Infotyp 3207 | 36 | LGTXT | Additional Payment Description | nvarchar | 50 | 0 | | |
TOPClinical System |
18 | N1PRTLNR | IS-H*MED: PATREG: Teilnehmerstammdatentabelle | 8 | LGTXT | PATREG: Bagli sirketteki katilimci adi | nvarchar | 25 | 0 | | |
19 | N2CLIM_OBSVS | Vital Signs: Examination | 9 | LGTXT | Indicator Whether Comment Exists | nvarchar | 1 | 0 | | |
20 | N2CLIM_VALVS | Vital Signs: Measured Values | 13 | LGTXT | Indicator Whether Comment Exists | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
21 | DFKK_VT_PRDT | PRD: Texts for Product | 5 | LGTXT | Long Text for Product | nvarchar | 100 | 0 | | |
TOPDenmark |
22 | T5M8E | Verify Changes to Wage Type Texts | 5 | LGTXT | Wage Type Long Text | nvarchar | 25 | 0 | | |
23 | T5V3D | Texts for T5V3C (DK/N) | 5 | LGTXT | Wage Type Long Text | nvarchar | 25 | 0 | | |
TOPExternal Services |
24 | ESLL | Lines of Service Package | 32 | LGTXT | Wage Type Long Text | nvarchar | 25 | 0 | | |
TOPFrance |
25 | T5F63 | Dynamic Mapping for Interface: Interfaced Wage Types | 6 | LGTXT | Wage Type Long Text | nvarchar | 25 | 0 | | |
TOPPatient Accounting |
26 | NCIR | IS-H: Insurance Relationships of a Case | 44 | LGTXT | Language Key | nvarchar | 1 | 0 | | |
27 | NPIR | IS-H: Insurance Relationship Proposal Pool | 43 | LGTXT | Language Key | nvarchar | 1 | 0 | | |
TOPPatient Management |
28 | NAPP | IS-H: Provisional Appointments for Visit Scheduling | 21 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
29 | NBEW | IS-H: Movements for Case | 20 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
30 | NDIA | IS-H: Diagnoses | 28 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
31 | NFFZ | IS-H: Assignment of a case to another case | 10 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
32 | NFKL | IS-H: Case classification | 17 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
33 | NFPZ | IS-H: Assignment of a case to a person | 11 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
34 | NGEB | IS-H: Birth Data of Newborns | 14 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
35 | NKSK | IS-H: Insurance verification/certificate - Header data | 28 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
36 | NPAT | IS-H: Patient Master Data (General) | 75 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
37 | NRSF | IS-H: Patient Risk Factors | 6 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
38 | NSHIFT | IS-H: Results of Case Revision | 16 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
39 | NVVF | IS-H: Case-Related Insurance Relationships | 11 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
40 | NVVP | IS-H: Patient-related insurance relationship | 36 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
41 | TNPGR | IS-H: Patient groups for PPR (Germany) | 12 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
TOPPayroll |
42 | T5T4B | Text of lines of forms | 5 | LGTXT | Text of total group | nvarchar | 50 | 0 | | |
43 | T7RO4B | Forms - field properties | 5 | LGTXT | Text of total group | nvarchar | 60 | 0 | | |
44 | T7SK4B | Texts of summary groups of payroll form | 5 | LGTXT | Text of total group | nvarchar | 50 | 0 | | |
45 | T7TRIC01 | Ücret Türü Tanim Tablosu | 3 | LGTXT | Ücret Türü Uzun Metni | nvarchar | 25 | 0 | | |
46 | T7UA_512T | Wage Type Long Texts | 5 | LGTXT | Wage Type Long Text | nvarchar | 200 | 0 | | |
TOPPayroll General Parts |
47 | T512S | Texts for Cumulation Wage Types in Forms | 6 | LGTXT | Wage Type Long Text | nvarchar | 25 | 0 | | |
48 | T52A0_T | Texts for Objects in T52A0 | 5 | LGTXT | Long Texts for Table T52A0 | nvarchar | 70 | 0 | | |
TOPPersonnel Administration |
49 | T512T | Wage Type Texts | 5 | LGTXT | Wage Type Long Text | nvarchar | 25 | 0 | | |
50 | T703T | Incentive Wages: Premium Formula Texts | 4 | LGTXT | Premium formula text | nvarchar | 30 | 0 | | |
51 | T7PLZLA_MODT | Remuneration models for PLZLA - texts | 6 | LGTXT | Model of PLZLA description | nvarchar | 25 | 0 | | |
52 | T7SI2T | Type of Inalidism SI Texts | 4 | LGTXT | Texts | nvarchar | 30 | 0 | | |
53 | T7SI3T | Article 212 Texts | 4 | LGTXT | Texts | nvarchar | 30 | 0 | | |
54 | T7SI4T | Type of Inalidism SI Texts | 4 | LGTXT | Texts | nvarchar | 30 | 0 | | |
55 | T7SI5T | Limitation of work Texts | 4 | LGTXT | Texts | nvarchar | 30 | 0 | | |
TOPPersonnel Time Management |
56 | T5550 | [OBSOLETE; NOW USE T705Q] Ext. Wage Types from Subsystem Txt | 6 | LGTXT | Wage Type Long Text | nvarchar | 25 | 0 | | |
57 | T705Q | External Wage Types Long Texts from Subsystem | 6 | LGTXT | Wage Type Long Text | nvarchar | 25 | 0 | | |
TOPProcess Controls -Automated Controls |
58 | GRPCRTA_HRDA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 23 | LGTXT | Wage Type Long Text | nvarchar | 25 | 0 | | |
59 | GRPCRTA_HRDA0267 | PC HR control data for infotype 0267 | 23 | LGTXT | Wage Type Long Text | nvarchar | 25 | 0 | | |
60 | GRPCRTA_HRDAT1 | PC HR control data for infotype 0014 and 0015 | 23 | LGTXT | Wage Type Long Text | nvarchar | 25 | 0 | | |
TOPReuse Services for Country Development |
61 | PA0860 | HR Master Record: Infotype 0860 | 47 | LGTXT | Prefix for Long Text IDs | nvarchar | 70 | 0 | | |
62 | PA0861 | HR Master Record: Infotype 0861 | 40 | LGTXT | Prefix for Long Text IDs | nvarchar | 70 | 0 | | |
TOPRussia |
63 | PA0298 | HR Master Record: Infotype 0298 | 36 | LGTXT | Prefix for Long Text IDs | nvarchar | 70 | 0 | | |
TOPSAP Ambulatory Care Management |
64 | NREDOMA | IS-H: Table Renewable Documents - Header Data | 20 | LGTXT | Language Key | nvarchar | 1 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
65 | NAPX | IS-H: Appendix Main Data | 3 | LGTXT | Language Key | nvarchar | 1 | 0 | | |
66 | NDAE | IS-H: Requesting/borrowing medical records | 18 | LGTXT | IS-H: Indicator that Borrowing Long Text Exists | nvarchar | 1 | 0 | | |
TOPTime Tickets |
67 | T703M | Incentive Wages: Texts for Time Ticket Types | 4 | LGTXT | Long text for time ticket type | nvarchar | 30 | 0 | | |
68 | T703R | Incentive Wages: Text for Premium Formula/Premium Result | 5 | LGTXT | Premium formula text | nvarchar | 30 | 0 | | |
TOPVenezuela |
69 | T7VEST | Description of Risks | 3 | LGTXT | Description of Hazard Codes | nvarchar | 40 | 0 | | |
TOPVital Signs |
70 | N1VPST | Master Data Vital Signs (Language-Dependent Texts) | 7 | LGTXT | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
TOPWithout Description |
71 | RSTT_REP_T | Table of Existing BI Reports for RSTT Reporting | 4 | LGTXT | Trace Tool: General Text Field | nvarchar | 128 | 0 | | |
72 | RSTT_TREQ_T | Texts for Test Requests | 3 | LGTXT | Description | nvarchar | 60 | 0 | | |