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

94 columns | Print definition?ERP 6.0  | MODDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BTP_DL_OBJECTBTP Object18MODDATEBTP Date of Modificationnvarchar80
2BTP_DL_PPHITABTP Project Composed IT Approaches in Phases11MODDATEBTP Date of Modificationnvarchar80
3BTP_DL_PSTEPUPDBTP Reported Updates on Steps by external Applications5MODDATEBTP Date of Modificationnvarchar80
4ICFSRV4ADMIN_LOGICF Services, which only have to be used for administration5MODDATESystem Datenvarchar80
5ICFSRV4ADM_LOLOGLocal Log table for ICFSRV4ADMIN_LOG5MODDATESystem Datenvarchar80
6RFC_TT_ACL_HISTHistory for Access Control of Trust Relationships5MODDATEnvarchar80
7SACF_ALERTCollector for Failed Calls5MODDATEModification datenvarchar80
8SE16N_SP_DEFSE16N: Definition of Search Strings6MODDATEDate of last changenvarchar80
9SLDW_ALERTCollector for Failed Calls5MODDATEModification datenvarchar80
10SLDW_ELEMENTSElements of Whitelists (Design)5MODDATEModification datenvarchar80
11SLDW_ELEMENTS_RTElements of Whitelists (Runtime)5MODDATEModification datenvarchar80
12SLDW_HEADERHeader Attributes for Whitelists9MODDATEModification datenvarchar80
13SLDW_HEADER_RTHeader Attributes for Whitelists7MODDATEModification datenvarchar80
14TCDCOUPLES_SCheck at Call Transaction (Modification Memory)4MODDATEModification datenvarchar80
15TOBJ_CHK_CTRL_DScenario for Switchable Authorization Check (Design Phase)5MODDATEModification datenvarchar80
16TOBJ_CHK_CTRL_DHScenario for Switchable Authorization Check (Design Phase)6MODDATEModification datenvarchar80
17TOBJ_CHK_CTRL_RActive Scenario for Switchable Authorization Check5MODDATEModification datenvarchar80
18TOBJ_CHK_CTRL_RHActive Scenario for Switchable Authorization Check5MODDATEModification datenvarchar80
19ZNOTRTables Excluded from Translation Process9MODDATEModification datenvarchar80
TOPABAP Authorization and Role Management
20AUSOBTRelation transaction > authorization object8MODDATEModification datenvarchar80
21AUSOBT_CRelation Transaction > Auth. Object (Customer)8MODDATEModification datenvarchar80
22TBRG_OBJObjects with Cross-Client Authorization Groups7MODDATEModification datenvarchar80
23TCDCOUPLESCheck on S_TCODE at call transaction4MODDATEModification datenvarchar80
24TOBJVORSAP_NEW Release-Dependent Data for Authorization Objects4MODDATESystem Datenvarchar80
25TOBJ_TPODefinition table for global templates3MODDATESystem Datenvarchar80
26TPRVORTemplates Profile Generator: Entity Table3MODDATESystem Datenvarchar80
27TSTC_SMControl table SU22: Auth.obj.maint. for transactions4MODDATEDate of Last Changenvarchar80
28USOBTRelation transaction > authorization object8MODDATEModification datenvarchar80
29USOBT_BACKBackup Table USOBT for Modified SU258MODDATEModification datenvarchar80
30USOBT_CRelation Transaction > Auth. Object (Customer)8MODDATEModification datenvarchar80
31USOBT_CDChange History for Field Values8MODDATEModification datenvarchar80
32USOBT_C_BACKBackup Table USOBT_C for Modified SU258MODDATEModification datenvarchar80
33USOBT_DUPModification log for table USOBT. For SAP only10MODDATEModification datenvarchar80
34USOBT_TSTMPLocal Time Stamp of Last SAP Change (USOBT)7MODDATEModification datenvarchar80
35USOBXCheck table for table USOBT5MODDATEModification datenvarchar80
36USOBX_BACKBackup Table USOBX for Modified SU255MODDATEModification datenvarchar80
37USOBX_CCheck Table for Table USOBT_C5MODDATEModification datenvarchar80
38USOBX_CDChange History for Check Indicator5MODDATEModification datenvarchar80
39USOBX_C_BACKBackup Table USOBX_C for Modified SU255MODDATEModification datenvarchar80
40USOBX_DUPModification log for table USOBX. Only for SAP7MODDATEModification datenvarchar80
41USOBX_MODCheck table for table USOBT6MODDATEModification datenvarchar80
42USOBX_REVContains Incorrect Traces from USOBX5MODDATEModification datenvarchar80
43USOBX_TSTMPLocal Time Stamp of Last SAP Change (USOBX)5MODDATEModification datenvarchar80
44USOB_AUTHVALTRCAuthorization Trace Result: Objects and Values22MODDATEModification datenvarchar80
45USOB_SMControl Table SU22: Auth. Obj. Maint. for Transact./Service4MODDATEModification datenvarchar80
46USOB_TIMESTAMPApplication Time Stamp for Default Data7MODDATEModification datenvarchar80
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
47DTELRENAMEsddo4MODDATEDate of Last Changenvarchar80
TOPBackground Processing
48TSRVLSTContents of Background Processing Server Groups3MODDATESystem Datenvarchar80
TOPBusiness Configuration Sets
49SCPRACTPBC Set: Activated in local system4MODDATEBC Set: Changed onnvarchar80
50SCPRACTRBC Set: Active records in Local System8MODDATEBC Set: Changed onnvarchar80
51SCPRACTXBC Set: Activated in local system3MODDATEBC Set: Changed onnvarchar80
52SCPRACTXLBC Sets: Language-Dependent Activation Links for Variable3MODDATEBC Set: Changed onnvarchar80
53SCPRATTRBC Set: Attributes3MODDATEBC Set: Changed onnvarchar80
54SCPRCOBJBC Set: Manually maintained cust. object tables5MODDATEBC Set: Changed onnvarchar80
55SCPRSACTBCBC Sets: Assignment of Switch BC Sets to Activation Process5MODDATEBC Set: Changed onnvarchar80
56SCPRSALDBC Sets: Client-Dependent Switch Activation Links5MODDATEBC Set: Changed onnvarchar80
57SCPRSALIBC Sets: Client-Independent Switch Activation Links4MODDATEBC Set: Changed onnvarchar80
58SCPRSATTRSwitch BC Set: Attributes3MODDATEBC Set: Changed onnvarchar80
59SCPRSMLDBC Sets: Client-Dependent Switch Modification Links4MODDATEBC Set: Changed onnvarchar80
60SCPRSMLIBC Sets: Client-Independent Switch Modification Links3MODDATEBC Set: Changed onnvarchar80
TOPCCMS Database Monitors for Oracle
61DBCHECKORAConfiguration of Database Check12MODDATETime of Check or Changenvarchar140
TOPChange Transport System
62GTADIRAGlobal Object List (Change and Transport System)14MODDATEDatenvarchar80
63TPSTATStatus of tp Calls13MODDATESystem Datenvarchar80
TOPCost Center Accounting
64T811CAllocations: Cycles10MODDATEDate of last changenvarchar80
65T811VRSSpecification of Version Change for Cycles7MODDATELast changed onnvarchar80
TOPDatabase Interface, Database Platforms
66DB6ALRTCFGDB6: Alert Configuration Data18MODDATEDB6: Timestamp (Format: YYYYMMDDHHMMSS)nvarchar140
67DB6AUDITDTDB6: Audit log for maintenance actions1MODDATESystem Datenvarchar80
68DB6AUDITHDDB6: Audit log for maintenance actions1MODDATESystem Datenvarchar80
69DB6SCRIPTDB6: SQL Script Source3MODDATESystem Datenvarchar80
TOPDB2 for OS39
70DBCHECKDB2Configuration of DB2/390 System Check Parameters8MODDATEDate of last modificationnvarchar80
TOPGRC Access Control Plug-In
71/VIRSA/TCDCOUPLECheck on S_TCODE at call transaction4MODDATEModification datenvarchar80
TOPIntegration Engine
72SXMSPCONFXMB: Administrative Data for Pipeline Configuration2MODDATESystem Datenvarchar80
73SXMSTSACTAction Table for Integration Server Troubleshooting6MODDATEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
74SXMSTSTRIGTable of Troubleshooting Trigger6MODDATEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPLanguage Transport
75TLSY8Language import client data3MODDATESystem Datenvarchar80
TOPMicrosoft SQL Server
76MSSPROCSMS SQL Server: Stored Procedures7MODDATEnvarchar80
TOPOverhead Cost Controlling
77T823CRevaluation groups9MODDATEDate of last changenvarchar80
TOPService Data Download
78/SDF/DB6ALRTCFGDB2 UDB: Alert Configuration Data17MODDATEnvarchar140
TOPSystem Administration Assistant
79SAACONTCCustomizing for System Administration Assistant2MODDATESystem Datenvarchar80
TOPTransaction Variant and Table Control Settings
80SHDIPICATRImage attributes8MODDATESystem Datenvarchar80
TOPTranslation Tools
81NOINDTables Excluded from Conversion10MODDATEModification datenvarchar80
82NOTRATables Excluded from Translation Process9MODDATEModification datenvarchar80
TOPTransport Management System
83LISCOMDESLIS: Destination Table45MODDATESystem Datenvarchar80
84LISCOMDESCLIS: Characteristic Central Systems8MODDATESystem Datenvarchar80
85LISCOMDESPLIS: User Profiles9MODDATESystem Datenvarchar80
86LISCOMDESULIS: Users for Generation10MODDATESystem Datenvarchar80
TOPTransport Organizer
87TLOCKCIOLock Table for CheckOut-CheckIn8MODDATESystem Datenvarchar80
88TRESNTable of Naming Conventions in ABAP Workbench10MODDATEDate of Last Changenvarchar80
TOPUpgrade - General
89PUTTBCExchange Tables for Each SAP Release and Component11MODDATEDate of Last Changenvarchar80
90PUTTBHHistory of PUTTB Generation (from PUTTBC)2MODDATEDate of Last Changenvarchar80
TOPUser and Authorization Management
91USOTTRelation transaction > authorization object6MODDATEModification datenvarchar80
92USRSTAMPTime Stamp for all Changes to the User5MODDATEModification datenvarchar80
93USZBVSYSCUA: Assignment of Systems to Users6MODDATEDatenvarchar80
94USZBVSYSCCUA: Assignment of Systems to Company Addresses6MODDATEDatenvarchar80