SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

185 tablesERP 6.0 

Basis Components :: Security :: User Administration :: User and Authorization Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0AUTHX41Authorization Fields (Maintain with SU20)User and Authorization Management
2ERP EHP76.0AUTH_FLDINFO_TMP471Authorization fields: technical info from dictionaryUser and Authorization Management
3ERP EHP76.0BPO_ENGINES61Applications (Such as HR or IS) for System MeasurementUser and Authorization Management
4ERP EHP76.0BPO_ENGINEST31Name of an Application (such as an IBU) for System Meas.User and Authorization Management
5ERP EHP76.0BPO_MEASBADIN51BPO System Measurement: BAdI NameUser and Authorization Management
6ERP EHP76.0BPO_MEASCTRL61System Measurement: Control TableUser and Authorization Management
7ERP EHP76.0BPO_MEASJOB121System Measurement Jobs Scheduled and RunningUser and Authorization Management
8ERP EHP76.0BPO_MEAS_UNIT11Units for System Measurement ObjectsUser and Authorization Management
9ERP EHP76.0BPO_MEAS_UNITT31Name of a Unit for System Measurement ObjectsUser and Authorization Management
10ERP EHP76.0IDM_BADI_FILTER11BADIs for Identity ManagementUser and Authorization Management
11ERP EHP76.0IDM_BADI_TEXT31Description of BADIs for Identity ManagementUser and Authorization Management
12ERP EHP76.0IDM_INTEG_CUST51Identity Management SPML ConfigurationUser and Authorization Management
13ERP EHP76.0LICENSE_DATA41Storage of SAP LicensesUser and Authorization Management
14ERP EHP76.0LICENSE_HASH31Index Table to Allow Quicker Access to LICENSE_DATAUser and Authorization Management
15ERP EHP76.0SAPLIKEY21Storage of SAP License KeysUser and Authorization Management
16ERP EHP76.0SLICORDER81List of Requested LicensesUser and Authorization Management
17ERP EHP76.0SUID_ENV31Identity Model SettingsUser and Authorization Management
18ERP EHP76.0SUID_USORGDEF31Default User OrganizationUser and Authorization Management
19ERP EHP76.0SUID_USORGDEFS41Default User Organization Shadow TableUser and Authorization Management
20ERP EHP76.0SUIM_CHG_IDX84Change Document Index for User DataUser and Authorization Management
21ERP EHP76.0SUKRI61Transaction Combinations Critical for SecurityUser and Authorization Management
22ERP EHP76.0SUKRIT71Text table for SUKRI (crit. comb. of trans. authoriz.)User and Authorization Management
23ERP EHP76.0TACT11Activities which can be ProtectedUser and Authorization Management
24ERP EHP76.0TACTT31Activities that can be protectedUser and Authorization Management
25ERP EHP76.0TACTZ21Valid activities for each authorization objectUser and Authorization Management
26ERP EHP76.0TADMI11Foreign key table for values of object S_ADMI_FCDUser and Authorization Management
27ERP EHP76.0TADMT31Texts for table TADMIUser and Authorization Management
28ERP EHP76.0TAUTL11List of tables AUTH (authorization fields)User and Authorization Management
29ERP EHP76.0TBRG31Authorization groupsUser and Authorization Management
30ERP EHP76.0TBRGT51Authorization Group NamesUser and Authorization Management
31ERP EHP76.0TFBKT31Function blocks in the SAP systemUser and Authorization Management
32ERP EHP76.0TFBLK11Function blocks for price listUser and Authorization Management
33ERP EHP76.0TOBJ152Authorization ObjectsUser and Authorization Management
34ERP EHP76.0TOBJT31Short Texts for Authorization ObjectsUser and Authorization Management
35ERP EHP76.0TSTCA_C41Values for Transaction Code AuthorizationsUser and Authorization Management
36ERP EHP76.0TUAPP51Applications (Such as HR or IS) for System MeasurementUser and Authorization Management
37ERP EHP76.0TUAPPT31Name of an Application (such as an IBU) for System Meas.User and Authorization Management
38ERP EHP76.0TUAPUSG71System Measurement: User-Specific Use of ApplicationUser and Authorization Management
39ERP EHP76.0TUCNT51Counters for Application ObjectsUser and Authorization Management
40ERP EHP76.0TUCNTNM61Counters for Application Objects for each Work ProcessUser and Authorization Management
41ERP EHP76.0TUCNTNM_RAW71Counters for Application Objects for each Work ProcessUser and Authorization Management
42ERP EHP76.0TUCNTRAW71Counters for Application Objects for each Work ProcessUser and Authorization Management
43ERP EHP76.0TUCON31System Measurement: ConfigurationUser and Authorization Management
44ERP EHP76.0TUGRP91Field Assignment for User TypesUser and Authorization Management
45ERP EHP76.0TUJOB121System Measurement Jobs Scheduled and RunningUser and Authorization Management
46ERP EHP76.0TULAPP_PL21System Measurement: Price List-Dependent ApplicationsUser and Authorization Management
47ERP EHP76.0TULTRANS51System Measurement ResultsUser and Authorization Management
48ERP EHP76.0TUL_ACRES171System Measurement: AC Results TableUser and Authorization Management
49ERP EHP76.0TUL_ACTTC151System Measurement: AC tables to be checkedUser and Authorization Management
50ERP EHP76.0TUL_AC_UNIT11System Measurement: Units for System Measurement ObjectsUser and Authorization Management
51ERP EHP76.0TUL_AC_UNITT31Name of a Unit for System Measurement ObjectsUser and Authorization Management
52ERP EHP76.0TUL_AUCESS21System Measurement: List of Unsuitable User TypesUser and Authorization Management
53ERP EHP76.0TUL_CLIENTS31System Measurement: Client HandlingUser and Authorization Management
54ERP EHP76.0TUL_CONTROL61System Measurement: Control TableUser and Authorization Management
55ERP EHP76.0TUL_CPU51System Measurement: Engine Use LogsUser and Authorization Management
56ERP EHP76.0TUL_CPU_RAW41System Measurement: Engine Use LogsUser and Authorization Management
57ERP EHP76.0TUL_ENGINES51Applications (Such as HR or IS) for System MeasurementUser and Authorization Management
58ERP EHP76.0TUL_ENGINEST31Name of an Application (such as an IBU) for System Meas.User and Authorization Management
59ERP EHP76.0TUL_ENG_PL21System Measurement: Price List-Dependent ApplicationsUser and Authorization Management
60ERP EHP76.0TUL_ENG_PROT111System Measurement: Engine Use LogsUser and Authorization Management
61ERP EHP76.0TUL_ENG_RESULT111System Measurement: Engine Use LogsUser and Authorization Management
62ERP EHP76.0TUL_ENG_RESULT_1111System Measurement: Engine Use LogsUser and Authorization Management
63ERP EHP76.0TUL_JOB121System Measurement Jobs Scheduled and RunningUser and Authorization Management
64ERP EHP76.0TUL_MEMOS41System Measurement: Customer Memos to SAPUser and Authorization Management
65ERP EHP76.0TUL_MSG111Text Table for System Evaluation MessagesUser and Authorization Management
66ERP EHP76.0TUL_TRANS51System Measurement ResultsUser and Authorization Management
67ERP EHP76.0TUL_TRSTAT151Status of Transfer of a System Measurement to SAPUser and Authorization Management
68ERP EHP76.0TUL_UNIT11Units for System Measurement ObjectsUser and Authorization Management
69ERP EHP76.0TUL_UNITT31Name of a Unit for System Measurement ObjectsUser and Authorization Management
70ERP EHP76.0TUMRES31System Measurement ResultsUser and Authorization Management
71ERP EHP76.0TUMSG91Text Table for System Evaluation MessagesUser and Authorization Management
72ERP EHP76.0TUPL41Price lists in the SAP SystemUser and Authorization Management
73ERP EHP76.0TUPLT31System measurement: Texts for price listsUser and Authorization Management
74ERP EHP76.0TUPRO61System Measurement: Logging of Last MeasurementsUser and Authorization Management
75ERP EHP76.0TUREP71History of the System Evaluation, User and ISUser and Authorization Management
76ERP EHP76.0TUSTAT131Status of Transfer of a System Measurement to SAPUser and Authorization Management
77ERP EHP76.0TUTYHLP31Mass Maintain Price CategoriesUser and Authorization Management
78ERP EHP76.0TUTYP41SAP System User Type TextsUser and Authorization Management
79ERP EHP76.0TUTYPA71System measurement: User types with attributesUser and Authorization Management
80ERP EHP76.0TUTYPASYS52CUA: Available Features in Child SystemUser and Authorization Management
81ERP EHP76.0TUTYPNOWSYS61System Measurement: System-Specific Active User TypesUser and Authorization Management
82ERP EHP76.0TUTYPP41System Measurement: Authorizations for User ClassesUser and Authorization Management
83ERP EHP76.0TUTYPPL21Assigning user types to price listsUser and Authorization Management
84ERP EHP76.0TUUNT11Units for System Measurement ObjectsUser and Authorization Management
85ERP EHP76.0TUUNTT31Name of a Unit for System Measurement ObjectsUser and Authorization Management
86ERP EHP76.0TUZUS31Text for Special VersionsUser and Authorization Management
87ERP EHP76.0TUZUSSYS51System Measurement: System-Specific Special VersionsUser and Authorization Management
88ERP EHP76.0USADDEF21Default company addressUser and Authorization Management
89ERP EHP76.0USADDEFS31Shadow table: Default company addressUser and Authorization Management
90ERP EHP76.0USAGR_SYS51GUM: Assignment of Role/Position to System (Type)User and Authorization Management
91ERP EHP76.0USAPPLREF52CUA: Assignment of Users to Application ObjectsUser and Authorization Management
92ERP EHP76.0USARC_CD201Not Required: Archived User Data -> Change DocumentsUser and Authorization Management
93ERP EHP76.0USARC_CDRED242Reloaded Archived Change Documents for User DataUser and Authorization Management
94ERP EHP76.0USATTRDEF51Directory of Additional User AttributesUser and Authorization Management
95ERP EHP76.0USATTRDEFT41Directory of Additional User AttributesUser and Authorization Management
96ERP EHP76.0USBAPILINK41CUA: Default BAPI Link for Central User AdministrationUser and Authorization Management
97ERP EHP76.0USCOMPANY31Company in user's addressUser and Authorization Management
98ERP EHP76.0USCOMPANYS41Shadow table for USCOMPANYUser and Authorization Management
99ERP EHP76.0USCRAUIDT41Short Texts for Critical AuthorizationsUser and Authorization Management
100ERP EHP76.0USCRAUTH81Authorization Data for Critical AuthorizationsUser and Authorization Management
101ERP EHP76.0USCRAUTHID41Critical AuthorizationsUser and Authorization Management
102ERP EHP76.0USCRCOMID41Part List for Critical Combinations of AuthorizationsUser and Authorization Management
103ERP EHP76.0USEXIT21Individual Maint. Dialog for Authorization Field - Exit FMUser and Authorization Management
104ERP EHP76.0USGRP21User GroupsUser and Authorization Management
105ERP EHP76.0USGRPT41Text table for USGRP (User groups)User and Authorization Management
106ERP EHP76.0USGRP_USER61Assignment of Users to User GroupsUser and Authorization Management
107ERP EHP76.0USH02_ARC_TMP181Change History for Logon Data: Last Entries from ArchiveUser and Authorization Management
108ERP EHP76.0USH0471Change history for authorizationsUser and Authorization Management
109ERP EHP76.0USH04_ARC_TMP73Authorizations Change History: Last Entries from ArchiveUser and Authorization Management
110ERP EHP76.0USH10101Change history for authorization profilesUser and Authorization Management
111ERP EHP76.0USH10_ARC_TMP101Change History for Profile Data: Last Entries from ArchiveUser and Authorization Management
112ERP EHP76.0USH12101Change history for authorization valuesUser and Authorization Management
113ERP EHP76.0USH12_ARC_TMP101Change History for Authorizations: Last Archive EntriesUser and Authorization Management
114ERP EHP76.0USKRI51Critical combination of authorizations for transactionsUser and Authorization Management
115ERP EHP76.0USKRIA81Entry of Critical Auths for Report RSUSR009User and Authorization Management
116ERP EHP76.0USKRIAT81Text table for USKRIAUser and Authorization Management
117ERP EHP76.0USL0441CUA: Assignment of Users to Local ProfilesUser and Authorization Management
118ERP EHP76.0USLA0471CUA: Assignment of Users to RolesUser and Authorization Management
119ERP EHP76.0USOGR11Object groups for TCode < > Auth. object assignmentUser and Authorization Management
120ERP EHP76.0USOGT31Texts for object groupsUser and Authorization Management
121ERP EHP76.0USOTT71Relation transaction > authorization objectUser and Authorization Management
122ERP EHP76.0USR03281User address dataUser and Authorization Management
123ERP EHP76.0USR0472User master authorizationsUser and Authorization Management
124ERP EHP76.0USR06111Additional Data per UserUser and Authorization Management
125ERP EHP76.0USR06SYS111System-Specific User Classification (License-Related)User and Authorization Management
126ERP EHP76.0USR07371Object/values of last authorization check that failedUser and Authorization Management
127ERP EHP76.0USR10102User master authorization profilesUser and Authorization Management
128ERP EHP76.0USR1153User Master Texts for Profiles (USR10)User and Authorization Management
129ERP EHP76.0USR12102User Master Authorization ValuesUser and Authorization Management
130ERP EHP76.0USR1363Short Texts for AuthorizationsUser and Authorization Management
131ERP EHP76.0USR1431Surchargeable Language Versions per UserUser and Authorization Management
132ERP EHP76.0USR1542External User Name (Replaced By Table USRACL)User and Authorization Management
133ERP EHP76.0USR1681Values for Variables for User AuthorizationsUser and Authorization Management
134ERP EHP76.0USR2051Date of last user master reorganizationUser and Authorization Management
135ERP EHP76.0USR21124User Name/Address Key AssignmentUser and Authorization Management
136ERP EHP76.0USR21S131Shadow table: Assignment of user name to address keyUser and Authorization Management
137ERP EHP76.0USR2231Logon data without kernel accessUser and Authorization Management
138ERP EHP76.0USRARCSTAT111Reloaded Archiving RunsUser and Authorization Management
139ERP EHP76.0USRATTR51Additional Attributes for UsersUser and Authorization Management
140ERP EHP76.0USRBF41User Buffer Contents for Fast RFC LogonUser and Authorization Management
141ERP EHP76.0USRBF241User buffer content for fast RFC logon - newUser and Authorization Management
142ERP EHP76.0USRCOMB31Critical Combinations of AuthorizationsUser and Authorization Management
143ERP EHP76.0USRCOMBT41Short Texts for Critical Combinations of AuthorizationsUser and Authorization Management
144ERP EHP76.0USRCRCOMB31Part List of Variants for Critical Combinations of AuthsUser and Authorization Management
145ERP EHP76.0USREFUS43Reference user for internet applicationsUser and Authorization Management
146ERP EHP76.0USREFUSVAR31Assignment of Reference User Variabe to Reference UserUser and Authorization Management
147ERP EHP76.0USRFLD21CUA: Definition of Logical FieldsUser and Authorization Management
148ERP EHP76.0USRFLDDEF41CUA: Definition of Logical Field Names of ALE Distrib. UsersUser and Authorization Management
149ERP EHP76.0USRFLDGRP41CUA: Field Selection GroupsUser and Authorization Management
150ERP EHP76.0USRFLDSEL51CUA: Field AttributesUser and Authorization Management
151ERP EHP76.0USRFLDT51CUA: Text Table to Define Logical FieldsUser and Authorization Management
152ERP EHP76.0USRFLDVAL71CUA: Selection Criteria for Field AttributesUser and Authorization Management
153ERP EHP76.0USRSTAMP71Time Stamp for all Changes to the UserUser and Authorization Management
154ERP EHP76.0USRSYSACT41CUA: Roles in Distributed SystemsUser and Authorization Management
155ERP EHP76.0USRSYSACTT61CUA: Roles in Distributed SystemsUser and Authorization Management
156ERP EHP76.0USRSYSPRF91CUA: Profiles in Distributed SystemsUser and Authorization Management
157ERP EHP76.0USRSYSPRFT51CUA: Profile Text in Distributed SystemsUser and Authorization Management
158ERP EHP76.0USRSYSUPL61CUA: Price Lists in SAP SystemUser and Authorization Management
159ERP EHP76.0USRSYSUPPL41CUA: Assignment of User Types to Price ListsUser and Authorization Management
160ERP EHP76.0USRSYSUTPA81CUA: System Measurement: User Types with AttributesUser and Authorization Management
161ERP EHP76.0USRSYSUTYP61CUA: Texts for User Types in SAP SystemUser and Authorization Management
162ERP EHP76.0USRSYSUZUS51CUA: Texts for Special VersionsUser and Authorization Management
163ERP EHP76.0USRVAR21Variants for Critical AuthorizationsUser and Authorization Management
164ERP EHP76.0USRVARCOM21Variants of Critical Combinations of AuthorizationsUser and Authorization Management
165ERP EHP76.0USRVARCOMT41Short Texts for Variants of Critical Combs of AuthorizationsUser and Authorization Management
166ERP EHP76.0USRVARID31Part List of Variants for Critical AuthorizationsUser and Authorization Management
167ERP EHP76.0USRVART41Short Texts for Variants of Critical AuthorizationsUser and Authorization Management
168ERP EHP76.0USR_CUST31Customizing Settings for Users / AuthorizationsUser and Authorization Management
169ERP EHP76.0USR_FLAGS31Various Flags for Authorization ProgramsUser and Authorization Management
170ERP EHP76.0USSETTINGS31Customizing settings in user maintenanceUser and Authorization Management
171ERP EHP76.0USSETTINGT41Text table for USSETTINGSUser and Authorization Management
172ERP EHP76.0USSYSTYP21GUM: System TypesUser and Authorization Management
173ERP EHP76.0USSYSTYPT41GUM: System Type TextsUser and Authorization Management
174ERP EHP76.0UST0432User mastersUser and Authorization Management
175ERP EHP76.0UST10C42User master: Composite profilesUser and Authorization Management
176ERP EHP76.0UST10S52User master: Single profilesUser and Authorization Management
177ERP EHP76.0UST1272User master: AuthorizationsUser and Authorization Management
178ERP EHP76.0USUSER_AGR81GUM: Assignment of Role to UserUser and Authorization Management
179ERP EHP76.0USUSER_SYS51GUM: Assignment of User (Group) to System (Type)User and Authorization Management
180ERP EHP76.0USZBVLNDRC81CUA: System Landscape RecipientUser and Authorization Management
181ERP EHP76.0USZBVLNDSC31CUA: System Landscape SenderUser and Authorization Management
182ERP EHP76.0USZBVPROT161CUA: Protocols of the Distribution of UsersUser and Authorization Management
183ERP EHP76.0USZBVPROTC161CUA: Protocols of the Distribution of Company AddressesUser and Authorization Management
184ERP EHP76.0USZBVSYS91CUA: Assignment of Systems to UsersUser and Authorization Management
185ERP EHP76.0USZBVSYSC81CUA: Assignment of Systems to Company AddressesUser and Authorization Management