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

116 columns | Print definition?ERP 6.0  | IFNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/ALERTSList of all AIF alerts3IFNAMEInterface Namenvarchar100
2/AIF/ALERT_IDXStandard index table for multiple recipients5IFNAMEInterface Namenvarchar100
3/AIF/ALRT_USRNOTUser Notification3IFNAMEInterface Namenvarchar100
4/AIF/BDC_IF_CONFAssign Batch Input Session and Creator (Config.)3IFNAMEInterface Namenvarchar100
5/AIF/BDC_IF_GENAssign Batch Input Session and Creator (Gen.)2IFNAMEInterface Namenvarchar100
6/AIF/CDATADatabase table for changed data5IFNAMEInterface Namenvarchar100
7/AIF/CFUNC_DETFunction Information3IFNAMEInterface Namenvarchar100
8/AIF/CFUNC_PARAParameter ID's and Values3IFNAMEInterface Namenvarchar100
9/AIF/CFUNC_RECIAuthorized Recipients for Function3IFNAMEInterface Namenvarchar100
10/AIF/CFUNC_TEXTFunction Text in Diffrent Languages3IFNAMEInterface Namenvarchar100
11/AIF/CFUNC_USERAuthorized Users for Functions3IFNAMEInterface Namenvarchar100
12/AIF/CLINKCustom Data Link4IFNAMEInterface Namenvarchar100
13/AIF/CTEXTCustom Message Text4IFNAMEInterface Namenvarchar100
14/AIF/DOCU_ID_IDXDocument search index table5IFNAMEInterface Namenvarchar100
15/AIF/ERRSTAT_DError statistic (with date)5IFNAMEInterface Namenvarchar100
16/AIF/ERR_INFInterface <-> Multiple key fields link3IFNAMEInterface Namenvarchar100
17/AIF/FHEADFile header data14IFNAMEInterface Namenvarchar100
18/AIF/FINF_TLTrace level for Interfaces3IFNAMEInterface Namenvarchar100
19/AIF/FLBOOK_IDXStandard index table4IFNAMEInterface Namenvarchar100
20/AIF/HINTSDB Table for saving the hints3IFNAMEInterface Namenvarchar100
21/AIF/IDC_IDX_TBLStandard index table4IFNAMEInterface Namenvarchar100
22/AIF/MIDX_TEMPLTemplate for a multi index table5IFNAMEInterface Namenvarchar100
23/AIF/MSGSTAT_LGTMessage statistics for log3IFNAMEInterface Namenvarchar100
24/AIF/MSGSTAT_LOGMessage statistics trace log5IFNAMEInterface Namenvarchar100
25/AIF/MSG_SNAP_DIDAILY snapshot message statistics4IFNAMEInterface Namenvarchar100
26/AIF/MSG_SNAP_DMDAILY message summary data for snapshot4IFNAMEInterface Namenvarchar100
27/AIF/MSG_SNAP_ITSnapshot message statistics4IFNAMEInterface Namenvarchar100
28/AIF/MSG_SNAP_MSSnapshot: Log message categories4IFNAMEInterface Namenvarchar100
29/AIF/MSG_STATMessage statistics3IFNAMEInterface Namenvarchar100
30/AIF/MSG_STATALLMessage statistics3IFNAMEInterface Namenvarchar100
31/AIF/PERF_MSGSStarted messages for Performance Analysis5IFNAMEInterface Namenvarchar100
32/AIF/PERF_VARSVariants for performance time tracking5IFNAMEInterface Namenvarchar100
33/AIF/PERS_QMSGAIF Persistence: Runtime Queue11IFNAMEInterface Namenvarchar100
34/AIF/PERS_XMLAIF XML Persistency: Message Header5IFNAMEInterface Namenvarchar100
35/AIF/POC_C_CFGADConfigure Additional Tasks3IFNAMEInterface Namenvarchar100
36/AIF/POC_C_CFGIFConfiguration for Process Observer3IFNAMEInterface Namenvarchar100
37/AIF/POC_C_CFGTSConfigure Process Observer3IFNAMEInterface Namenvarchar100
38/AIF/QNAMEAIF: Queue name determination3IFNAMEInterface Namenvarchar100
39/AIF/QNAME_FLDSAIF: Queue name determination4IFNAMEInterface Namenvarchar100
40/AIF/QRFC_S_IDXqRFC Standard index table4IFNAMEInterface Namenvarchar100
41/AIF/QRFC_TJ_SOSelection Options for qRFC transfer job4IFNAMEInterface Namenvarchar100
42/AIF/QRFC_TJ_SOTSelection Options Text table4IFNAMEInterface Namenvarchar100
43/AIF/Q_STD_IDX_TqRFC Standard index table4IFNAMEInterface Namenvarchar100
44/AIF/REP_AC_ASGNAIF Automatic Reprocessing: Assign Reprocessing Action3IFNAMEInterface Namenvarchar100
45/AIF/STD_IDX_MULStandard index table for multiple recipients5IFNAMEInterface Namenvarchar100
46/AIF/STD_IDX_TBLStandard index table4IFNAMEInterface Namenvarchar100
47/AIF/TEST_BP_IDXStandard index table4IFNAMEInterface Namenvarchar100
48/AIF/TEST_RA_CNTRecipient Assignment Table for Business Partner Interface3IFNAMEInterface Namenvarchar100
49/AIF/TEXT_HINTSDB Table for saving the hints3IFNAMEInterface Namenvarchar100
50/AIF/TICKETSTicket content table for Ticket System11IFNAMEInterface Namenvarchar100
51/AIF/TRFCQDAqRFC Call Data (Inbound Queue)16IFNAMEInterface Namenvarchar100
52/AIF/TRFC_S_IDXtRFC Standard index table4IFNAMEInterface Namenvarchar100
53/AIF/T_ALRT_DEFAIF Default Keyfield Table3IFNAMEInterface Namenvarchar100
54/AIF/T_ALRT_INFInterface <-> Table names3IFNAMEInterface Namenvarchar100
55/AIF/T_ALRT_KEYSInterface <-> Key Fields for Alert Management3IFNAMEInterface Namenvarchar100
56/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing4IFNAMEInterface Namenvarchar100
57/AIF/T_ERR_LABELDifferent label definition for /AIF/ERR View 2 and View 33IFNAMEInterface Namenvarchar100
58/AIF/T_ERR_MSGError message search3IFNAMEInterface Namenvarchar100
59/AIF/T_FINFInterface definition3IFNAMEInterface Namenvarchar100
60/AIF/T_FINFTInterface definition3IFNAMEInterface Namenvarchar100
61/AIF/T_FINFVVariant Interface Selection5IFNAMEInterface Namenvarchar100
62/AIF/T_FMAPField mapping3IFNAMEInterface Namenvarchar100
63/AIF/T_FMAPCONDField condition mapping3IFNAMEInterface Namenvarchar100
64/AIF/T_FMAPCONDVField condition mapping variant5IFNAMEInterface Namenvarchar100
65/AIF/T_FMAPVField mapping (obsolete)6IFNAMEInterface Namenvarchar100
66/AIF/T_HASHHash table3IFNAMEInterface Namenvarchar100
67/AIF/T_HFLDHash table key3IFNAMEInterface Namenvarchar100
68/AIF/T_IDXIndex table3IFNAMEInterface Namenvarchar100
69/AIF/T_IFACTAssign actions3IFNAMEInterface Namenvarchar100
70/AIF/T_IFACTVAssign actions5IFNAMEInterface Namenvarchar100
71/AIF/T_IFCHECKCheck assignment3IFNAMEInterface Namenvarchar100
72/AIF/T_IFCHECKVCheck assignment5IFNAMEInterface Namenvarchar100
73/AIF/T_IFDETVALValues for Interface Determination9IFNAMEInterface Namenvarchar100
74/AIF/T_IFLDIndex table key3IFNAMEInterface Namenvarchar100
75/AIF/T_IF_HDFLDHide Fields of Structures3IFNAMEInterface Namenvarchar100
76/AIF/T_INFDET_VLValues for Interface Determination22IFNAMEInterface Namenvarchar100
77/AIF/T_INF_AFLDAIF Interface <-> Authorization object mapping3IFNAMEInterface Namenvarchar100
78/AIF/T_INF_ALVHLayout alv handler3IFNAMEInterface Namenvarchar100
79/AIF/T_INF_AOBJAIF Interface <-> Authorization object mapping3IFNAMEInterface Namenvarchar100
80/AIF/T_INF_AUTHChanges authorization3IFNAMEInterface Namenvarchar100
81/AIF/T_INF_HIDEHide Structures3IFNAMEInterface Namenvarchar100
82/AIF/T_INF_KFLDSInterface <-> Key fields link3IFNAMEInterface Namenvarchar100
83/AIF/T_INF_MKFLDInterface <-> Multiple key fields link3IFNAMEInterface Namenvarchar100
84/AIF/T_INF_TBLInterface <-> Tables link3IFNAMEInterface Namenvarchar100
85/AIF/T_INTFIXFix value for interface3IFNAMEInterface Namenvarchar100
86/AIF/T_INTFIXVFix value for interface5IFNAMEInterface Namenvarchar100
87/AIF/T_INTRECDestination record type for interface3IFNAMEInterface Namenvarchar100
88/AIF/T_LOCCCommand line for local interface3IFNAMEInterface Namenvarchar100
89/AIF/T_LOCIParameter for local interface3IFNAMEInterface Namenvarchar100
90/AIF/T_MMSG_IDXMulti Msg class&No. search index table5IFNAMEInterface Namenvarchar100
91/AIF/T_MSG_INF_MPI Message <-> AIF Interface linkage4IFNAMEInterface Namenvarchar100
92/AIF/T_QRFC_FUNCPlayback Functions for RFC Reader3IFNAMEInterface Namenvarchar100
93/AIF/T_RFC_FGLOGFunction Module List Generation Log14IFNAMEInterface Namenvarchar100
94/AIF/T_RFC_FUNCSFunction Module List7IFNAMEInterface Namenvarchar100
95/AIF/T_SMAPStructure mapping3IFNAMEInterface Namenvarchar100
96/AIF/T_SM_FMAPVField mapping condition5IFNAMEInterface Namenvarchar100
97/AIF/T_STD_IDX_TtRFC Standard index table4IFNAMEInterface Namenvarchar100
98/AIF/T_STRMAPVSelect & Add Structure Mapping5IFNAMEInterface Namenvarchar100
99/AIF/T_TJSS_INFAssign Interface to Selection Options3IFNAMEInterface Namenvarchar100
100/AIF/T_TRFC_FUNCPlayback Functions for tRFC Reader3IFNAMEInterface Namenvarchar100
101/AIF/VAR_AS_TMPLTemplate for a variant assignment table3IFNAMEInterface Namenvarchar100
102/AIFX/ECH_STD_TBStandard ECH key fields table19IFNAMEInterface Namenvarchar100
103/AIFX/T_PPOAIF PPO5IFNAMEInterface Namenvarchar100
104ZAIF_D01_SIDX_01Single index table for DEMO BUPA_IN4IFNAMEInterface Namenvarchar100
105ZAIF_REC_CNTRYAIF Default Keyfield Table3IFNAMEInterface Namenvarchar100
TOPClinical System
106N2ETIS-H*MED: Table of docElement to DocCategory assignments101IFNAMEInterface representationnvarchar300
TOPCustomer Enhancements
107ENHCONTRACTTOOLTable of Contract Tools3IFNAMEDevelopment Environment TADIR Namenvarchar400
TOPIntegration Engine
108SXMSARCITFXML Message Archiving3IFNAMEOutbound Interface Namenvarchar1200
109SXMSARCITF2XML Message: Archiving for Interface/NS4IFNAMEOutbound Interface Namenvarchar1200
110SXMSCONFPPPrincipal Propagation Configuration for IE3IFNAMEOutbound Interface Namenvarchar1200
111SXMS_WS_SYSERRQualified Names for System Error Fragments3IFNAMEXI: Interface Namenvarchar1200
112SXMS_WS_SYSERSAPQualified Names for System Error Fragments3IFNAMEXI: Interface Namenvarchar1200
TOPWeb Service and SOAP - ABAP
113SRT_UTIL_ERRLOGSRT Utilities: Error Log Data42IFNAMEnvarchar300
114SRT_UTIL_TRCFUNCSRT Utilities: Functional Trace Data41IFNAMEnvarchar300
115SRT_UTIL_TRCPERFSRT Utilities: Performance Trace Data35IFNAMEnvarchar300
116SRT_UTIL_TRCPLOASRT Utilities: Payload Trace Data41IFNAMEnvarchar300