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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
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
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

144 columns | Print definition?B1 8.82  | LINETOTAL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPInventory and Production
1AMR1Inventory Revaluation - History - Rows7LineTotalRow TotalNum196
2AMR2Inventory Revaluation FIFO Rows (Archive)6LineTotalRow TotalNum196
3ENT1Entry - Rows12LineTotalRow TotalNum196
4IGE1Goods Issue - Rows19LineTotalRow TotalNum196
5IGE11Goods Issue - Drawn Dpm Detail8LineTotalNet LCNum196
6IGE13Goods Issue Rows - Distributed Expenses5LineTotalTotalNum196
7IGE2Goods Issue - Freight - Rows5LineTotalTotalNum196
8IGE3Goods Issue - Freight3LineTotalTotalNum196
9IGN1Goods Receipt - Rows19LineTotalRow TotalNum196
10IGN11Goods Receipt - Drawn Dpm Det8LineTotalNet LCNum196
11IGN13Goods Receipt Rows - Distributed Expenses5LineTotalTotalNum196
12IGN2Goods Receipt - Freight - Rows5LineTotalTotalNum196
13IGN3Goods Receipt - Freight3LineTotalTotalNum196
14IPF1Landed Costs - Rows17LineTotalRow TotalNum196
15MRV1Inventory Revaluation Information Array7LineTotalRow TotalNum196
16MRV2Inventory Revaluation FIFO Rows6LineTotalRow TotalNum196
17WTQ1Inventory Transfer Request - Rows19LineTotalRow TotalNum196
18WTQ11Inv. Transfer Request - Drawn Dpm Det.8LineTotalNet LCNum196
19WTQ13Inventory Transfer Request Rows - Distributed Freights5LineTotalTotalNum196
20WTQ2Inventory Transfer Request - Freight - Rows5LineTotalTotalNum196
21WTQ3Inventory Transfer Request - Freight3LineTotalTotalNum196
22WTR1Inventory Transfer - Rows19LineTotalRow TotalNum196
23WTR11Inv. Transfer - Drawn Dpm Det.8LineTotalNet LCNum196
24WTR13Inventory Transfer Rows - Distributed Freights5LineTotalTotalNum196
25WTR2Inventory Transfer - Freight - Rows5LineTotalTotalNum196
26WTR3Inventory Transfer - Freight3LineTotalTotalNum196
TOPMarketing Documents
27ADO1A/R Invoice (Rows) - History19LineTotalTotal RowNum196
28ADO11A/R Inv (Drawn Dpm Det) - Hist8LineTotalNet LCNum196
29ADO13A/R Invoice Rows - Distributed Expenses5LineTotalTotalNum196
30ADO2A/R Invoice - Freight - Rows5LineTotalTotalNum196
31ADO3A/R Invoice - Freight - History3LineTotalTotalNum196
32CIN1Correction Invoice - Rows19LineTotalRow TotalNum196
33CIN13Correction Invoice Rows - Distributed Expenses5LineTotalTotalNum196
34CIN2A/R Correction Invoice - Freight - Rows5LineTotalTotalNum196
35CIN3A/R Correction Invoice - Freight3LineTotalTotalNum196
36CPI1A/P Correction Invoice - Rows19LineTotalRow TotalNum196
37CPI11A/P Corr. Inv - Drawn Dpm Det.8LineTotalNet LCNum196
38CPI13A/P Correction Invoice Rows - Distributed Expenses5LineTotalTotalNum196
39CPI2A/P Correction Invoice - Freight - Rows5LineTotalTotalNum196
40CPI3A/P Correction Invoice - Freight3LineTotalTotalNum196
41CPV1A/P Correction Invoice Reversal - Rows19LineTotalRow TotalNum196
42CPV11A/P CrIn Rev - Drawn Dpm Det.8LineTotalNet LCNum196
43CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses5LineTotalTotalNum196
44CPV2A/P Correction Invoice Reversal - Freight - Rows5LineTotalTotalNum196
45CPV3A/P Correction Invoice Reversal - Freight3LineTotalTotalNum196
46CSI1A/R Correction Invoice - Rows19LineTotalRow TotalNum196
47CSI11A/R Corr. Inv. - Drawn Dpm Det8LineTotalNet LCNum196
48CSI13A/R Correction Invoice Rows - Distributed Expenses5LineTotalTotalNum196
49CSI2A/R Corr Inv - Freight - Rows5LineTotalTotalNum196
50CSI3A/R Correction Invoice - Freight3LineTotalTotalNum196
51CSV1A/R Correction Invoice Reversal - Rows19LineTotalRow TotalNum196
52CSV11A/R CrIn Rev - Drawn Dpm Det.8LineTotalNet LCNum196
53CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses5LineTotalTotalNum196
54CSV2A/R Correction Invoice Reversal - Freight - Rows5LineTotalTotalNum196
55CSV3A/R Correction Invoice Reversal - Freight3LineTotalTotalNum196
56DLN1Delivery - Rows19LineTotalRow TotalNum196
57DLN11Delivery - Drawn Dpm Detail8LineTotalNet LCNum196
58DLN13Delivery Rows - Distributed Expenses5LineTotalTotalNum196
59DLN2Delivery Notes - Freight - Rows5LineTotalTotalNum196
60DLN3Delivery Notes - Freight3LineTotalTotalNum196
61DPI1A/R Down Payment - Rows19LineTotalRow TotalNum196
62DPI11A/R DP - Drawn Dpm Detail8LineTotalNet LCNum196
63DPI13A/R Down Payment Rows - Distributed Expenses5LineTotalTotalNum196
64DPI2A/R Down Payment - Freight - Rows5LineTotalTotalNum196
65DPI3A/R Down Payment - Freight3LineTotalTotalNum196
66DPO1A/P Down Payment - Rows19LineTotalRow TotalNum196
67DPO11A/P DP - Drawn Dpm Detail8LineTotalNet LCNum196
68DPO13A/P Down Payment Rows - Distributed Expenses5LineTotalTotalNum196
69DPO2A/P Down Payment - Freight - Rows5LineTotalTotalNum196
70DPO3A/P Down Payment - Freight3LineTotalTotalNum196
71DRF1Draft - Rows19LineTotalRow TotalNum196
72DRF11Draft - Drawn Dpm Detail8LineTotalNet LCNum196
73DRF13Draft Rows - Distributed Expenses5LineTotalTotalNum196
74DRF2Draft - Freight - Rows5LineTotalTotalNum196
75DRF3Draft - Freight3LineTotalTotalNum196
76IEI1Incoming Excise Invoice - Rows19LineTotalRow TotalNum196
77IEI11IEI - Drawn Dpm Detail8LineTotalNet LCNum196
78IEI13Incoming Excise Invoice Rows - Distributed Expenses5LineTotalTotalNum196
79IEI2Incoming Excise Invoice - Freight - History - Rows5LineTotalTotalNum196
80IEI3IEI - Freight3LineTotalTotalNum196
81INV1A/R Invoice - Rows19LineTotalRow TotalNum196
82INV11A/R Invoice - Drawn Dpm Detail8LineTotalNet LCNum196
83INV13A/R Invoice Rows - Distributed Freights5LineTotalTotalNum196
84INV2A/R Invoice - Freight - Rows5LineTotalTotalNum196
85INV3A/R Invoice - Freight3LineTotalTotalNum196
86MIN2Item Imformation of MI15LineTotalRow TotalNum196
87MIV2A/P Monthly Invoice - Item15LineTotalGross TotalNum196
88OEI1Outgoing Excise Invoice - Rows19LineTotalRow TotalNum196
89OEI11OEI - Drawn Dpm Detail8LineTotalNet LCNum196
90OEI13Outgoing Excise Invoice Rows - Distributed Expenses5LineTotalTotalNum196
91OEI2OEI - Freight Rows5LineTotalTotalNum196
92OEI3OEI - Freight3LineTotalTotalNum196
93PCH1A/P Invoice - Rows19LineTotalRow TotalNum196
94PCH11A/P Invoice - Drawn Dpm Det.8LineTotalNet LCNum196
95PCH13A/P Invoice Rows - Distributed Expenses5LineTotalTotalNum196
96PCH2A/P Invoice - Freight - Rows5LineTotalTotalNum196
97PCH3A/P Invoice - Freight3LineTotalTotalNum196
98PDN1Goods Receipt PO - Rows19LineTotalRow TotalNum196
99PDN11GRPO - Drawn Dpm Detail8LineTotalNet LCNum196
100PDN13Goods Receipt PO Rows - Distributed Expenses5LineTotalTotalNum196
101PDN2Goods Receipt PO - Freight - Rows5LineTotalTotalNum196
102PDN3Goods Receipt PO - Freight3LineTotalTotalNum196
103POR1Purchase Order - Rows19LineTotalRow TotalNum196
104POR11PO - Drawn Dpm Detail8LineTotalNet LCNum196
105POR13Purchase Order Rows - Distributed Expenses5LineTotalTotalNum196
106POR2Purchase Order - Freight - Rows5LineTotalTotalNum196
107POR3Purchase Order - Freight3LineTotalTotalNum196
108PQT1Purchase Quotation - Rows19LineTotalRow TotalNum196
109PQT11PQ - Drawn DPM Detail8LineTotalNet LCNum196
110PQT13Purchase Quotation Rows - Distributed Expenses5LineTotalTotalNum196
111PQT2Purchase Quotation - Freight - Rows5LineTotalTotalNum196
112PQT3Purchase Quotation - Freight3LineTotalTotalNum196
113QUT1Sales Quotation - Rows19LineTotalRow TotalNum196
114QUT11Sls Quote - Drawn Dpm Detail8LineTotalNet LCNum196
115QUT13Sales Quotation Rows - Distributed Expenses5LineTotalTotalNum196
116QUT2Sales Quotation - Freight - Rows5LineTotalTotalNum196
117QUT3Sales Quotation - Freight3LineTotalTotalNum196
118RDN1Returns - Rows19LineTotalRow TotalNum196
119RDN11Returns - Drawn Dpm Detail8LineTotalNet LCNum196
120RDN13Returns Rows - Distributed Expenses5LineTotalTotalNum196
121RDN2Return - Freight - Rows5LineTotalTotalNum196
122RDN3Return - Freight3LineTotalTotalNum196
123RDR1Sales Order - Rows19LineTotalRow TotalNum196
124RDR11Sls Ord. - Drawn Dpm Detail8LineTotalNet LCNum196
125RDR13Sales Order Rows - Distributed Expenses5LineTotalTotalNum196
126RDR2Sales Order - Freight - Rows5LineTotalTotalNum196
127RDR3Sales Order - Freight3LineTotalTotalNum196
128RIN1A/R Credit Memo - Rows19LineTotalRow TotalNum196
129RIN11A/R Cr. Memo - Drawn Dpm Det.8LineTotalNet LCNum196
130RIN13A/R Credit Memo Rows - Distributed Expenses5LineTotalTotalNum196
131RIN2A/R Credit Memo - Freight - Rows5LineTotalTotalNum196
132RIN3A/R Credit Memo - Freight3LineTotalTotalNum196
133RPC1A/P Credit Memo - Rows19LineTotalRow TotalNum196
134RPC11A/P Cr. Memo - Drawn Dpm Det.8LineTotalNet LCNum196
135RPC13A/P Credit Memo Rows - Distributed Expenses5LineTotalTotalNum196
136RPC2A/P Credit Memo Rows - Expenses5LineTotalTotalNum196
137RPC3A/P Credit Memo - Freight3LineTotalTotalNum196
138RPD1Goods Return - Rows19LineTotalRow TotalNum196
139RPD11Gds Return - Drawn Dpm Detail8LineTotalNet LCNum196
140RPD13Goods Returns Rows - Distributed Expenses5LineTotalTotalNum196
141RPD2Goods Return - Freight - Rows5LineTotalTotalNum196
142RPD3Goods Return - Freight3LineTotalTotalNum196
143SAL1Salida - Rows12LineTotalRow TotalNum196
144TRA1Transition - Rows12LineTotalRow TotalNum196