| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BBPM_PRGENERAL | Product - Purchasing Set | 10 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
2 | COMM_PR_TTCODE | Set type for tax details in service | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
3 | ISPS_MARA | Product Master MARA | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
TOPAuto-ID Infrastructure |
4 | AIN_PROD_TGRAI | GRAI-Global Returnable Asset Identifier | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
TOPBasic functions |
5 | COMM_IL_PRDBP | Master Data of Relationship Type Partner | 16 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
TOPCentral Part of Product Master |
6 | COMC_MINITP_REL | Mini-Template Grouping Without Differentiation Key (REL) | 8 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
7 | COMM_ATTR_ALIAS | Attribute Alias | 9 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
8 | COMM_CATEGORY | Category | 10 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
9 | COMM_CATEGORYDEL | Categories To Be Deleted (Temporary) in Download | 10 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
10 | COMM_CATEGORYT | Category Description | 9 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
11 | COMM_CATFRGR | Category Set-Type Assignment | 8 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
12 | COMM_HIERARCHY | Hierarchy | 12 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
13 | COMM_HIERARCHYT | Hierarchy Description | 9 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
14 | COMM_IL_ACCESS | Master Data of Relationship Type Accessories | 10 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
15 | COMM_IL_COMPET | Assignment of Own Products to Competitor Products | 9 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
16 | COMM_IL_PRDCPN | Master Data of Relationship Type Customers | 11 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
17 | COMM_IL_PRDCTP | Master Data of Relationship Type Content Provider | 11 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
18 | COMM_IL_PRDMPN | Master Data of Relationship Type Manufacturer | 11 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
19 | COMM_IL_PRDMRK | Marketing Material | 9 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
20 | COMM_IL_PRDVND | Master Data of Relationship Type Vendors | 11 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
21 | COMM_IL_PROREF | Master Data of Relationship Type Reference Product | 11 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
22 | COMM_IL_SERVI | Master Data of Relationship Type Services | 10 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
23 | COMM_IL_SPARE | Master Data of Relationship Type Spare Parts | 10 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
24 | COMM_IPRODUCT | Inactive Product | 13 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
25 | COMM_PRCAT | Product Category | 18 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
26 | COMM_PRCATFRGR | Assignment Product Category - Set Type | 11 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
27 | COMM_PRCAT_IL | Product Category - Relationship Type Assignment | 9 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
28 | COMM_PRFREEATTR | Free Attributes for a Product | 7 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
29 | COMM_PRODUCT | Product | 13 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
30 | COMM_PROD_VAR | Assignment of Product Variants to Configurable Product | 9 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
31 | COMM_PRPRDCATR | Product - Product Category Assignment | 9 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
32 | COMM_PRSHTEXT | Product Description | 9 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
33 | COMM_PRVIEW | Product View | 7 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
34 | COMM_PRVIEWT | Product View Description | 8 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
35 | COMM_PR_FRG_REG | Product-Set Assignment (Gen. Link-Handler) | 12 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
36 | COMM_PR_FRG_REL | Product - Set - Assignment | 10 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
37 | COMM_PR_GTIN | GTIN - Global Trade Item Number | 12 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
38 | COMM_PR_PUR_1 | Purchasing | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
39 | COMM_PR_UNIT | Product Unit of Measurement | 21 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
40 | COMM_SCHEME | Numbering Scheme | 8 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
41 | COMM_SETTP_TEMP | Template XXXX | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
42 | COM_COMMERCIAL | Business data | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
43 | CRMM_PR_TAX | Product Sales Tax | 13 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
44 | PRREF | Permitted Object Categories | 7 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
TOPClassification System New |
45 | CHARACTERTEXT | DML Text Object | 13 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
46 | CME_ST_CHARATR | Characteristic: Global Attributes | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
47 | CME_ST_FORMAT | CME Data Type: Format Details | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
48 | CME_ST_FORMAT1 | CME-Datentyp: Formatangaben | 6 | HISTEX | Historie vorhanden | nvarchar | 1 | 0 | | |
49 | CME_ST_ISO_AT1 | CME Characteristic: ISO Attributes | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
50 | CME_ST_ISO_ATA | CME Characteristic: ISO Attributes | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
51 | CME_ST_ISO_ATB | CME Characteristic: ISO Attributes | 7 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
52 | CME_ST_R3_ATTR | CME Characteristic: R/3 Attributes | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
53 | CME_ST_R3_DEP | CME Characteristic: Object Dependencies for R/3 Characterstc | 7 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
54 | CME_ST_REF | Characteristic: Data Reference | 9 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
55 | CME_ST_VALUE | CME Data Type: Values | 11 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
56 | CME_ST_VAL_TXT | DML Text Object | 13 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
57 | COMM_IL_DSCOPE | Definition Scope | 17 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
58 | COMM_IL_DTYPE | Engineering Change Management: Change Graph | 17 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
59 | COMM_IL_SCPCHR | Definition Scope -> Characteristic | 23 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
60 | DEFSCOPETEXT | DML Text Object | 13 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
61 | DTYPETEXT | DML Text Object | 13 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
TOPEngineering Change Management |
62 | COMM_IL_ECMCHG | Engineering Change Management: Change Graph | 20 | HISTEX | Indicates That History Records Exist | nvarchar | 1 | 0 | | |
TOPMaster Data Framework |
63 | DML_LH_FRG_REG | Product-Set Assignment (Gen. Link-Handler) | 12 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
64 | DML_ST_TEXT | DML Text Object | 13 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
TOPObjects |
65 | COM_TA_MANUFAC | Manufacturer Information | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
66 | COM_TA_R3_ID | R3 Identification | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
TOPSet Types and Attributes |
67 | COMT_EXT_TEMP | Template for Extension Tables | 7 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
68 | COMT_EXT_TEMP_DB | Template for Extension Tables | 7 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
69 | COMT_SETT | Master Data of Set Type <SETTYPE_ID> | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
70 | COMT_SETT_ML | Master Data of Set Type <SETTYPE_ID> | 7 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
71 | COMT_SETT_X | Master Data of Set Type <SETTYPE_ID> | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
72 | COMT_SETT_XML | Master Data of Set Type <SETTYPE_ID> | 7 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
73 | COMT_TEMPLATE | Set Type Template | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
74 | COMT_TEMP_MR | Set Type Template | 6 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
75 | COMT_TEMP_MR_DB | Set Type Template for Multi-Value Set Types | 7 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
TOPTemplates |
76 | COMC_MINITP_DATA | Mini-Template Data for Set Types (Generic Store) | 13 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
77 | COMC_MINITP_DATS | Shadow Table Mini-Template Data for Set Types (Generic) | 13 | HISTEX | History Exists | nvarchar | 1 | 0 | | |
78 | COMC_MINITP_REG | Wrapping of Several Mini-Templates by a Key GUID (REG) | 9 | HISTEX | History Exists | nvarchar | 1 | 0 | | |