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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

54 columns | Print definition?ERP 6.0  | AUTH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/CRB_RSTACHGRBD: Definition of Status Change with Authorization4AUTHActivitynvarchar20
2/SDF/UST12Copy of table UST12 (used in Security Optimization Services)7AUTHAuthorization name in user master maintenancenvarchar120
3GRACROLEPERMAUTHRole Permission Authorization Table5AUTHAuthorization Namenvarchar1000
4RS2HANA_AUTH_APMAuth: Metadata of dyn. analytical privileges2AUTHAuthorization name in user master maintenancenvarchar120
5RS2HANA_AUTH_AUMAuth: Mapping of user/authorizations3AUTHAuthorization name in user master maintenancenvarchar120
6RS2HANA_AUTH_FILAuth: Filter data for dyn. analytical privileges5AUTHAuthorization name in user master maintenancenvarchar120
7RS2HANA_AUTH_PRMAuth: Metadata of procedures2AUTHAuthorization name in user master maintenancenvarchar120
8RSECENVITable for assignment of authorizations to an environment2AUTHBW Analysis Authorizations: Name of an Authorizationnvarchar120
TOPABAP Authorization and Role Management
9AGR_1250Authorization data for the activity group5AUTHAuthorization name in user master maintenancenvarchar120
10AGR_1251Authorization data for the activity group5AUTHAuthorization name in user master maintenancenvarchar120
11CD1251Authorization Data for Role3AUTHAuthorization name in user master maintenancenvarchar120
12HRT1250Table section authorizations5AUTHAuthorization name in user master maintenancenvarchar120
13HRT1251Table section fields5AUTHAuthorization name in user master maintenancenvarchar120
TOPBusiness Package for Manager Self-Service FI
14FPB_AUTHSAuthorizations for FG FPB_Berechtigungen5AUTHAuthorization Name in User Master Maintenancenvarchar120
15FPB_GEN_PROF_LOGLog Entries for Generating Authorizations5AUTHAuthorization Name in User Master Maintenancenvarchar120
16FPB_VALUESAuthorizations for FG FPB_Berechtigungen3AUTHAuthorization Name in User Master Maintenancenvarchar120
TOPDirectory
17LDAPUSERLDAP System User5AUTHAuthentication mechanism (for example, simple bind)int100
TOPDocuments
18TN1IM_IMSETTINGSCustomizing: Image System6AUTHExecute / Do not Execute Authorization Checknvarchar10
TOPEngineering Change Management
19ECM_GROUPGroup Assignment for Change Number7AUTHAuthorizationvarbinary160
TOPIndustry-Specific Component Automotive
20MGV_LAMASCRLAYOULAMA Screen Fields25AUTHAuthorization IDnvarchar30
TOPMobile Applications
21/ISDFPS/MECAA010Local Authorization (Item) for Logging7AUTHAuthorization name in user master maintenancenvarchar120
TOPNetWeaver Enterprise Search
22ESH_AU_AUTH_DATAESH Authorization: User authorization data4AUTHAuthorization name in user master maintenancenvarchar120
TOPOLAP Technology
23RSDDTPS_AUTHAuthorized Users for Polestar3AUTHBW Analysis Authorizations: Name of an Authorizationnvarchar120
24RSECAUTHGENERATDBI AS Authorization Reporting: Generated Authorizations3AUTHAuthorization name in user master maintenancenvarchar120
25RSECBIAUHeader Table for TLOGO BI Authorization BIAU1AUTHBW Analysis Authorizations: Name of an Authorizationnvarchar120
26RSECUSERAUTHBI AS Authorizations: Assignment of User Auth2AUTHAuthorization name in user master maintenancenvarchar120
27RSECUSERAUTH_CLBI AS Authorizations: Assignment of User Auth (Change Log)4AUTHAuthorization name in user master maintenancenvarchar120
28RSSBAUTHGENERATDBW Reporting Authorizations: Generated Authorizations3AUTHAuthorization name in user master maintenancenvarchar120
29RSWSPPROFWorkspace: Authorization Profiles6AUTHAuthorization name in user master maintenancenvarchar120
TOPPostprocessing Office
30/SAPPO/S_CMPNTSAP Software Components: UI Attributes4AUTHComponent-Specific Module for Authorization Checknvarchar300
TOPPrint and Output Management
31TSP0SName Conventions For Spool Request Authorizations2AUTHValue for authorization checknvarchar120
TOPProfitability Analysis
32TKEPPLFUNCFunction Modules for Planning Screens25AUTHName of Function Modulenvarchar300
TOPReuse Services for Country Development
33T5DF6Statement Parameters - Customer Settings8AUTHPrint: Authorizationnvarchar120
TOPSAP Query
34AQGDBBNSAP Query: Assigning Users to User Groups3AUTHSAP Query (S): Flagnvarchar10
TOPTraders and Schedulers Workbench
35TOIJNOM_ST01Nomination status codes5AUTHStatus Relevant for Authority Checknvarchar10
TOPTranslation Tools
36LXEAUTHTranslation Environment: Authorizations1AUTHTranslation Environment Authorizationnvarchar40
37LXEAUTHTTexts2AUTHTranslation Environment Authorizationnvarchar40
38LXEPROFVValues for Translation Authorization Profiles2AUTHTranslation Environment Authorizationnvarchar40
39TRNL_AUTHTranslation Authorizations1AUTHAuthorization areas for translationnvarchar20
40TRNL_AUTHTTexts for Translation Authorizations2AUTHAuthorization areas for translationnvarchar20
41TRNL_PROFVValues for Translation Authorization Profiles2AUTHAuthorization areas for translationnvarchar20
TOPUse BC-FES-CTL SAP Note 835896
42F4EXTACCAuthorization for external use of search help3AUTHAuthorization classes for external search helpnvarchar100
TOPUser and Authorization Management
43USH12Change history for authorization values3AUTHAuthorization name in user master maintenancenvarchar120
44USH12_ARC_TMPChange History for Authorizations: Last Archive Entries3AUTHAuthorization name in user master maintenancenvarchar120
45USR12User Master Authorization Values3AUTHAuthorization name in user master maintenancenvarchar120
46USR13Short Texts for Authorizations4AUTHAuthorization name in user master maintenancenvarchar120
47USRBF2User buffer content for fast RFC logon - new4AUTHAuthorization name in user master maintenancenvarchar120
48UST10SUser master: Single profiles5AUTHAuthorization name in user master maintenancenvarchar120
49UST12User master: Authorizations3AUTHAuthorization name in user master maintenancenvarchar120
TOPVisit Control
50/DSD/VC_AUTHDSD: Visit Group2AUTHVisit Groupnvarchar100
51/DSD/VC_AUTHTDSD: Visit Group - Texts2AUTHVisit Groupnvarchar100
52/DSD/VC_VLHDSD: Visit List - Header Data16AUTHVisit Groupnvarchar100
53/DSD/VC_VPHDSD: Visit Schedule - Header Data26AUTHVisit Groupnvarchar100
TOPWithout Description
54RSSBAUTHTRACEAuthorization Trace BW Reporting5AUTHAuthorization name in user master maintenancenvarchar120