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
3OPCH268A/P Invoice
4OIVL77Whse Journal
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

104 columns | Print definition?B1 9.2  | BPLID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ABP1Business Place Tax IDs1BPLIdBPL IDInt110
2ABP2Branch Tributary Info. Log1BPLIdBPL IDInt110
3BPL1Branch I.E. Numbers1BPLIdBPL IDInt110
4BPL2Branch Tributary Info.1BPLIdBPL IDInt110
5DGP4Business Place List3BPLIdBusiness Place IDInt110
6GPC1Authority Assignment2BPLIdBranchInt110
7NFN1Not a Fiscal Sequence21BPLIdAssigned BranchInt1100
8NNM1Documents Numbering - Series23BPLIdAssigned BranchInt110
9ODGPDocument Generation Parameter Sets54BPLIdBranchInt110
10OPQWPurchase Quotation Generation: Parameter Sets10BPLIdBranchInt110
11OUDGUser Defaults33BPLIdDefault BranchInt110
TOPBanking
12ACHOChecks for Payment - History50BPLIdBranchInt110
13ARCTIncoming Payment - History166BPLIdBranchInt110
14BNK2Bank Statement - Recommendation List28BPLIdBranch IDInt110
15OCHDChecks for Payment Drafts50BPLIdBranchInt110
16OCHOChecks for Payment50BPLIdBranchInt110
17ODPSDeposit63BPLIdBranchInt110
18OITRInternal Reconciliation24BPLIdBranchInt110
19OPDFPayment Draft166BPLIdBranchInt110
20OPWZPayment Wizard57BPLIdActive BranchInt110
21ORCTIncoming Payment166BPLIdBranchInt110
22OVPMOutgoing Payments166BPLIdBranchInt110
23PWZ3Payment Wizard - Rows 3123BPLIdBranchInt110
24PWZ5Payment Wizard - Rows 519BPLIdBranchInt110
TOPBusiness Partners
25ABPLBusiness Place1BPLIdBranch IDInt110
26CRD8BP Branch Assignment2BPLIdAssigned BranchInt110
27OBPLBusiness Place1BPLIdBranch IDInt110
28USR6User Branch Assignment2BPLIdAssigned BranchInt110
TOPFinance
29AACSAsset Classes - History12BPLIdBranchInt110
30AACTG/L Account - History107BPLIdAssigned BranchInt110
31AFADAsset Document - History38BPLIdBranchInt110
32AJD1Journal Entry - History - Rows118BPLIdBranchInt110
33BTF1Journal Voucher - Rows118BPLIdBranchInt110
34JDT1Journal Entry - Rows118BPLIdBranchInt110
35OACDCredit Memo38BPLIdBranchInt110
36OACQCapitalization38BPLIdBranchInt110
37OACSAsset Classes12BPLIdBranchInt110
38OACTG/L Accounts107BPLIdAssigned BranchInt110
39OFARFixed Asset Revaluation14BPLIdBranchInt110
40OFTRTransfer38BPLIdBranchInt110
41OMDPManual Depreciation38BPLIdBranchInt110
42ORTIRetirement38BPLIdBranchInt110
43ORTMRate Differences16BPLIdBranchInt110
44OVRWVAT Reposting Wizard15BPLIdActive BranchInt110
45RCR1Recurring Postings - Rows28BPLIdBranchInt110
46RTM1Rate Differences - Rows18BPLIdBranchInt110
47VRW2VAT Reposting Wizard - Rows 216BPLIdBranchInt110
TOPGeneral
48OBTABrazil - Tax Adjustment42BPLIdBranch IDInt110
49OPTIPoint of Issue8BPLIdBranchInt110
TOPHuman Resources
50AHEMEmployees116BPLIdBranchInt110
51OHEMEmployees116BPLIdBranchInt110
TOPInventory and Production
52AINCInventory Counting23BPLIdBranchInt110
53AIQIInventory Opening Balance30BPLIdBranchInt110
54AIQRInventory Posting31BPLIdBranchInt110
55AWHSWarehouses - History67BPLidBusiness Place IDInt110
56OICDInventory Counting Draft23BPLIdBranchInt110
57OIGEGoods Issue166BPLIdBranchInt110
58OIGNGoods Receipt166BPLIdBranchInt110
59OINCInventory Counting23BPLIdBranchInt110
60OIODInventory Opening Balance Draft30BPLIdBranchInt110
61OIPDInventory Posting Draft31BPLIdBranchInt110
62OIQIInventory Opening Balance30BPLIdBranchInt110
63OIQRInventory Posting31BPLIdBranchInt110
64OWHSWarehouses67BPLidBusiness Place IDInt110
65OWTQInventory Transfer Request166BPLIdBranchInt110
66OWTRInventory Transfer166BPLIdBranchInt110
TOPMarketing Documents
67ADOCInvoice - History166BPLIdBranchInt110
68ATXITax Invoice - History42BPLIdBranchInt110
69DWZ3Dunning Wizard Array 3 - Recommended Service Invoice21BPLIdBPL ID Assigned to InvoiceInt110
70OCINA/R Correction Invoice166BPLIdBranchInt110
71OCPIA/P Correction Invoice166BPLIdBranchInt110
72OCPVA/P Correction Invoice Reversal166BPLIdBranchInt110
73OCSIA/R Correction Invoice166BPLIdBranchInt110
74OCSVA/R Correction Invoice Reversal166BPLIdBranchInt110
75ODLNDelivery166BPLIdBranchInt110
76ODPIA/R Down Payment166BPLIdBranchInt110
77ODPOA/P Down Payment166BPLIdBranchInt110
78ODRFDrafts166BPLIdBranchInt110
79ODWZDunning Wizard38BPLIdBPL ID Assigned to InvoiceInt110
80OIEIIncoming Excise Invoice166BPLIdBranchInt110
81OINVA/R Invoice166BPLIdBranchInt110
82OOEIOutgoing Excise Invoice166BPLIdBranchInt110
83OPCHA/P Invoice166BPLIdBranchInt110
84OPDNGoods Receipt PO166BPLIdBranchInt110
85OPORPurchase Order166BPLIdBranchInt110
86OPQTPurchase Quotation166BPLIdBranchInt110
87OPRQPurchase Request166BPLIdBranchInt110
88OQUTSales Quotation166BPLIdBranchInt110
89ORDNReturns166BPLIdBranchInt110
90ORDRSales Order166BPLIdBranchInt110
91ORINA/R Credit Memo166BPLIdBranchInt110
92ORPCA/P Credit Memo166BPLIdBranchInt110
93ORPDGoods Return166BPLIdBranchInt110
94OTPIPurchase Tax Invoice42BPLIdBranchInt110
95OTSISales Tax Invoice42BPLIdBranchInt110
96OTXDTax Invoice Draft42BPLIdBranchInt110
97VRT2Tax Invoice Report Grid Info3BPLIdBusiness Place IDInt110
TOPMRP
98ORCMRecommendation Data18BPLidBusiness Place IDInt110-1
TOPReports
99AEC1Parameters for Various Types of Electronic Communication4BPLIdBranch IDInt110-1
100AEC2Electronic Transactions11BPLIdBranch IDInt110-1
101ECM1Parameters for Various Types of Electronic Communication4BPLIdBranch IDInt110-1
102ECM2Electronic Transactions11BPLIdBranch IDInt110-1
103OSRTKorean Summary Report4BPLIdBusiness Place IDInt110
104OTRBTax Report Wizard for Brazil2BPLIdBranch IDInt110