| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BBPM_PRGENERAL | Product - Purchasing Set | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
2 | BBPM_PRGENERALH | General Purchasing Data on Product (History) | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
3 | COMM_PR_TTCODE | Set type for tax details in service | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
4 | COMM_PR_TTCODEH | Set type for tax details in service | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
5 | ISPS_MARA | Product Master MARA | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
6 | ISPS_MARAH | Product Master MARA | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
TOPCentral Part of Product Master |
7 | COMM_PROD_VAR | Assignment of Product Variants to Configurable Product | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
8 | COMM_PROD_VARH | History: Assignment of Variants to Configurable Product | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
9 | COMM_PR_PUR_1 | Purchasing | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
10 | COMM_PR_PUR_1H | Purchasing | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
11 | COMM_SETTPH_TEMP | Template XXXX (History) | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
12 | COMM_SETTP_TEMP | Template XXXX | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
13 | PRREF | Permitted Object Categories | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
14 | PRREFH | Permitted Object Categories | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
TOPClassification System New |
15 | CHARACTERTEXT | DML Text Object | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
16 | CHARACTERTEXTH | DML Text Object | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
17 | CME_ST_CHARATR | Characteristic: Global Attributes | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
18 | CME_ST_CHARATRH | Characteristic: Global Attributes | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
19 | CME_ST_FORMAT | CME Data Type: Format Details | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
20 | CME_ST_FORMAT1 | CME-Datentyp: Formatangaben | 2 | FRG_GUID | Set-GUID | varbinary | 16 | 0 | | |
21 | CME_ST_FORMATH | CME Data Type: Format Details | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
22 | CME_ST_ISO_AT1 | CME Characteristic: ISO Attributes | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
23 | CME_ST_ISO_AT1H | CME Characteristic: ISO Attributes | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
24 | CME_ST_ISO_ATA | CME Characteristic: ISO Attributes | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
25 | CME_ST_ISO_ATAH | CME Characteristic: ISO Attributes | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
26 | CME_ST_ISO_ATB | CME Characteristic: ISO Attributes | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
27 | CME_ST_ISO_ATBH | CME Characteristic: ISO Attributes | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
28 | CME_ST_R3_ATTR | CME Characteristic: R/3 Attributes | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
29 | CME_ST_R3_ATTRH | CME Characteristic: R/3 Attributes | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
30 | CME_ST_R3_DEP | CME Characteristic: Object Dependencies for R/3 Characterstc | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
31 | CME_ST_R3_DEPH | CME Characteristic: Object Dependencies for R/3 Characterstc | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
32 | CME_ST_REF | Characteristic: Data Reference | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
33 | CME_ST_REFH | Characteristic: Data Reference | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
34 | CME_ST_VALUE | CME Data Type: Values | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
35 | CME_ST_VALUEH | CME Data Type: Values | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
36 | CME_ST_VAL_TXT | DML Text Object | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
37 | CME_ST_VAL_TXTH | DML Text Object | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
38 | DEFSCOPETEXT | DML Text Object | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
39 | DEFSCOPETEXTH | DML Text Object | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
40 | DTYPETEXT | DML Text Object | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
41 | DTYPETEXTH | DML Text Object | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
TOPMaster Data Framework |
42 | DML_DELIVERY_TXT | MDF Text Object | 2 | FRG_GUID | Object Version Key | nvarchar | 32 | 0 | | |
43 | DML_ST_TEXT | DML Text Object | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
44 | DML_ST_TEXTH | DML Text Object | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
TOPSet Types and Attributes |
45 | COMT_SETT | Master Data of Set Type <SETTYPE_ID> | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
46 | COMT_SETT_H | History of Set Type <SETTYPE_ID> | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
47 | COMT_SETT_ML | Master Data of Set Type <SETTYPE_ID> | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
48 | COMT_SETT_ML_H | History of Set Type <SETTYPE_ID> | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
49 | COMT_TEMPLATE | Set Type Template | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
50 | COMT_TEMPLATEH | Set Type History Template | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
51 | COMT_TEMP_MR | Set Type Template | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
52 | COMT_TEMP_MRH | Set Type History Template | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |
53 | COMT_TEMP_MR_DB | Set Type Template for Multi-Value Set Types | 2 | FRG_GUID | Set GUID | varbinary | 16 | 0 | | |