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

41 columns | Print definition?ERP 6.0  | UTCTIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPD_OR_INVHUBObject Link: Invoice/Invoice Template to Reference Document14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
2BBPD_OR_PCOObject Link: Purchase Order/Order Confirmation14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
3BBPD_OR_SUSPCOObject Link: SUS Purchase Order/Order Confirmation14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
4BBPD_OVE_OBRELObject Linkage Purch. Doc. / Online Vendor Evaln14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
5BBP_PDBINRELTransaction Object Linkage (EBP)6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPALE Integration Technology
6IDOCRELLinks between IDoc and application object6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPAudit Management
7PLMM_ACT_BRELRelationships in GOS Environment14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPCommunication Services Mail, Fax, SMS, Telephony
8SRBCSBRELRelationships in GOS Environment14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPConfiguration management
9TCM_PFRELData storage for generic object links6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPCustomer Bill of Services
10ADBOS_ECP_RELObject Relationship Service: Generic Binary Links6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPCustomer Contact
11BPCTSRGBINRELBusiness Partner Contact: Generic Binary Relationships6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPDocument Management Framework
12SKWG_BRELTable for WCM Object Link Service14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPGeneral Object Relations
13SFLIBRELDefault Table for Object Relationship Service14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
14SRCICRELObject Relationship Service: generic binary links6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
15SRGBINRELObject Relationship Service: generic binary links6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
16SROBJINGRPObject Relationship Service table objects in group6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
17SROBLBRELDefault Table for Object Relationship Service14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
18SROBLROLBPersistent Roles of BOR Objects7UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
19SROBLROLCPersistent Roles of Business Classes7UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
20SRPROCESSObject Relationship Service: generic binary links6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
21SRRELROLESObject Relationship Service: Roles7UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPGeneric Object Services
22SRGBTBRELRelationships in GOS Environment14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPIntegrated Product and Process Engineering
23PPESBINRELObject Relationship Service: Generic Binary Links6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPLogistics - General
24CRMBINREL2Object Relationship Service: Generic Binary Links6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPMaintenance Notifications
25SMZB_BINRELObject Relationship Service: Generic Binary Links6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPMaterials Management
26/SAPPSPRO/RMOBRLObjekt Links in GOS Environmen forRecords Management14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
27/SAPPSPRO/RMRLRelationships to records in Records Management14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPMedia Product
28JPOBJLINKGeneric Binary Object Linking for IS-M/PD6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
29JPTTITLELINKGeneric Binary Object Link for By Title6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
30JPTTITLERELObject Relationship Service: Title Relationships14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPPayment Transactions
31ACRELATIONRelationships in Accounting6UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPRecipe Development
32/PLMB/RCP_RECRELDefault Table for Object Relationship Service12UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
33/PLMB/RCP_WBSRELDefault Table for Object Relationship Service12UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPSales and Distribution
34IPM_RAWRECDue Pre-List for Product Sales22UTCTIMEUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
TOPSAP Media
35JPTRAWRECDue Pre-List for Product Sales22UTCTIMEUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
TOPShared Service Center Framework
36SSCDOCSRRELRelationships in GOS Link to Service Request14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPWeb Service and SOAP - ABAP
37SPROXMSGRELLink Table XI Message-> Application Object14UTCTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
38SRT_UTIL_PERFSRT Utilities: Performance Trace Data23UTCTIMEint100
39SRT_UTIL_TRCFUNCSRT Utilities: Functional Trace Data27UTCTIMEint100
40SRT_UTIL_TRCPERFSRT Utilities: Performance Trace Data27UTCTIMEint100
41SRT_UTIL_TRCPLOASRT Utilities: Payload Trace Data29UTCTIMEint100