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

57 columns | Print definition?B1 8.82  | BPLID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ABP1Business Place Tax IDs1BPLIdBPL IDInt110
2BPL1Business Place Tax IDs1BPLIdBPL IDInt110
3DGP4Business Place List3BPLIdBusiness Place IDInt110
4NFN1Not a Fiscal Sequence21BPLIdAssigned BranchInt1100
5NNM1Documents Numbering - Series23BPLIdAssigned BranchInt110
6OUDGUser Defaults33BPLIdDefault BranchInt110
TOPBanking
7ARCTIncoming Payment - History166BPLIdBranchInt110
8OITRInternal Reconciliation24BPLIdBranchInt110
9OPDFPayment Draft166BPLIdBranchInt110
10OPWZPayment Wizard57BPLIdActive BranchInt110
11ORCTIncoming Payment166BPLIdBranchInt110
12OVPMOutgoing Payments166BPLIdBranchInt110
TOPBusiness Partners
13ABPLBusiness Place1BPLIdBranch IDInt110
14CRD8BP Branch Assignment2BPLIdAssigned BranchInt110
15OBPLBusiness Place1BPLIdBranch IDInt110
TOPFinance
16AACTG/L Account - History106BPLIdAssigned BranchInt110
17AJD1Journal Entry - History - Rows118BPLIdBranchInt110
18BTF1Journal Voucher 118BPLIdBranchInt110
19JDT1Journal Entry - Rows118BPLIdBranchInt110
20OACTG/L Accounts106BPLIdAssigned BranchInt110
TOPHuman Resources
21AHEMEmployees116BPLidBusiness Place IDInt110
22OHEMEmployees116BPLidBusiness Place IDInt110
TOPInventory and Production
23AWHSWarehouses - History67BPLidBusiness Place IDInt110
24OIGEGoods Issue166BPLIdBranchInt110
25OIGNGoods Receipt166BPLIdBranchInt110
26OWHSWarehouses67BPLidBusiness Place IDInt110
27OWTQInventory Transfer Request166BPLIdBranchInt110
28OWTRInventory Transfer166BPLIdBranchInt110
TOPMarketing Documents
29ADOCInvoice - History166BPLIdBranchInt110
30DWZ3Dunning Wizard Array 3 - Recommended Service Invoice21BPLIdBPL ID Assigned to InvoiceInt110
31OCINA/R Correction Invoice166BPLIdBranchInt110
32OCPIA/P Correction Invoice166BPLIdBranchInt110
33OCPVA/P Correction Invoice Reversal166BPLIdBranchInt110
34OCSIA/R Correction Invoice166BPLIdBranchInt110
35OCSVA/R Correction Invoice Reversal166BPLIdBranchInt110
36ODLNDelivery166BPLIdBranchInt110
37ODPIA/R Down Payment166BPLIdBranchInt110
38ODPOA/P Down Payment166BPLIdBranchInt110
39ODRFDrafts166BPLIdBranchInt110
40ODWZDunning Wizard38BPLIdBPL ID Assigned to InvoiceInt110
41OIEIIncoming Excise Invoice166BPLIdBranchInt110
42OINVA/R Invoice166BPLIdBranchInt110
43OOEIOutgoing Excise Invoice166BPLIdBranchInt110
44OPCHA/P Invoice166BPLIdBranchInt110
45OPDNGoods Receipt PO166BPLIdBranchInt110
46OPORPurchase Order166BPLIdBranchInt110
47OPQTPurchase Quotation166BPLIdBranchInt110
48OQUTSales Quotation166BPLIdBranchInt110
49ORDNReturns166BPLIdBranchInt110
50ORDRSales Order166BPLIdBranchInt110
51ORINA/R Credit Memo166BPLIdBranchInt110
52ORPCA/P Credit Memo166BPLIdBranchInt110
53ORPDGoods Return166BPLIdBranchInt110
54VRT2Tax Invoice Report Grid Info3BPLIdBusiness Place IDInt110
TOPMRP
55ORCMRecommendation Data18BPLidBusiness Place IDInt110-1
TOPReports
56OSRTKorean Summary Report4BPLIdBusiness Place IDInt110
TOPService
57USR6User Branch Assignment2BPLIdAssigned BranchInt110