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
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

41 columns | Print definition?B1 9.3  | STGSEQNUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPInventory and Production
1IGE1Goods Issue - Rows276StgSeqNumStage Sequence NumberInt110
2IGN1Goods Receipt - Rows276StgSeqNumStage Sequence NumberInt110
3ILM3Non-Inventory and Resource Components Log Msg13StgSeqNumStage Sequence NumberInt110
4IVL2Inventory Components for Production16StgSeqNumStage Sequence NumberInt110
5OILMInventory Log Message87StgSeqNumStage Sequence NumberInt110
6ORTLResource Transaction Log22StgSeqNumStage Sequence NumberInt110
7SIVL2Inventory Components for Production16StgSeqNumStage Sequence NumberInt110
8UILMIVI Inventory Log Message87StgSeqNumStage Sequence NumberInt110
9UILM3Non-Inventory and Resource Components Log Msg13StgSeqNumStage Sequence NumberInt110
10UIVL2Inventory Components for Production16StgSeqNumStage Sequence NumberInt110
11WTQ1Inventory Transfer Request - Rows276StgSeqNumStage Sequence NumberInt110
12WTR1Inventory Transfer - Rows276StgSeqNumStage Sequence NumberInt110
TOPMarketing Documents
13ADO1A/R Invoice (Rows) - History276StgSeqNumStage Sequence NumberInt110
14CIN1Correction Invoice - Rows276StgSeqNumStage Sequence NumberInt110
15CPI1A/P Correction Invoice - Rows276StgSeqNumStage Sequence NumberInt110
16CPV1A/P Correction Invoice Reversal - Rows276StgSeqNumStage Sequence NumberInt110
17CSI1A/R Correction Invoice - Rows276StgSeqNumStage Sequence NumberInt110
18CSV1A/R Correction Invoice Reversal - Rows276StgSeqNumStage Sequence NumberInt110
19DLN1Delivery - Rows276StgSeqNumStage Sequence NumberInt110
20DPI1A/R Down Payment - Rows276StgSeqNumStage Sequence NumberInt110
21DPO1A/P Down Payment - Rows276StgSeqNumStage Sequence NumberInt110
22DRF1Draft - Rows276StgSeqNumStage Sequence NumberInt110
23IEI1Incoming Excise Invoice - Rows276StgSeqNumStage Sequence NumberInt110
24INV1A/R Invoice - Rows276StgSeqNumStage Sequence NumberInt110
25OEI1Outgoing Excise Invoice - Rows276StgSeqNumStage Sequence NumberInt110
26PCH1A/P Invoice - Rows276StgSeqNumStage Sequence NumberInt110
27PDN1Goods Receipt PO - Rows276StgSeqNumStage Sequence NumberInt110
28POR1Purchase Order - Rows276StgSeqNumStage Sequence NumberInt110
29PQT1Purchase Quotation - Rows276StgSeqNumStage Sequence NumberInt110
30PRQ1Purchase Request - Rows276StgSeqNumStage Sequence NumberInt110
31PRR1A/P Return Request - Rows276StgSeqNumStage Sequence NumberInt110
32QUT1Sales Quotation - Rows276StgSeqNumStage Sequence NumberInt110
33RDN1Returns - Rows276StgSeqNumStage Sequence NumberInt110
34RDR1Sales Order - Rows276StgSeqNumStage Sequence NumberInt110
35RIN1A/R Credit Memo - Rows276StgSeqNumStage Sequence NumberInt110
36RPC1A/P Credit Memo - Rows276StgSeqNumStage Sequence NumberInt110
37RPD1Goods Return - Rows276StgSeqNumStage Sequence NumberInt110
38RRR1A/R Return Request - Rows276StgSeqNumStage Sequence NumberInt110
39SFC1Self Credit Memo - Rows276StgSeqNumStage Sequence NumberInt110
40SFI1Self Invoice - Rows276StgSeqNumStage Sequence NumberInt110
TOPReports
41OFLTReport - Selection Criteria290StgSeqNumUse Stage Sequence NumberVarChar10NN=No, Y=Yes