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

24 columns | Print definition?ERP 6.0  | OIHANTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZEIM_VBAPSales Document: Item Data254OIHANTYPExcise Duty Handling Typenvarchar20
TOPInterface to Terminal Automation System
2OIK01IS-OIL/TAS: LID Document Data77OIHANTYPExcise Duty Handling Typenvarchar20
3OIK01DIS-OIL/TAS: deactivated LID Document Data78OIHANTYPExcise Duty Handling Typenvarchar20
4OIKCFTAS - Control Field Data13OIHANTYPExcise Duty Handling Typenvarchar20
5OIKCFWTAS - Control Field Data13OIHANTYPExcise Duty Handling Typenvarchar20
6OIKLIDTAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes)44OIHANTYPExcise Duty Handling Typenvarchar20
7OIKLIDRTD - TAS Reference Table44OIHANTYPExcise Duty Handling Typenvarchar20
8OIKLIDWTAS LID Working version (NOTE: keep DB eq to DB OIKLID)44OIHANTYPExcise Duty Handling Typenvarchar20
TOPInventory Management
9MSEGDocument Segment: Material279OIHANTYPExcise Duty Handling Typenvarchar20
TOPProduction Orders
10AFKOOrder Header Data PP Orders161OIHANTYPExcise Duty Handling Typenvarchar20
11T399XParameters dependent on order type81OIHANTYPExcise Duty Handling Typenvarchar20
TOPPurchasing
12EKPOPurchasing Document Item284OIHANTYPExcise Duty Handling Typenvarchar20
TOPSales
13VBAPSales Document: Item Data261OIHANTYPExcise Duty Handling Typenvarchar20
TOPSimulation
14VSAFKO_CNVersion: Order header data for PP orders164OIHANTYPExcise Duty Handling Typenvarchar20
TOPTariffs, Duties and Permits
15A419ED pricing/Origin/Tax Group/Handl.Type/Orig.reg.7OIHANTYPExcise Duty Handling Typenvarchar20
16A443Red Rate Exc Duty Comp/Plant/Tax Group/Handling Type7OIHANTYPExcise Duty Handling Typenvarchar20
17OIH09Excise duty defaults for Stock Transfers5OIHANTYPExcise Duty Handling Typenvarchar20
18OIH40Excise Duty defaulting table GI/GR for production orders7OIHANTYPExcise Duty Handling Typenvarchar20
19OIHEDOObject table 1, IS-OIL Excise Duty Special Ledger12OIHANTYPExcise Duty Handling Typenvarchar20
20OIHSLOTDP (excise duty) special ledger object table11OIHANTYPExcise Duty Handling Typenvarchar20
21OIH_MIGO_HTDPStore the TDP-GOITEM for MIGOs hold/restore feature10OIHANTYPExcise Duty Handling Typenvarchar20
22OIH_TAX_REVExcise Duty Revaluation Documents29OIHANTYPExcise Duty Handling Typenvarchar20
TOPTraders and Schedulers Workbench
23OIJNOMINomination Item117OIHANTYPExcise Duty Handling Typenvarchar20
TOPTransportation and Distribution
24TOIGS3TD Intransit Batch/Handling Type Determination8OIHANTYPTD handling type bulk shipment loadnvarchar20