| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVCMIS_A_1_LDBD | Administration information for LDB | 11 | VERNR | Version number | nvarchar | 6 | 0 | | |
2 | P01BN_BWXX | Data Record: Contribution Statement | 7 | VERNR | Version Number | nvarchar | 2 | 0 | | |
3 | P2RD_VBL | Payroll Result: Supplementary Pension Public Sector | 38 | VERNR | Supp. Insurance Number | nvarchar | 12 | 0 | | |
4 | PDPBSZVADM_R | SPI Confirmation: Administration Table | 14 | VERNR | Supp. Insurance Number | nvarchar | 12 | 0 | | |
TOPConstruction Industry |
5 | PDBKAN | Construction Industry Social Fund Proced: ANMEL Data Records | 13 | VERNR | Version of Data Medium Exchange | nvarchar | 2 | 0 | | |
6 | PDBKAU | Construction Industry Social Fund Proced: AUMEL Data Records | 13 | VERNR | Version of Data Medium Exchange | nvarchar | 2 | 0 | | |
7 | PDBKBE | Constr. Ind. Social Fund Procedure: BEMEL (PerNo) Records | 13 | VERNR | Version of Data Medium Exchange | nvarchar | 2 | 0 | | |
8 | PDBKBESUM | Constr. Ind. Social Fund Procedure: BEMEL Records (Total) | 17 | VERNR | Version of Data Medium Exchange | nvarchar | 2 | 0 | | |
9 | PDBKLO | Construction Industry Social Fund Proced: LOMEL Data Records | 13 | VERNR | Version of Data Medium Exchange | nvarchar | 2 | 0 | | |
10 | PDBKNE | Construction Industry Social Fund Proced: NEMEL Data Records | 13 | VERNR | Version of Data Medium Exchange | nvarchar | 2 | 0 | | |
11 | PDBKRA | Construction Industry Social Fund Proced: RAMEL Data Records | 13 | VERNR | Version of Data Medium Exchange | nvarchar | 2 | 0 | | |
12 | PDBKUR | Construction Industry Social Fund Proced: URMEL Data Records | 13 | VERNR | Version of Data Medium Exchange | nvarchar | 2 | 0 | | |
TOPGermany |
13 | PD3DSME | HR-DDU: Data Record Notfication | 8 | VERNR | Version Number | nvarchar | 2 | 0 | | |
TOPInvestment Programs |
14 | IMPR | Investment Program Positions | 11 | VERNR | Person responsible | nvarchar | 8 | 0 | | |
15 | IMTP | Investment programs | 4 | VERNR | Person responsible | nvarchar | 8 | 0 | | |
TOPLogical DB, Selection Screens, Selection Variants |
16 | LDBD | Administration information for LDB | 7 | VERNR | Version number | nvarchar | 6 | 0 | | |
17 | VARI | ABAP/4: Variant storage (similar to INDX) | 8 | VERNR | ABAP: Program version number | nvarchar | 6 | 0 | | |
TOPOperative Structures |
18 | PROJ | Project definition | 14 | VERNR | Number of the responsible person (project manager) | nvarchar | 8 | 0 | | |
19 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 12 | VERNR | Number of the responsible person (project manager) | nvarchar | 8 | 0 | | |
20 | TCJ04 | Person in Responsible for Project | 2 | VERNR | Number of the responsible person (project manager) | nvarchar | 8 | 0 | | |
TOPPatient Accounting |
21 | NCIR | IS-H: Insurance Relationships of a Case | 20 | VERNR | IS-H: Patient Health Insurance Number | nvarchar | 20 | 0 | | |
22 | NPIR | IS-H: Insurance Relationship Proposal Pool | 19 | VERNR | IS-H: Patient Health Insurance Number | nvarchar | 20 | 0 | | |
TOPPatient Management |
23 | NVVF | IS-H: Case-Related Insurance Relationships | 31 | VERNR | IS-H: Patient Health Insurance Number | nvarchar | 20 | 0 | | |
24 | NVVP | IS-H: Patient-related insurance relationship | 8 | VERNR | IS-H: Patient Health Insurance Number | nvarchar | 20 | 0 | | |
TOPProduction Orders |
25 | COMPH | OCM: Comparison result (header entry) | 12 | VERNR | Internal counter | nvarchar | 4 | 0 | | |
TOPProject Summarization |
26 | PSERB | Inheritance data, Project System | 7 | VERNR | Number of the responsible person (project manager) | nvarchar | 8 | 0 | | |
TOPProject System |
27 | PSHLPDB_HIER_TMP | Table to store temporary hierarchy data | 28 | VERNR | Number of the responsible person (project manager) | nvarchar | 8 | 0 | | |
28 | PSHLP_HIER_DB | Local cache:Project/Independent Network hierarchy | 26 | VERNR | Number of the responsible person (project manager) | nvarchar | 8 | 0 | | |
TOPPublic Sector |
29 | PA0051 | HR Master Record Infotype 0051 (VBL/SPI Data) | 49 | VERNR | Supp. Insurance Number | nvarchar | 12 | 0 | | |
30 | PDPBSZVADM | Administration Table for ZVE-PBS Notification Procedure | 15 | VERNR | Supp. Insurance Number | nvarchar | 12 | 0 | | |
TOPSAP Ambulatory Care Management |
31 | NREDOMA | IS-H: Table Renewable Documents - Header Data | 38 | VERNR | IS-H: Patient Health Insurance Number | nvarchar | 20 | 0 | | |
TOPSimulation |
32 | VSPROJ_CN | Version: Project definition | 15 | VERNR | Number of the responsible person (project manager) | nvarchar | 8 | 0 | | |
33 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 13 | VERNR | Number of the responsible person (project manager) | nvarchar | 8 | 0 | | |
TOPSocial Insurance |
34 | P01BD_DSBD | Business Data Maintenance Data Record | 6 | VERNR | Version Number of Data Record | nvarchar | 2 | 0 | | |
35 | P01BM_DSME | Data Records Notification of PPO DEUEV Notifications | 6 | VERNR | Version Number | nvarchar | 2 | 0 | | |
36 | P01D3_DSKK | DEUEV Confirmation: Data Record HI Fund Notification | 6 | VERNR | Version Number | nvarchar | 2 | 0 | | |
37 | P01D3_DSME | DEUEV Confirmation: Notification Data Record | 6 | VERNR | Version Number | nvarchar | 2 | 0 | | |
38 | P01DS_DSME | DEUEV Immediate Notification: Data Record Notification | 6 | VERNR | Version Number | nvarchar | 2 | 0 | | |
39 | P01EE_DSLW | Data Record Benefits of Compensation Benefits Notification | 6 | VERNR | Version Number | nvarchar | 2 | 0 | | |
40 | P01EL_DSVV | Data Record Assignment of Insurance No./Process No. ELENA | 6 | VERNR | Version Number of Data Record | nvarchar | 2 | 0 | | |
41 | P01EL_MVDS | Data Record Multifunctional Remun. Rec. (MVDS) ELENA | 6 | VERNR | Version Number of Data Record | nvarchar | 2 | 0 | | |
TOPStatements |
42 | P01W_DSLW | Data Module: General Information | 10 | VERNR | Version Number of Data Record | nvarchar | 2 | 0 | | |
TOPStructures |
43 | PSHLP_PROJWL_DB | Project Definition ACL Worklist | 6 | VERNR | Number of the responsible person (project manager) | nvarchar | 8 | 0 | | |
44 | PSHLP_WBSWL_DB | WBS Elements ACL Worklist | 6 | VERNR | Number of the responsible person (project manager) | nvarchar | 8 | 0 | | |
TOPTemplates |
45 | PROJS | Standard project definition | 14 | VERNR | Number of the responsible person (project manager) | nvarchar | 8 | 0 | | |
46 | PRPSS | Standard WBS Element (WBS element) - Master Data | 12 | VERNR | Number of the responsible person (project manager) | nvarchar | 8 | 0 | | |
TOPTranslation Tools |
47 | LXE_CSN_HD | Notes | 14 | VERNR | Numeric Character Field, Length 10 | nvarchar | 10 | 0 | | |
48 | LXE_CSN_TXL | Notes | 10 | VERNR | Numeric Character Field, Length 10 | nvarchar | 10 | 0 | | |
49 | LXE_CSN_TXS | Notes | 9 | VERNR | Numeric Character Field, Length 10 | nvarchar | 10 | 0 | | |
TOPWork Clearance Management |
50 | WCAK | WCM: Verification List (Header Data) | 3 | VERNR | Verification List | nvarchar | 2 | 0 | | |
51 | WCAQ | WCM: Verification List (Items) | 3 | VERNR | Verification List | nvarchar | 2 | 0 | | |