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
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9/OPT/Z1344Reporting table: Text table for exception definitions
10FCO_DOC_HEAD61Failure Cost Document Header

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OIVL77Whse Journal
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

206 columns | Print definition?B1 8.82  | STATUS

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