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

62 columns | Print definition?ERP 6.0  | OBJTP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BWSD_DATAData Store for Scenario Objects4OBJTPObject Typenvarchar40
2BWSD_LOCKLock table1OBJTPObject Typenvarchar40
3BWSD_LOGIStatus of Element Objects from Transfer2OBJTPObject Typenvarchar40
4BWSD_LOGOStatus of Scenario Objects from Transfer2OBJTPObject Typenvarchar40
5BWSD_LOGTProtocol for manual tasks3OBJTPObject Typenvarchar40
6BWSD_TRANSName Replacements of Object Transformation6OBJTPObject Typenvarchar40
TOPBusiness Navigator
7DFDOCLinks from R/3 Reference Model objects to mail folder3OBJTPCode for document classnvarchar30
8DFMLHLinks from R/3 Reference Model objects to mail folder4OBJTPCode for document classnvarchar30
9DFMLOLinks from R/3 Reference Model objects to mail folder5OBJTPCode for document classnvarchar30
TOPCommunication Services Mail, Fax, SMS, Telephony
10BCST_ASSIGNMENTBCS: Assignment to Disclosure Documents1OBJTPCode for document classnvarchar30
11BCST_ASSIGNMENTSBCS: Assignment to Disclosure Documents2OBJTPCode for document classnvarchar30
12BCST_DLBCS: Folder for Semantic and Technical DL Key2OBJTPDistribution list type from IDnvarchar30
13BCST_NOTEMapping: Send Order GUID -> SAPOffice Doc. ID of Note3OBJTPCode for document classnvarchar30
TOPData Basis
14RSCNVTSTDATARemodeling test data4OBJTPnvarchar50
TOPFinancial Accounting
15J_1GALLG/L to A/L link deficiencies (Log file)5OBJTPAccount assignment object typenvarchar30
16J_1GGAG/L to A/L connection rules4OBJTPAccount assignment object typenvarchar30
17J_1GOPObject type priorities3OBJTPAccount assignment object typenvarchar30
18J_1GORObject ranges3OBJTPAccount assignment object typenvarchar30
TOPForeign Trade
19/SAPSLL/OBJSSFGTS: R/3 FS: Index of Documents to Be Released2OBJTPObject Typenvarchar100
20/SAPSLL/OBJSYNCGTS: R/3 Feeder System: Index of Generated Documents3OBJTPObject Typenvarchar100
TOPGlobal Trade Services
21/SAPSLL/CORREFReference Data12OBJTPObject Type of Reference Documentnvarchar100
22/SAPSLL/PREVDHPreference: Long-Term Vendor Declaration Header28OBJTPObject Type of Reference Documentnvarchar100
23/SAPSLL/SPLAUDLegal Control - SPL - Audit33OBJTPObject Type of Reference Documentnvarchar100
24/SAPSLL/SPLAUDRAudit Trail for SPL Screening - Additional Object References20OBJTPObject Type of Reference Documentnvarchar100
TOPLogistics - General
25MGWPICTURECustomizing Image Data2OBJTPObject Typenvarchar20
26MGWPICTUREURLObject URL3OBJTPObject Typenvarchar20
27MGWPICTUREURLSETObject URL3OBJTPObject Typenvarchar20
TOPNetWeaver Business Content
28BIZCROBJBusiness Content: Content Object5OBJTPBusiness Content: ID of an Object Typenvarchar700
29BIZCROBJTBusiness Content: Object Type2OBJTPBusiness Content: ID of an Object Typenvarchar700
30BIZCROBJT_TBusiness Content: Object Type2OBJTPBusiness Content: ID of an Object Typenvarchar700
TOPReal Estate Management
31VZWDVLBuffer for sends within Financial Assets Management11OBJTPCode for document classnvarchar30
TOPRecords and Case Management
32RMPSSIGSTATEPersistence of Signature Status7OBJTPCode for document classnvarchar30
TOPUse Subcomponents
33SOATTSAPoffice: Attachments for BOR objects4OBJTPCode for document classnvarchar30
34SOCSSAPoffice: table for storage of an Office ID (SAPcomm)11OBJTPCode for document classnvarchar30
35SOCVPCSAPoffice: Conversion Table for PC Documents2OBJTPCode for document classnvarchar30
36SOCXSAPoffice: table for storing SAPcomm IDs10OBJTPCode for document classnvarchar30
37SOERSAPoffice: receive externally2OBJTPCode for document classnvarchar30
38SOFINDSAPoffice: Search table via SOFD4OBJTPCode for document classnvarchar30
39SOMGTable for persistence of objects MESSAGE/RECIPIENT2OBJTPObject typenvarchar30
40SOOCSAPoffice: object counter (per object type and year)2OBJTPCode for document classnvarchar30
41SOODSAPoffice: Object definition2OBJTPCode for document classnvarchar30
42SOOSSAPoffice: send process2OBJTPCode for document classnvarchar30
43SORDSAPoffice: Viewed Records for Shared Folders8OBJTPCode for document classnvarchar30
44SOREORGObsolete -SAPoffice: Reorg. tab. for interim storage of keys2OBJTPCode for document classnvarchar30
45SORSSAPoffice: Resubmission of user5OBJTPResubmission: Object type from IDnvarchar30
46SOSCSAPoffice: Connection table to SAPcomm and SAPconnect3OBJTPCode for document classnvarchar30
47SOSTSAPoffice: Status log table2OBJTPCode for document classnvarchar30
48SOSXTESTSAPoffice/SAPconnect: Temporary folder for test results3OBJTPCode for document classnvarchar30
49TSOCXSAPoffice: SOC3 split2OBJTPCode for document classnvarchar30
50TSOTDValid Object Types1OBJTPCode for document classnvarchar30
51TSOTTObject Type Texts2OBJTPCode for document classnvarchar30
TOPWithout Description
52RSTT_CMNTComment Archive1OBJTPTrace-Tool: Trace Object Typenvarchar10
53RSTT_DLTADelta Entry of Released Report Data2OBJTPTrace-Tool: Trace Object Typenvarchar10
54RSTT_DLTAEDelta Entry of Released Report Data Elements2OBJTPTrace-Tool: Trace Object Typenvarchar10
55RSTT_FREE_INDIZERSTT: Table for Indexes That Are Now Free1OBJTPTrace-Tool: Trace Object Typenvarchar10
56RSTT_LOCK_IDTable for Locking Trace Objects Using ID1OBJTPTrace-Tool: Trace Object Typenvarchar10
57RSTT_LOCK_TRACERSTT: Table for Locking Traces, Packages and Jobs1OBJTPTrace-Tool: Trace Object Typenvarchar10
58RSTT_OBJHISTTrace Tool: History for Trace Objects1OBJTPTrace-Tool: Trace Object Typenvarchar10
59RSTT_OBJRESPResponsibility for Test Objects1OBJTPTrace-Tool: Trace Object Typenvarchar10
60RSTT_OBJTMPTemporary Trace Object Storage2OBJTPObject Typenvarchar10
61RSTT_SRCHSearch Table for Attributes of RSTT Objects1OBJTPTrace-Tool: Trace Object Typenvarchar10
62RSTT_TXTTexts for Test-Related Objects5OBJTPTrace-Tool: Trace Object Typenvarchar10