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

82 columns | Print definition?ERP 6.0  | USERGROUP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GRCPI/GRIACTGRPMaintain Controller Group and FF ID/Role Assignment5USERGROUPUser group in user master maintenancenvarchar120
2FMPEP_ADM_SVSession Variants administration5USERGROUPUser group in user master maintenancenvarchar120
3GRACCTGRPMaster table for SPM Controller Groups2USERGROUPUser group in user master maintenancenvarchar120
4GRACCTGRPDTLMaintain Controllers assigned to Controller Groups2USERGROUPUser group in user master maintenancenvarchar120
5GRACCTGRPDTLTText Table for GRACCTGRPDTL table3USERGROUPUser group in user master maintenancenvarchar120
6GRACFFCTRLGRPMaintain Controller Group and FF ID/Role Assignment5USERGROUPUser group in user master maintenancenvarchar120
7GRACFFCTRLGRPTText Table for GRACFFCTRLGRP table6USERGROUPUser group in user master maintenancenvarchar120
8GRACMGRISKDRisk Analysis Mgmt Sum data for Batch Risk Analysis.7USERGROUPUser Groupnvarchar500
9GRACMITUSERGPUser Group mitigating control assignment2USERGROUPUser Groupnvarchar500
10GRACREQUSERGROUPObselete -- User Groups4USERGROUPUser groupnvarchar120
11SMI_UG_SGASSGNUser Group to Search Group Assignment2USERGROUPUser Group IDnvarchar40
12SMI_USERGRPUser Group Definition2USERGROUPUser Group IDnvarchar40
13SMI_USERGRP_TSocial User Group Description3USERGROUPUser Group IDnvarchar40
14SMI_USR_UGASSGNUser to Search Group Assignment2USERGROUPUser Group IDnvarchar40
15ZSKUSRCTLZSKUSERCONTROL10USERGROUPBenutzergruppe in Benutzerstammpflegenvarchar120
TOPBusiness Context Viewer
16/BCV/C_DSISData Provider InfoSets4USERGROUPSAP Query (L): Name of a user groupnvarchar120
TOPBW Service API
17AQBWCATInfoSource Catalog (SAP Query) Customer5USERGROUPSAP Query (S): Name of a user groupnvarchar120
18AQBWCAT_SAPInfoSource Catalog (SAP Query) Used by SAP5USERGROUPSAP Query (S): Name of a user groupnvarchar120
TOPClaims Management
19ICLUSClaim Handler3USERGROUPClaim Handler Groupnvarchar20
20TICL000Claim Header - Screen Sequence Determination4USERGROUPClaim Handler Groupnvarchar20
21TICL017Business Partner Screen Sequence Determination4USERGROUPClaim Handler Groupnvarchar20
22TICL040Damaged Object-Screen Sequence Determination4USERGROUPClaim Handler Groupnvarchar20
23TICL064Subclaim-Screen Sequence Determination4USERGROUPClaim Handler Groupnvarchar20
24TICL068Internal Claim Type: Permitted Claim Handler Group4USERGROUPClaim Handler Groupnvarchar20
25TICL068_2Internal Claim Type: Permitted Claim Handler Group4USERGROUPClaim Handler Groupnvarchar20
26TICL068_3Internal Claim Type: Permitted Claim Handler Group4USERGROUPClaim Handler Groupnvarchar20
27TICL068_4Internal Claim Type: Permitted Claim Handler Group4USERGROUPClaim Handler Groupnvarchar20
28TICL070Claim Handler Group2USERGROUPClaim Handler Groupnvarchar20
29TICL070TClaim Handler Group Text3USERGROUPClaim Handler Groupnvarchar20
30TICL071Data Sets for Which FMOD2A Is Not Executed3USERGROUPClaim Handler Groupnvarchar20
31TICL087Display Profile2USERGROUPClaim Handler Groupnvarchar20
32TIGN220Search6USERGROUPUser Group for Search with Querynvarchar120
TOPClinical System
33N1GUISTATUSIS-H*MED: User-Dependant GUI-Status3USERGROUPUser group in user master maintenancenvarchar120
TOPCross-Application Components
34/IXOS/DC46TAREPAGenerated reports for the selection screen > 4.6 systems6USERGROUPUser groupnvarchar120
35/IXOS/DC46TAREPBGenerated reports for the detail screen > 4.6 systems6USERGROUPUser groupnvarchar120
36/IXOS/DC46TAREPEGenerated reports for the create screen > 4.6 systems6USERGROUPUser groupnvarchar120
37/IXOS/DC46TAREPFGenerated reports for the change screen > 4.6 systems6USERGROUPUser groupnvarchar120
38/IXOS/DC_TACAAdministrator maintenance for Editing4USERGROUPUser groupnvarchar120
39/IXOS/DC_TADAAdministrator maintenance for Details4USERGROUPUser groupnvarchar120
40/IXOS/DC_TAHAHitlist Administrator maintenance (hierachy/separat)5USERGROUPUser groupnvarchar120
41/IXOS/DC_TAIAAdministrator maintenance for Creating4USERGROUPUser groupnvarchar120
42/IXOS/DC_TAREPCGenerated reports for the change mask6USERGROUPUser groupnvarchar120
43/IXOS/DC_TAREPDGenerated reports for the detail mask6USERGROUPUser groupnvarchar120
44/IXOS/DC_TAREPHGenerated reports for hitlists7USERGROUPUser groupnvarchar120
45/IXOS/DC_TAREPIGenerated reports for the insert mask6USERGROUPUser groupnvarchar120
46/IXOS/DC_TAREPSGenerated reports for the selection mask6USERGROUPUser groupnvarchar120
47/IXOS/DC_TASASelectionscreen Administrator maintenance8USERGROUPUser groupnvarchar120
48/IXOS/DC_TAUGUsergroups3USERGROUPUser groupnvarchar120
49/IXOS/DC_TAUGTUsergroups Description4USERGROUPUser groupnvarchar120
50/IXOS/DC_TAUGUAssignment of users to usergroups4USERGROUPUser groupnvarchar120
51/IXOS/DC_TAVARSAVariant INDX table for data cluster variants backup6USERGROUPUser groupnvarchar120
52/IXOS/DC_TAXFCAOScreens: Excluded function codes for attr. object screens7USERGROUPUser groupnvarchar120
53/IXOS/DC_TAXFCSSScreens: Excluded function codes for selection screen6USERGROUPUser groupnvarchar120
TOPDocument Builder
54/IPRO/TUSRTMPLTable of user template data7USERGROUPUser Groupnvarchar300
TOPE-Recruiting
55T77RCF_EREC_UGRUser Groups That Are To Appear in E-Recruiting3USERGROUPSAP Query (S): Name of a user groupnvarchar120
TOPEnd User Technology
56RSRASSUSERAssignment of users to user groups2USERGROUPChannel in the InfoCatalognvarchar100
TOPGovernance, Risk and Compliance
57GRFNSCRSAPQSAP Query Scripts4USERGROUPName of a user groupnvarchar120
TOPHR Administrative Services
58T5ASRSEARCHAssignment of Variant for Search Fields for User Group2USERGROUPUser groupnvarchar20
59T5ASRSELFLDReport Selection Fields for LPA13USERGROUPUser Groupnvarchar20
TOPHR Information Systems
60LDA_QUERY_MAPHR LDAP: Mapping Query Field Name <-> LDAP Attribute Name2USERGROUPSAP Query (S): Name of a user groupnvarchar120
TOPHR Managers Desktop
61T77SCENQYQueries per scenario and object type (customer)3USERGROUPSAP Query (S): Name of a user groupnvarchar120
62T77SCENQY_SYSTQueries per Scenario and Object Type (SAP)3USERGROUPSAP Query (S): Name of a user groupnvarchar120
TOPInspection
63MSR_D_UGROUPInspection: User Groups2USERGROUPInspection User Groupnvarchar300
64MSR_D_UGROUP_TInspection: User Group Description3USERGROUPInspection User Groupnvarchar300
65MSR_D_USER_GROUPAssignment of Users to User Groups3USERGROUPInspection User Groupnvarchar300
TOPMove-InOut
66TE970Configuration for Move-In/Out (EC60)2USERGROUPUser group in user master maintenancenvarchar120
67TECAMIOVARUIS-U: Pre-entry Groups / User Groups2USERGROUPUser group in user master maintenancenvarchar120
TOPMusing Tools
68WDKCUSTREPORTAssignment of InfoSet Query Selcrits to Customizing Keys2USERGROUPSAP Query (L): Name of a user groupnvarchar120
69WDKQTYPESInfoSet Query POWL Types3USERGROUPSAP Query (L): Name of a user groupnvarchar120
TOPProcess Controls
70GRPCSCRIPTScript7USERGROUPName for Query User Group or BI Info Providernvarchar300
71GRPCSCRIPT_TEMPScript - Temporary table for installation7USERGROUPName for Query User Group or BI Info Providernvarchar300
TOPProduct Data Management
72PLM_USERGROUPSData Fields for User Groups2USERGROUPUser Groupnvarchar150
TOPSAP Query
73AQGQDOCSAP Query: Documentation for queries (key entries)1USERGROUPSAP Query: User groupnvarchar120
74AQGQSTRUCSAP Query: Query / Structure Assignment1USERGROUPSAP Query (S): Name of a user groupnvarchar120
75AQLQDOCSAP Query: Documentation for queries (key entries)2USERGROUPSAP Query: User groupnvarchar120
76AQLQSTRUCSAP Query: Query / Structure Assignment2USERGROUPSAP Query (S): Name of a user groupnvarchar120
77AQRLASSRole Assignment of InfoSet Query Call-up4USERGROUPSAP Query (S): Name of a user groupnvarchar120
TOPTREX Enterprise File Search
78SEFS_LDAP_GROUPEnterprise File Search: Persistent LDAP cache for usergroups3USERGROUPDestinguished Name (DN) of an User Group in LDAPnvarchar3000
TOPUser and Authorization Management
79USGRPUser Groups2USERGROUPUser group in user master maintenancenvarchar120
80USGRPTText table for USGRP (User groups)3USERGROUPUser group in user master maintenancenvarchar120
81USGRP_USERAssignment of Users to User Groups3USERGROUPUser group in user master maintenancenvarchar120
TOPWeb Service and SOAP - ABAP
82SRT_UTIL_TRCLOCKSRT Utilities: Lock Functional & Payload Trace3USERGROUPUser group in user master maintenancenvarchar120