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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

99 tablesB1 9.3 

Reports
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.3AEC1161Parameters for Various Types of Electronic CommunicationReports
2Business One9.3AEC2361Electronic TransactionsReports
3Business One9.3AEC3151Statuses and Logs for Actions in Electronic CommunicationReports
4Business One9.3AEC4131Import Mapping DeterminationReports
5Business One9.3AEC5131List of Canceled Reconciliations for Actions in Electronic CommunicationReports
6Business One9.3AEC6151Electronic Protocol DI API PropertiesReports
7Business One9.3AECM61Electronic Communication Types or ProtocolsReports
8Business One9.3AMD1161Amout Differences Report LinesReports
9Business One9.3AQAG101Query Authorization Groups - LogReports
10Business One9.3ATHL121ThresholdsReports
11Business One9.3BTA121Brazil - Tax Adjustment - Tax TypesReports
12Business One9.3BTA242Brazil Tax Adujstment - Taxes Paid in AdvanceReports
13Business One9.3EBL171E-Balance Report DataReports
14Business One9.3ECDW181ECD Wizard - Rows 1Reports
15Business One9.3ECM1162Parameters for Various Types of Electronic CommunicationReports
16Business One9.3ECM2363Electronic TransactionsReports
17Business One9.3ECM3151Statuses and Logs for Actions in Electronic CommunicationReports
18Business One9.3ECM4132Import Mapping DeterminationReports
19Business One9.3ECM5131List of Related Documents for Actions in Electronic CommunicationReports
20Business One9.3ECM6151Electronic Protocol DI API PropertiesReports
21Business One9.3EFDW121EFD Wizard - Rows 1Reports
22Business One9.3EJB1101ERV-JAb Wizard Signing PersonsReports
23Business One9.3EJB291Docs List for ERV-JAb WizardReports
24Business One9.3EJD181ERV-JAb Signing Persons ListReports
25Business One9.3EML151E-mail Log - RowsReports
26Business One9.3FLT1101856 Report - Selection CriteriaReports
27Business One9.3GDP191General Data Protection Wizard - Personal Fields SetupReports
28Business One9.3GDP282General Data Protection Wizard - Natural PersonsReports
29Business One9.3GDP352General Data Protection Wizard - Processed DocumentsReports
30Business One9.3IRD171Report Definition - RowsReports
31Business One9.3LLR141Electronic Report Generation Result - ReportsReports
32Business One9.3OAMD91Amount Differences ReportReports
33Business One9.3OCRT41CRDB Tables Tree ListReports
34Business One9.3OEBL51E-BalanceReports
35Business One9.3OECDW401ECD WizardReports
36Business One9.3OECM61Electronic Communication Types or ProtocolsReports
37Business One9.3OEFDW241EFD WizardReports
38Business One9.3OEJB241Wizard Run Details for ERV-JAbReports
39Business One9.3OEJD61Company Details for ERV-JAbReports
40Business One9.3OEML141E-mail LogReports
41Business One9.3OFLT2921Report - Selection CriteriaReports
42Business One9.3OGDP142General Data Protection WizardReports
43Business One9.3OIRC101Interactive Report CategoryReports
44Business One9.3OIRD111Report DefinitionReports
45Business One9.3OLLR92Electronic Report Generation ResultReports
46Business One9.3OQAG103Query Authorization GroupsReports
47Business One9.3OQCN52Query CatagoriesReports
48Business One9.3OQWZ32Query WizardReports
49Business One9.3ORFL61Already Displayed 347, 349 and WTax ReportsReports
50Business One9.3OSEL41Selection ListsReports
51Business One9.3OSOI121Statement of Import WizardReports
52Business One9.3OSOIL42Statement of Import Wizard RunReports
53Business One9.3OSQR72Standard QueriesReports
54Business One9.3OSRA401Scheduled Report ActionsReports
55Business One9.3OSRT102Korean Summary ReportReports
56Business One9.3OTHL121ThresholdsReports
57Business One9.3OTRB182Tax Report Wizard for BrazilReports
58Business One9.3OTRS151Tax Report Saving ObjectReports
59Business One9.3OTRX52Transformation DocumentsReports
60Business One9.3OTSM21Tax Summary Report MethodReports
61Business One9.3OTWS62E-Tax Web SiteReports
62Business One9.3OUQR102QueriesReports
63Business One9.3PRS1101Detail Lines of Print Sequence DefinitionReports
64Business One9.3QWZ191Query TablesReports
65Business One9.3QWZ2191Query Result FieldsReports
66Business One9.3QWZ3151Query Condition FieldsReports
67Business One9.3RDC192Multilingual ReportReports
68Business One9.3RDFL62Document StandardsReports
69Business One9.3RDOC653DocumentReports
70Business One9.3RITM884Reporting ElementReports
71Business One9.3RPRS52Print Sequence DefinitionReports
72Business One9.3RTYP91Document Type ListReports
73Business One9.3SCRT41SAP Crystal Reports TranslationsReports
74Business One9.3SEL121Selection Lists - ListsReports
75Business One9.3SOI121Statement of Import - Business PartnersReports
76Business One9.3SOI221Statement of Import - BranchesReports
77Business One9.3SOI3191Statement of Import - InvoicesReports
78Business One9.3SOI491Statement of Import - InvoicesReports
79Business One9.3SOI5302Statement of Import - LinesReports
80Business One9.3SQR121System QueriesReports
81Business One9.3SRA172Scheduled Report ParametersReports
82Business One9.3SRA2132Scheduled Report Run OutputReports
83Business One9.3SRA3152Scheduled Report RecipientsReports
84Business One9.3SRT161Korean Summary Report - Rows1Reports
85Business One9.3SRT291Korean Summary Report - Rows2Reports
86Business One9.3TRB121Tax Report Wizard Selected StatesReports
87Business One9.3TRB221Tax Report Wizard Selected Tax TypesReports
88Business One9.3TRB321Tax Report Wizard - Selected Tax CategoriesReports
89Business One9.3TRB441Tax Report Wizard - Selected Tax EntriesReports
90Business One9.3TRB5121Tax Report Wizard Reported Tax SumsReports
91Business One9.3TRS1112Tax Report Saving Object - Approved DocumentsReports
92Business One9.3TRS282Tax Rpt Sav Obj Man Chgd ValsReports
93Business One9.3UQR121QueriesReports
94Business One9.3XRDBV81XLR company DB versionReports
95Business One9.3XROBJ131XLR Company Report ObjectsReports
96Business One9.3XRREL51XLR Company Report ObjectsReports
97Business One9.3XRUDF61XLR company UDFReports
98Business One9.3XRXLS31XLR company XLSReports
99Business One9.3XRXML31XLR company XMLReports