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
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPOR386Purchase Order
8JDT1124Journal Entry - Rows
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OPCH268A/P Invoice
4OSRN20Serial Numbers Master Data
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7ORCT154Incoming Payment
8OBOT10Bill Of Exchang Transaction
9OOCR9Loading Factors
10JDT1110Journal Entry - Rows
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 sent8StatusStatusVarChar10UU=Not Sent, P=In Process, S=Sent
2USR1Short Cut1STATUSStatusVarChar10
TOPBanking
3ARCTIncoming Payment - History84StatusCreated by Payment WizardVarChar10NY=No, N=BoE Canceled, C=Yes
4CHO2Checks for Payment - Print Status3StatusStatusVarChar10ND=Details, V=Void, N=Not Confirmed, T=Not Printed, O=Overflow
5OBNHBank Statement Header5StatusStatusVarChar10DE=Finalized, D=Draft, O=Old
6OPDFPayment Draft84StatusCreated by Payment RunVarChar10NY=Yes, N=No, C=BoE Canceled
7OPEXPayment Results Table40StatusStatusVarChar10OO=Open, C=Closed
8OPWZPayment Wizard20StatusObject StatusVarChar10SS=Saved Wizard, R=Recommended Wizard, E=Executed Wizard
9ORCTIncoming Payment84StatusCreated by Payment RunVarChar10NY=Yes, N=No, C=BoE Canceled
10OVPMOutgoing Payments84StatusCreated by Payment RunVarChar10NY=Yes, N=No, C=BoE Canceled
11PWZ3Payment Wizard - Rows 356StatusInv StatusVarChar10
TOPBusiness Partners
12OCLGActivities42statusStatusInt110
TOPFinance
13OBTDJournal Vouchers List2StatusOpen/Closed DocumentVarChar10OO=Open, C=Closed
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 StatusVarChar10NN=New, S=Sent, A=Accepted, E=Error
23OHEMEmployees28statusStatusInt110
24OHETObject: HR Employee Transfer4StatusProcessing StatusVarChar10NN=New, P=Processing, S=Sent, R=Received, A=Accepted, E=Error
TOPInventory and Production
25APKLPick List - History9StatusStatusVarChar10RR=Released, Y=Picked, P=Partially Picked, D=Partially Delivered, C=Closed
26AWORProduction Order - History5StatusProduction Order StatusVarChar10PP=Planned, R=Released, L=Closed, C=Cancelled
27IGE2Goods Issue - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
28IGE3Goods Issue - Freight45StatusStatusVarChar10OO=Open, C=Closed
29IGE5Goods Issue - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
30IGE6Goods Issue - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
31IGN2Goods Receipt - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
32IGN3Goods Receipt - Freight45StatusStatusVarChar10OO=Open, C=Closed
33IGN5Goods Receipt - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
34IGN6Goods Receipt- Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
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 List9StatusStatusVarChar10RR=Released, Y=Picked, P=Partially Picked, D=Partially Delivered, C=Closed
40OSRISerial Numbers for Items23StatusStatusVarChar1000=Available, 1=Unavailable
41OSRNSerial Numbers Master Data13StatusStatusVarChar100=Available, 1=Unavailable
42OWKOProduction Instructions2StatusProcessing StatusVarChar10OO=Work Instructions, I=Work Instructions, E=Production Completed
43OWORProduction Order5StatusProduction Order StatusVarChar10PP=Planned, R=Released, L=Closed, C=Cancelled
44UWKOProduction Instructions2StatusProcessing StatusVarChar10OO=Work Instructions, I=Work Instructions, E=Production Completed
45UWORProduction Order5StatusProduction Order StatusVarChar10PP=Planned, R=Released, L=Closed, C=Cancelled
46WTR2Inventory Transfer - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
47WTR3Inventory Transfer - Freight45StatusStatusVarChar10OO=Open, C=Closed
48WTR5Inventory Transfer - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
49WTR6Inventory Transfer - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
TOPMarketing Documents
50ADO13A/R Invoice Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
51ADO2A/R Invoice - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
52ADO3A/R Invoice - Freight - History45StatusStatusVarChar10OO=Open, C=Closed
53ADO5Withholding Tax - History24StatusStatusVarChar10OO=Open, C=Closed
54ADO6Documents History - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
55AJD2Withholding Tax - History24StatusStatusVarChar10OO=Open, C=Closed
56BTF2Journal Voucher Withholding Tax - History24StatusStatusVarChar10OO=Open, C=Closed
57CIN13Correction Invoice Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
58CIN2A/R Correction Invoice - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
59CIN3A/R Correction Invoice - Freight45StatusStatusVarChar10OO=Open, C=Closed
60CIN5AR Correction Invoice - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
61CIN6Correction Invoice - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
62CPI13A/P Correction Invoice Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
63CPI2A/P Correction Invoice - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
64CPI3A/P Correction Invoice - Freight45StatusStatusVarChar10OO=Open, C=Closed
65CPI5Withholding Tax Data24StatusStatusVarChar10OO=Open, C=Closed
66CPI6Documents History - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
67CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
68CPV2A/P Correction Invoice Reversal - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
69CPV3A/P Correction Invoice Reversal - Freight45StatusStatusVarChar10OO=Open, C=Closed
70CPV5A/P Correction Invoice Reversal - WTax24StatusStatusVarChar10OO=Open, C=Closed
71CPV6A/P Correction Invoice Reversal - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
72CSI13A/R Correction Invoice Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
73CSI2A/R Corr Inv - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
74CSI3A/R Correction Invoice - Freight45StatusStatusVarChar10OO=Open, C=Closed
75CSI5A/R Correction Invoice - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
76CSI6A/R Corr. Inv. - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
77CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
78CSV2A/R Correction Invoice Reversal - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
79CSV3A/R Correction Invoice Reversal - Freight45StatusStatusVarChar10OO=Open, C=Closed
80CSV5A/R Correction Invoice Reversal - WTax24StatusStatusVarChar10OO=Open, C=Closed
81CSV6A/R Correction Invoice Reversal - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
82DLN13Delivery Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
83DLN2Delivery Notes - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
84DLN3Delivery Notes - Freight45StatusStatusVarChar10OO=Open, C=Closed
85DLN5Delivery - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
86DLN6Delivery - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
87DPI13A/R Down Payment Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
88DPI2A/R Down Payment - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
89DPI3A/R Down Payment - Freight45StatusStatusVarChar10OO=Open, C=Closed
90DPI5A/R Down Payment - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
91DPI6A/R Down Payment - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
92DPO13A/P Down Payment Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
93DPO2A/P Down Payment - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
94DPO3A/P Down Payment - Freight45StatusStatusVarChar10OO=Open, C=Closed
95DPO5A/P Down Payment - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
96DPO6Down Payment Out - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
97DRF13Draft Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
98DRF2Draft - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
99DRF3Draft - Freight45StatusStatusVarChar10OO=Open, C=Closed
100DRF5Draft Documents - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
101DRF6Document Drafts - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
102IEI13Incoming Excise Invoice Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
103IEI2Incoming Excise Invoice - Freight - History - Rows41StatusStatusVarChar10OO=Open, C=Close
104IEI3IEI - Freight45StatusStatusVarChar10OO=Open, C=Closed
105IEI5Incoming Excise Invoice - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
106IEI6IEI - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
107IGE13Goods Issue Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
108IGN13Goods Receipt Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
109INV13A/R Invoice Rows - Distributed Freights47StatusStatusVarChar10OO=Open, C=Close
110INV2A/R Invoice - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
111INV3A/R Invoice - Freight45StatusStatusVarChar10OO=Open, C=Closed
112INV5A/R Invoice - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
113INV6A/R Invoice - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
114JDT2Withholding Tax - History24StatusStatusVarChar10OO=Open, C=Closed
115ODWZDunning Wizard5StatusWizard StatusVarChar10SS=Saved Parameters, R=Recommended Wizard, E=Executed and Printed Wizard, O=Executed, Not Yet Printed Wizard
116OEI13Outgoing Excise Invoice Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
117OEI2OEI - Freight Rows41StatusStatusVarChar10OO=Open, C=Close
118OEI3OEI - Freight45StatusStatusVarChar10OO=Open, C=Closed
119OEI5Outgoing Excise Invoice - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
120OEI6Outgoing Excise Invoice - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
121OWDDDocs. for Confirmation8StatusStatusVarChar10WW=Pending, Y=Approved, N=Rejected, P=Generated, A=Generated By Authorizer, C=Cancelled
122PCH13A/P Invoice Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
123PCH2A/P Invoice - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
124PCH3A/P Invoice - Freight45StatusStatusVarChar10OO=Open, C=Closed
125PCH5A/P Invoice - Withholding Tax Data24StatusStatusVarChar10OO=Open, C=Closed
126PCH6A/P Invoice - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
127PDN13Goods Receipt PO Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
128PDN2Goods Receipt PO - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
129PDN3Goods Receipt PO - Freight45StatusStatusVarChar10OO=Open, C=Closed
130PDN5Goods Reciept PO - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
131PDN6Goods Receipt PO - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
132POR13Purchase Order Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
133POR2Purchase Order - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
134POR3Purchase Order - Freight45StatusStatusVarChar10OO=Open, C=Closed
135POR5Purchase Order - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
136POR6Purchase Order - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
137QUT13Sales Quotation Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
138QUT2Sales Quotation - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
139QUT3Sales Quotation - Freight45StatusStatusVarChar10OO=Open, C=Closed
140QUT5Sales Quotation - Tax24StatusStatusVarChar10OO=Open, C=Closed
141QUT6Sales Quotation - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
142RDN13Returns Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
143RDN2Return - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
144RDN3Return - Freight45StatusStatusVarChar10OO=Open, C=Closed
145RDN5Returns - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
146RDN6Returns - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
147RDR13Sales Order Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
148RDR2Sales Order - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
149RDR3Sales Order - Freight45StatusStatusVarChar10OO=Open, C=Closed
150RDR5Sales Order - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
151RDR6Sales Order - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
152RIN13A/R Credit Memo Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
153RIN2A/R Credit Memo - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
154RIN3A/R Credit Memo - Freight45StatusStatusVarChar10OO=Open, C=Closed
155RIN5A/R Credit Memo - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
156RIN6A/R Credit Memo - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
157RPC13A/P Credit Memo Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
158RPC2A/P Credit Memo Rows - Expenses41StatusStatusVarChar10OO=Open, C=Close
159RPC3A/P Credit Memo - Freight45StatusStatusVarChar10OO=Open, C=Closed
160RPC5A/P Credit Memo - Withholding Tax24StatusStatusVarChar10OO=Open, C=Closed
161RPC6A/P Credit Memo - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
162RPD13Goods Returns Rows - Distributed Expenses47StatusStatusVarChar10OO=Open, C=Close
163RPD2Goods Return - Freight - Rows41StatusStatusVarChar10OO=Open, C=Close
164RPD3Goods Return - Freight45StatusStatusVarChar10OO=Open, C=Closed
165RPD5Goods Return - Withholding Tax Data24StatusStatusVarChar10OO=Open, C=Closed
166RPD6Goods Return - Installments6StatusInstallment StatusVarChar10OO=Open, C=Closed
167WDD1Documents for Approval - Authorizers4StatusStatusVarChar10WW=Pending, Y=Approved, N=Not Approved
168WTR13Inventory Transfer Rows - Distributed Freights47StatusStatusVarChar10OO=Open, C=Close
TOPMRP
169ORCMRecommendation Data14StatusOrder StatusVarChar10OO=Opened, A=Accepted, P=Proceeded, D=Deleted
TOPReports
170OEJBWizard Run Details for ERV-JAb8StatusStatusVarChar10OO=Open, C=Closed
171OLLRElectronic Report Generation Result6StatusStatusVarChar10CC=Cancelled, E=Executed, F=Failed
172RDOCDocument56StatusStatusVarChar10AA=Active, I=Inactive
TOPSales Opportunities
173OOPRSales Opportunity21StatusStatusVarChar10OO=Open, L=Lost, W=Won
174OPR1Sales Opportunity - Rows14StatusStatusVarChar10OO=Open, C=Closed
TOPService
175AINSCustomer Equipment Card - History43statusStatusVarChar10AA=Active, R=Returned, T=Terminated, L=Loaned, I=In Repair Lab
176ASCLHistory18statusStatusInt60-3
177OCTRService Contracts6StatusContract StatusVarChar10DA=Approved, F=On Hold, D=Draft, T=Terminated
178OINSCustomer Equipment Card43statusStatusVarChar10AA=Active, R=Returned, T=Terminated, L=Loaned, I=In Repair Lab
179OISRService Calls10StatusCall StatusVarChar10OO=Open, C=Closed
180OREQExternal System Call Request3StatusRequest StatusVarChar10NN=New, P=In Process, S=Completed, C=Comfirmed, F=Failed
181OSCLService Calls18statusStatusInt60-3
182REQ1External System Call Request - Message List6StatusMessage StatusVarChar10UU=Unread, R=Read