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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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

92 columns | Print definition?B1 8.8  | CODE

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