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

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OIVL77Whse Journal
4OPCH268A/P Invoice
5OVPM154Outgoing Payments
6ORCT154Incoming Payment
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9OBOT10Bill Of Exchang Transaction
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

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