SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPOR386Purchase Order
8JDT1124Journal Entry - Rows
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OPCH268A/P Invoice
4OSRN20Serial Numbers Master Data
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7ORCT154Incoming Payment
8OBOT10Bill Of Exchang Transaction
9OOCR9Loading Factors
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

152 tablesB1 8.8 

Inventory and Production
ProductVersionTableColumnsIndexesDescriptionModule
1Business One8.8AIT181Item - Prices - HistoryInventory and Production
2Business One8.8AITB722Item Groups - HistoryInventory and Production
3Business One8.8AITM2497Items - HistoryInventory and Production
4Business One8.8AITT231Product Tree - HistoryInventory and Production
5Business One8.8AITW654Items - Warehouse - HistoryInventory and Production
6Business One8.8AKL1101Pick List - Rows - HistoryInventory and Production
7Business One8.8AMR1223Inventory Revaluation - History - RowsInventory and Production
8Business One8.8AMR2211Inventory Revaluation FIFO Rows (Archive)Inventory and Production
9Business One8.8AMRV273Inventory Revaluation - HistoryInventory and Production
10Business One8.8APKL161Pick List - HistoryInventory and Production
11Business One8.8ATT1201Bill of Materials - Component Items - HistoryInventory and Production
12Business One8.8AWHS771Warehouses - HistoryInventory and Production
13Business One8.8AWO1181Production Order (Rows) - HistoryInventory and Production
14Business One8.8AWOR402Production Order - HistoryInventory and Production
15Business One8.8CIVI141IVI Config FileInventory and Production
16Business One8.8ENT1131Entry - RowsInventory and Production
17Business One8.8IGE12129Goods Issue - RowsInventory and Production
18Business One8.8IGE1082Goods Issue - Row StructureInventory and Production
19Business One8.8IGE11591Goods Issue - Drawn Dpm DetailInventory and Production
20Business One8.8IGE12521Goods Issue - Tax ExtensionInventory and Production
21Business One8.8IGE2502Goods Issue - Freight - RowsInventory and Production
22Business One8.8IGE3582Goods Issue - FreightInventory and Production
23Business One8.8IGE4422Goods Issue - Tax Amount per DocumentInventory and Production
24Business One8.8IGE5802Goods Issue - Withholding TaxInventory and Production
25Business One8.8IGE6601Goods Issue - InstallmentsInventory and Production
26Business One8.8IGE771Delivery Packages - Goods IssueInventory and Production
27Business One8.8IGE861Items in Package - Goods IssueInventory and Production
28Business One8.8IGE9271Goods Issue - Drawn DpmInventory and Production
29Business One8.8IGN12129Goods Receipt - RowsInventory and Production
30Business One8.8IGN1082Goods Receipt - Row StructureInventory and Production
31Business One8.8IGN11591Goods Receipt - Drawn Dpm DetInventory and Production
32Business One8.8IGN12521Goods Receipt - Tax ExtensionInventory and Production
33Business One8.8IGN2502Goods Receipt - Freight - RowsInventory and Production
34Business One8.8IGN3582Goods Receipt - FreightInventory and Production
35Business One8.8IGN4422Goods Receipt - Tax Amount per DocumentInventory and Production
36Business One8.8IGN5802Goods Receipt - Withholding TaxInventory and Production
37Business One8.8IGN6601Goods Receipt- InstallmentsInventory and Production
38Business One8.8IGN771Goods Receipt - Delivery PackagesInventory and Production
39Business One8.8IGN861Goods Receipt - Items in PackageInventory and Production
40Business One8.8IGN9271Goods Receipt - Drawn DpmInventory and Production
41Business One8.8ILM151Srl & Batch Det of Inv Log MsgInventory and Production
42Business One8.8ILM241Inventory Account SubstituteInventory and Production
43Business One8.8IMT141Acct data in selected templateInventory and Production
44Business One8.8IMT1141Calculated expression's constituent with sign for specifying account in specific templateInventory and Production
45Business One8.8IPF1664Landed Costs - RowsInventory and Production
46Business One8.8IPF2111Landed Costs - CostsInventory and Production
47Business One8.8IQI1222Inventory Initial Qty RowsInventory and Production
48Business One8.8IQR1222Inventory Stock Posting (Reconcile) LinesInventory and Production
49Business One8.8ITL161Srl & Batch Details in TransacInventory and Production
50Business One8.8ITM184Items - PricesInventory and Production
51Business One8.8ITT1204Bill of Materials - Component ItemsInventory and Production
52Business One8.8ITW191Item Count AlertInventory and Production
53Business One8.8IVL181IVL Layer LevelInventory and Production
54Business One8.8IVLG171Inventory Revaluation Log FileInventory and Production
55Business One8.8IVRU181Inventory Valuation UtilityInventory and Production
56Business One8.8LIVI71IVI Log FileInventory and Production
57Business One8.8LIVI1141IVI Log Array FileInventory and Production
58Business One8.8MRV1223Inventory Revaluation Information ArrayInventory and Production
59Business One8.8MRV2211Inventory Revaluation FIFO RowsInventory and Production
60Business One8.8OAIM481Archive Inventory MessageInventory and Production
61Business One8.8OALI41Alternative Items 2Inventory and Production
62Business One8.8OARG122Customs GroupsInventory and Production
63Business One8.8OBTN203Batch Numbers Master DataInventory and Production
64Business One8.8OBTQ82Batch No. QuantitiesInventory and Production
65Business One8.8OBTW112Batch Attributes in LocationInventory and Production
66Business One8.8OCHP63India Chapter IDInventory and Production
67Business One8.8OCYC82CycleInventory and Production
68Business One8.8ODBN202Bat. Nos - Draft - Master DataInventory and Production
69Business One8.8ODBW111Batch Draft Attribs in Locat.Inventory and Production
70Business One8.8ODNF52DNF CodeInventory and Production
71Business One8.8ODSN203SNs - Draft - Master DataInventory and Production
72Business One8.8ODSW111SN Draft Attribs in LocationInventory and Production
73Business One8.8OENT405Shipping TypesInventory and Production
74Business One8.8OIBT291Batch No. for ItemInventory and Production
75Business One8.8OIGE2689Goods IssueInventory and Production
76Business One8.8OIGN2689Goods ReceiptInventory and Production
77Business One8.8OILM773Inventory Log MessageInventory and Production
78Business One8.8OIMT102Templates for Inventory JEInventory and Production
79Business One8.8OINM10110Whse JournalInventory and Production
80Business One8.8OIPF596Landed CostsInventory and Production
81Business One8.8OIQI153Inventory Initial QuantityInventory and Production
82Business One8.8OIQR153Inventory Stock Posting (Reconcile)Inventory and Production
83Business One8.8OIRT51Interest PricesInventory and Production
84Business One8.8OITB722Item GroupsInventory and Production
85Business One8.8OITG32Item PropertiesInventory and Production
86Business One8.8OITL322Inventory Transactions LogInventory and Production
87Business One8.8OITM2497ItemsInventory and Production
88Business One8.8OITT232Product TreeInventory and Production
89Business One8.8OITW652Items - WarehouseInventory and Production
90Business One8.8OIVE122FIFO Based Sales ReturnInventory and Production
91Business One8.8OIVK62IVL Vs OINM KeysInventory and Production
92Business One8.8OIVL776Whse JournalInventory and Production
93Business One8.8OIVQ122FIFO Queue Working TableInventory and Production
94Business One8.8OLCT352LocationInventory and Production
95Business One8.8OLGT84Length UnitsInventory and Production
96Business One8.8OMGP32Material GroupInventory and Production
97Business One8.8OMRC42ManufacturersInventory and Production
98Business One8.8OMRL323Advanced Inventory RevaluationInventory and Production
99Business One8.8OMRV273Inventory RevaluationInventory and Production
100Business One8.8OOFR41Defect CauseInventory and Production
101Business One8.8OOIN41InterestInventory and Production
102Business One8.8OOIR41Interest LevelInventory and Production
103Business One8.8OOSR41Information SourceInventory and Production
104Business One8.8OPKG22Package TypesInventory and Production
105Business One8.8OPKL161Pick ListInventory and Production
106Business One8.8OPLN102Price ListsInventory and Production
107Business One8.8ORCN112Retail ChainsInventory and Production
108Business One8.8OSCG32Service CategoryInventory and Production
109Business One8.8OSPG61Special Prices for GroupsInventory and Production
110Business One8.8OSPP94Special PricesInventory and Production
111Business One8.8OSRI284Serial Numbers for ItemsInventory and Production
112Business One8.8OSRN204Serial Numbers Master DataInventory and Production
113Business One8.8OSRQ82Serial No. QuantitiesInventory and Production
114Business One8.8OSRW112Serial No. Attribs in LocationInventory and Production
115Business One8.8OWGT73Weight UnitsInventory and Production
116Business One8.8OWHS771WarehousesInventory and Production
117Business One8.8OWKO313Production InstructionsInventory and Production
118Business One8.8OWOR403Production OrderInventory and Production
119Business One8.8OWTR2689Inventory TransferInventory and Production
120Business One8.8PKL1102Pick List - RowsInventory and Production
121Business One8.8SPP1114Special Prices - Data AreasInventory and Production
122Business One8.8SPP284Special Prices - Quantity AreasInventory and Production
123Business One8.8TMP1204Bill of Materials - Component ItemsInventory and Production
124Business One8.8UILM773IVI Inventory Log MessageInventory and Production
125Business One8.8UILM151Srl & Batch Det of Inv Log MsgInventory and Production
126Business One8.8UILM241Inventory Account SubstituteInventory and Production
127Business One8.8UITM2497ItemsInventory and Production
128Business One8.8UITW652Items - WarehouseInventory and Production
129Business One8.8UIVE122FIFO Based Sales ReturnInventory and Production
130Business One8.8UIVK62IVL Vs OINM KeysInventory and Production
131Business One8.8UIVL776Whse JournalInventory and Production
132Business One8.8UIVL181IVL Layer LevelInventory and Production
133Business One8.8UIVQ122FIFO Queue Working TableInventory and Production
134Business One8.8UWKO313Production InstructionsInventory and Production
135Business One8.8UWKO1122Production Instructions - RowsInventory and Production
136Business One8.8UWOR403Production OrderInventory and Production
137Business One8.8UWOR1182Production Order - RowsInventory and Production
138Business One8.8VLG1131Validation of Recalc. From ToInventory and Production
139Business One8.8WKO1122Production Instructions - RowsInventory and Production
140Business One8.8WOR1182Production Order - RowsInventory and Production
141Business One8.8WTR12129Inventory Transfer - RowsInventory and Production
142Business One8.8WTR1082Inventory Transfer - Row StructureInventory and Production
143Business One8.8WTR11591Inv. Transfer - Drawn Dpm Det.Inventory and Production
144Business One8.8WTR12521Inventory Transfer - Tax ExtensionInventory and Production
145Business One8.8WTR2502Inventory Transfer - Freight - RowsInventory and Production
146Business One8.8WTR3582Inventory Transfer - FreightInventory and Production
147Business One8.8WTR4422Inventory Transfer - Tax Amount per DocumentInventory and Production
148Business One8.8WTR5802Inventory Transfer - Withholding TaxInventory and Production
149Business One8.8WTR6601Inventory Transfer - InstallmentsInventory and Production
150Business One8.8WTR771Inventory Transfer - Delivery PackagesInventory and Production
151Business One8.8WTR861Inventory Transfer - Items in PackageInventory and Production
152Business One8.8WTR9271Inventory Transfer - Drawn DpmInventory and Production