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
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
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

78 tablesB1 9.3 

Business Partners
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.3ABPL551Business PlaceBusiness Partners
2Business One9.3ACL1101Activity Check-insBusiness Partners
3Business One9.3ACLG933Activities - HistoryBusiness Partners
4Business One9.3ACP1451Campaign - BPsBusiness Partners
5Business One9.3ACP281Campaign - ItemsBusiness Partners
6Business One9.3ACP381Campaign - PartnersBusiness Partners
7Business One9.3ACPN271CampaignBusiness Partners
8Business One9.3ACPR501Contact Persons - HistoryBusiness Partners
9Business One9.3ACR1321Business Partner Addresses - HistoryBusiness Partners
10Business One9.3ACR11101BP Tributary Info.Business Partners
11Business One9.3ACR1251BP eDoc SettingsBusiness Partners
12Business One9.3ACR251Bussiness Partners - Payment Methods-HistoryBusiness Partners
13Business One9.3ACR351Business Partner Control Accounts - HistoryBusiness Partners
14Business One9.3ACR431Allowed WTax Codes for BP - HistoryBusiness Partners
15Business One9.3ACR531BP Payment DatesBusiness Partners
16Business One9.3ACR7251Fiscal IDs for BP Master DataBusiness Partners
17Business One9.3ACRB462Business Partner Bank Accounts - HistoryBusiness Partners
18Business One9.3ACRD3672Business Partners - HistoryBusiness Partners
19Business One9.3AOA1351Blanket Agreement - RowsBusiness Partners
20Business One9.3AOA2141Blanket Agreement - DetailsBusiness Partners
21Business One9.3AOA351Item Details: ActivityBusiness Partners
22Business One9.3AOA431Blanket Agreement - Recurring TransactionsBusiness Partners
23Business One9.3AOAT531Blanket AgreementBusiness Partners
24Business One9.3AWD3122WTax Codes Details for BPBusiness Partners
25Business One9.3AWD492WTax Codes Details for ItemBusiness Partners
26Business One9.3AWD592WTax Codes Details for FreightBusiness Partners
27Business One9.3CLG1101Activity CheckInsBusiness Partners
28Business One9.3CPN1451Campaign - BPsBusiness Partners
29Business One9.3CPN281Campaign - ItemsBusiness Partners
30Business One9.3CPN381Campaign - PartnersBusiness Partners
31Business One9.3CRD1321Business Partners - AddressesBusiness Partners
32Business One9.3CRD11101BP Tributary Info.Business Partners
33Business One9.3CRD1251BP eDoc SettingsBusiness Partners
34Business One9.3CRD252Bussiness Partners - Payment MethodsBusiness Partners
35Business One9.3CRD351BP Control AccountBusiness Partners
36Business One9.3CRD431Allowed WTax Codes for BPBusiness Partners
37Business One9.3CRD531BP Payment DatesBusiness Partners
38Business One9.3CRD621BP's Payer NameBusiness Partners
39Business One9.3CRD7251Fiscal IDs for BP Master DataBusiness Partners
40Business One9.3CRD831BP Branch AssignmentBusiness Partners
41Business One9.3CRD9111OCRD ExtensionBusiness Partners
42Business One9.3DDT161Withholding Tax Deduction Hierarchy - RowsBusiness Partners
43Business One9.3OAT1351Blanket Agreement - RowsBusiness Partners
44Business One9.3OAT2141Blanket Agreement - DetailsBusiness Partners
45Business One9.3OAT351Item Details: ActivityBusiness Partners
46Business One9.3OAT431Blanket Agreement - Recurring TransactionsBusiness Partners
47Business One9.3OBPL552Business PlaceBusiness Partners
48Business One9.3OBPP21BP PrioritiesBusiness Partners
49Business One9.3OCLA41Activity StatusBusiness Partners
50Business One9.3OCLG933ActivitiesBusiness Partners
51Business One9.3OCLO52Meetings LocationBusiness Partners
52Business One9.3OCLS62Activity SubjectsBusiness Partners
53Business One9.3OCLT52Activity TypesBusiness Partners
54Business One9.3OCOG72Commission GroupsBusiness Partners
55Business One9.3OCPN271CampaignBusiness Partners
56Business One9.3OCPR502Contact PersonsBusiness Partners
57Business One9.3OCQG42Card PropertiesBusiness Partners
58Business One9.3OCRB462BP - Bank AccountBusiness Partners
59Business One9.3OCRD36711Business PartnerBusiness Partners
60Business One9.3OCRG93Card GroupsBusiness Partners
61Business One9.3OCRW82BP for IIS AnnualBusiness Partners
62Business One9.3ODDT122Withholding Tax Deduction HierarchyBusiness Partners
63Business One9.3ODUN81Dunning LettersBusiness Partners
64Business One9.3OEGP61E-Mail GroupBusiness Partners
65Business One9.3OOAT532Blanket AgreementBusiness Partners
66Business One9.3OPRT82PartnersBusiness Partners
67Business One9.3ORPT31Response TypeBusiness Partners
68Business One9.3OSCN85Customer/Vendor Cat. No.Business Partners
69Business One9.3OSLP153Sales EmployeeBusiness Partners
70Business One9.3OTBP161Target Group Business PartnerBusiness Partners
71Business One9.3OTER53TerritoriesBusiness Partners
72Business One9.3OTGG31Target GroupBusiness Partners
73Business One9.3OVTP42Vendor TypeBusiness Partners
74Business One9.3TGG1321Target Group DetailsBusiness Partners
75Business One9.3USR641User Branch AssignmentBusiness Partners
76Business One9.3WTD3122WTax Codes Details for BPBusiness Partners
77Business One9.3WTD492WTax Codes Details for ItemBusiness Partners
78Business One9.3WTD592WTax Codes Details for FreightBusiness Partners