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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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

163 columns | Print definition?B1 8.8  | BASETYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPFinance
1AWHTWithholding Tax6BaseTypeBase TypeVarChar10NG=Gross, N=Net, V=VAT
2JST1TDS Adjustment - Rows20BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
3OWHTWithholding Tax6BaseTypeBase TypeVarChar10NG=Gross, N=Net, V=VAT
TOPInventory and Production
4IGE1Goods Issue - Rows6BaseTypeBase Document TypeInt110-1202=Production Order
5IGE11Goods Issue - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
6IGE3Goods Issue - Freight41BaseTypeBase Document TypeInt110-1202=Production Order
7IGE4Goods Issue - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
8IGE5Goods Issue - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
9IGN1Goods Receipt - Rows6BaseTypeBase Document TypeInt110-1202=Production Order
10IGN11Goods Receipt - Drawn Dpm Det5BaseTypeBase Object TypeInt110-1
11IGN3Goods Receipt - Freight41BaseTypeBase Document TypeInt110-1202=Production Order
12IGN4Goods Receipt - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
13IGN5Goods Receipt - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
14IPF1Landed Costs - Rows3BaseTypeBase Document TypeInt110-120=Goods Receipt PO, 69=Landed Costs
15OAIMArchive Inventory Message12BaseTypeBase Transaction TypeInt110-113=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat
16OIBTBatch No. for Item13BaseTypeBase Doc. TypeInt110
17OILMInventory Log Message13BaseTypeBase Transaction TypeInt110-113=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat
18OIMTTemplates for Inventory JE3BaseTypeBase Transaction TypeInt60-1
19OITLInventory Transactions Log12BaseTypeBase Document TypeInt110-113=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat
20OSRISerial Numbers for Items15BaseTypeBase Doc. TypeInt110
21UILMIVI Inventory Log Message13BaseTypeBase Transaction TypeInt110-113=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat
22WTR1Inventory Transfer - Rows6BaseTypeBase Document TypeInt110-120=Purchase Delivery Notes, 59=Inventory General Entry, 67=Warehouses Transfers
23WTR11Inv. Transfer - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
24WTR3Inventory Transfer - Freight41BaseTypeBase Document TypeInt110-120=Goods Receipt PO, 59=Goods Receipt, 67=Inventory Transfer
25WTR4Inventory Transfer - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
26WTR5Inventory Transfer - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
TOPMarketing Documents
27ADO1A/R Invoice (Rows) - History6BaseTypeBase Document TypeInt110-113=Invoices, 15=Delivery notes, 16=A/R Returns, 17=Sales Order, 18=Purchases, 20=Purchase Delivery Notes, 21=Revert Purchase Delivery Notes, 22=Purchase orders, 23=Sales Quotation
28ADO11A/R Inv (Drawn Dpm Det) - Hist5BaseTypeBase Object TypeInt110-1
29ADO13A/R Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
30ADO3A/R Invoice - Freight - History41BaseTypeBase Document TypeInt110-113=Invoices, 15=Delivery Notes, 16=Revert Delivery Notes, 17=Orders, 18=Purchases, 20=Purchase Delivery Notes, 21=Revert Purchase Delivery Notes, 22=Purchase Orders, 23=Quotations
31ADO4Documents - Tax - History25BaseTypeBase Document TypeInt110-1
32ADO5Withholding Tax - History18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
33AJD2Withholding Tax - History18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
34BTF2Journal Voucher Withholding Tax - History18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
35CIN1Correction Invoice - Rows6BaseTypeBase Document TypeInt110-116=A/R Returns, 17=Sales Order, 23=Sales Quotation
36CIN13Correction Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
37CIN3A/R Correction Invoice - Freight41BaseTypeBase Document TypeInt110-116=A/R Returns, 17=Sales Order, 23=Sales Quotation
38CIN4Correction Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
39CIN5AR Correction Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
40CPI1A/P Correction Invoice - Rows6BaseTypeBase Document TypeInt110-1163=A/P Correction Invoice, 18=A/P Invoice
41CPI11A/P Corr. Inv - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
42CPI13A/P Correction Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
43CPI3A/P Correction Invoice - Freight41BaseTypeBase Document TypeInt110163=A/P Correction Invoice, 18=A/P Invoice
44CPI4A/P Correction Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
45CPI5Withholding Tax Data18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
46CPV1A/P Correction Invoice Reversal - Rows6BaseTypeBase Document TypeInt110-1163=A/P Correction Invoice
47CPV11A/P CrIn Rev - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
48CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
49CPV3A/P Correction Invoice Reversal - Freight41BaseTypeBase Document TypeInt110163=A/P Correction Invoice
50CPV4A/P Correction Invoice Reversal - Tax Amt per Doc.25BaseTypeBase Document TypeInt110-1
51CPV5A/P Correction Invoice Reversal - WTax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
52CSI1A/R Correction Invoice - Rows6BaseTypeBase Document TypeInt110-113=A/R Invoice, 165=A/R Correction Invoice
53CSI11A/R Corr. Inv. - Drawn Dpm Det5BaseTypeBase Object TypeInt110-1
54CSI13A/R Correction Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
55CSI3A/R Correction Invoice - Freight41BaseTypeBase Document TypeInt11013=A/R Invoice, 165=A/R Correction Invoice
56CSI4A/R Correction Invoice - Tax Amount Per Document25BaseTypeBase Document TypeInt110-1
57CSI5A/R Correction Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
58CSV1A/R Correction Invoice Reversal - Rows6BaseTypeBase Document TypeInt110-1165=A/R Correction Invoice
59CSV11A/R CrIn Rev - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
60CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
61CSV3A/R Correction Invoice Reversal - Freight41BaseTypeBase Document TypeInt110165=A/R Correction Invoice
62CSV4A/R Correction Invoice Reversal - Tax Amount Per Document25BaseTypeBase Document TypeInt110-1
63CSV5A/R Correction Invoice Reversal - WTax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
64DLN1Delivery - Rows6BaseTypeBase Document TypeInt110-113=A/R Invoice, 165=A/R Correction Invoice, 16=A/R Returns, 17=Sales Order, 23=Sales Quotation
65DLN11Delivery - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
66DLN13Delivery Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
67DLN3Delivery Notes - Freight41BaseTypeBase Document TypeInt110-113=A/R Invoice, 16=A/R Returns, 17=Sales Order, 23=Sales Quotation
68DLN4Delivery - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
69DLN5Delivery - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
70DPI1A/R Down Payment - Rows6BaseTypeBase Document TypeInt110-115=Delivery, 17=Sales Order, 203=A/R Down Payment, 23=Quotation
71DPI11A/R DP - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
72DPI13A/R Down Payment Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
73DPI3A/R Down Payment - Freight41BaseTypeBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
74DPI4A/R Down Payment - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
75DPI5A/R Down Payment - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
76DPO1A/P Down Payment - Rows6BaseTypeBase Document TypeInt110-1204=A/P Down Payment, 20=Goods Receipt PO, 22=Purchase Order
77DPO11A/P DP - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
78DPO13A/P Down Payment Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
79DPO3A/P Down Payment - Freight41BaseTypeBase Document TypeInt110-120=Goods Receipt PO, 22=Purchase orders
80DPO4A/P Down Payment - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
81DPO5A/P Down Payment - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
82DRF1Draft - Rows6BaseTypeBase Document TypeInt110-1132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 16=Returns, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 67=Inventory Transfers
83DRF11Draft - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
84DRF13Draft Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
85DRF3Draft - Freight41BaseTypeBase Document TypeInt11013=A/R Invoice, 15=Delivery notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Good Receipt PO, 21=Goods Return, 22=Purchase order, 23=Sales Quotation
86DRF4Draft Documents - Tax25BaseTypeBase Document TypeInt110-1
87DRF5Draft Documents - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
88IEI1Incoming Excise Invoice - Rows6BaseTypeBase Document TypeInt110-1140000009=Outgoing Excise Invoice, 14=A/R Credit Memo, 16=A/R Returns, 20=Goods Receipt PO
89IEI11IEI - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
90IEI13Incoming Excise Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
91IEI3IEI - Freight41BaseTypeBase Document TypeInt110-1
92IEI4Incoming Excise Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
93IEI5Incoming Excise Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
94IGE13Goods Issue Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
95IGN13Goods Receipt Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
96INV1A/R Invoice - Rows6BaseTypeBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
97INV11A/R Invoice - Drawn Dpm Detail5BaseTypeBase Object TypeInt110203203=A/R Down Payment
98INV13A/R Invoice Rows - Distributed Freights41BaseTypeBase Document TypeInt110
99INV3A/R Invoice - Freight41BaseTypeBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
100INV4A/R Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
101INV5A/R Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
102JDT2Withholding Tax - History18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
103OEI1Outgoing Excise Invoice - Rows6BaseTypeBase Document TypeInt110-115=Delivery, 19=A/P Credit Memo, 21=Goods Return, 67=Inventory Transfers
104OEI11OEI - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
105OEI13Outgoing Excise Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
106OEI3OEI - Freight41BaseTypeBase Document TypeInt110-1
107OEI4Outgoing Excise Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
108OEI5Outgoing Excise Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
109PCH1A/P Invoice - Rows6BaseTypeBase Document TypeInt110-120=Goods Receipt PO, 22=Purchase Orders
110PCH11A/P Invoice - Drawn Dpm Det.5BaseTypeBase Object TypeInt110204204=A/P Down Payment
111PCH13A/P Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
112PCH3A/P Invoice - Freight41BaseTypeBase Document TypeInt110-120=Goods Receipt PO, 22=Purchase orders
113PCH4A/P Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
114PCH5A/P Invoice - Withholding Tax Data18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
115PDN1Goods Receipt PO - Rows6BaseTypeBase Document TypeInt110-1163=A/P Correction Invoice, 18=A/P Invoice, 21=Goods Return, 22=Purchase Orders
116PDN11GRPO - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
117PDN13Goods Receipt PO Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
118PDN3Goods Receipt PO - Freight41BaseTypeBase Document TypeInt110-118=A/P Invoice, 21=Goods Return, 22=Purchase orders
119PDN4Goods Receipt PO - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
120PDN5Goods Reciept PO - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
121POR1Purchase Order - Rows6BaseTypeBase Document TypeInt110-117=Sales Order, 22=Purchase Orders
122POR11PO - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
123POR13Purchase Order Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
124POR3Purchase Order - Freight41BaseTypeBase Document TypeInt110-117=Sales Order
125POR4Purchase Order - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
126POR5Purchase Order - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
127QUT1Sales Quotation - Rows6BaseTypeBase Document TypeInt110-1
128QUT11Sls Quote - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
129QUT13Sales Quotation Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
130QUT3Sales Quotation - Freight41BaseTypeBase Document TypeInt110-1
131QUT4Sales Quotation - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
132QUT5Sales Quotation - Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
133RDN1Returns - Rows6BaseTypeBase Document TypeInt110-115=A/R Delivery Note
134RDN11Returns - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
135RDN13Returns Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
136RDN3Return - Freight41BaseTypeBase Document TypeInt110-115=Delivery
137RDN4Returns - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
138RDN5Returns - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
139RDR1Sales Order - Rows6BaseTypeBase Document TypeInt110-123=Sales Quotation
140RDR11Sls Ord. - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
141RDR13Sales Order Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
142RDR3Sales Order - Freight41BaseTypeBase Document TypeInt110-123=Sales Quotation
143RDR4Sales Order - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
144RDR5Sales Order - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
145RIN1A/R Credit Memo - Rows6BaseTypeBase Document TypeInt110-113=A/R Invoice, 16=A/R Returns, 203=A/R Down Payment
146RIN11A/R Cr. Memo - Drawn Dpm Det.5BaseTypeBase Object TypeInt110203203=A/R Down Payment
147RIN13A/R Credit Memo Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
148RIN3A/R Credit Memo - Freight41BaseTypeBase Document TypeInt110-113=A/R Invoice, 16=A/R Returns, 203=A/R Down Payment
149RIN4A/R Credit Memo - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
150RIN5A/R Credit Memo - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
151RPC1A/P Credit Memo - Rows6BaseTypeBase Document TypeInt110-118=A/P Invoice, 204=A/P Down Payment, 21=Goods Return
152RPC11A/P Cr. Memo - Drawn Dpm Det.5BaseTypeBase Object TypeInt110204204=A/P Down Payment
153RPC13A/P Credit Memo Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
154RPC3A/P Credit Memo - Freight41BaseTypeBase Document TypeInt110-118=A/P Invoice, 204=A/P Down Payment, 21=Goods Return
155RPC4A/P Credit Memo - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
156RPC5A/P Credit Memo - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
157RPD1Goods Return - Rows6BaseTypeBase Document TypeInt110-120=Purchase Delivery Notes
158RPD11Gds Return - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
159RPD13Goods Returns Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
160RPD3Goods Return - Freight41BaseTypeBase Document TypeInt110-120=Purchase Delivery Notes
161RPD4Goods Return - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
162RPD5Goods Return - Withholding Tax Data18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
163WTR13Inventory Transfer Rows - Distributed Freights41BaseTypeBase Document TypeInt110