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

36 columns | Print definition?ERP 6.0  | SEQ_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/X005Approval COA Fields9SEQ_IDDummy for B20 int1 (Local Everywhere)tinyint30
2/OPT/Y005Approval COA Fields9SEQ_IDDummy for B20 int1 (Local Everywhere)tinyint30
3/OPT/Z005Approval COA Fields9SEQ_IDDummy for B20 int1 (Local Everywhere)tinyint30
TOPAdvanced Returns Management
4MSR_I_SEQMulti-step returns -sequence bundles steps1SEQ_IDSequence Identification Numbernvarchar40
5MSR_I_SEQ2CHAINMulti-step returns - combines the current state with planned3SEQ_IDSequence Identification Numbernvarchar40
6MSR_I_SEQ_TMulti-step returns - associated text table to MSR_I_SEQ2SEQ_IDSequence Identification Numbernvarchar40
7MSR_I_STEP2SEQMulti-step returns - assign steps to sequence1SEQ_IDSequence Identification Numbernvarchar40
TOPCalculations
8CMS_BCM_CGP_ADMAdmin data of covarage gap monitoring report4SEQ_IDNatural Numberint100
TOPFinancial Accounting
9/OPT/BL_T401Approval COA Fields9SEQ_IDDummy for B20 int1 (Local Everywhere)tinyint30
TOPIncentive and Commission Management ICM
10CACS25_SESHDSettlement Schedule Header5SEQ_IDSequence Number of Settlement Schedulenvarchar60
11CACS25_SESITSettlement Schedule Item4SEQ_IDSequence Number of Settlement Schedulenvarchar60
12CACS_FFLTITFulfillment Level Item4SEQ_IDFulfillment Level Sequence IDnvarchar40
13YCRM01_SESHDSettlement Schedule Header5SEQ_IDSequence Number of Settlement Schedulenvarchar60
14YCRM01_SESITSettlement Schedule Item4SEQ_IDSequence Number of Settlement Schedulenvarchar60
15YSVMA_SESHDSettlement Schedule Header5SEQ_IDSequence Number of Settlement Schedulenvarchar60
16YSVMA_SESITSettlement Schedule Item4SEQ_IDSequence Number of Settlement Schedulenvarchar60
17YTEL05_SESHDSettlement Schedule Header5SEQ_IDSequence Number of Settlement Schedulenvarchar60
18YTEL05_SESITSettlement Schedule Item4SEQ_IDSequence Number of Settlement Schedulenvarchar60
TOPWeb Service and SOAP - ABAP
19SRT_SEQ_CX_INFOsoap sequence exceptons as xstring3SEQ_IDSoap Sequence Idnvarchar320
20SRT_SEQ_ERR_INFOsoap sequence status information3SEQ_IDSoap Sequence Idnvarchar320
21SRT_SEQ_HDR_STATsoap_sequence header and state info3SEQ_IDSoap Sequence Idnvarchar320
22SRT_SEQ_HEADERsoap_sequence header information3SEQ_IDSoap Sequence Idnvarchar320
23SRT_SEQ_MSG_DELBuffer previous message id3SEQ_IDSoap Sequence Idnvarchar320
24SRT_SEQ_MSG_QUEBuffer message id#s that are queued but not processed3SEQ_IDSoap Sequence Idnvarchar320
25SRT_SEQ_QUEUESoap sequence: assigned queue3SEQ_IDSoap Sequence Idnvarchar320
26SRT_SEQ_QUE_HISTSoap sequence : History of former queues3SEQ_IDSoap Sequence Idnvarchar320
27SRT_SEQ_REORGqueue for sequences that can be reorg after termination3SEQ_IDSoap Sequence Idnvarchar320
28SRT_SEQ_RETRYsoap_sequence header information3SEQ_IDSoap Sequence Idnvarchar320
29SRT_SEQ_RTRYCONTsoap_sequence header information3SEQ_IDSoap Sequence Idnvarchar320
30SRT_SEQ_STATEsoap sequence status information3SEQ_IDSoap Sequence Idnvarchar320
31SRT_SEQ_TST_DTSequence Manager test data3SEQ_IDSoap Sequence Idnvarchar320
32SRT_SEQ_WSRMSoap Sequence: assigned WSRM sequence3SEQ_IDSoap Sequence Idnvarchar320
33SRT_SEQ_WSRM_RELRelationship WSRM sequence to soap sequence for fast access4SEQ_IDSoap Sequence Idnvarchar320
34SRT_SEQ_WS_HISTSoap sequence: History of former wsrm sequences3SEQ_IDSoap Sequence Idnvarchar320
35SRT_TEST_WSA_CLContains info for the received msg from ws-a client test1SEQ_IDCharacter field of length 40nvarchar400
36SRT_TF_TST_DATADB Table where the data from Test Scenarios to be store2SEQ_IDSoap Sequence Idnvarchar320