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

139 columns | Print definition?ERP 6.0  | AGR_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_ALRT_ROLERole <-> Recipient5AGR_NAMERole Namenvarchar300
2/PERSONAS/ROFLASPersonas : ROle FLavor ASsignments2AGR_NAMERole Namenvarchar300
3/PERSONAS/ROFLSHPersonas : ROle FLavor SHaring2AGR_NAMERole Namenvarchar300
4/PERSONAS/ROLESPersonas : Role Ranks2AGR_NAMERole Namenvarchar300
5/PERSONAS/ROTHASPersonas : ROle THeme ASsignments2AGR_NAMERole Namenvarchar300
6/SYCLO/SC001Syclo Security Check Profile7AGR_NAMERole Namenvarchar300
7/XFT/REG_APARRAPAR - Roles3AGR_NAMERole Namenvarchar300
8/XFT/REG_SPVARSPVA - Roles3AGR_NAMERole Namenvarchar300
9BBPC_SUS_UM_RSYSSUS: Replication Systems for Users Created in SUS UM6AGR_NAMERole to be Created in External Systemnvarchar300
10BBPC_SUS_UM_RSYTSUS: Replication Systems for Users Created in SUS UM4AGR_NAMERole to be Created in External Systemnvarchar300
11BBP_ATTR_ACCESSAttribute Access Mode4AGR_NAMERole Namenvarchar300
12BBP_MENUUser-Specific Start Menu2AGR_NAMERole Namenvarchar300
13GRACRTROLELOGLog of user reason for profile gen with conflicts3AGR_NAMERole Namenvarchar300
14RSDMDM_IOBJ_AGRCustomizing for Master Data Maintenance1AGR_NAMERole Namenvarchar300
15RSDMDM_IOBJ_DTLSCustomizing for Master Data Maintenance1AGR_NAMERole Namenvarchar300
16SMI_ROLE_SGASSGNRole Search Group Assignment2AGR_NAMERole Namenvarchar300
TOPABAP Authorization and Role Management
17AAACD1Standard Change Documents Table (Not Used)1AGR_NAMERole Namenvarchar300
18AAACD2Standard Change Documents Table (Not Used)1AGR_NAMERole Namenvarchar300
19AAA_KEYSSAP Authorization Assistant - Definition2AGR_NAMERole Namenvarchar300
20AAA_ROLESSAP Authorization Assistant - Roles Managed by Tool2AGR_NAMERole Namenvarchar300
21AAA_ROLES2SAP Authorization Assistant - Roles no longer Managed2AGR_NAMERole Namenvarchar300
22AAA_USERSSAP Authorization Assistant - Definition2AGR_NAMERole Namenvarchar300
23AAA_VALUESSAP Authorization Assistant - Values2AGR_NAMERole Namenvarchar300
24AAF_ROLESSAP Authorization Assistant - User-Specific Favorites3AGR_NAMERole Namenvarchar300
25AAT_ROLESSAP Authorization Assistant - Definition2AGR_NAMERole Namenvarchar300
26AAT_USERSSAP Authorization Assistant - Definition2AGR_NAMERole Namenvarchar300
27AAT_VALUESSAP Authorization Assistant - Values2AGR_NAMERole Namenvarchar300
28AGR_1016Name of the activity group profile2AGR_NAMERole Namenvarchar300
29AGR_1016BName of the activity group profile2AGR_NAMERole Namenvarchar300
30AGR_1250Authorization data for the activity group2AGR_NAMERole Namenvarchar300
31AGR_1251Authorization data for the activity group2AGR_NAMERole Namenvarchar300
32AGR_1252Organizational elements for authorizations2AGR_NAMERole Namenvarchar300
33AGR_1253Authorization Data for Activity Group - Static Objects2AGR_NAMERole Namenvarchar300
34AGR_AGRSRoles in Composite Roles2AGR_NAMEComposite rolenvarchar300
35AGR_AGRS2Role definition2AGR_NAMERole Namenvarchar300
36AGR_ATTSRole attributes2AGR_NAMERole Namenvarchar300
37AGR_BUFFIInternet Links for a Role2AGR_NAMERole Namenvarchar300
38AGR_BUFFI2Internet links table - Customer version of SAP roles2AGR_NAMERole Namenvarchar300
39AGR_BUFFI3Internet links table - SAP versions of SAP roles2AGR_NAMERole Namenvarchar300
40AGR_CUSTOMRole Customizing objects2AGR_NAMERole Namenvarchar300
41AGR_DEFINERole definition2AGR_NAMERole Namenvarchar300
42AGR_FAVOSPersonal settings for PFCG3AGR_NAMERole Namenvarchar300
43AGR_FLAGSRole attributes2AGR_NAMERole Namenvarchar300
44AGR_FLAGSBRole attributes2AGR_NAMERole Namenvarchar300
45AGR_HIERTable for Structure Information for Menu2AGR_NAMERole Namenvarchar300
46AGR_HIER2Menu structure information - Customer version of SAP roles2AGR_NAMERole Namenvarchar300
47AGR_HIER3Menu structure information - SAP version of SAP roles2AGR_NAMERole Namenvarchar300
48AGR_HIERTRole menu texts2AGR_NAMERole Namenvarchar300
49AGR_HIERT2Role menu texts - Customer version of SAP objects2AGR_NAMERole Namenvarchar300
50AGR_HIERT3Role menu texts - SAP Original2AGR_NAMERole Namenvarchar300
51AGR_HIER_BORTable for Object-Oriented Navigation (OBN)2AGR_NAMERole Namenvarchar300
52AGR_HPAGERole Home Page2AGR_NAMERole Namenvarchar300
53AGR_HPAGETDescription of the Home Page for a Role2AGR_NAMERole Namenvarchar300
54AGR_INFOFilter Values from Generation Run2AGR_NAMERole Namenvarchar300
55AGR_LOGSYSLogical system2AGR_NAMERole Namenvarchar300
56AGR_LSDRole attributes2AGR_NAMERole Namenvarchar300
57AGR_MAPPMiniApps in Role2AGR_NAMERole Namenvarchar300
58AGR_MINIMiniApps in Role2AGR_NAMERole Namenvarchar300
59AGR_MINI2MiniApps in Role2AGR_NAMERole Namenvarchar300
60AGR_MINITRole mini-appl texts2AGR_NAMERole Namenvarchar300
61AGR_MINIT2Role mini-application texts2AGR_NAMERole Namenvarchar300
62AGR_OBJAssignment of Menu Nodes to Role2AGR_NAMERole Namenvarchar300
63AGR_PROFProfile name for role2AGR_NAMERole Namenvarchar300
64AGR_SELECTAssignment of roles to Tcodes2AGR_NAMERole Namenvarchar300
65AGR_TCDTXTAssignment of roles to Tcodes2AGR_NAMERole Namenvarchar300
66AGR_TCODE3Assignment of roles to Tcodes2AGR_NAMERole Namenvarchar300
67AGR_TCODESAssignment of roles to Tcodes2AGR_NAMERole Namenvarchar300
68AGR_TEXTSFile Structure for Hierarchical Menu - Customer2AGR_NAMERole Namenvarchar300
69AGR_TIMETime Stamp for Role (Menu, Profile, Authorizations)2AGR_NAMERole Namenvarchar300
70AGR_TIMEBTime Stamp for Role (Profile Generation)2AGR_NAMERole Namenvarchar300
71AGR_TIMECTime Stamp for Role (User Assignment)2AGR_NAMERole Namenvarchar300
72AGR_TIMEDTime Stamp for Role (Profile Comparison, RFC Distribution)2AGR_NAMERole Namenvarchar300
73AGR_USERSAssignment of roles to users2AGR_NAMERole Namenvarchar300
74AGR_USERTAssignment of roles to users2AGR_NAMERole Namenvarchar300
75CD1016Role Profile Name1AGR_NAMERole Namenvarchar300
76CD1251Authorization Data for Role1AGR_NAMERole Namenvarchar300
77CD1252Organizational elements for authorizations1AGR_NAMERole Namenvarchar300
78FAVO_ROLESFavorites for roles in PFCG3AGR_NAMERole Namenvarchar300
79PRGN_SSMPermitted menus for the Session Manager for role2AGR_NAMERole Namenvarchar300
80ROLE_INAKInactive roles buffer2AGR_NAMERole Namenvarchar300
81ROLE_INAKTInactive roles buffer2AGR_NAMERole Namenvarchar300
TOPAccounting - General
82TFC_INST_ITEMAdministration of a Job (Report/Transaction or Workflow)32AGR_NAMERole Namenvarchar300
83TFC_TEMPL_ITEMAdministration of a Job (Report/Transaction or Workflow)32AGR_NAMERole Namenvarchar300
TOPApplication Framework
84USMD2001Personalization: Default Data Model2AGR_NAMERole Namenvarchar300
85USMD2003Personalization: Default UI Model for Each Data Model2AGR_NAMERole Namenvarchar300
86USMD2005Personalization: Role-depend. Personalization per Data Model2AGR_NAMERole Namenvarchar300
TOPBasis Technology R3
87/ISDFPS/SYS_LSCPSystem Landscape for the Distribution of Users4AGR_NAMERole Namenvarchar300
TOPBusiness Consolidation
88UCMP040Global Parameters: Roles with Authorization Check2AGR_NAMERole Namenvarchar300
89UCUM020Assignment of Cutoff Tasks to User Role5AGR_NAMERole Namenvarchar300
90UCUM04CFavorites in Web Dynpro Monitor2AGR_NAMERole Namenvarchar300
91UCUM04TFavorites in Web Dynpro Monitor2AGR_NAMERole Namenvarchar300
92UCUM060Reports in Web Dynpro Monitor2AGR_NAMERole Namenvarchar300
93UCUW001SAP Cons.: Personalization Workbench: Object Lists2AGR_NAMERole Namenvarchar300
94UCUW011SAP Cons.: Personalization Workbench: Object Lists2AGR_NAMERole Namenvarchar300
TOPClinical System
95N1DCS_AGR_RANGEDCS: Quick Entry of Settings for Roles (Ranges)3AGR_NAMERole Namenvarchar300
96TN1PRECCONFUSERAi.s.h.med: Patient Record, User-Configuration Assignment5AGR_NAMERole Namenvarchar300
TOPCommunication Services Mail, Fax, SMS, Telephony
97BCST_ROBCS: Folders for Semantic and Technical SAP Role Keys2AGR_NAMERole Namenvarchar300
TOPCross-Application Components
98TWPLROLESWorkplace Roles3AGR_NAMERole (Release 4.5 and Above)nvarchar300
99TWPLROLEUSAssignment of Workplace Roles to Users10AGR_NAMERole (Release 4.5 and Above)nvarchar300
TOPDistributed System Landscape
100/ISDFPS/DIST_AGRUser Distribution Additional Roles3AGR_NAMERole Namenvarchar300
TOPEnd User Technology
101RSZW_MINI_URLConversion: URLs for MiniApps1AGR_NAMERole Namenvarchar300
102RSZW_ROLE_URLConversion: URLs for Roles1AGR_NAMERole Namenvarchar300
TOPGRC Access Control Plug-In
103/GRCPI/GRIA_LOCKFor RT loacking2AGR_NAMERole Namenvarchar300
104/GRCPI/GRIA_ROLDRisk Terminator Role Old image2AGR_NAMERole Namenvarchar300
105/VIRSA/RTROLELCKRisk Terminator Role Lock2AGR_NAMERole Namenvarchar300
106/VIRSA/RTROLELOGLog of user reason for profile gen with conflicts2AGR_NAMERole Namenvarchar300
107/VIRSA/RTROLEOLDRisk Terminator Role Old image2AGR_NAMERole Namenvarchar300
108/VIRSA/ZMITROLEMitigating Control - Role4AGR_NAMERolesnvarchar300
TOPPatient Accounting
109NWVIEW_W01IS-H: Workplace - View Type W01 - MiniApp Reports4AGR_NAMERole Namenvarchar300
TOPPatient Management
110NWPLACE_AD1IS-H: Clinical Process Builder - Personal Settings4AGR_NAMERole Namenvarchar300
111NWPUSZWork Environment-to-User (Role) Assignment4AGR_NAMERole Namenvarchar300
112NWPUSZTWork Environment-to-User (Role) Assignment5AGR_NAMERole Namenvarchar300
113NWPVZ_USZIS-H / IS-H*MED: Work Environment-to-Service View Assignment7AGR_NAMERole Namenvarchar300
114TN1TC_RESP_ROLETreatment Contract - Assignments of OU Jurisdiction to Roles2AGR_NAMERole Namenvarchar300
TOPProject Management
115DPR_APPL_VIEWApplication Views When Accessing Project Management2AGR_NAMERole Namenvarchar300
TOPRecords and Case Management
116RMPS_DESK_MODWork Areas Available2AGR_NAMERole Namenvarchar300
TOPRole Generator
117/ISDFPS/AGR_DEFRole Definitions for the Role Generator2AGR_NAMERole Namenvarchar300
118/ISDFPS/AUTH_BCKOriginal Data of the Deactivated Authorizations for Roles2AGR_NAMERole Namenvarchar300
TOPSAP Business Workflow
119SWLIAGWorkflow Inbox Setting for Role2AGR_NAMERole Namenvarchar300
TOPSAP Query
120AQRLASSRole Assignment of InfoSet Query Call-up2AGR_NAMERole Namenvarchar300
TOPSAP Records Management
121RCM_ORG_QACT_PRARCM Organizer: Quick Action: Profile <-> Role Assignment3AGR_NAMERole Namenvarchar300
122RCM_REC_TAFPRCM Record: Function Profile <-> Role Assignment3AGR_NAMERole Namenvarchar300
123SRMORGRL2BC-RM : Roles (new)2AGR_NAMERole Namenvarchar300
124SRMORGRL2TText Table: View Elements3AGR_NAMERole Namenvarchar300
125SRMORGROLSRM View Generator : Role Definition2AGR_NAMERole Namenvarchar300
126SRMORGROLTText Table for View Definition3AGR_NAMERole Namenvarchar300
TOPUser Administration
127WP3ROLEAGRPortal Roles: Assignment to Authorization Roles4AGR_NAMEAuthorization Rolenvarchar300
128WP3ROLEHIERRole Data Read from Child Systems for User Assignment4AGR_NAMEAuthorization Rolenvarchar300
TOPUser and Authorization Management
129TUTYHLPMass Maintain Price Categories2AGR_NAMERole Namenvarchar300
130USLA04CUA: Assignment of Users to Roles4AGR_NAMEName of role in distribution modelnvarchar300
131USRSYSACTCUA: Roles in Distributed Systems3AGR_NAMEName of role in distribution modelnvarchar300
132USRSYSACTTCUA: Roles in Distributed Systems4AGR_NAMEName of role in distribution modelnvarchar300
TOPWD ABAP Page Builder
133CHIP_PFCG_MAPAssignment of Page to PFCG Menu Entry2AGR_NAMERole Namenvarchar300
TOPWeb Channel User Management and Customer Profile
134COMC_WEC_AGR_DWeb channel: Web Descriptions for web channel UA Roles2AGR_NAMERole Namenvarchar300
135COMC_WEC_UA_AGRWeb channel: User Management Possible Activity Groups2AGR_NAMERole Namenvarchar300
TOPWorkbench
136UGWB1101FIN Workbench: Personalization - General Settings2AGR_NAMERole Namenvarchar300
137UGWB1201FIN Workbench: Personalization - General Settings2AGR_NAMERole Namenvarchar300
TOPWorkforce Management Application
138WFAC_APPL_UI_CFGWFM Application UI Configuration2AGR_NAMERole Namenvarchar300
TOPWorkforce Management Core
139WFMC_APPL_UI_CFGWFM Application UI Configuration2AGR_NAMERole Namenvarchar300