SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

105 columns | Print definition?B1 8.82  | CODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AAD1Administration Extension-Log15CodeCodeInt1101
2AADMAdministration - Log270CodeCodeInt1101
3ACFPCFOP for Nota Fiscal2CodeCFOP CodenVarChar60
4ADM1Administration Extension15CodeCodeInt1101
5ADM2Administration Electronic Report1CodeCodeInt110
6AFMLTax Formula Master Table2CodeCodenVarChar200
7ALR1Queue of messages to be sent1CodeInternal NumberInt110
8ALR2Dynamic message data row1CodeInternal NumberInt110
9ALR3Dynamic message data cells1CodeInternal NumberInt110
10ALT1Alerts - Users1CodeInternal NumberInt110
11ASTCSales Tax Codes1CodeCodenVarChar80
12ATSCCST Code for Nota Fiscal2CODECST Code IncomingnVarChar200
13CSTNWorkstation ID1CodeCodeInt110
14MAP1Input and Output of Mapping2CodeCodeInt110
15MLS1Distribution Lists - Recipients1CodeCodeInt110
16OADFAddress Formats1CodeCodeInt60
17OADMAdministration270CodeCodeInt1101
18OALRAlerts1CodeInternal NumberInt110
19OALTAlerts Template1CodeInternal NumberInt110
20OBDCB1i DI Configuration1CodeCodeInt110
21OBSIBrazil String Indexer2CodeCodenVarChar20
22OCDTCredit Card Payment1CodeCredit Card Payment CodenVarChar80
23OCFPCFOP for Nota Fiscal2CodeCFOP CodenVarChar60
24OCNTCounties2CodeCounty CodenVarChar70
25OCPTCockpit Main Table2CodeCockpit CodeInt60
26OCRYCountries1CodeCodenVarChar30
27OCSNCertificate Series2CodeCodenVarChar40
28OCSTStates1CodeCodenVarChar30
29ODMWData Migration1CodePackage CodeInt110
30OFMLTax Formula Master Table2CodeCodenVarChar200
31OGSPGoods Shipment1CodeCodeVarChar10
32OINDTriangular Deal1CodeCodeVarChar10
33OJPELocal Era Calendar1CodeLocal Era CodeVarChar10
34OLNGUser Language Table1CodeCodeInt110
35OMAOMobile Add-On Setting1CodeAdd-On CodenVarChar200
36OMLSDistribution List1CodeCodeInt110
37ONFTNota Fiscal Tax Category (Brazil)2CodeTax CategorynVarChar200
38ONOANature of Assessee2CodeCodenVarChar40
39OPROProperty Object3CodeInput/Output CodeInt110
40OPVLLender - Pelecard1CodeInternal NumberInt110
41ORITDunning Interest Rate1CodeInterest CodenVarChar200
42OSECSections2CodeCodenVarChar40
43OSSPService Supply1CodeCodeVarChar10
44OSTASales Tax Authorities1CodeCodenVarChar80
45OSTCSales Tax Codes1CodeCodenVarChar80
46OTFCTax Type Combination2CodeCodenVarChar200
47OTPATax Parameter Attributes2CodeAttribute CodenVarChar80
48OTPRTax Return Values2CodeReturn Value CodenVarChar70
49OTPSTax Parameter2CodeCodenVarChar50
50OTSCCST Code for Nota Fiscal2CODECST Code IncomingnVarChar200
51OUDGUser Defaults1CodeCodenVarChar80
52OUDOUser-Defined Object1CodeCodenVarChar200
53RIT1Interest Rates1CodeObject CodenVarChar200
54UDG1User Defaults - Documents1CodeCodenVarChar80
55UDG2User Defaults - Credit Cards1CodeCodenVarChar80
56UDO1User-Defined Objects - Child1CodeCodenVarChar200
57UDO2User-Defined Objects - Find Columns1CodeCodenVarChar200
58UDO3User-Defined Objects - Found Columns1CodeCodenVarChar200
59UDO4User-Defined Objects - Child Table Columns1CodeCodenVarChar200
TOPBanking
60ACH1Checks for Payment - Rows - History8CodeTax DefinitionnVarChar80
61BOE1Bill of Exchange for Payment - Rows8CodeTax DefinitionnVarChar80
62CHD1Checks for Payment Drafts - Rows8CodeTax DefinitionnVarChar80
63CHO1Checks for Payment - Rows8CodeTax DefinitionnVarChar80
64OBCABank Charges Allocation Codes1CodeCodenVarChar30
65OPFTPortfolio Definitions1CodeCodenVarChar80
66OPYDPayment Run1CodePayment Run CodenVarChar200
67OUBRBranches1CodeCodeInt60
68OUDPDepartments1CodeCodeInt60
TOPBusiness Partners
69OCLOMeetings Location1CodeCodeInt60
70OCLSActivity Subjects1CodeCodeInt60
71OCLTActivity Types1CodeCodeInt60
TOPFinance
72AFPRPosting Period-Log2CodePeriod CodenVarChar200
73AVT1Tax Definition1CodeGroup CodenVarChar80
74AVTGTax Definition1CodeCodenVarChar80
75AWH2WTax Definition - Rows22CodeTax CodenVarChar80
76OACRAccrual Type1CodeAccrual Type CodenVarChar80
77OASCAccount Segmentation Categories2CodeCodenVarChar200
78OCDCCash Discount1CodeCodenVarChar200
79OCFLCash Flow Additional Trans.1CodeCodeInt110
80OCIGCIG Codes2CodeContract Code IdentificationnVarChar100
81OCUPCUP Codes2CodeUnique Code of ProjectnVarChar150
82OFPRPosting Period2CodePeriod CodenVarChar200
83OFYMFinancial Year Master2CodeCodenVarChar60
84OIDCIndicator1CodeIndicator CodenVarChar20
85OVTGTax Definition1CodeCodenVarChar80
86VTG1Tax Definition1CodeGroup CodenVarChar80
87WHT2Withholding Tax Definition - Rows22CodeTax CodenVarChar80
TOPInventory and Production
88AITTProduct Tree - History1CodeParent ItemnVarChar200
89ATT1Bill of Materials - Component Items - History3CodeChild ItemnVarChar200
90ITT1Bill of Materials - Component Items3CodeComponent ItemnVarChar200
91OCYCCycle1CodeCycle CodeInt60
92OITTProduct Tree1CodeParent ItemnVarChar200
93OLCTLocation1CodeLocation CodeInt110
94TMP1Bill of Materials - Component Items3CodeComponent ItemnVarChar200
TOPMarketing Documents
95ORCPRecurring Transaction Template2CodeTemplate CodenVarChar80
TOPMRP
96OFCTSales Forecast2CodeForecast CodenVarChar160
TOPReports
97FLT1856 Report - Selection Criteria2CodeCodenVarChar500
98OQWZQuery Wizard1CodeQuery CodenVarChar80
99OTRXTransformation Documents2CodeCodenVarChar200
100QWZ1Query Tables1CodeQuery CodenVarChar80
101QWZ2Query Result Fields1CodeQuery CodenVarChar80
102QWZ3Query Condition Fields1CodeQuery CodenVarChar80
103RTYPDocument Type List1CODEReport TypenVarChar40
TOPService
104OBFIBrazil Fuel Indexer1CodeFuel CodenVarChar100
105OBNIBrazil Numeric Indexer2CodeCodeInt110