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

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

66 columns | Print definition?B1 8.82  | TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1CSPISolution Packager Information3TypeParameter TypenVarChar200
2MAP1Input and Output of Mapping3TypeTypenVarChar100NACRYSTAL=Crystal Report, CSV=CSV File, NA=Not Avalible, TXT=Text File, XML=XML File
3OALRAlerts2TypeTypeVarChar10AA=Alert, M=Message
4OALTAlerts Template3TypeTypeVarChar10US=System Alert, U=User Alert
5OCMNCustomized Menu4TypeMenu TypeVarChar10CA=Add-On, C=Customized, S=System
6OLLFLegal List Format14TypeFormat TypenVarChar50L
7OMAOMobile Add-On Setting4TypeAdd-On TypeVarChar10M
8OPROProperty Object4TypeProperty TypenVarChar50StringString=String type property, XML=XML type property
9OSTASales Tax Authorities6TypeTypeInt110
10OUDOUser-Defined Object5TYPEObject TypeVarChar101
11TCD4Withholding Tax Code Determination4TypeWTax Code TypeVarChar10LL=Line Item WT Code, P=AP Default WT Code, R=AR Default WT Code
12TCD5Tax Code by Usage5TypeTax Code TypeVarChar10LL=Line Item Tax Code, P=AP Default Tax Code, R=AR Default Tax Code
TOPBanking
13OPFTPortfolio Definitions3TypeTypeVarChar10CB=Bill of Exchange, C=Cheque
14OPYMPayment Methods for Payment Wizard3TypeTypeVarChar10
TOPBusiness Partners
15ACPNCampaign3TypeCampaign TypeVarChar10E
16AOATBlanket Agreement9TypeAgreement TypeVarChar10G
17OCLSActivity Subjects3TypeRelated TypeInt60-1
18OCPNCampaign3TypeCampaign TypeVarChar10E
19OOATBlanket Agreement9TypeAgreement TypeVarChar10G
TOPFinance
20AJD2Withholding Tax - History16TypeWithholding TypeVarChar10
21AWHTWithholding Tax12TypeWithholding TypeVarChar10V
22BTF2Journal Voucher Withholding Tax - History16TypeWithholding Tax TypeVarChar10
23JDT2Withholding Tax - History16TypeWithholding TypeVarChar10
24JST1TDS Adjustment - Rows18TypeWithholding Tax TypeVarChar10I=Incoming Tax Withholding, V=VAT Withholding
25OASGAccount Segmentation4TypeTypeVarChar10AA=Alphanumeric, N=Numeric
26OWHTWithholding Tax12TypeWithholding TypeVarChar10V
TOPHuman Resources
27AHE2Education5typeEducation TypeInt110
28AHEMEmployees7typeEmployee TypeInt110
29HEM2Education5typeEducation TypeInt110
30OHEMEmployees7typeEmployee TypeInt110
TOPInventory and Production
31AWORProduction Order - History6TypeProduction Order TypeVarChar10S
32IGE5Goods Issue - Withholding Tax16TypeWithholding TypeVarChar10
33IGN5Goods Receipt - Withholding Tax16TypeWithholding TypeVarChar10
34OCYCCycle8TypeCycle TypeVarChar10CC=Cycle, M=MRP
35OWORProduction Order6TypeProduction Order TypeVarChar10S
36UWORProduction Order6TypeProduction Order TypeVarChar10S
37WTQ5Inventory Transfer Request - Withholding Tax16TypeWithholding TypeVarChar10
38WTR5Inventory Transfer - Withholding Tax16TypeWithholding TypeVarChar10
TOPMarketing Documents
39ADO5Withholding Tax - History16TypeWithholding TypeVarChar10
40CIN5AR Correction Invoice - Withholding Tax16TypeWithholding TypeVarChar10
41CPI5Withholding Tax Data16TypeWithholding TypeVarChar10
42CPV5A/P Correction Invoice Reversal - WTax16TypeWithholding TypeVarChar10
43CSI5A/R Correction Invoice - Withholding Tax16TypeWithholding TypeVarChar10
44CSV5A/R Correction Invoice Reversal - WTax16TypeWithholding TypeVarChar10
45DLN5Delivery - Withholding Tax16TypeWithholding Tax TypeVarChar10
46DPI5A/R Down Payment - Withholding Tax16TypeWithholding TypeVarChar10
47DPO5A/P Down Payment - Withholding Tax16TypeWithholding TypeVarChar10
48DRF5Draft Documents - Withholding Tax16TypeWithholding TypeVarChar10
49IEI5Incoming Excise Invoice - Withholding Tax16TypeWithholding Tax TypeVarChar10
50INV5A/R Invoice - Withholding Tax16TypeWithholding Tax TypeVarChar10
51OEI5Outgoing Excise Invoice - Withholding Tax16TypeWithholding Tax TypeVarChar10
52PCH5A/P Invoice - Withholding Tax Data16TypeWithholding TypeVarChar10
53PDN5Goods Reciept PO - Withholding Tax16TypeWithholding TypeVarChar10
54POR5Purchase Order - Withholding Tax16TypeWithholding TypeVarChar10
55PQT5Purchase Quotation - Withholding Tax16TypeWithholding TypeVarChar10
56QUT5Sales Quotation - Tax16TypeWithholding TypeVarChar10
57RDN5Returns - Withholding Tax16TypeWithholding TypeVarChar10
58RDR5Sales Order - Withholding Tax16TypeWithholding TypeVarChar10
59RIN5A/R Credit Memo - Withholding Tax16TypeWithholding TypeVarChar10
60RPC5A/P Credit Memo - Withholding Tax16TypeWithholding TypeVarChar10
61RPD5Goods Return - Withholding Tax Data16TypeWithholding TypeVarChar10
TOPReports
62EJB2Docs List for ERV-JAb Wizard5TypeTypenVarChar30PDF=PDF, XML=XML
63OTRXTransformation Documents4TypeTypenVarChar80XSLTXSLT=XSLT Document
64RDFLDocument Standards6TYPETypeVarChar10L
65RITMReporting Element4TypeTypeInt60
66RTYPDocument Type List9TYPETypeVarChar10L