| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /IAM/C_ACTIVTYP | Activity Template | 4 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
2 | /IAM/C_AUTHGR | Authorization Group | 3 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
3 | /IAM/C_AUTHGR_T | Authorization Group | 4 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
4 | /IAM/C_CODEGR | Code Group | 4 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
5 | /IAM/D_ACT_ROOT | Root | 12 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
6 | /IAM/D_I_ROOT | Root node DB table | 11 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
7 | DMC_MT_HEADER | DMC: Header Record of a Mass Data Transfer | 7 | AUTH_GROUP | Authorization Group | nvarchar | 20 | 0 | | |
8 | DYNABAPHDR | Header Table for Dynamic ABAP Coding | 14 | AUTH_GROUP | Authorization Group | nvarchar | 8 | 0 | | |
9 | GRACOBJECTAUTH | contains object(user/role/profile) auth for legacy system | 9 | AUTH_GROUP | Authorization Name | nvarchar | 100 | 0 | | |
TOPAP-LIM Logistics Inventory Management Engine |
10 | /LIME/HU_I003 | LIME - HU Key SSCC | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
11 | /LIME/HU_S003 | Shadow Table for LIME - SSCC | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
12 | /LIME/LOC_I001 | LIME - Location Key Plant, Storage Location (R/3) | 7 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
13 | /LIME/LOC_I002 | LIME - Location Key Plant (R/3) | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
14 | /LIME/LOC_I003 | LIME - Location Key GLN | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
15 | /LIME/LOC_I004 | LIME - Location Key DUNS+4 | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
16 | /LIME/LOC_I005 | LIME - Location Key APO Location (F&R) | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
17 | /LIME/LOC_I006 | LIME - Location Key Location GUID (ICH) | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
18 | /LIME/LOC_I007 | LIME - Location Key Partner (incl. R/3) | 7 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
19 | /LIME/LOC_I008 | LIME - Location Key Means of Transport, Code (incl. R/3) | 7 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
20 | /LIME/LOC_S001 | Shadow Table for LIME - Plant, Storage Location (R/3) | 7 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
21 | /LIME/LOC_S002 | Shadow Table for LIME - Plant (R/3) | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
22 | /LIME/LOC_S003 | Shadow Table for LIME - GLN | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
23 | /LIME/LOC_S004 | Shadow Table for LIME - DUNS+4 | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
24 | /LIME/LOC_S005 | Shadow Table for LIME - APO Location (F&R) | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
25 | /LIME/LOC_S006 | Shadow Table for LIME - Location GUID (ICH) | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
26 | /LIME/LOC_S007 | Shadow Table for LIME - Partner (incl. R/3) | 7 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
27 | /LIME/LOC_S008 | Shadow Table for LIME - Means of Transport, Code (incl. R/3) | 7 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
28 | /LIME/PN_ITEM | Table to Save Prima Nota Item Data | 82 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
29 | /LIME/STOCK_I001 | LIME - Stock Key Material (R/3) | 8 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
30 | /LIME/STOCK_I002 | LIME - Stock Key Material, Batch (R/3) | 9 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
31 | /LIME/STOCK_I003 | LIME - Stock Key GTIN, Variant | 9 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
32 | /LIME/STOCK_I005 | LIME - Stock Key APO Material (F&R) | 8 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
33 | /LIME/STOCK_I006 | LIME - Stock Key Product GUID, Version (ICH) | 9 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
34 | /LIME/STOCK_I011 | LIME - Stock Key Sales Order Stock (R/3) | 10 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
35 | /LIME/STOCK_I012 | LIME - Stock Key Sales Order Stock, Batch (R/3) | 11 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
36 | /LIME/STOCK_I021 | LIME - Stock Key Project Stock (R/3) | 9 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
37 | /LIME/STOCK_I022 | LIME - Stock Key Project Stock, Batch (R/3) | 10 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
38 | /LIME/STOCK_S001 | Shadow Table for LIME - Material (R/3) | 8 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
39 | /LIME/STOCK_S002 | Shadow Table for LIME - Material, Batch (R/3) | 9 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
40 | /LIME/STOCK_S003 | Shadow Table for LIME - GTIN, Variant | 9 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
41 | /LIME/STOCK_S005 | Shadow Table for LIME - APO Material (F&R) | 8 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
42 | /LIME/STOCK_S006 | Shadow Table for LIME - Product GUID, Version (ICH) | 9 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
43 | /LIME/STOCK_S011 | Shadow Table for LIME - Sales Order Stock (R/3) | 10 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
44 | /LIME/STOCK_S012 | Shadow Table for LIME - Sales Order Stock, Batch (R/3) | 11 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
45 | /LIME/STOCK_S021 | Shadow Table for LIME - Project Stock (R/3) | 9 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
46 | /LIME/STOCK_S022 | Shadow Table for LIME - Project Stock, Batch (R/3) | 10 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
TOPAudit Management |
47 | PLMC_AUTH | Audit - Authorization Group | 2 | AUTH_GROUP | Authorization Group | nvarchar | 6 | 0 | | |
48 | PLMC_AUTHT | Audit-Authorization Group, Text | 3 | AUTH_GROUP | Authorization Group | nvarchar | 6 | 0 | | |
49 | PLMM_AUDIT | Audit | 5 | AUTH_GROUP | Authorization Group | nvarchar | 6 | 0 | | |
50 | PLMM_AUDITPLAN | Audit Plan | 4 | AUTH_GROUP | Authorization Group | nvarchar | 6 | 0 | | |
51 | PLMM_AUDIT_ACT | Audit - Corrective Action | 3 | AUTH_GROUP | Authorization Group | nvarchar | 6 | 0 | | |
52 | PLMM_QUEST_H | Question List | 10 | AUTH_GROUP | Authorization Group | nvarchar | 6 | 0 | | |
53 | PLMM_QUEST_RES | Audit Question/Reply List/Item | 6 | AUTH_GROUP | Authorization Group | nvarchar | 6 | 0 | | |
TOPCentral Part of Product Master |
54 | COMC_PR_AUTHGR | Authorization Groups for Product Master Maintenance | 2 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
55 | COMC_PR_AUTHGR_T | Authorization Group Descriptions | 3 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
56 | COMM_PRCAT | Product Category | 4 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
57 | COMM_PRCATH | Product Category: History | 5 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
TOPCountry-Specific Objects |
58 | DMEE_TYPE_ABA | DMEE: Supported Tree Types | 14 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
59 | /IXOS/DC_TCHIER | Hierarchy of a view | 18 | AUTH_GROUP | Authority group in node types | nvarchar | 10 | 0 | | |
TOPExpenditure Certification |
60 | FMEUFOPH | Define Operation Header | 23 | AUTH_GROUP | FM: General Authorization Group | nvarchar | 10 | 0 | | |
TOPFSCM In-House Cash |
61 | IHC_TAB_AUTH_GRP | IHC:Authorization Groups for Amount-Dependent Authorizations | 2 | AUTH_GROUP | Authorization Group for Amount-Dependent Authorizations | nvarchar | 12 | 0 | | |
TOPFunds Management |
62 | FMIUR | Open Interval Rules for updating FM | 8 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
TOPGlobal Trade Services |
63 | /SAPSLL/L_IG01 | GTS - Location Table for Customs Warehouse IDs | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
64 | /SAPSLL/L_SG01 | GTS: Shadow Location Table for Customs Warehouse IDs | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
65 | /SAPSLL/S_IG01 | GTS - Make-to-Order Stock (Duty Unpaid) | 14 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
66 | /SAPSLL/S_IG02 | GTS - Stock | 12 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
67 | /SAPSLL/S_SG01 | GTS - Make-to-Order Stock (Duty Unpaid) | 14 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
68 | /SAPSLL/S_SG02 | GTS - Shadow Stock | 12 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
TOPLocalization |
69 | DMEE_TREE_TYPE | DMEE: Supported Tree Types | 14 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
TOPLocations Location Structure |
70 | EHFNDD_LOC_REV | Location - Revisions | 21 | AUTH_GROUP | Location Authorization Group | nvarchar | 21 | 0 | | |
TOPMarket Risk Analyzer |
71 | JBRREGD | Rule Definition | 5 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
72 | JBRRH | Check Table for Risk Hierarchy | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
73 | JBRRHH | Check Table for the Risk Hierarchy (History) | 7 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
74 | JBRRH_BACK | Backup Table JBRRH (Required for Transport Imports) | 6 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
TOPMaster Data |
75 | GMSPCLASS | Sponsored Class Master | 9 | AUTH_GROUP | Grants Management: Authorization Groups | nvarchar | 10 | 0 | | |
76 | GMSPPROGRAM | Sponsored program master | 12 | AUTH_GROUP | Grants Management: Authorization Groups | nvarchar | 10 | 0 | | |
77 | GMSTATNET | Grants Management Status Network | 14 | AUTH_GROUP | Authority Group | nvarchar | 10 | 0 | | |
78 | GMSTATNET_INT | Grants Management Status Network | 12 | AUTH_GROUP | Authority Group | nvarchar | 10 | 0 | | |
TOPOwnership |
79 | GHO_OWN_TRO_HDR | Transfer of Ownership Header Table | 12 | AUTH_GROUP | Technical object authorization group | nvarchar | 4 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
80 | TFACT_SET | Facts Set | 3 | AUTH_GROUP | Fact Set Authorization Group | nvarchar | 4 | 0 | | |
81 | TFACT_SET_PART | Fact Set Parts | 8 | AUTH_GROUP | Fact Type Authorization Group | nvarchar | 4 | 0 | | |
82 | TFACT_TYPE_PART | Fact Type Parts | 9 | AUTH_GROUP | Fact Type Authorization Group | nvarchar | 4 | 0 | | |
TOPRapid Applications |
83 | AXT_RUN_RAP_APP | Rapid application | 5 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |
TOPTransaction Manager |
84 | IDCFMBRSE_PST | Customizing for creation of sales transactions for tax pmnts | 28 | AUTH_GROUP | Authorization Group | nvarchar | 4 | 0 | | |