| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAerospace Defence Industry Solution |
| 1 | ADPMPRIOPRF | Component Maintenance Cockpit Profile | 2 | PROFID | CMC: Profile | nvarchar | 6 | 0 | | |
| 2 | ADPMPRIOPRFT | Component Maintenance Cockpit Profile Text Table | 3 | PROFID | CMC: Profile | nvarchar | 6 | 0 | | |
| 3 | ADPMSTAT | A&D CMC: Definition of Status Groups | 2 | PROFID | CMC User Status Profile | nvarchar | 8 | 0 | | |
| 4 | ADPMSTATPRF | CMC User Status Profile | 2 | PROFID | CMC User Status Profile | nvarchar | 8 | 0 | | |
| 5 | ADPMSTATPRFT | CMC Profile Text Table | 3 | PROFID | CMC User Status Profile | nvarchar | 8 | 0 | | |
| TOPBusiness Configuration Sets |
| 6 | SCPRACTP | BC Set: Activated in local system | 2 | PROFID | Business Configuration Set | nvarchar | 32 | 0 | | |
| 7 | SCPRACTR | BC Set: Active records in Local System | 5 | PROFID | Business Configuration Set | nvarchar | 32 | 0 | | |
| 8 | SCPRACTX | BC Set: Activated in local system | 2 | PROFID | Business Configuration Set | nvarchar | 32 | 0 | | |
| TOPCapacity Evaluations |
| 9 | TCYF | Profile detailed list: Displayed fields | 3 | PROFID | Profile for fields displayed | nvarchar | 12 | 0 | | |
| 10 | TCYFT | Texts for displayed fields profile | 4 | PROFID | Profile for fields displayed | nvarchar | 12 | 0 | | |
| 11 | TCYP | Profile detailed list: Criteria grouping | 3 | PROFID | Profile for grouping criteria | nvarchar | 12 | 0 | | |
| 12 | TCYPT | Texts for criteria grouping | 4 | PROFID | Profile for grouping criteria | nvarchar | 12 | 0 | | |
| 13 | TCYS | Profile detailed list: Sort criteria | 3 | PROFID | Profile for sort criteria | nvarchar | 12 | 0 | | |
| 14 | TCYST | Texts for sort criteria profile | 4 | PROFID | Profile for sort criteria | nvarchar | 12 | 0 | | |
| TOPClaims Management |
| 15 | ICL_CRESPROF | Reserve Profile Determination in Multiple Insurance | 2 | PROFID | Reserve Profile Determination | nvarchar | 10 | 0 | | |
| 16 | ICL_CRESPROFT | Reserve Profile Determination in Multiple Insurance (Texts) | 3 | PROFID | Reserve Profile Determination | nvarchar | 10 | 0 | | |
| TOPCross-Application Component CA Enhancements |
| 17 | MILL_CLPROFC | Profile for Selection by Characteristics: Classes | 2 | PROFID | Internal Profile No. for Selection by Characteristic | nvarchar | 10 | 0 | | |
| 18 | MILL_CLPROFH | Profile for Selection by Characteristics: Header data | 2 | PROFID | Internal Profile No. for Selection by Characteristic | nvarchar | 10 | 0 | | |
| 19 | MILL_CLPROFP | Profile for Selection by Characteristics: Items | 2 | PROFID | Internal Profile No. for Selection by Characteristic | nvarchar | 10 | 0 | | |
| 20 | MILL_CLPROFT | Profile for Selection by Characteristics: Texts | 3 | PROFID | Internal Profile No. for Selection by Characteristic | nvarchar | 10 | 0 | | |
| TOPInformation System |
| 21 | PSJHIEDATA | Hierarchy data to test LDB PSJ | 1 | PROFID | Profile for logical database PSJ | nvarchar | 12 | 0 | | |
| 22 | TCNA | Project Information System: Summarization Criteria (Aggr.) | 3 | PROFID | Project Information System Profile: Summarization Criteria | nvarchar | 12 | 0 | | |
| 23 | TCNAT | Texts for project information system summarization criteria | 4 | PROFID | Project Information System Profile: Summarization Criteria | nvarchar | 12 | 0 | | |
| 24 | TCND | Project Info System: Overview Settings | 3 | PROFID | Information system profile: Overview | nvarchar | 12 | 0 | | |
| 25 | TCNDB | Profile: Database parameters in Project Info System | 2 | PROFID | Profile for logical database PSJ | nvarchar | 12 | 0 | | |
| 26 | TCNDBT | Texts for profile settings - Database parameters | 3 | PROFID | Profile for logical database PSJ | nvarchar | 12 | 0 | | |
| 27 | TCNDB_PSJT | Profile: as TCNDB, only for verification of LDB PSJ!! | 1 | PROFID | Profile for logical database PSJ | nvarchar | 12 | 0 | | |
| 28 | TCNDT | Texts for Overview Settings in Project Info System | 4 | PROFID | Information system profile: Overview | nvarchar | 12 | 0 | | |
| 29 | TCNEG | Project Information System: Field Selecton for Graphic | 3 | PROFID | Project information system profile: graphic field selection | nvarchar | 12 | 0 | | |
| 30 | TCNEGT | Texts for Fields Displayed in the Project Info System | 4 | PROFID | Project information system profile: graphic field selection | nvarchar | 12 | 0 | | |
| 31 | TCNF | Project Information System: Displayed Fields | 3 | PROFID | Information System Profile: Displayed Fields | nvarchar | 12 | 0 | | |
| 32 | TCNFT | Texts for Fields Displayed in the Project Info System | 4 | PROFID | Information System Profile: Displayed Fields | nvarchar | 12 | 0 | | |
| 33 | TCNP | Project Info System: Grouping Criteria | 3 | PROFID | Project Information System Profile: Grouping Criteria | nvarchar | 12 | 0 | | |
| 34 | TCNPT | Text for Grouping Criteria in Project Info System | 4 | PROFID | Project Information System Profile: Grouping Criteria | nvarchar | 12 | 0 | | |
| 35 | TCNS | Project Info System: Sort Criteria | 3 | PROFID | Project Information System Profile: Sort Criteria | nvarchar | 12 | 0 | | |
| 36 | TCNST | Texts for Sort Criteria in Project Info System | 4 | PROFID | Project Information System Profile: Sort Criteria | nvarchar | 12 | 0 | | |
| 37 | TCNT | Project Information System: PS Info Profile | 2 | PROFID | Project Info System overall profile | nvarchar | 12 | 0 | | |
| 38 | TCNTT | Texts for Overall Profile in Project Info System | 3 | PROFID | Project Info System overall profile | nvarchar | 12 | 0 | | |
| 39 | TCNU | Project Information System: Unit Conversion | 2 | PROFID | Project Information System Profile: Unit Conversion | nvarchar | 12 | 0 | | |
| 40 | TCNUT | Texts for Project Information System Unit Conversion | 3 | PROFID | Project Information System Profile: Unit Conversion | nvarchar | 12 | 0 | | |
| 41 | TCNVG | Project Information System: Version Comparison Criteria | 3 | PROFID | Project Info System Profile: Comparison Criteria | nvarchar | 12 | 0 | | |
| 42 | TCNVGT | Texts for Project Info System Version Comparision Criteria | 4 | PROFID | Project Info System Profile: Comparison Criteria | nvarchar | 12 | 0 | | |
| TOPMaintenance Orders |
| 43 | /MRSS/C_RMI_PS | Project System data required for creating Request | 2 | PROFID | Network profile | nvarchar | 7 | 0 | | |
| TOPMaster Data |
| 44 | T464 | Customizing: Order Report Profiles | 2 | PROFID | Profile for Order Report | nvarchar | 12 | 0 | | |
| 45 | T464T | Customizing: Order Report Profile Texts | 3 | PROFID | Profile for Order Report | nvarchar | 12 | 0 | | |
| 46 | T46PR | List layout and print parameters | 5 | PROFID | Profile for displaying availability check | nvarchar | 6 | 0 | | |
| TOPMaterial |
| 47 | TPGPRF | Profile for static pegging and data distribution | 2 | PROFID | Distribution profile | nvarchar | 6 | 0 | | |
| 48 | TPGPRFT | Text table for pegging profile | 3 | PROFID | Distribution profile | nvarchar | 6 | 0 | | |
| TOPNetwork and Activity |
| 49 | TCN61 | Parameter: Create network from sales order | 9 | PROFID | Network profile | nvarchar | 7 | 0 | | |
| TOPPegging, Grouping, and Distribution |
| 50 | DIS_ADMIN | Distribution - Administration Table | 5 | PROFID | Distribution profile | nvarchar | 6 | 0 | | |
| 51 | DIS_PGPRF | Distribution: Assignemnt Distribution Profile - Group WBSEl. | 3 | PROFID | Distribution profile | nvarchar | 6 | 0 | | |
| TOPProduction Orders |
| 52 | AFKO | Order Header Data PP Orders | 53 | PROFID | Network profile | nvarchar | 7 | 0 | | |
| 53 | T441C | Profile - availability check | 3 | PROFID | Profile for displaying availability check | nvarchar | 6 | 0 | | |
| 54 | T441CT | Texts for Profile "Display Availability Check" | 4 | PROFID | Profile for displaying availability check | nvarchar | 6 | 0 | | |
| 55 | TCOA | Overall profile for order information system | 2 | PROFID | Order information sytem: overall profile | nvarchar | 12 | 0 | | |
| 56 | TCOAD | Object profile - detail list - order information system | 3 | PROFID | Object profile - Order Information System | nvarchar | 6 | 0 | | |
| 57 | TCOADT | Texts for object profile - order information system | 4 | PROFID | Object profile - Order Information System | nvarchar | 6 | 0 | | |
| 58 | TCOAF | Profile order progress report | 2 | PROFID | Profile order progress report | nvarchar | 12 | 0 | | |
| 59 | TCOAFT | Texts for order progress report | 3 | PROFID | Profile order progress report | nvarchar | 12 | 0 | | |
| 60 | TCOAT | Texts for Overall Profile in Order Information System | 3 | PROFID | Order information sytem: overall profile | nvarchar | 12 | 0 | | |
| 61 | TCOF | Profile for missing parts info system | 3 | PROFID | Profile for missing parts info system | nvarchar | 12 | 0 | | |
| 62 | TCOFF | Profile for Missing Parts Info System: Displayed Fields | 3 | PROFID | Profile for missing parts info system: displayed fields | nvarchar | 12 | 0 | | |
| 63 | TCOFFT | Texts for Missing Parts Info System: Displayed Fields | 4 | PROFID | Profile for missing parts info system: displayed fields | nvarchar | 12 | 0 | | |
| 64 | TCOFG | Profile for missing parts info system: criteria for grouping | 3 | PROFID | Profile for missing parts info system: Indicator | nvarchar | 12 | 0 | | |
| 65 | TCOFGT | Texts for Missing Parts Info System: Criteria for Grouping | 4 | PROFID | Profile for missing parts info system: Indicator | nvarchar | 12 | 0 | | |
| 66 | TCOFS | Profile for Missing Parts Info System: Sort Criteria | 3 | PROFID | Profile for missing parts info system: Sort criterion | nvarchar | 12 | 0 | | |
| 67 | TCOFST | Texts for Missing Parts Info System: Sort Criteria | 4 | PROFID | Profile for missing parts info system: Sort criterion | nvarchar | 12 | 0 | | |
| 68 | TCOFT | Texts for Missing Parts Info System | 4 | PROFID | Profile for missing parts info system | nvarchar | 12 | 0 | | |
| 69 | TCOP | Field selection profile | 4 | PROFID | Profile for field selection | nvarchar | 6 | 0 | | |
| 70 | TCOPS | Field selection profile | 4 | PROFID | Profile for field selection | nvarchar | 6 | 0 | | |
| 71 | TCOPSFI | Ranges for Fields in Table TCOPS | 4 | PROFID | Profile for field selection | nvarchar | 6 | 0 | | |
| 72 | TCOPT | Description of Profile for Field Selection | 5 | PROFID | Profile for field selection | nvarchar | 6 | 0 | | |
| TOPSimulation |
| 73 | VSAFKO_CN | Version: Order header data for PP orders | 54 | PROFID | Network profile | nvarchar | 7 | 0 | | |
