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

54 columns | Print definition?ERP 6.0  | MESSAGE_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BSNAGT/T_SENDIDSender ID for FSN Connector2MESSAGE_TYPEMessage Typenvarchar320
2/FLDQ/AD_ERRMAPTable to store error codes8MESSAGE_TYPEMessage Typenvarchar10
3/SAPPSSRM/RCODEReason Code4MESSAGE_TYPEMessage Typenvarchar10
4/SLOAP/IMP_LOGImprovement message log3MESSAGE_TYPESLOAS text typenvarchar300
5/XFT/DIOAIQ_HMESArchive: IQ History - Messages7MESSAGE_TYPEMessage Typenvarchar10
6/XFT/DIO_IQ_HMESIQ History - Messages7MESSAGE_TYPEMessage Typenvarchar10
7/XFT/SRM_REC35Process instance: Messages8MESSAGE_TYPEMessage Typenvarchar10
8BBPD_LA_MESSAGEMessage5MESSAGE_TYPEMessage typenvarchar20
9CNVCMIS_A_10_RUNcmis table for tracking execution of the analysis prg14MESSAGE_TYPEMessage Typenvarchar10
10CNVCMIS_A_30_RUNCmis table for tracking execution of the analysis prg11MESSAGE_TYPEnvarchar10
11CNVMBTCRORGVariant of checking rules5MESSAGE_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
12EHPRCD_COD_CHKLCheck Log11MESSAGE_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
13HRSFI_D_COMP_ERRSuccessFactors: Comp Log Table for Errors in Delta Handling12MESSAGE_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
14HRSFI_D_ERR_LOGSuccessFactors: Log Table for Errors in Delta Handling10MESSAGE_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
15HRSFI_D_ONB_ERRSuccessFactors: Messages from Onboarding Integration8MESSAGE_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
16HRSFI_D_ONB_GERSuccessFactors: General Messages from Onboarding Integration9MESSAGE_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
17HRSFI_D_RCT_ERRSuccessFactors: Messages from Recruiting Import9MESSAGE_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
18HRSFI_D_RCT_GERSuccessFactors: General Messages from Recruiting Import9MESSAGE_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
19HRSFI_D_VARPY_ERSuccessFactors: Variable Pay Log Table for Errors13MESSAGE_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
20SRAL_FIELDS_WSRAL: Channel specific fields5MESSAGE_TYPERAL: Internal Message Type Name of Web Servicenvarchar300
21ZRDB_DEL_DIR16.09.2009: Delete DIR76MESSAGE_TYPEMeldungstyp: S Success, E Error, W Warning, I Info, A Abortnvarchar10
TOPBank Customer Accounts
22TBKK_PAR_MODEMethod for Assigning the Numbers5MESSAGE_TYPEMessage Category for Errors in Number Determinationnvarchar10
TOPBatch-Oriented Parallel Processing of Mass Data
23TBCA_PAR_MODE_YSettings for Number Assignment5MESSAGE_TYPEError Message Category for Numbers Determinationnvarchar10
TOPComplaints and Returns
24/SPE/RET_SPLIPROSPE: Determination of split profile for message processing2MESSAGE_TYPESPE: Message type of portal messagesnvarchar10
25/SPE/T_RETMSGTYDefinition of message for split profile1MESSAGE_TYPESPE: Message type of portal messagesnvarchar10
26/SPE/T_RETMSGTYTText table Definition of message for split profile2MESSAGE_TYPESPE: Message type of portal messagesnvarchar10
TOPDownloadUpload
27/DSD/HH_RACOLPAYDSD - RA: Revenue and Payment Processing14MESSAGE_TYPEMessage Type for Cash Payer Messagenvarchar10
TOPEngineering Change Record
28/PLMI/ECR_TYPERecord Type7MESSAGE_TYPEDuplication Message Type for Change Recordnvarchar10
TOPInternet Communication Framework
29ICFRECORDERStore ICF Documents (Related to Recorder Layer)3MESSAGE_TYPEICF Message Typesnvarchar10
TOPLease Accounting
30/LSIERP/PROC_LOGPersistence for Payment Trigger Containing Errors17MESSAGE_TYPEMessage Typenvarchar10
TOPLocalization
31J_1BNFE_INVALIDElectronic Nota Fiscal: Invalid Status Actions22MESSAGE_TYPEMessage Type of Message in NF-e Lognvarchar10
TOPMaterial Master
32TMGW3Change Restrictions for structured Materials8MESSAGE_TYPEMessage Typenvarchar10
TOPMaterials Management
33/SAPPSPRO/RCODEReason Code4MESSAGE_TYPEMessage Typenvarchar10
TOPMobile Applications
34/ISDFPS/MSG_HDRCommunication Information for Error/Conflict Messages9MESSAGE_TYPEMessage Typenvarchar10
TOPOffice Suite Program
35OSPCT_T_CHK_MAPChecktool: Table to map scenarios with checks5MESSAGE_TYPEChecktool: Message Type (S/E/W)nvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
36DFMCA_NOTE_ATTNote Attributes for Process Objects6MESSAGE_TYPEMessage Typenvarchar10
TOPRetail Demand Management
37RDMT_PACK_SIZEPrice Optimization: Package Size for Data Transfer2MESSAGE_TYPEMessage Type - Demand Managementnvarchar20
38RDMT_PROC_MESSPrice Optimization: Assignment: DM Messages for Processes3MESSAGE_TYPEMessage Type - Demand Managementnvarchar20
39RDM_OUTB_STATUSPrice Optimization: Status Table for DM Message Types5MESSAGE_TYPEMessage Type - Demand Managementnvarchar20
TOPSAP Healthcare - Industry-Specific Components for Hospitals
40NNL_CLASS_MESSMeldung Klassification Nachrichten5MESSAGE_TYPENachrichtentypnvarchar10
41NNL_CLASS_MESSLMeldung Klassification Nachrichten Log5MESSAGE_TYPENachrichtentypnvarchar10
TOPSupply Chain Management
42/SDF/EM_MSGMessages6MESSAGE_TYPEMessage Typenvarchar10
TOPWeb Dynpro ABAP
43WDG_GEN_LOGWeb Dynpro Generation Log8MESSAGE_TYPEMessage Typenvarchar10
TOPWeb Service and SOAP - ABAP
44SRT_CFG_LOG_ITEMSRT Logging: Item Table12MESSAGE_TYPEMessage Typenvarchar10
45SRT_CTRL_TSK_MSGSOAManager Central Configuration: Tasks8MESSAGE_TYPECharacter Field Length = 10nvarchar100
46SRT_SOAM_CONNECTSOAManager Connectivity : Application data for distribution15MESSAGE_TYPEMessage Typenvarchar10
TOPWorkforce Management Application
47WFAC_LGC_HEADOutbound IDoc Logical System Configuration2MESSAGE_TYPEWFM Message Typenvarchar300
48WFAC_LGC_MAPLogical System Mapping for message type2MESSAGE_TYPEWFM Message Typenvarchar300
49WFAC_OUT_MSGWFM Delivered Outbound Message types1MESSAGE_TYPEWFM Message Typenvarchar300
50WFA_CALCSTMSGCalculation Status Messages5MESSAGE_TYPEMessage Typenvarchar10
TOPWorkforce Management Core
51WFMCAS_CALCSTMSGCalculation Status Messages5MESSAGE_TYPEMessage Typenvarchar10
52WFMC_LGC_HEADOutbound IDoc Logical System Configuration2MESSAGE_TYPEWFM Message Typenvarchar300
53WFMC_LGC_MAPLogical System Mapping for message type2MESSAGE_TYPEWFM Message Typenvarchar300
54WFMC_OUT_MSGWFM Delivered Outbound Message types1MESSAGE_TYPEWFM Message Typenvarchar300