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
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
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

145 columns | Print definition?B1 8.82  | EQUVATSUMF

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ARC4Incoming Payment - Account List - History34EquVatSumFEqualization VAT Amount (FC)Num196
2ARC5Reciept log 25EquVatSumFTotal Equalization Tax (FC)Num196
3PDF4Payment Draft - Account List34EquVatSumFEqualization VAT Amount (FC)Num196
4PDF5PaymentDraft - 25EquVatSumFTotal Equalization Tax (FC)Num196
5PMN5Payment - VAT Adjustment25EquVatSumFTotal Equalization Tax (FC)Num196
6RCC4Incoming Payment - Credit Vouchers34EquVatSumFEqualization VAT Amount (FC)Num196
7RCT4Incoming Payment - Account List34EquVatSumFEqualization VAT Amount (FC)Num196
8RCT5Reciept vat adjustment25EquVatSumFTotal Equalization Tax (FC)Num196
9VPM4Outgoing Payments - Accounts34EquVatSumFEqualization VAT Amount (FC)Num196
10VPM5Outgoing Payments - Vat Adjustment25EquVatSumFEquVatSumFNum196
TOPInventory and Production
11IGE1Goods Issue - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
12IGE13Goods Issue Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
13IGE2Goods Issue - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
14IGE3Goods Issue - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
15IGN1Goods Receipt - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
16IGN13Goods Receipt Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
17IGN2Goods Receipt - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
18IGN3Goods Receipt - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
19OIGEGoods Issue147EquVatSumFTotal Equalization Tax (FC)Num196
20OIGNGoods Receipt147EquVatSumFTotal Equalization Tax (FC)Num196
21OWTQInventory Transfer Request147EquVatSumFTotal Equalization Tax (FC)Num196
22OWTRInventory Transfer147EquVatSumFTotal Equalization Tax (FC)Num196
23WTQ1Inventory Transfer Request - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
24WTQ13Inventory Transfer Request Rows - Distributed Freights30EquVatSumFTotal Equalization Tax (FC)Num196
25WTQ2Inventory Transfer Request - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
26WTQ3Inventory Transfer Request - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
27WTR1Inventory Transfer - Rows119EquVatSumFEqualization Tax Total FCNum196
28WTR13Inventory Transfer Rows - Distributed Freights30EquVatSumFTotal Equalization Tax (FC)Num196
29WTR2Inventory Transfer - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
30WTR3Inventory Transfer - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
TOPMarketing Documents
31ADO1A/R Invoice (Rows) - History119EquVatSumFTotal Equalization Tax (FC)Num196
32ADO13A/R Invoice Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
33ADO2A/R Invoice - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
34ADO3A/R Invoice - Freight - History31EquVatSumFTotal Equalization Tax (FC)Num196
35ADOCInvoice - History147EquVatSumFTotal Equalization Tax (FC)Num196
36CIN1Correction Invoice - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
37CIN13Correction Invoice Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
38CIN2A/R Correction Invoice - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
39CIN3A/R Correction Invoice - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
40CPI1A/P Correction Invoice - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
41CPI13A/P Correction Invoice Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
42CPI2A/P Correction Invoice - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
43CPI3A/P Correction Invoice - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
44CPV1A/P Correction Invoice Reversal - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
45CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
46CPV2A/P Correction Invoice Reversal - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
47CPV3A/P Correction Invoice Reversal - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
48CSI1A/R Correction Invoice - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
49CSI13A/R Correction Invoice Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
50CSI2A/R Corr Inv - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
51CSI3A/R Correction Invoice - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
52CSV1A/R Correction Invoice Reversal - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
53CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
54CSV2A/R Correction Invoice Reversal - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
55CSV3A/R Correction Invoice Reversal - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
56DLN1Delivery - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
57DLN13Delivery Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
58DLN2Delivery Notes - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
59DLN3Delivery Notes - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
60DPI1A/R Down Payment - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
61DPI13A/R Down Payment Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
62DPI2A/R Down Payment - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
63DPI3A/R Down Payment - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
64DPO1A/P Down Payment - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
65DPO13A/P Down Payment Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
66DPO2A/P Down Payment - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
67DPO3A/P Down Payment - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
68DRF1Draft - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
69DRF13Draft Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
70DRF2Draft - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
71DRF3Draft - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
72IEI1Incoming Excise Invoice - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
73IEI13Incoming Excise Invoice Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
74IEI2Incoming Excise Invoice - Freight - History - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
75IEI3IEI - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
76INV1A/R Invoice - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
77INV13A/R Invoice Rows - Distributed Freights30EquVatSumFTotal Equalization Tax (FC)Num196
78INV2A/R Invoice - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
79INV3A/R Invoice - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
80OCINA/R Correction Invoice147EquVatSumFTotal Equalization Tax (FC)Num196
81OCPIA/P Correction Invoice147EquVatSumFTotal Equalization Tax (FC)Num196
82OCPVA/P Correction Invoice Reversal147EquVatSumFTotal Equalization Tax (FC)Num196
83OCSIA/R Correction Invoice147EquVatSumFTotal Equalization Tax (FC)Num196
84OCSVA/R Correction Invoice Reversal147EquVatSumFTotal Equalization Tax (FC)Num196
85ODLNDelivery147EquVatSumFTotal Equalization Tax (FC)Num196
86ODPIA/R Down Payment147EquVatSumFTotal Equalization Tax (FC)Num196
87ODPOA/P Down Payment147EquVatSumFTotal Equalization Tax (FC)Num196
88ODRFDrafts147EquVatSumFTotal Equalization Tax (FC)Num196
89OEI1Outgoing Excise Invoice - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
90OEI13Outgoing Excise Invoice Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
91OEI2OEI - Freight Rows30EquVatSumFTotal Equalization Tax (FC)Num196
92OEI3OEI - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
93OIEIIncoming Excise Invoice147EquVatSumFTotal Equalization Tax (FC)Num196
94OINVA/R Invoice147EquVatSumFTotal Equalization Tax (FC)Num196
95OOEIOutgoing Excise Invoice147EquVatSumFTotal Equalization Tax (FC)Num196
96OPCHA/P Invoice147EquVatSumFTotal Equalization Tax (FC)Num196
97OPDNGoods Receipt PO147EquVatSumFTotal Equalization Tax (FC)Num196
98OPORPurchase Order147EquVatSumFTotal Equalization Tax (FC)Num196
99OPQTPurchase Quotation147EquVatSumFTotal Equalization Tax (FC)Num196
100OQUTSales Quotation147EquVatSumFTotal Equalization Tax (FC)Num196
101ORDNReturns147EquVatSumFTotal Equalization Tax (FC)Num196
102ORDRSales Order147EquVatSumFTotal Equalization Tax (FC)Num196
103ORINA/R Credit Memo147EquVatSumFTotal Equalization Tax (FC)Num196
104ORPCA/P Credit Memo147EquVatSumFTotal Equalization Tax (FC)Num196
105ORPDGoods Return147EquVatSumFTotal Equalization Tax (FC)Num196
106PCH1A/P Invoice - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
107PCH13A/P Invoice Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
108PCH2A/P Invoice - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
109PCH3A/P Invoice - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
110PDN1Goods Receipt PO - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
111PDN13Goods Receipt PO Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
112PDN2Goods Receipt PO - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
113PDN3Goods Receipt PO - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
114POR1Purchase Order - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
115POR13Purchase Order Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
116POR2Purchase Order - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
117POR3Purchase Order - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
118PQT1Purchase Quotation - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
119PQT13Purchase Quotation Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
120PQT2Purchase Quotation - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
121PQT3Purchase Quotation - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
122QUT1Sales Quotation - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
123QUT13Sales Quotation Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
124QUT2Sales Quotation - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
125QUT3Sales Quotation - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
126RDN1Returns - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
127RDN13Returns Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
128RDN2Return - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
129RDN3Return - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
130RDR1Sales Order - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
131RDR13Sales Order Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
132RDR2Sales Order - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
133RDR3Sales Order - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
134RIN1A/R Credit Memo - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
135RIN13A/R Credit Memo Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
136RIN2A/R Credit Memo - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
137RIN3A/R Credit Memo - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
138RPC1A/P Credit Memo - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
139RPC13A/P Credit Memo Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
140RPC2A/P Credit Memo Rows - Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
141RPC3A/P Credit Memo - Freight31EquVatSumFTotal Equalization Tax (FC)Num196
142RPD1Goods Return - Rows119EquVatSumFTotal Equalization Tax (FC)Num196
143RPD13Goods Returns Rows - Distributed Expenses30EquVatSumFTotal Equalization Tax (FC)Num196
144RPD2Goods Return - Freight - Rows30EquVatSumFTotal Equalization Tax (FC)Num196
145RPD3Goods Return - Freight31EquVatSumFTotal Equalization Tax (FC)Num196