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

122 columns | Print definition?B1 9.2  | 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, R=Currency Rounding, H=Down Payment Document Rounding
9LGL1Legal Data - Rows3LineTypeLine TypeVarChar10RT=Document Total, R=Tax Per Line, V=Total Tax
TOPInventory and Production
10IGE1Goods Issue - Rows135LineTypeRow TypeVarChar10RR=Item, M=Resource
11IGE10Goods Issue - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
12IGE11Goods Issue - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
13IGE15Gds Issue - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
14IGN1Goods Receipt - Rows135LineTypeRow TypeVarChar10RR=Regular
15IGN10Goods Receipt - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
16IGN11Goods Receipt - Drawn Dpm Det37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
17IGN15Gds Rcpt - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
18WTQ1Inventory Transfer Request - Rows135LineTypeRow TypeVarChar10RR=Regular
19WTQ10Inventory Transfer Request - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
20WTQ11Inv. Transfer Request - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
21WTQ15Inv. Transfer Request - Drawn Dpm Appl58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
22WTR1Inventory Transfer - Rows135LineTypeLine TypeVarChar10RR=Regular
23WTR10Inventory Transfer - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
24WTR11Inv. Transfer - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
25WTR15Inv. Transfer - Drawn Dpm Appl58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
TOPMarketing Documents
26ADO1A/R Invoice (Rows) - History135LineTypeLine TypeVarChar10RR=Regular, M=Resource
27ADO10A/R Invoice - Row Structure - History5LineTypeRow TypeVarChar10T=Text, S=Subtotal
28ADO11A/R Inv (Drawn Dpm Det) - Hist37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
29ADO15A/R Inv (Drawn Dpm Applied) - Hist58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
30CIN1Correction Invoice - Rows135LineTypeLine TypeVarChar10RR=Regular
31CIN10Correction Invoice - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
32CPI1A/P Correction Invoice - Rows135LineTypeRow TypeVarChar10RR=Regular
33CPI10A/P Correction Invoice - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
34CPI11A/P Corr. Inv - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
35CPI15A/P Corr Inv - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
36CPV1A/P Correction Invoice Reversal - Rows135LineTypeRow TypeVarChar10RR=Regular
37CPV10A/P CrIn Rev - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
38CPV11A/P CrIn Rev - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
39CPV15A/P CrIn Rev - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
40CSI1A/R Correction Invoice - Rows135LineTypeRow TypeVarChar10RR=Regular
41CSI10A/R Correction Invoice - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
42CSI11A/R Corr. Inv. - Drawn Dpm Det37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
43CSI15A/R Corr Inv - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
44CSV1A/R Correction Invoice Reversal - Rows135LineTypeRow TypeVarChar10RR=Regular
45CSV10A/R Correction Invoice Reversal - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
46CSV11A/R CrIn Rev - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
47CSV15A/R CrIn Rev - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
48DLN1Delivery - Rows135LineTypeRow TypeVarChar10RR=Regular
49DLN10Delivery - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
50DLN11Delivery - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
51DLN15Delivery - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
52DPI1A/R Down Payment - Rows135LineTypeRow TypeVarChar10RR=Regular
53DPI10A/R Down Payment - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
54DPI11A/R DP - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
55DPI15A/R DP - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
56DPO1A/P Down Payment - Rows135LineTypeRow TypeVarChar10RR=Regular
57DPO10A/P Down Payment - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
58DPO11A/P DP - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
59DPO15A/P DP - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
60DRF1Draft - Rows135LineTypeRow TypeVarChar10RR=Regular, A=Alternative, M=Resource
61DRF10Draft - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
62DRF11Draft - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
63DRF15Draft - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
64GPA1Gross Profit Adjustment - Documents44LineTypeWizard Line TypeVarChar10NN=Normal, C=Chained, I=Non Based Correction Invoice
65GPA4Gross Profit Adjustment - JE Details Accounts3LineTypeLine TypeVarChar10TT=Total, A=Account
66IEI1Incoming Excise Invoice - Rows135LineTypeRow TypeVarChar10RR=Regular
67IEI10Incoming Excise Invoice - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
68IEI11IEI - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
69IEI15IEI - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
70INV1A/R Invoice - Rows135LineTypeRow TypeVarChar10RR=Regular
71INV10A/R Invoice - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
72INV11A/R Invoice - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
73INV15A/R Inv. - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
74OEI1Outgoing Excise Invoice - Rows135LineTypeRow TypeVarChar10RR=Regular
75OEI10Outgoing Excise Invoice - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
76OEI11OEI - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
77OEI15OEI - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
78PCH1A/P Invoice - Rows135LineTypeRow TypeVarChar10RR=Regular
79PCH10A/P Invoice - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
80PCH11A/P Invoice - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
81PCH15A/P Invoice - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
82PDN1Goods Receipt PO - Rows135LineTypeRow TypeVarChar10RR=Regular
83PDN10Goods Receipt PO - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
84PDN11GRPO - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
85PDN15GRPO - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
86POR1Purchase Order - Rows135LineTypeRow TypeVarChar10RR=Regular
87POR10Purchase Order - Row structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
88POR11PO - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
89POR15PO - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
90PQT1Purchase Quotation - Rows135LineTypeRow TypeVarChar10RR=Regular
91PQT10Purchase Quotation - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
92PQT11PQ - Drawn DPM Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
93PQT15PQ - Drawn DPM Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
94PRQ1Purchase Request - Rows135LineTypeRow TypeVarChar10RR=Regular
95PRQ10Purchase Request - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
96PRQ11PR - Drawn DPM Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
97PRQ15PR - Drawn DPM Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
98QUT1Sales Quotation - Rows135LineTypeRow TypeVarChar10RR=Regular, A=Alternative
99QUT10Sales Quotation - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
100QUT11Sls Quote - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
101QUT15Sls Quote - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
102RDN1Returns - Rows135LineTypeLine TypeVarChar10RR=Regular
103RDN10Returns - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
104RDN11Returns - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
105RDN15Returns - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
106RDR1Sales Order - Rows135LineTypeRow TypeVarChar10RR=Regular
107RDR10Sales Order - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
108RDR11Sls Ord. - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
109RDR15Sls Ord. - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
110RIN1A/R Credit Memo - Rows135LineTypeRow TypeVarChar10RR=Regular
111RIN10A/R Credit Memo - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
112RIN11A/R Cr. Memo - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
113RIN15A/R Cr. Memo - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
114RPC1A/P Credit Memo - Rows135LineTypeRow TypeVarChar10RR=Regular
115RPC10A/P Credit Memo - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
116RPC11A/P Cr. Memo - Drawn Dpm Det.37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
117RPC15A/P Cr. Memo - Drawn Dpm Appld58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
118RPD1Goods Return - Rows135LineTypeRow TypeVarChar10RR=Regular
119RPD10Goods Return - Row Structure5LineTypeRow TypeVarChar10T=Text, S=Subtotal
120RPD11Gds Return - Drawn Dpm Detail37LineTypeLine TypeVarChar10DD=Document Row, R=Currency Rounding, H=Down Payment Document Rounding
121RPD15Gds Return - Drawn Dpm Applied58LineTypeRow TypeVarChar10DD=Document, R=Exchange Rate Rounding, H=Document Header Rounding
122VRT2Tax Invoice Report Grid Info14LineTypeRow TypeInt110