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

123 columns | Print definition?B1 9.3  | 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
12ABOEBill of Exchange for Payment - History89BPLIdBranchInt110
13ACHOChecks for Payment - History50BPLIdBranchInt110
14ARCTIncoming Payment - History166BPLIdBranchInt110
15BNK2Bank Statement - Recommendation List28BPLIdBranch IDInt110
16BOT1Bill of Exchange Transactions11BPLIdBranchInt110
17OBOEBill of Exchange for Payment89BPLIdBranchInt110
18OCHDChecks for Payment Drafts50BPLIdBranchInt110
19OCHOChecks for Payment50BPLIdBranchInt110
20ODPSDeposit63BPLIdBranchInt110
21OITRInternal Reconciliation24BPLIdBranchInt110
22OPDFPayment Draft166BPLIdBranchInt110
23OPWZPayment Wizard57BPLIdActive BranchInt110
24ORCTIncoming Payment166BPLIdBranchInt110
25OVPMOutgoing Payments166BPLIdBranchInt110
26PWZ3Payment Wizard - Rows 3123BPLIdBranchInt110
27PWZ5Payment Wizard - Rows 519BPLIdBranchInt110
TOPBusiness Partners
28ABPLBusiness Place1BPLIdBranch IDInt110
29CRD8BP Branch Assignment2BPLIdAssigned BranchInt110
30OBPLBusiness Place1BPLIdBranch IDInt110
31USR6User Branch Assignment2BPLIdAssigned BranchInt110
TOPFinance
32AACSAsset Classes - History12BPLIdBranchInt110
33AACTG/L Account - History107BPLIdAssigned BranchInt110
34AFADAsset Document - History38BPLIdBranchInt110
35AJD1Journal Entry - History - Rows118BPLIdBranchInt110
36BTF1Journal Voucher - Rows118BPLIdBranchInt110
37JDT1Journal Entry - Rows118BPLIdBranchInt110
38OACDCredit Memo38BPLIdBranchInt110
39OACQCapitalization38BPLIdBranchInt110
40OACSAsset Classes12BPLIdBranchInt110
41OACTG/L Accounts107BPLIdAssigned BranchInt110
42OFARFixed Asset Revaluation14BPLIdBranchInt110
43OFTRTransfer38BPLIdBranchInt110
44OMDPManual Depreciation38BPLIdBranchInt110
45ORTIRetirement38BPLIdBranchInt110
46ORTMRate Differences16BPLIdBranchInt110
47OVRWVAT Reposting Wizard15BPLIdThis field is not used anymoreInt110
48OWTAWithholding Tax Accumulation8BPLIdBranchInt1100
49RCR1Recurring Postings - Rows28BPLIdBranchInt110
50RTM1Rate Differences - Rows18BPLIdBranchInt110
51VRW2VAT Reposting Wizard - Rows 216BPLIdBranchInt110
TOPGeneral
52APMGProject Management Document - History23BPLidBusiness Place IDInt110
53OBTABrazil - Tax Adjustment42BPLIdBranch IDInt110
54OPMGProject Management Document23BPLidBusiness Place IDInt110
55OPTIPoint of Issue8BPLIdBranchInt110
TOPHuman Resources
56AHEMEmployees - History116BPLIdBranchInt110
57HEM10Employee Branch Assignment2BPLIdAssigned BranchInt110
58OHEMEmployees116BPLIdBranchInt110
TOPInventory and Production
59AINCInventory Counting23BPLIdBranchInt110
60AIQIInventory Opening Balance30BPLIdBranchInt110
61AIQRInventory Posting31BPLIdBranchInt110
62AWHSWarehouses - History67BPLidBusiness Place IDInt110
63OICDInventory Counting Draft23BPLIdBranchInt110
64OIGEGoods Issue166BPLIdBranchInt110
65OIGNGoods Receipt166BPLIdBranchInt110
66OINCInventory Counting23BPLIdBranchInt110
67OIODInventory Opening Balance Draft30BPLIdBranchInt110
68OIPDInventory Posting Draft31BPLIdBranchInt110
69OIPFLanded Costs63BPLIdBranchInt110
70OIQIInventory Opening Balance30BPLIdBranchInt110
71OIQRInventory Posting31BPLIdBranchInt110
72OWHSWarehouses67BPLidBusiness Place IDInt110
73OWTQInventory Transfer Request166BPLIdBranchInt110
74OWTRInventory Transfer166BPLIdBranchInt110
TOPMarketing Documents
75ADOCInvoice - History166BPLIdBranchInt110
76ATXITax Invoice - History42BPLIdBranchInt110
77DWZ2Dunning Wizard Array 2-Invoice Filter43BPLIdAssigned BranchInt110
78DWZ3Dunning Wizard Array 3 - Recommended Service Invoice21BPLIdBPL ID Assigned to InvoiceInt110
79DWZ4Dunning Wizard Array 4-Paging Grid51BPLIdBranch IDInt110
80DWZ5Dunning Wizard Array 5-Selected Branches2BPLIdAssigned BranchInt110
81OCINA/R Correction Invoice166BPLIdBranchInt110
82OCPIA/P Correction Invoice166BPLIdBranchInt110
83OCPVA/P Correction Invoice Reversal166BPLIdBranchInt110
84OCSIA/R Correction Invoice166BPLIdBranchInt110
85OCSVA/R Correction Invoice Reversal166BPLIdBranchInt110
86ODLNDelivery166BPLIdBranchInt110
87ODPIA/R Down Payment166BPLIdBranchInt110
88ODPOA/P Down Payment166BPLIdBranchInt110
89ODRFDrafts166BPLIdBranchInt110
90ODWZDunning Wizard38BPLIdBPL ID Assigned to InvoiceInt110
91OIEIIncoming Excise Invoice166BPLIdBranchInt110
92OINVA/R Invoice166BPLIdBranchInt110
93OOEIOutgoing Excise Invoice166BPLIdBranchInt110
94OPCHA/P Invoice166BPLIdBranchInt110
95OPDNGoods Receipt PO166BPLIdBranchInt110
96OPORPurchase Order166BPLIdBranchInt110
97OPQTPurchase Quotation166BPLIdBranchInt110
98OPRQPurchase Request166BPLIdBranchInt110
99OPRRGoods Return Request166BPLIdBranchInt110
100OQUTSales Quotation166BPLIdBranchInt110
101ORDNReturns166BPLIdBranchInt110
102ORDRSales Order166BPLIdBranchInt110
103ORINA/R Credit Memo166BPLIdBranchInt110
104ORPCA/P Credit Memo166BPLIdBranchInt110
105ORPDGoods Return166BPLIdBranchInt110
106ORRRReturn Request166BPLIdBranchInt110
107OSFCSelf Credit Memo166BPLIdBranchInt110
108OSFISelf Invoice166BPLIdBranchInt110
109OTPIPurchase Tax Invoice42BPLIdBranchInt110
110OTSISales Tax Invoice42BPLIdBranchInt110
111OTXDTax Invoice Draft42BPLIdBranchInt110
112PWZ7Payment Wizard 7-Selected Branches2BPLIdAssigned BranchInt110
113VRT2Tax Invoice Report Grid Info3BPLIdBusiness Place IDInt110
114VRW4VAT Reposting Wizard Array 4-Selected Branches2BPLIdAssigned BranchInt110
TOPMRP
115ORCMRecommendation Data18BPLidBusiness Place IDInt110-1
TOPReports
116AEC1Parameters for Various Types of Electronic Communication4BPLIdBranch IDInt110-1
117AEC2Electronic Transactions10BPLIdBranch IDInt110-1
118ECM1Parameters for Various Types of Electronic Communication4BPLIdBranch IDInt110-1
119ECM2Electronic Transactions10BPLIdBranch IDInt110-1
120OSRTKorean Summary Report4BPLIdBusiness Place IDInt110
121OTRBTax Report Wizard for Brazil2BPLIdBranch IDInt110
122SOI2Statement of Import - Branches2BPLIdAssigned BranchInt110
123SOI3Statement of Import - Invoices19BPLIdBranchInt110