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

70 tablesB1 9.2 

Business Partners
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.2ABPL541Business PlaceBusiness Partners
2Business One9.2ACP1441Campaign - BPsBusiness Partners
3Business One9.2ACP281Campaign - ItemsBusiness Partners
4Business One9.2ACP381Campaign - PartnersBusiness Partners
5Business One9.2ACPN231CampaignBusiness Partners
6Business One9.2ACPR441Contact Persons - HistoryBusiness Partners
7Business One9.2ACR1261Business Partner Addresses - HistoryBusiness Partners
8Business One9.2ACR251Bussiness Partners - Payment Methods-HistoryBusiness Partners
9Business One9.2ACR351Business Partner Control Accounts - HistoryBusiness Partners
10Business One9.2ACR431Allowed WTax Codes for BP - HistoryBusiness Partners
11Business One9.2ACR531BP Payment DatesBusiness Partners
12Business One9.2ACR7251Fiscal IDs for BP Master DataBusiness Partners
13Business One9.2ACRB432Business Partner Bank Accounts - HistoryBusiness Partners
14Business One9.2ACRD3322Business Partners - HistoryBusiness Partners
15Business One9.2AOA1241Blanket Agreement - RowsBusiness Partners
16Business One9.2AOA2141Blanket Agreement - DetailsBusiness Partners
17Business One9.2AOA351Item Details: ActivityBusiness Partners
18Business One9.2AOA431Blanket Agreement - Recurring TransactionsBusiness Partners
19Business One9.2AOAT431Blanket AgreementBusiness Partners
20Business One9.2AWD3121WTax Codes Details for BPBusiness Partners
21Business One9.2AWD491WTax Codes Details for ItemBusiness Partners
22Business One9.2AWD591WTax Codes Details for FreightBusiness Partners
23Business One9.2CPN1441Campaign - BPsBusiness Partners
24Business One9.2CPN281Campaign - ItemsBusiness Partners
25Business One9.2CPN381Campaign - PartnersBusiness Partners
26Business One9.2CRD1261Business Partners - AddressesBusiness Partners
27Business One9.2CRD252Bussiness Partners - Payment MethodsBusiness Partners
28Business One9.2CRD351BP Control AccountBusiness Partners
29Business One9.2CRD431Allowed WTax Codes for BPBusiness Partners
30Business One9.2CRD531BP Payment DatesBusiness Partners
31Business One9.2CRD621BP's Payer NameBusiness Partners
32Business One9.2CRD7251Fiscal IDs for BP Master DataBusiness Partners
33Business One9.2CRD821BP Branch AssignmentBusiness Partners
34Business One9.2CRD9111OCRD ExtensionBusiness Partners
35Business One9.2DDT161Withholding Tax Deduction Hierarchy - RowsBusiness Partners
36Business One9.2OAT1241Blanket Agreement - RowsBusiness Partners
37Business One9.2OAT2141Blanket Agreement - DetailsBusiness Partners
38Business One9.2OAT351Item Details: ActivityBusiness Partners
39Business One9.2OAT431Blanket Agreement - Recurring TransactionsBusiness Partners
40Business One9.2OBPL542Business PlaceBusiness Partners
41Business One9.2OBPP21BP PrioritiesBusiness Partners
42Business One9.2OCLA41Activity StatusBusiness Partners
43Business One9.2OCLG823ActivitiesBusiness Partners
44Business One9.2OCLO52Meetings LocationBusiness Partners
45Business One9.2OCLS52Activity SubjectsBusiness Partners
46Business One9.2OCLT42Activity TypesBusiness Partners
47Business One9.2OCOG72Commission GroupsBusiness Partners
48Business One9.2OCPN231CampaignBusiness Partners
49Business One9.2OCPR442Contact PersonsBusiness Partners
50Business One9.2OCQG42Card PropertiesBusiness Partners
51Business One9.2OCRB432BP - Bank AccountBusiness Partners
52Business One9.2OCRD33211Business PartnerBusiness Partners
53Business One9.2OCRG83Card GroupsBusiness Partners
54Business One9.2ODDT122Withholding Tax Deduction HierarchyBusiness Partners
55Business One9.2ODUN81Dunning LettersBusiness Partners
56Business One9.2OEGP61E-Mail GroupBusiness Partners
57Business One9.2OOAT432Blanket AgreementBusiness Partners
58Business One9.2OPRT81PartnersBusiness Partners
59Business One9.2ORPT31Response TypeBusiness Partners
60Business One9.2OSCN85Customer/Vendor Cat. No.Business Partners
61Business One9.2OSLP143Sales EmployeeBusiness Partners
62Business One9.2OTBP161Target Group Business PartnerBusiness Partners
63Business One9.2OTER53TerritoriesBusiness Partners
64Business One9.2OTGG21Target GroupBusiness Partners
65Business One9.2OVTP42Vendor TypeBusiness Partners
66Business One9.2TGG1321Target Group DetailsBusiness Partners
67Business One9.2USR631User Branch AssignmentBusiness Partners
68Business One9.2WTD3122WTax Codes Details for BPBusiness Partners
69Business One9.2WTD492WTax Codes Details for ItemBusiness Partners
70Business One9.2WTD592WTax Codes Details for FreightBusiness Partners