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

182 columns | Print definition?B1 8.8  | STATUS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ALR1Queue of messages to be sent8StatusStatusVarChar10UP=In Process, S=Sent, U=Not Sent
2USR1Short Cut1STATUSStatusVarChar10
TOPBanking
3ARCTIncoming Payment - History84StatusCreated by Payment WizardVarChar10NC=Yes, N=BoE Canceled, Y=No
4CHO2Checks for Payment - Print Status3StatusStatusVarChar10ND=Details, N=Not Confirmed, O=Overflow, T=Not Printed, V=Void
5OBNHBank Statement Header5StatusStatusVarChar10DD=Draft, E=Finalized, O=Old
6OPDFPayment Draft84StatusCreated by Payment RunVarChar10NC=BoE Canceled, N=No, Y=Yes
7OPEXPayment Results Table40StatusStatusVarChar10OC=Closed, O=Open
8OPWZPayment Wizard20StatusObject StatusVarChar10SE=Executed Wizard, R=Recommended Wizard, S=Saved Wizard
9ORCTIncoming Payment84StatusCreated by Payment RunVarChar10NC=BoE Canceled, N=No, Y=Yes
10OVPMOutgoing Payments84StatusCreated by Payment RunVarChar10NC=BoE Canceled, N=No, Y=Yes
11PWZ3Payment Wizard - Rows 356StatusInv StatusVarChar10
TOPBusiness Partners
12OCLGActivities42statusStatusInt110
TOPFinance
13OBTDJournal Vouchers List2StatusOpen/Closed DocumentVarChar10OC=Closed, O=Open
14OCFTCash Flow Transactions - Rows20StatusStatusVarChar10
15OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material4StatusRule StatusVarChar10
16OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses4StatusRule StatusVarChar10
17OSLMSpecial Ledger - Analytical Accounting Report: Material5StatusDocument StatusVarChar10
18OSLRSpecial Ledger - Analytical Accounting Report: Revenues & Expenses5StatusDocument StatusVarChar10
19SLM1Special Ledger - Analytical Accounting Report Lines: Material9StatusStatusVarChar10
20SLR1Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses9StatusStatusVarChar10
TOPHuman Resources
21AHEMEmployees28statusStatusInt110
22HET1Employee Transfer Details4StatusProcessing StatusVarChar10NA=Accepted, E=Error, N=New, S=Sent
23OHEMEmployees28statusStatusInt110
24OHETObject: HR Employee Transfer4StatusProcessing StatusVarChar10NA=Accepted, E=Error, N=New, P=Processing, R=Received, S=Sent
TOPInventory and Production
25APKLPick List - History9StatusStatusVarChar10RC=Closed, D=Partially Delivered, P=Partially Picked, R=Released, Y=Picked
26AWORProduction Order - History5StatusProduction Order StatusVarChar10PC=Cancelled, L=Closed, P=Planned, R=Released
27IGE2Goods Issue - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
28IGE3Goods Issue - Freight45StatusStatusVarChar10OC=Closed, O=Open
29IGE5Goods Issue - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
30IGE6Goods Issue - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
31IGN2Goods Receipt - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
32IGN3Goods Receipt - Freight45StatusStatusVarChar10OC=Closed, O=Open
33IGN5Goods Receipt - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
34IGN6Goods Receipt- Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
35OBTNBatch Numbers Master Data13StatusStatusVarChar1000=Released, 1=Not Accessible, 2=Locked
36ODBNBat. Nos - Draft - Master Data13StatusStatusVarChar1000=Released, 1=Not Accessible, 2=Locked
37ODSNSNs - Draft - Master Data13StatusStatusVarChar100=Available, 1=Unavailable
38OIBTBatch No. for Item20StatusStatusVarChar1000=Released, 1=Not Accessible, 2=Locked
39OPKLPick List9StatusStatusVarChar10RC=Closed, D=Partially Delivered, P=Partially Picked, R=Released, Y=Picked
40OSRISerial Numbers for Items23StatusStatusVarChar1000=Available, 1=Unavailable
41OSRNSerial Numbers Master Data13StatusStatusVarChar100=Available, 1=Unavailable
42OWKOProduction Instructions2StatusProcessing StatusVarChar10OE=Production Completed, I=Work Instructions, O=Work Instructions
43OWORProduction Order5StatusProduction Order StatusVarChar10PC=Cancelled, L=Closed, P=Planned, R=Released
44UWKOProduction Instructions2StatusProcessing StatusVarChar10OE=Production Completed, I=Work Instructions, O=Work Instructions
45UWORProduction Order5StatusProduction Order StatusVarChar10PC=Cancelled, L=Closed, P=Planned, R=Released
46WTR2Inventory Transfer - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
47WTR3Inventory Transfer - Freight45StatusStatusVarChar10OC=Closed, O=Open
48WTR5Inventory Transfer - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
49WTR6Inventory Transfer - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
TOPMarketing Documents
50ADO13A/R Invoice Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
51ADO2A/R Invoice - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
52ADO3A/R Invoice - Freight - History45StatusStatusVarChar10OC=Closed, O=Open
53ADO5Withholding Tax - History24StatusStatusVarChar10OC=Closed, O=Open
54ADO6Documents History - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
55AJD2Withholding Tax - History24StatusStatusVarChar10OC=Closed, O=Open
56BTF2Journal Voucher Withholding Tax - History24StatusStatusVarChar10OC=Closed, O=Open
57CIN13Correction Invoice Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
58CIN2A/R Correction Invoice - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
59CIN3A/R Correction Invoice - Freight45StatusStatusVarChar10OC=Closed, O=Open
60CIN5AR Correction Invoice - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
61CIN6Correction Invoice - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
62CPI13A/P Correction Invoice Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
63CPI2A/P Correction Invoice - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
64CPI3A/P Correction Invoice - Freight45StatusStatusVarChar10OC=Closed, O=Open
65CPI5Withholding Tax Data24StatusStatusVarChar10OC=Closed, O=Open
66CPI6Documents History - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
67CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
68CPV2A/P Correction Invoice Reversal - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
69CPV3A/P Correction Invoice Reversal - Freight45StatusStatusVarChar10OC=Closed, O=Open
70CPV5A/P Correction Invoice Reversal - WTax24StatusStatusVarChar10OC=Closed, O=Open
71CPV6A/P Correction Invoice Reversal - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
72CSI13A/R Correction Invoice Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
73CSI2A/R Corr Inv - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
74CSI3A/R Correction Invoice - Freight45StatusStatusVarChar10OC=Closed, O=Open
75CSI5A/R Correction Invoice - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
76CSI6A/R Corr. Inv. - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
77CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
78CSV2A/R Correction Invoice Reversal - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
79CSV3A/R Correction Invoice Reversal - Freight45StatusStatusVarChar10OC=Closed, O=Open
80CSV5A/R Correction Invoice Reversal - WTax24StatusStatusVarChar10OC=Closed, O=Open
81CSV6A/R Correction Invoice Reversal - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
82DLN13Delivery Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
83DLN2Delivery Notes - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
84DLN3Delivery Notes - Freight45StatusStatusVarChar10OC=Closed, O=Open
85DLN5Delivery - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
86DLN6Delivery - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
87DPI13A/R Down Payment Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
88DPI2A/R Down Payment - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
89DPI3A/R Down Payment - Freight45StatusStatusVarChar10OC=Closed, O=Open
90DPI5A/R Down Payment - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
91DPI6A/R Down Payment - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
92DPO13A/P Down Payment Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
93DPO2A/P Down Payment - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
94DPO3A/P Down Payment - Freight45StatusStatusVarChar10OC=Closed, O=Open
95DPO5A/P Down Payment - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
96DPO6Down Payment Out - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
97DRF13Draft Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
98DRF2Draft - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
99DRF3Draft - Freight45StatusStatusVarChar10OC=Closed, O=Open
100DRF5Draft Documents - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
101DRF6Document Drafts - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
102IEI13Incoming Excise Invoice Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
103IEI2Incoming Excise Invoice - Freight - History - Rows41StatusStatusVarChar10OC=Close, O=Open
104IEI3IEI - Freight45StatusStatusVarChar10OC=Closed, O=Open
105IEI5Incoming Excise Invoice - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
106IEI6IEI - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
107IGE13Goods Issue Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
108IGN13Goods Receipt Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
109INV13A/R Invoice Rows - Distributed Freights47StatusStatusVarChar10OC=Close, O=Open
110INV2A/R Invoice - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
111INV3A/R Invoice - Freight45StatusStatusVarChar10OC=Closed, O=Open
112INV5A/R Invoice - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
113INV6A/R Invoice - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
114JDT2Withholding Tax - History24StatusStatusVarChar10OC=Closed, O=Open
115ODWZDunning Wizard5StatusWizard StatusVarChar10SE=Executed and Printed Wizard, O=Executed, Not Yet Printed Wizard, R=Recommended Wizard, S=Saved Parameters
116OEI13Outgoing Excise Invoice Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
117OEI2OEI - Freight Rows41StatusStatusVarChar10OC=Close, O=Open
118OEI3OEI - Freight45StatusStatusVarChar10OC=Closed, O=Open
119OEI5Outgoing Excise Invoice - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
120OEI6Outgoing Excise Invoice - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
121OWDDDocs. for Confirmation8StatusStatusVarChar10WA=Generated By Authorizer, C=Cancelled, N=Rejected, P=Generated, W=Pending, Y=Approved
122PCH13A/P Invoice Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
123PCH2A/P Invoice - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
124PCH3A/P Invoice - Freight45StatusStatusVarChar10OC=Closed, O=Open
125PCH5A/P Invoice - Withholding Tax Data24StatusStatusVarChar10OC=Closed, O=Open
126PCH6A/P Invoice - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
127PDN13Goods Receipt PO Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
128PDN2Goods Receipt PO - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
129PDN3Goods Receipt PO - Freight45StatusStatusVarChar10OC=Closed, O=Open
130PDN5Goods Reciept PO - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
131PDN6Goods Receipt PO - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
132POR13Purchase Order Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
133POR2Purchase Order - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
134POR3Purchase Order - Freight45StatusStatusVarChar10OC=Closed, O=Open
135POR5Purchase Order - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
136POR6Purchase Order - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
137QUT13Sales Quotation Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
138QUT2Sales Quotation - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
139QUT3Sales Quotation - Freight45StatusStatusVarChar10OC=Closed, O=Open
140QUT5Sales Quotation - Tax24StatusStatusVarChar10OC=Closed, O=Open
141QUT6Sales Quotation - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
142RDN13Returns Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
143RDN2Return - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
144RDN3Return - Freight45StatusStatusVarChar10OC=Closed, O=Open
145RDN5Returns - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
146RDN6Returns - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
147RDR13Sales Order Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
148RDR2Sales Order - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
149RDR3Sales Order - Freight45StatusStatusVarChar10OC=Closed, O=Open
150RDR5Sales Order - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
151RDR6Sales Order - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
152RIN13A/R Credit Memo Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
153RIN2A/R Credit Memo - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
154RIN3A/R Credit Memo - Freight45StatusStatusVarChar10OC=Closed, O=Open
155RIN5A/R Credit Memo - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
156RIN6A/R Credit Memo - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
157RPC13A/P Credit Memo Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
158RPC2A/P Credit Memo Rows - Expenses41StatusStatusVarChar10OC=Close, O=Open
159RPC3A/P Credit Memo - Freight45StatusStatusVarChar10OC=Closed, O=Open
160RPC5A/P Credit Memo - Withholding Tax24StatusStatusVarChar10OC=Closed, O=Open
161RPC6A/P Credit Memo - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
162RPD13Goods Returns Rows - Distributed Expenses47StatusStatusVarChar10OC=Close, O=Open
163RPD2Goods Return - Freight - Rows41StatusStatusVarChar10OC=Close, O=Open
164RPD3Goods Return - Freight45StatusStatusVarChar10OC=Closed, O=Open
165RPD5Goods Return - Withholding Tax Data24StatusStatusVarChar10OC=Closed, O=Open
166RPD6Goods Return - Installments6StatusInstallment StatusVarChar10OC=Closed, O=Open
167WDD1Documents for Approval - Authorizers4StatusStatusVarChar10WN=Not Approved, W=Pending, Y=Approved
168WTR13Inventory Transfer Rows - Distributed Freights47StatusStatusVarChar10OC=Close, O=Open
TOPMRP
169ORCMRecommendation Data14StatusOrder StatusVarChar10OA=Accepted, D=Deleted, O=Opened, P=Proceeded
TOPReports
170OEJBWizard Run Details for ERV-JAb8StatusStatusVarChar10OC=Closed, O=Open
171OLLRElectronic Report Generation Result6StatusStatusVarChar10CC=Cancelled, E=Executed, F=Failed
172RDOCDocument56StatusStatusVarChar10AA=Active, I=Inactive
TOPSales Opportunities
173OOPRSales Opportunity21StatusStatusVarChar10OL=Lost, O=Open, W=Won
174OPR1Sales Opportunity - Rows14StatusStatusVarChar10OC=Closed, O=Open
TOPService
175AINSCustomer Equipment Card - History43statusStatusVarChar10AA=Active, I=In Repair Lab, L=Loaned, R=Returned, T=Terminated
176ASCLHistory18statusStatusInt60-3
177OCTRService Contracts6StatusContract StatusVarChar10DA=Approved, D=Draft, F=On Hold, T=Terminated
178OINSCustomer Equipment Card43statusStatusVarChar10AA=Active, I=In Repair Lab, L=Loaned, R=Returned, T=Terminated
179OISRService Calls10StatusCall StatusVarChar10OC=Closed, O=Open
180OREQExternal System Call Request3StatusRequest StatusVarChar10NC=Comfirmed, F=Failed, N=New, P=In Process, S=Completed
181OSCLService Calls18statusStatusInt60-3
182REQ1External System Call Request - Message List6StatusMessage StatusVarChar10UR=Read, U=Unread