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

110 columns | Print definition?B1 9.3  | TRANSFERED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ABOEBill of Exchange for Payment - History39TransferedTransferred to next yearVarChar10NN=No, Y=Yes
2ACHOChecks for Payment - History40TransferedTransferred to Next YearVarChar10NN=No, Y=Yes
3OBOEBill of Exchange for Payment39TransferedTransferred to next yearVarChar10NN=No, Y=Yes
4OCHDChecks for Payment Drafts40TransferedTransferred to next yearVarChar10NN=No, Y=Yes
5OCHHCheck Register24TransferedPostponed to Next YearVarChar10NN=No, Y=Yes
6OCHOChecks for Payment40TransferedTransferred to next yearVarChar10NN=No, Y=Yes
7OCRHCredit Card Management32TransferedPostponed to Next YearVarChar10NN=No, Y=Yes
8OCRVCredit Payments24TransferedPostponed to Next YearVarChar10NN=No, Y=Yes
9ODPSDeposit25TransferedYear TransferVarChar10NN=No, Y=Yes
TOPBusiness Partners
10ACLGActivities - History13TransferedTransferred to Next YearVarChar10NN=No, Y=Yes
11ACPNCampaign20TransferedYear TransferVarChar10N
12ACRDBusiness Partners - History36TransferedYear TransferVarChar10NN=No, Y=Yes
13AOATBlanket Agreement25TransferedYear TransferVarChar10NN=No, Y=Yes
14OCLGActivities13TransferedTransfered to Next YearVarChar10NN=No, Y=Yes
15OCPNCampaign20TransferedYear TransferVarChar10NN=No, Y=Yes
16OCRDBusiness Partner36TransferedYear TransferVarChar10NN=No, Y=Yes
17OOATBlanket Agreement25TransferedYear TransferVarChar10NN=No, Y=Yes
18OSCNCustomer/Vendor Cat. No.4TransferedPostponed to Next YearVarChar10NN=No, Y=Yes
TOPFinance
19AACTG/L Account - History25TransferedYear Transferred [Y/N]VarChar10NN=No, Y=Yes
20AGARG/L Account Advanced Rules - History29TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
21OACTG/L Accounts25TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
22OGARG/L Account Advanced Rules29TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
TOPGeneral
23AGRSG/L Account Advanced Rules for Resources - History29TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
24AHF1Hide Functions Configuration - Rows History12TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
25AHF2Hide Function Configuration - Rows History8TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
26AHFCHide Functions Configuration - History7TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
27HFC1Hide Function Configuration - Rows12TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
28HFC2Hide Function Configuration - Rows8TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
29OGRSG/L Account Advanced Rules for Resources29TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
30OHFCHide Functions Configuration7TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
TOPHuman Resources
31HET1Employee Transfer Details3TransferedTimestamp: Status "Sent"Date80
TOPInventory and Production
32ABATAttribute - History6TransferedYear Transfer [Y/N]VarChar10N
33ABFCBin Field Configuration - History8TransferedYear Transfer [Y/N]VarChar10N
34ABINBin Location - History46TransferedYear Transfer [Y/N]VarChar10N
35ABSLWarehouse Sublevel - History7TransferedYear Transfer [Y/N]VarChar10N
36ABTNBatch Numbers Master Data17TransferedTransferredVarChar10NN=No, Y=Yes
37ABTWBatch Attributes in Location7TransferedTransferredVarChar10NN=No, Y=Yes
38AITMItems - History45TransferedYear Transferred [Y/N]VarChar10NN=No, Y=Yes
39AITTProduct Tree - History7TransferedPostponed to Next YearVarChar10NN=No, Y=Yes
40ASRNSerial Numbers Master Data17TransferedTransferredVarChar10NN=No, Y=Yes
41OBATBin Location Attribute6TransferedYear Transfer [Y/N]VarChar10N
42OBFCBin Field Configuration8TransferedYear Transfer [Y/N]VarChar10N
43OBINBin Location46TransferedYear Transfer [Y/N]VarChar10N
44OBSLWarehouse Sublevel7TransferedYear Transfer [Y/N]VarChar10N
45OBTNBatch Numbers Master Data17TransferedTransferredVarChar10NN=No, Y=Yes
46OBTWBatch Attributes in Location7TransferedTransferredVarChar10NN=No, Y=Yes
47ODBNBat. Nos - Draft - Master Data17TransferedTransferredVarChar10NN=No, Y=Yes
48ODBWBatch Draft Attribs in Locat.7TransferedTransferredVarChar10NN=No, Y=Yes
49ODSNSNs - Draft - Master Data17TransferedTransferredVarChar10NN=No, Y=Yes
50ODSWSN Draft Attribs in Location7TransferedTransferredVarChar10NN=No, Y=Yes
51OIGEGoods Issue9TransferedYear TransferVarChar10NN=No, Y=Yes
52OIGNGoods Receipt9TransferedYear TransferVarChar10NN=No, Y=Yes
53OIPFLanded Costs40TransferedYear TransferVarChar10NN=No, Y=Yes
54OITLInventory Transactions Log28TransferedYear TranferVarChar10N
55OITMItems45TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
56OITTProduct Tree7TransferedPostponed to Next YearVarChar10NN=No, Y=Yes
57OMRLAdvanced Inventory Revaluation8TransferedYear TransferVarChar10NN=No, Y=Yes
58OSRNSerial Numbers Master Data17TransferedTransferredVarChar10NN=No, Y=Yes
59OSRWSerial No. Attribs in Location7TransferedTransferredVarChar10NN=No, Y=Yes
60OWKOProduction Instructions20TransferedPostponed to Next YearVarChar10NN=No, Y=Yes
61OWTQInventory Transfer Request9TransferedYear TransferVarChar10NN=No, Y=Yes
62OWTRInventory Transfer9TransferedYear TransferVarChar10NN=No, Y=Yes
63SITMItems45TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
64UBTNBatch Numbers Master Data17TransferedTransferredVarChar10NN=No, Y=Yes
65UITMItems45TransferedYear Transfer [Y/N]VarChar10NN=No, Y=Yes
66USRNSerial Numbers Master Data17TransferedTransferredVarChar10NN=No, Y=Yes
67UWKOProduction Instructions20TransferedPostponed to Next YearVarChar10NN=No, Y=Yes
TOPMarketing Documents
68ADOCInvoice - History9TransferedYear TransferredVarChar10NN=No, Y=Yes
69ATXITax Invoice - History7TransferedYear TransferVarChar10NN=No, Y=Yes
70OCINA/R Correction Invoice9TransferedYear TransferVarChar10NN=No, Y=Yes
71OCPIA/P Correction Invoice9TransferedYear TransferVarChar10NN=No, Y=Yes
72OCPVA/P Correction Invoice Reversal9TransferedYear TransferVarChar10NN=No, Y=Yes
73OCSIA/R Correction Invoice9TransferedYear TransferVarChar10NN=No, Y=Yes
74OCSVA/R Correction Invoice Reversal9TransferedYear TransferVarChar10NN=No, Y=Yes
75ODLNDelivery9TransferedYear TransferVarChar10NN=No, Y=Yes
76ODPIA/R Down Payment9TransferedYear TransferVarChar10NN=No, Y=Yes
77ODPOA/P Down Payment9TransferedYear TransferVarChar10NN=No, Y=Yes
78ODRFDrafts9TransferedTransferredVarChar10NN=No, Y=Yes
79OIEIIncoming Excise Invoice9TransferedTransfer YearVarChar10NN=No, Y=Yes
80OINVA/R Invoice9TransferedYear TransferVarChar10NN=No, Y=Yes
81OOEIOutgoing Excise Invoice9TransferedTransfer YearVarChar10NN=No, Y=Yes
82OPCHA/P Invoice9TransferedTransfer YearVarChar10NN=No, Y=Yes
83OPDNGoods Receipt PO9TransferedYear TransferVarChar10NN=No, Y=Yes
84OPORPurchase Order9TransferedYear TransferVarChar10NN=No, Y=Yes
85OPQTPurchase Quotation9TransferedYear TransferVarChar10NN=No, Y=Yes
86OPRQPurchase Request9TransferedYear TransferVarChar10NN=No, Y=Yes
87OPRRGoods Return Request9TransferedYear TransferVarChar10NN=No, Y=Yes
88OQUTSales Quotation9TransferedYear TransferVarChar10NN=No, Y=Yes
89ORDNReturns9TransferedYear TransferVarChar10NN=No, Y=Yes
90ORDRSales Order9TransferedYear TransferVarChar10NN=No, Y=Yes
91ORINA/R Credit Memo9TransferedYear TransferVarChar10NN=No, Y=Yes
92ORPCA/P Credit Memo9TransferedYear TransferVarChar10NN=No, Y=Yes
93ORPDGoods Return9TransferedYear TransferVarChar10NN=No, Y=Yes
94ORRRReturn Request9TransferedYear TransferVarChar10NN=No, Y=Yes
95OSFCSelf Credit Memo9TransferedYear TransferVarChar10NN=No, Y=Yes
96OSFISelf Invoice9TransferedYear TransferVarChar10NN=No, Y=Yes
97OTPIPurchase Tax Invoice7TransferedYear TransferVarChar10NN=No, Y=Yes
98OTSISales Tax Invoice7TransferedYear TransferVarChar10NN=No, Y=Yes
99OTXDTax Invoice Draft7TransferedYear TransferVarChar10NN=No, Y=Yes
TOPSales Opportunities
100AOPROpportunity31TransferedTransferred to Next YearVarChar10NN=No, Y=Yes
101OOPROpportunity31TransferedTransferred to next yearVarChar10NN=No, Y=Yes
TOPService
102ACTRService Contracts59TransferedYear TransferVarChar10N
103AINSCustomer Equipment Card - History49TransferedYear TransferVarChar10N
104ASC4Service Call Travel/Labor Expenses - History14TransferedTransferedVarChar10YN=No, Y=Yes
105ASCLHistory57TransferedYear TransferVarChar10N
106OCTRService Contracts59TransferedYear TransferVarChar10N
107OINSCustomer Equipment Card49TransferedYear TransferVarChar10N
108OSCLService Calls57TransferedYear TransferVarChar10N
109OSLTService Call Solutions15TransferedYear TransferVarChar10N
110SCL4Expense Documents14TransferedTransferedVarChar10YN=No, Y=Yes