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

39 columns | Print definition?ERP 6.0  | SEQUENCE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/SC_ENVEnvelope specific data in the schema4SEQUENCE_IDEnvelope Sequencetinyint30
2BBPC_MENV_ENVDTLMulti Envelope Bidding: Envelope details under a schema4SEQUENCE_IDMulti-Envelope RFx Response: Envelope Sequencetinyint30
3ECWD_TRACEeCATT - Trace for Web Dynpro Recording2SEQUENCE_IDint100
4HRHAPCN_OBJ_MSGObject Library: Additional Message2SEQUENCE_ID10 digit numbernvarchar100
5RSBPCB_SOBJ_LKPBPC: Semantic object link parameter3SEQUENCE_IDint100
6RSBPCB_SOBJ_LKPTBPC: Semantic object link parameter text.3SEQUENCE_IDint100
7SNWD_EPM_SNAPSEPM: Table to hold snapshots (backups) of generated data4SEQUENCE_IDnvarchar100
8TCGLABSQNEHS: Sequence Number2SEQUENCE_IDType of Sequence Numbernvarchar400
9TCGLABSQNDEHS: Description of Sequence Number2SEQUENCE_IDType of Sequence Numbernvarchar400
10TCGLABSQNPAREHS: Assignment of Sequence Number - Parameter2SEQUENCE_IDType of Sequence Numbernvarchar400
TOPAdvertising Management
11JJTPCAUPackage: Ad - Upselling Values4SEQUENCE_IDAccess Sequencenvarchar100
12JJTPCDUPackage: Service - Upselling Values4SEQUENCE_IDAccess Sequencenvarchar100
13JJTPCEAAPackage Elements: Ad - Admissible Values5SEQUENCE_IDAccess Sequencenvarchar100
14JJTPCEDAPackage Elements: Service - Admissible Values5SEQUENCE_IDAccess Sequencenvarchar100
15JJTPCEOAPackage Elements: Online - Admissible Values5SEQUENCE_IDAccess Sequencenvarchar100
16JJTPCESAPackage Elements: Ad Insert - Admissible Values5SEQUENCE_IDAccess Sequencenvarchar100
17JJTPCEVAPackage Elements: Distribution - Admissible Values5SEQUENCE_IDAccess Sequencenvarchar100
18JJTPCEWAPackage Elements: Commercial - Admissible Values5SEQUENCE_IDAccess Sequencenvarchar100
19JJTPCOUPackage: Online - Upselling Values4SEQUENCE_IDAccess Sequencenvarchar100
20JJTPCSUPackage: Ad Insert - Upselling Values4SEQUENCE_IDAccess Sequencenvarchar100
21JJTPCVUPackage: Distribution - Upselling Values4SEQUENCE_IDAccess Sequencenvarchar100
22JJTPCWUPackage: Commercial - Upselling Values4SEQUENCE_IDAccess Sequencenvarchar100
23TJJPCCKPackage Check/Search Strategy: Define Access Sequence3SEQUENCE_IDAccess Sequencenvarchar100
24TJJPCCKAPackage Check/Search Strategy: Attribute Definition3SEQUENCE_IDAccess Sequencenvarchar100
25TJJPCCKEPackage Check/Search Strategy: Packages Used3SEQUENCE_IDAccess Sequencenvarchar100
26TJJPCCKTPackage Check/Search Strategy: Texts4SEQUENCE_IDAccess Sequencenvarchar100
TOPCollections Management
27UDM_STR_RULEAssignment of Rules to Strategies3SEQUENCE_IDSequential Number of Strategyint100
28UDM_STR_RULE_VAssignment of Rules to Collection Strategies3SEQUENCE_IDSequential Number of Strategyint100
29UDM_STR_SELOPSelection Options for Strategies3SEQUENCE_IDSequential Number of Strategyint100
30UDM_STR_SELOP_VSelection Options of Collection Strategies3SEQUENCE_IDSequential Number of Strategyint100
31UDM_WL_ITEM_DValuation Details for Worklist Items4SEQUENCE_IDSequential Number of Strategyint100
TOPFinancial Supply Chain Management
32TBNK_RULE_SELOPRule select options4SEQUENCE_IDSequence IDint100
TOPTransaction Manager
33TCORITS_MT_STARTTreasury: Start field and code for MT messages2SEQUENCE_IDPath of Sequencenvarchar600
TOPWeb Service and SOAP - ABAP
34SRT_MMASTERWS message (Master table)19SEQUENCE_IDGUID Part of Sequence IDvarbinary160
35SRT_SEQ_CPENSATEobsolete - compensate relationship persist id -> message2SEQUENCE_IDSoap Sequence Idnvarchar320
36SRT_SEQ_CPS_PSRVcompensate preserve info2SEQUENCE_IDSoap Sequence Idnvarchar320
37SRT_SOAM_CONNECTSOAManager Connectivity : Application data for distribution8SEQUENCE_IDSOAManager Connectivity : Sequence IDtinyint30
38SRT_UTIL_ERRLOGSRT Utilities: Error Log Data20SEQUENCE_IDnvarchar320
39SRT_UTIL_LOGSRT Utilities: Error Log Data18SEQUENCE_IDnvarchar320