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

52 columns | Print definition?ERP 6.0  | TID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing47TIDUnique Transaction ID (LUW) for qRFCsnvarchar240
2/OPT/X018Key Determination Template Definition2TIDKey Determination Template Idnvarchar300
3/OPT/X019Key Determination Template Texts2TIDKey Determination Template Idnvarchar300
4/OPT/X020Key Determination Template Details2TIDKey Determination Template Idnvarchar300
5/OPT/X021Key Determination Templates for Product Roles4TIDKey Determination Template Idnvarchar300
6/OPT/X022Template Field Details2TIDKey Determination Template Idnvarchar300
7/OPT/Y018Key Determination Template Definition2TIDKey Determination Template Idnvarchar300
8/OPT/Y019Key Determination Template Texts2TIDKey Determination Template Idnvarchar300
9/OPT/Y020Key Determination Template Details2TIDKey Determination Template Idnvarchar300
10/OPT/Y021Key Determination Templates for Product Roles4TIDKey Determination Template Idnvarchar300
11/OPT/Y022Template Field Details2TIDKey Determination Template Idnvarchar300
12/OPT/Z018Key Determination Template Definition2TIDKey Determination Template Idnvarchar300
13/OPT/Z019Key Determination Template Texts2TIDKey Determination Template Idnvarchar300
14/OPT/Z020Key Determination Template Details2TIDKey Determination Template Idnvarchar300
15/OPT/Z021Key Determination Templates for Product Roles4TIDKey Determination Template Idnvarchar300
16/OPT/Z022Template Field Details2TIDKey Determination Template Idnvarchar300
17/SDF/IVISALEPNDGALE messages stuck in tRFC15TIDTransaction IDnvarchar240
18/SDF/IVISXIPNDGPending ALE messages for IDOC adapter11TIDTransaction IDnvarchar240
19BWBICS_INA_STOREPersistance for the Test Tool2TIDTest Data Identifiernvarchar300
20IDXLOGIDoc Adapter RFC Logging5TIDCharacter field length 24nvarchar240
TOPALE Integration Technology
21EDIDSStatus Record (IDoc)24TIDTransaction IDnvarchar240
TOPApplication Framework
22MDG_MDFTRTXTText Table for Translation of Master Data Content3TIDTable ID for Generic Text Tablenvarchar320
23MDG_MDFTRTXT2Text Table for Translation of Master Data Content3TIDTable ID for Generic Text Tablenvarchar320
24MDG_TR_TXTGeneral Text Table for Master Data Transport3TIDTable ID for Generic Text Tablenvarchar320
25MDG_TR_TXT_HHeader Table for Generic Texts6TIDTable ID for Generic Text Tablenvarchar320
26MDG_TR_TXT_KKey Table for Generic Texts2TIDTable ID for Generic Text Tablenvarchar320
TOPBasic Functions
27ETXDCHExternal tax document: header info11TIDTransaction ID for updating external tax systemnvarchar240
TOPBW generation tool and quantity object
28ODQDATAOperational Delta Queue: Data Store for Delta2TIDUnique Transaction IDdecimal239
29ODQTSNLOGOperational Delta Queue: Transaction Log3TIDUnique Transaction IDdecimal239
TOPCross-Application Components
30/OPT/CP_T910Key Determination Template Definition2TIDKey Determination Template Idnvarchar300
31/OPT/CP_T910TKey Determination Template Texts2TIDKey Determination Template Idnvarchar300
32/OPT/CP_T911Key Determination Template Details2TIDKey Determination Template Idnvarchar300
33/OPT/CP_T912Key Determination Templates for Product Roles4TIDKey Determination Template Idnvarchar300
34/OPT/CP_T913Template Field Details2TIDKey Determination Template Idnvarchar300
TOPDistribution Unit Distribution Packet
35DSPITMALE Distribution Packet : Objects10TIDTransaction IDnvarchar240
TOPFinancials Basis
36FINB_TR_TXTFINB Transport: General Text Table3TIDFINB TR: Table ID for Generic Text Tablenvarchar320
37FINB_TR_TXT_HFINB TR: Header Table for Generic Texts6TIDFINB TR: Table ID for Generic Text Tablenvarchar320
38FINB_TR_TXT_KFINB TR: Key Table for Generic Texts2TIDFINB TR: Table ID for Generic Text Tablenvarchar320
39UGMDTRTXTFIN Master Data: Text Table for Content Translation3TIDFINB TR: Table ID for Generic Text Tablenvarchar320
40UGMDTRTXT2FIN Master Data: Text Table for Content Translation3TIDFINB TR: Table ID for Generic Text Tablenvarchar320
TOPIntegration Engine
41SXMSTRANS_HEADERLookup Table for Message Transfer8TIDUnique Transaction ID (LUW -> COMMIT WORK)nvarchar240
TOPIntegration Server
42IDXRCVPORIDoc Adapter Link GUID with IDoc, Receiver and so on9TIDCharacter field length 24nvarchar240
43IDXSNDPORIDoc Adapter Link GUID with IDoc, Sender System and so on9TIDCharacter field length 24nvarchar240
TOPRFC
44QRFCLOGTrace Description1TIDTransaction IDnvarchar240
45QRFCTRACETrace Description1TIDTransaction IDnvarchar240
46RFCSTXTABRFC statistics administration21TIDUnique Transaction ID (LUW -> COMMIT WORK)nvarchar240
TOPSCM Basis
47CIFERRLOGError Recording in Enhanced CIF Error Handling3TIDUnique Transaction ID (LUW) for qRFCsnvarchar240
TOPTranslation Tools
48SBRNTTTTABSBRN Test Environment2TIDSingle-Character Indicatornvarchar10
TOPTransport Organizer
49TLOCKCIOLock Table for CheckOut-CheckIn5TIDnvarchar2550
TOPTREX ABAP JAVA API
50TREX_DELTA_QUEUETREX Delta Queue3TIDdecimal200
TOPUI Services, Screen, Batch Input
51BDCUSEOPUser-Specific Options for Transaction SM353TIDTransaction Codenvarchar200
TOPWeb Service and SOAP - ABAP
52SRT_AGS_E2E_TRCtest results of AGS E2E tracing tests1TIDUUID in character formnvarchar320