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

26 columns | Print definition?ERP 6.0  | BESTQ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZEIM_LIPSSD document: Delivery: Item data207BESTQStock Category in the Warehouse Management Systemnvarchar10
TOPBasic functions
2HUINV_ITEMHandling Unit: Physical Inventory Document Item8BESTQStock Category in the Warehouse Management Systemnvarchar10
3HUWM_LOAD_PROTLog Table of Initial Data Transfer for Subsequent Posting53BESTQStock Category in the Warehouse Management Systemnvarchar10
4THUBEW2HU: Movement Types for Stock Category Posting Change2BESTQStock Category in the Warehouse Management Systemnvarchar10
5THUBEW3HU Movement Types for Packing and Unpacking with Posting Chg2BESTQStock Category in the Warehouse Management Systemnvarchar10
6VEPOPacking: Handling Unit Item (Contents)20BESTQStock Category in the Warehouse Management Systemnvarchar10
TOPCross-Docking
7LXDCNCross Dock decision24BESTQStock Category in the Warehouse Management Systemnvarchar10
TOPHandling Unit Management
8THUINVBWARTBWART for Posting Inventory Differeneces with HUs2BESTQStock Category in the Warehouse Management Systemnvarchar10
TOPInventory Management
9MSEGDocument Segment: Material94BESTQStock Category in the Warehouse Management Systemnvarchar10
10MWXMSEGZMSEG: Interface for Posting of Value94BESTQStock Category in the Warehouse Management Systemnvarchar10
11MWZMSEGZMSEG:Interface for Posting of Value94BESTQStock Category in the Warehouse Management Systemnvarchar10
TOPR2-R3 Link
12LDK01Communication Record 01 Decentralized WMS: GR/GI R/2 -> ERP12BESTQStock Category in the Warehouse Management Systemnvarchar10
13LDK03Communication Rec. 03 Decentralized WMS: Del.Doc. R/2 -> ERP11BESTQStock Category in the Warehouse Management Systemnvarchar10
TOPShipping
14LIPSSD document: Delivery: Item data207BESTQStock Category in the Warehouse Management Systemnvarchar10
15TMAWBEVENTDefiniton of Possible Transactions for LE Goods Movements8BESTQLE Field Selection - Goods Movement BESTQnvarchar10
TOPWarehouse Management
16LINVInventory data per quant24BESTQStock Category in the Warehouse Management Systemnvarchar10
17LQUAQuants7BESTQStock Category in the Warehouse Management Systemnvarchar10
18LQUABTotal quant counts for certain strategies5BESTQStock Category in the Warehouse Management Systemnvarchar10
19LSEGDocument for Inward and Outward Movements9BESTQStock Category in the Warehouse Management Systemnvarchar10
20LTAPTransfer order item10BESTQStock Category in the Warehouse Management Systemnvarchar10
21LTBPTransfer requirement item8BESTQStock Category in the Warehouse Management Systemnvarchar10
22T321Assignment MM Movement Type --> MM-WM Movement Type10BESTQStock Category in the Warehouse Management Systemnvarchar10
23T321BStock Types and Special Stocks for External Systems3BESTQStock Category in the Warehouse Management Systemnvarchar10
24T322RM Movement Types for Clearing Inventory3BESTQStock Category in the Warehouse Management Systemnvarchar10
25T334TStorage Type Search5BESTQStock Category in the Warehouse Management Systemnvarchar10
26T334UAccess Strategy for Storage Type Search5BESTQConsideration of the stock categorynvarchar10