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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

138 columns | Print definition?B1 9.3  | LINETYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1OPEXPayment Results Table97LineTypeLine TypeVarChar10GG=General, O=Pay on Account, T=Pay to Account
2PWZ3Payment Wizard - Rows 387LineTypeLine TypeVarChar10GG=General, O=Pay on Account, T=Pay to Account
3PWZ4Payment Wizard - Rows 416LineTypeLine TypeVarChar10G
4PWZ5Payment Wizard - Rows 514LineTypeLine TypeVarChar10G
TOPFinance
5AJD1Journal Entry - History - Rows58LineTypeLineTypeInt1100
6BTF1Journal Voucher - Rows58LineTypeLineTypeInt1100
7JDT1Journal Entry - Rows58LineTypeLine TypeInt1100
TOPGeneral
8CIN11Correction Invoice - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
9LGL1Legal Data - Rows3LineTypeLine TypeVarChar10RR=Tax Per Line, T=Document Total, V=Total Tax
TOPInventory and Production
10IGE1Goods Issue - Rows135LineTypeRow TypeVarChar10RM=Resource, R=Item
11IGE10Goods Issue - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
12IGE11Goods Issue - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
13IGE15Gds Issue - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
14IGN1Goods Receipt - Rows135LineTypeRow TypeVarChar10RR=Regular
15IGN10Goods Receipt - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
16IGN11Goods Receipt - Drawn Dpm Det37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
17IGN15Gds Rcpt - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
18WTQ1Inventory Transfer Request - Rows135LineTypeRow TypeVarChar10RR=Regular
19WTQ10Inventory Transfer Request - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
20WTQ11Inv. Transfer Request - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
21WTQ15Inv. Transfer Request - Drawn Dpm Appl58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
22WTR1Inventory Transfer - Rows135LineTypeLine TypeVarChar10RR=Regular
23WTR10Inventory Transfer - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
24WTR11Inv. Transfer - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
25WTR15Inv. Transfer - Drawn Dpm Appl58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
TOPMarketing Documents
26ADO1A/R Invoice (Rows) - History135LineTypeLine TypeVarChar10RM=Resource, R=Regular
27ADO10A/R Invoice - Row Structure - History5LineTypeRow TypeVarChar10S=Subtotal, T=Text
28ADO11A/R Inv (Drawn Dpm Det) - Hist37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
29ADO15A/R Inv (Drawn Dpm Applied) - Hist58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
30CIN1Correction Invoice - Rows135LineTypeLine TypeVarChar10RR=Regular
31CIN10Correction Invoice - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
32CPI1A/P Correction Invoice - Rows135LineTypeRow TypeVarChar10RR=Regular
33CPI10A/P Correction Invoice - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
34CPI11A/P Corr. Inv - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
35CPI15A/P Corr Inv - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
36CPV1A/P Correction Invoice Reversal - Rows135LineTypeRow TypeVarChar10RR=Regular
37CPV10A/P CrIn Rev - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
38CPV11A/P CrIn Rev - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
39CPV15A/P CrIn Rev - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
40CSI1A/R Correction Invoice - Rows135LineTypeRow TypeVarChar10RR=Regular
41CSI10A/R Correction Invoice - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
42CSI11A/R Corr. Inv. - Drawn Dpm Det37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
43CSI15A/R Corr Inv - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
44CSV1A/R Correction Invoice Reversal - Rows135LineTypeRow TypeVarChar10RR=Regular
45CSV10A/R Correction Invoice Reversal - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
46CSV11A/R CrIn Rev - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
47CSV15A/R CrIn Rev - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
48DLN1Delivery - Rows135LineTypeRow TypeVarChar10RR=Regular
49DLN10Delivery - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
50DLN11Delivery - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
51DLN15Delivery - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
52DPI1A/R Down Payment - Rows135LineTypeRow TypeVarChar10RR=Regular
53DPI10A/R Down Payment - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
54DPI11A/R DP - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
55DPI15A/R DP - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
56DPO1A/P Down Payment - Rows135LineTypeRow TypeVarChar10RR=Regular
57DPO10A/P Down Payment - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
58DPO11A/P DP - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
59DPO15A/P DP - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
60DRF1Draft - Rows135LineTypeRow TypeVarChar10RA=Alternative, M=Resource, R=Regular
61DRF10Draft - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
62DRF11Draft - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
63DRF15Draft - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
64GPA1Gross Profit Adjustment - Documents44LineTypeWizard Line TypeVarChar10NC=Chained, I=Non Based Correction Invoice, N=Normal
65GPA4Gross Profit Adjustment - JE Details Accounts3LineTypeLine TypeVarChar10TA=Account, T=Total
66IEI1Incoming Excise Invoice - Rows135LineTypeRow TypeVarChar10RR=Regular
67IEI10Incoming Excise Invoice - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
68IEI11IEI - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
69IEI15IEI - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
70INV1A/R Invoice - Rows135LineTypeRow TypeVarChar10RR=Regular
71INV10A/R Invoice - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
72INV11A/R Invoice - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
73INV15A/R Inv. - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
74OEI1Outgoing Excise Invoice - Rows135LineTypeRow TypeVarChar10RR=Regular
75OEI10Outgoing Excise Invoice - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
76OEI11OEI - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
77OEI15OEI - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
78PCH1A/P Invoice - Rows135LineTypeRow TypeVarChar10RR=Regular
79PCH10A/P Invoice - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
80PCH11A/P Invoice - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
81PCH15A/P Invoice - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
82PDN1Goods Receipt PO - Rows135LineTypeRow TypeVarChar10RR=Regular
83PDN10Goods Receipt PO - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
84PDN11GRPO - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
85PDN15GRPO - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
86POR1Purchase Order - Rows135LineTypeRow TypeVarChar10RR=Regular
87POR10Purchase Order - Row structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
88POR11PO - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
89POR15PO - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
90PQT1Purchase Quotation - Rows135LineTypeRow TypeVarChar10RR=Regular
91PQT10Purchase Quotation - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
92PQT11PQ - Drawn DPM Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
93PQT15PQ - Drawn DPM Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
94PRQ1Purchase Request - Rows135LineTypeRow TypeVarChar10RR=Regular
95PRQ10Purchase Request - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
96PRQ11PR - Drawn DPM Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
97PRQ15PR - Drawn DPM Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
98PRR1A/P Return Request - Rows135LineTypeRow TypeVarChar10RR=Regular
99PRR10A/P Return Request - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
100PRR11A/P Return Request - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
101PRR15A/P Return Request - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
102QUT1Sales Quotation - Rows135LineTypeRow TypeVarChar10RA=Alternative, R=Regular
103QUT10Sales Quotation - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
104QUT11Sls Quote - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
105QUT15Sls Quote - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
106RDN1Returns - Rows135LineTypeLine TypeVarChar10RR=Regular
107RDN10Returns - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
108RDN11Returns - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
109RDN15Returns - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
110RDR1Sales Order - Rows135LineTypeRow TypeVarChar10RR=Regular
111RDR10Sales Order - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
112RDR11Sls Ord. - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
113RDR15Sls Ord. - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
114RIN1A/R Credit Memo - Rows135LineTypeRow TypeVarChar10RR=Regular
115RIN10A/R Credit Memo - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
116RIN11A/R Cr. Memo - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
117RIN15A/R Cr. Memo - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
118RPC1A/P Credit Memo - Rows135LineTypeRow TypeVarChar10RR=Regular
119RPC10A/P Credit Memo - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
120RPC11A/P Cr. Memo - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
121RPC15A/P Cr. Memo - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
122RPD1Goods Return - Rows135LineTypeRow TypeVarChar10RR=Regular
123RPD10Goods Return - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
124RPD11Gds Return - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
125RPD15Gds Return - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
126RRR1A/R Return Request - Rows135LineTypeRow TypeVarChar10RR=Regular
127RRR10A/R Return Request - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
128RRR11A/R Return Request - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
129RRR15A/R Return Request - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
130SFC1Self Credit Memo - Rows135LineTypeRow TypeVarChar10RR=Regular
131SFC10Self Credit Memo - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
132SFC11Self Credit Memo - Drawn Down Payment Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
133SFC15Self Credit Memo - Drawn Down Payment Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
134SFI1Self Invoice - Rows135LineTypeRow TypeVarChar10RR=Regular
135SFI10Self Invoice - Row Structure5LineTypeRow TypeVarChar10S=Subtotal, T=Text
136SFI11Self Invoice - Drawn Down Payment Detail37LineTypeLine TypeVarChar10DD=Document Row, H=Down Payment Document Rounding, R=Currency Rounding
137SFI15Self Invoice - Drawn Down Payment Applied58LineTypeRow TypeVarChar10DD=Document, H=Document Header Rounding, R=Exchange Rate Rounding
138VRT2Tax Invoice Report Grid Info14LineTypeRow TypeInt110