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

23 columns | Print definition?ERP 6.0  | MODULE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SLOAP/OUT_COMMSLOAS - Output Processing Commands7MODULE_IDSLOAS Module IDnvarchar700
2/SLOAP/OUT_COMMTTransport Tables for /SLOAS/OUT_COMM9MODULE_IDSLOAS Module IDnvarchar700
3/SLOAP/OUT_MAPPMapping table for IS mapping for QUA 2.02MODULE_IDSLOAS-Modul-IDnvarchar700
4/SLOAP/SM_MAPPTTransport table for /SLOAS/SM_MAPPI4MODULE_IDSLOAS Module IDnvarchar700
5CNVA_MD_CHK_MAPTable for module - check class mapping1MODULE_IDSLOAP Module IDnvarchar700
6EHPRCD_ICMDSCustomer MDS12MODULE_IDIMDS Module IDnvarchar180
7EHPRCD_ISMDSSupplier MDS10MODULE_IDIMDS Module IDnvarchar180
8SATC_WL_FINDING"Worklist": Findings (transactional data)4MODULE_IDModule key / IDvarbinary160
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
9SATC_AC_CHKCustomizing: - see longtext - SAP extras for check modules2MODULE_IDModule key / IDvarbinary160
10SATC_AC_CHK_MSGCustomizing: - see longtext - SAP extras to messages3MODULE_IDModule key / IDvarbinary160
11SATC_AC_CHK_MSGGCustomizing: - see longtext - SAP message Aspects3MODULE_IDModule key / IDvarbinary160
12SATC_AC_PLNERR_BTransaction data: 'Failure Set' data > 510 bytes4MODULE_IDModule key / IDvarbinary160
13SATC_AC_PLNERR_STransaction data: 'Failure Set' data <= 510 bytes4MODULE_IDModule key / IDvarbinary160
14SATC_AC_RESULTPTransaction data: 'Display Load' plugin failures4MODULE_IDModule key / IDvarbinary160
15SATC_AC_RESULTVPTransaction data: 'Display Load' processing state4MODULE_IDModule key / IDvarbinary160
16SATC_AC_RESULTVTTransaction data: 'Display Load' findings4MODULE_IDModule key / IDvarbinary160
17SATC_AC_VERDCT_BTransaction data: 'Finding (Verdict) Set' data > 510 bytes4MODULE_IDModule key / IDvarbinary160
18SATC_AC_VERDCT_STransaction data: 'Finding (Verdict) Set' data <= 510 bytes4MODULE_IDModule key / IDvarbinary160
TOPATC extensions for Technical Check
19SATC_AC_RESULTVCResults of comparision with RefDB4MODULE_IDModule key / IDvarbinary160
20SATC_AC_RESULTVRMovement data: 'Display Load' module verdicts4MODULE_IDModule key / IDvarbinary160
TOPEnvironment, Health and Safety
21/TDAG/CPA_ICMDSCustomer MDS11MODULE_IDMDS Module IDnvarchar180
22/TDAG/CPA_ISMDSSupplier MDS10MODULE_IDMDS Module IDnvarchar180
TOPWeb Channel Personalisation
23WECD_PERS_USERUser Personalization4MODULE_IDERP Web Channel Module IDnvarchar2550