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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

68 columns | Print definition?ERP 6.0  | MSGGUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/ALERT_IDXStandard index table for multiple recipients2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
2/AIF/CDATADatabase table for changed data2MSGGUIDGUID for Integration Engine Objectsvarbinary160
3/AIF/CDATAFDatabase table for changed data (fields)2MSGGUIDGUID for Integration Engine Objectsvarbinary160
4/AIF/DOCU_ID_IDXDocument search index table2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
5/AIF/FHEADFile header data3MSGGUIDXI: Message IDvarbinary160
6/AIF/FLBOOK_IDXStandard index table2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
7/AIF/IDC_IDX_TBLStandard index table2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
8/AIF/MIDX_TEMPLTemplate for a multi index table2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
9/AIF/MSGSTAT_LGTMessage statistics for log11MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
10/AIF/MSGSTAT_LOGMessage statistics trace log2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
11/AIF/PERS_QMSGAIF Persistence: Runtime Queue2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
12/AIF/PERS_RP_MSGAIF Persistence: Runtime run/packet message processing -temp4MSGGUIDPersistence: Message GUIDnvarchar320
13/AIF/PERS_XMLAIF XML Persistency: Message Header2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
14/AIF/POC_A_EVTAIF POC Events3MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
15/AIF/PO_DATAPurchase order data in inbound queue2MSGGUIDXI: Message IDvarbinary160
16/AIF/QRFC_S_IDXqRFC Standard index table2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
17/AIF/Q_STD_IDX_TqRFC Standard index table2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
18/AIF/REP_MSG_CNTAIF Automatic Reprocessing: Message Counter2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
19/AIF/STD_IDX_MULStandard index table for multiple recipients2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
20/AIF/STD_IDX_TBLStandard index table2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
21/AIF/TEMP_EXTIDTemplate for Serialization with External Index2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
22/AIF/TEMP_TIMETemplate for Serialization with Date and Time2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
23/AIF/TEMP_TIMESTTemplate for Serialization with Timestamp2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
24/AIF/TEST_BP_IDXStandard index table2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
25/AIF/TRFC_S_IDXtRFC Standard index table2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
26/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
27/AIF/T_MMSG_IDXMulti Msg class&No. search index table2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
28/AIF/T_MSG_INF_MPI Message <-> AIF Interface linkage2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
29/AIF/T_STD_IDX_TtRFC Standard index table2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
30/AIFX/ECH_STD_TBStandard ECH key fields table2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
31/AIFX/T_PPOAIF PPO3MSGGUIDXI: Message IDvarbinary160
32/SDF/IVISXIPNDGPending ALE messages for IDOC adapter2MSGGUIDvarbinary160
33SXMS_QERRORQueue Error2MSGGUIDGUID for Integration Engine Objectsvarbinary160
34SXMS_QERROR_SQueue Error Alert2MSGGUIDGUID for Integration Engine Objectsvarbinary160
35ZAIF_D01_SIDX_01Single index table for DEMO BUPA_IN2MSGGUIDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPBI Content Analyzer
36RSCONTACTStatus Overview of All BW TLOGO Content Objects13MSGGUIDBW Generation tool: GUID in compressed form (CHAR25)nvarchar250
37RSCONTACT_MMessage Table for RSCONTACT1MSGGUIDBW Generation tool: GUID in compressed form (CHAR25)nvarchar250
TOPData Basis
38RSDMDRSRVMSGMessages Generated by RSRV Jobs2MSGGUIDBW Generation tool: GUID in compressed form (CHAR25)nvarchar250
TOPIntegration Engine
39SXMSBULKXML Message Broker: Bulk Statistics2MSGGUIDXI: Message IDvarbinary160
40SXMSCLUPXMB: Property Cluster3MSGGUIDID for Message Queuenvarchar320
41SXMSCLUP2XMB: Property Cluster (Switch Table)3MSGGUIDID for Message Queuenvarchar320
42SXMSCLURXMB: Resources Cluster3MSGGUIDID for Message Queuenvarchar320
43SXMSCLUR2XMB: Resources Cluster (Switch Table)3MSGGUIDID for Message Queuenvarchar320
44SXMSINTFXMB: Container for Application Monitoring (Template)1MSGGUIDXI: Message IDvarbinary160
45SXMSINTFTSender/Receiver Interfaces1MSGGUIDXI: Message IDvarbinary160
46SXMSPDATAArchive for Message Extract2MSGGUIDXI: Message IDvarbinary160
47SXMSPEMASIntegration Engine: Enhanced Message Queue (Master)2MSGGUIDXI: Message IDvarbinary160
48SXMSPEMAS2Integration Engine: Extended Message Queue (Switch Table)2MSGGUIDXI: Message IDvarbinary160
49SXMSPERFTXMS: Monitor Table for Runtime Measurement1MSGGUIDXI: Message IDvarbinary160
50SXMSPERRO2XMB: Message Queue (Entries with Errors) (Switch Table)2MSGGUIDXI: Message IDvarbinary160
51SXMSPERRORXML Message Broker: Message Queue (Incorrect Entries)2MSGGUIDXI: Message IDvarbinary160
52SXMSPHISTXML Message Broker: History2MSGGUIDXI: Message IDvarbinary160
53SXMSPHIST2XML Message Broker: History (Switch Table)2MSGGUIDXI: Message IDvarbinary160
54SXMSPMASTIntegration Engine: Message Queue (Master)2MSGGUIDXI: Message IDvarbinary160
55SXMSPMAST2XML Message Broker: Message Queue (Master) (Switch Table)2MSGGUIDXI: Message IDvarbinary160
56SXMSPVERSIntegration Engine: Message Version2MSGGUIDXI: Message IDvarbinary160
57SXMSPVERS2Integration Engine: Message Version (Switch Table)2MSGGUIDXI: Message IDvarbinary160
58SXMSRECVTTechnical Receiver1MSGGUIDXI: Message IDvarbinary160
59SXMSTRANS_MSGBody Table for Message Transfer2MSGGUIDXI: Message IDvarbinary160
60SXMSTRC_DATXMS: Trace Data14MSGGUIDXI: Message IDvarbinary160
61SXMSTRC_SELXMS: Selection Conditions for Trace Start9MSGGUIDXI: Message IDvarbinary160
62SXMS_MULTIM_REFLink Table Leading Message - Submessages2MSGGUIDXI: Message IDvarbinary160
63SXMS_VIOL_LOGException Handling in EOIO Processing2MSGGUIDXI: Message IDvarbinary160
TOPRuntime WorkbenchMonitoring
64SXMSAGGRAWSAP XI Status Overview: Integration Engine Raw Data2MSGGUIDXI: Message IDvarbinary160
65SXMSALERTLOGXI Alert Log7MSGGUIDXI: Message IDvarbinary160
66SXMSALERTLOGGERXI Alert Logs4MSGGUIDSXMS: Message IDnvarchar320
67SXMSMSGINDLOGSAP XI: Indexing Log of Messages2MSGGUIDXI: Message IDvarbinary160
68SXMSMSGPMIUsing XI Messages in PMI3MSGGUIDXI: Message IDvarbinary160