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

61 columns | Print definition?ERP 6.0  | RECIPIENT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/ALERT_IDXStandard index table for multiple recipients8RECIPIENTAlert Management Recipientnvarchar300
2/AIF/ALRT_USRNOTUser Notification6RECIPIENTAlert Management Recipientnvarchar300
3/AIF/CFUNC_RECIAuthorized Recipients for Function6RECIPIENTAlert Management Recipientnvarchar300
4/AIF/CLINK_RECIAuthorized Recipients for Custom Data Link3RECIPIENTAlert Management Recipientnvarchar300
5/AIF/CTEXT_RECIAuthorized Recipients for Custom Message Text3RECIPIENTAlert Management Recipientnvarchar300
6/AIF/DOCU_ID_IDXDocument search index table15RECIPIENTAlert Management Recipientnvarchar300
7/AIF/ERRSTAT_DError statistic (with date)3RECIPIENTAlert Management Recipientnvarchar300
8/AIF/FLBOOK_IDXStandard index table12RECIPIENTAlert Management Recipientnvarchar300
9/AIF/IDC_IDX_TBLStandard index table12RECIPIENTAlert Management Recipientnvarchar300
10/AIF/MIDX_TEMPLTemplate for a multi index table13RECIPIENTAlert Management Recipientnvarchar300
11/AIF/MSGSTAT_LGTMessage statistics for log6RECIPIENTAlert Management Recipientnvarchar300
12/AIF/MSG_SNAP_DIDAILY snapshot message statistics7RECIPIENTAlert Management Recipientnvarchar300
13/AIF/MSG_SNAP_DMDAILY message summary data for snapshot7RECIPIENTAlert Management Recipientnvarchar300
14/AIF/MSG_SNAP_ITSnapshot message statistics7RECIPIENTAlert Management Recipientnvarchar300
15/AIF/MSG_SNAP_MSSnapshot: Log message categories7RECIPIENTAlert Management Recipientnvarchar300
16/AIF/MSG_STATMessage statistics6RECIPIENTAlert Management Recipientnvarchar300
17/AIF/MSG_STATALLMessage statistics6RECIPIENTAlert Management Recipientnvarchar300
18/AIF/QRFC_S_IDXqRFC Standard index table12RECIPIENTAlert Management Recipientnvarchar300
19/AIF/Q_STD_IDX_TqRFC Standard index table12RECIPIENTAlert Management Recipientnvarchar300
20/AIF/REP_AC_ASGNAIF Automatic Reprocessing: Assign Reprocessing Action8RECIPIENTAlert Management Recipientnvarchar300
21/AIF/STD_IDX_MULStandard index table for multiple recipients8RECIPIENTAlert Management Recipientnvarchar300
22/AIF/STD_IDX_TBLStandard index table12RECIPIENTAlert Management Recipientnvarchar300
23/AIF/TEST_BP_IDXStandard index table12RECIPIENTAlert Management Recipientnvarchar300
24/AIF/TEST_RA_CNTRecipient Assignment Table for Business Partner Interface6RECIPIENTAlert Management Recipientnvarchar300
25/AIF/TRFC_S_IDXtRFC Standard index table12RECIPIENTAlert Management Recipientnvarchar300
26/AIF/T_ALRT_DEFAIF Default Keyfield Table6RECIPIENTAlert Management Recipientnvarchar300
27/AIF/T_ALRT_EXTExternal Address <-> Recipient3RECIPIENTAlert Management Recipientnvarchar300
28/AIF/T_ALRT_INFInterface <-> Table names8RECIPIENTAlert Management Recipientnvarchar300
29/AIF/T_ALRT_RECRecipient for different AlertCategory <-> Interface3RECIPIENTAlert Management Recipientnvarchar300
30/AIF/T_ALRT_RECTRecipient for different AlertCategory <-> Interface3RECIPIENTAlert Management Recipientnvarchar300
31/AIF/T_ALRT_ROLERole <-> Recipient3RECIPIENTAlert Management Recipientnvarchar300
32/AIF/T_ALRT_USERUser <-> Recipient3RECIPIENTAlert Management Recipientnvarchar300
33/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing12RECIPIENTAlert Management Recipientnvarchar300
34/AIF/T_MMSG_IDXMulti Msg class&No. search index table17RECIPIENTAlert Management Recipientnvarchar300
35/AIF/T_STD_IDX_TtRFC Standard index table12RECIPIENTAlert Management Recipientnvarchar300
36/AIFX/ECH_STD_TBStandard ECH key fields table27RECIPIENTAlert Management Recipientnvarchar300
37/IAM/D_NF_RECIP/IAM/NOTIFIER Recipient7RECIPIENTBusiness Partner Numbernvarchar100
38BBPT_IMS_LOGIMS Log Data Table7RECIPIENTBusiness Partner Numbernvarchar100
39GRFNTSVYINSTSurvey Instance table9RECIPIENTSurvey recipientnvarchar120
40GRRMOBRCSAMATRIXRCSA Plan Matrix7RECIPIENTUser IDnvarchar120
41ZAIF_D01_SIDX_01Single index table for DEMO BUPA_IN12RECIPIENTAlert Management Recipientnvarchar300
42ZAIF_REC_CNTRYAIF Default Keyfield Table6RECIPIENTAlert Management Recipientnvarchar300
TOPCollaboration Folders
43CFX_ACTION_RECIPReceiver of a Status Action3RECIPIENTUser namenvarchar120
44CFX_NOTIFICATIONCollaboration Folders: Notifications4RECIPIENTRecipient of a Notificationnvarchar120
45CFX_NTF_QUEUEQueue for E-Mail Notifications4RECIPIENTRecipient of a Notificationnvarchar120
TOPCommunication Services Mail, Fax, SMS, Telephony
46BCST_PPFMDPersistence of BCS Medium for PPF26RECIPIENTSpool Recipient Namenvarchar120
47BCST_RESPOBCS: Persistence of a Spool/Print Recipient16RECIPIENTSpool Recipient Namenvarchar120
TOPEnd User Technology
48RSRD_HASHSTRINGHash Strings of BI Data during Precalculations4RECIPIENTRecipient ID for Recipient-Specific Creation of Documentsnvarchar400
TOPGRC Risk Management
49GRRMTSVYINSTSurvey Instance table11RECIPIENTSurvey recipientnvarchar120
TOPManagement of Internal Controls
50FOPCWFRECIPMIC: Workflow Recipients3RECIPIENTUser Name in User Master Recordnvarchar120
TOPMobiles User Interface
51PUSHLOGWAP Push Logging5RECIPIENTnvarchar200
TOPPost Processing Framework
52PPFTBCSTETransmission Medium Database Table (Template)29RECIPIENTSpool Recipient Namenvarchar120
53PPFTSFPRRUPPF: Medium Smart Forms Print (Runtime)3RECIPIENTSpool Recipient Namenvarchar120
54PPFTSFPRT2PPF: Medium Smart Forms Print (Template)3RECIPIENTSpool Recipient Namenvarchar120
55PPFTSFPRTEPPF: Medium Smart Forms Print (Template)3RECIPIENTSpool Recipient Namenvarchar120
TOPProcess Controls
56GRPCWFRECIPPC: Workflow Recipients3RECIPIENTUser Name in User Master Recordnvarchar120
TOPStock Visibility
57/DSD/SV_MAIL_RECDSD SV Recipient for Express Mail4RECIPIENTUser Namenvarchar120
TOPTransaction Manager
58TCORC_DEAL_ACTVTCorrespondence Deal's activity assignment9RECIPIENTInternal Recipientnvarchar100
59TCORFC_PART_BIC(Obsolete) Recipient mapping for BIC8 codes3RECIPIENTCorrespondence Recipientnvarchar100
60TCORT_COCorrespondence Administrative Data21RECIPIENTCorrespondence Recipientnvarchar100
61TCORT_SAT_ACTVTCorrespondence Security account transfer activity assignment9RECIPIENTInternal Recipientnvarchar100