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

76 columns | Print definition?B1 9.3  | ATCENTRY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1APJ1Project Plan Steps18AtcEntryAttachment EntryInt110
2AWLSWorkflow - Task Details28AtcEntryAttachment EntryInt110
3OALRAlerts13AtcEntryAttachment EntryInt110
4OPCIProcess Checklist Instance12AtcEntryAttachment EntryInt110
5OWLSWorkflow - Task Details28AtcEntryAttachment EntryInt110
6PJT1Project Plan Steps18AtcEntryAttachment EntryInt110
TOPBusiness Partners
7ACLGActivities - History54AtcEntryAttachment EntryInt110
8ACPNCampaign12AtcEntryAttachment EntryInt110
9ACRDBusiness Partners - History303AtcEntryAttachment EntryInt110
10OCLGActivities54AtcEntryAttachment EntryInt110
11OCPNCampaign12AtcEntryAttachment EntryInt110
12OCRDBusiness Partner303AtcEntryAttachment EntryInt110
TOPGeneral
13APH1Project Management - Stages - History31AtcEntryAttachment EntryInt110
14APM1Project Management - Stages - History31AtcEntryAttachment EntryInt110
15APMGProject Management Document - History24AtcEntryAttachment EntryInt110
16ARSCResource Master Data - Log111AtcEntryAttachment EntryInt110
17OPMGProject Management Document24AtcEntryAttachment EntryInt110
18ORSCResources111AtcEntryAttachment EntryInt110
19PHA1Project Management - Stages31AtcEntryAttachment EntryInt110
20PMG1Project Management - Stages31AtcEntryAttachment EntryInt110
TOPHuman Resources
21AHEMEmployees - History62AtcEntryAttachment EntryInt110
22OHEMEmployees62AtcEntryAttachment EntryInt110
TOPInventory and Production
23AITMItems - History259AtcEntryAttachment EntryInt110
24OIGEGoods Issue314AtcEntryAttachment EntryInt110
25OIGNGoods Receipt314AtcEntryAttachment EntryInt110
26OIPFLanded Costs61AtcEntryAttachment EntryInt110
27OITMItems259AtcEntryAttachment EntryInt110
28OWTQInventory Transfer Request314AtcEntryAttachment EntryInt110
29OWTRInventory Transfer314AtcEntryAttachment EntryInt110
30SITMItems259AtcEntryAttachment EntryInt110
31UITMItems259AtcEntryAttachment EntryInt110
TOPMarketing Documents
32ADOCInvoice - History314AtcEntryAttachment EntryInt110
33ATROTransportation Document - History12AtcEntryAttachment EntryInt110
34ATXITax Invoice - History36AtcEntryAttachment EntryInt110
35OCINA/R Correction Invoice314AtcEntryAttachment EntryInt110
36OCPIA/P Correction Invoice314AtcEntryAttachment EntryInt110
37OCPVA/P Correction Invoice Reversal314AtcEntryAttachment EntryInt110
38OCSIA/R Correction Invoice314AtcEntryAttachment EntryInt110
39OCSVA/R Correction Invoice Reversal314AtcEntryAttachment EntryInt110
40ODLNDelivery314AtcEntryAttachment EntryInt110
41ODPIA/R Down Payment314AtcEntryAttachment EntryInt110
42ODPOA/P Down Payment314AtcEntryAttachment EntryInt110
43ODRFDrafts314AtcEntryAttachment EntryInt110
44OIEIIncoming Excise Invoice314AtcEntryAttachment EntryInt110
45OINVA/R Invoice314AtcEntryAttachment EntryInt110
46OOEIOutgoing Excise Invoice314AtcEntryAttachment EntryInt110
47OPCHA/P Invoice314AtcEntryAttachment EntryInt110
48OPDNGoods Receipt PO314AtcEntryAttachment EntryInt110
49OPORPurchase Order314AtcEntryAttachment EntryInt110
50OPQTPurchase Quotation314AtcEntryAttachment EntryInt110
51OPRQPurchase Request314AtcEntryAttachment EntryInt110
52OPRRGoods Return Request314AtcEntryAttachment EntryInt110
53OQUTSales Quotation314AtcEntryAttachment EntryInt110
54ORDNReturns314AtcEntryAttachment EntryInt110
55ORDRSales Order314AtcEntryAttachment EntryInt110
56ORINA/R Credit Memo314AtcEntryAttachment EntryInt110
57ORPCA/P Credit Memo314AtcEntryAttachment EntryInt110
58ORPDGoods Return314AtcEntryAttachment EntryInt110
59ORRRReturn Request314AtcEntryAttachment EntryInt110
60OSFCSelf Credit Memo314AtcEntryAttachment EntryInt110
61OSFISelf Invoice314AtcEntryAttachment EntryInt110
62OTPIPurchase Tax Invoice36AtcEntryAttachment EntryInt110
63OTROTransportation Document12AtcEntryAttachment EntryInt110
64OTSISales Tax Invoice36AtcEntryAttachment EntryInt110
65OTXDTax Invoice Draft36AtcEntryAttachment EntryInt110
TOPReports
66OEMLE-mail Log14AtcEntryAttachment EntryInt110
TOPSales Opportunities
67AOPROpportunity50AtcEntryAttachment EntryInt110
68OOPROpportunity50AtcEntryAttachment EntryInt110
TOPService
69ACTRService Contracts58AtcEntryAttachment EntryInt110
70AINSCustomer Equipment Card - History48AtcEntryAttachment EntryInt110
71ASCLHistory86AtcEntryAttachment EntryInt110
72OCTRService Contracts58AtcEntryAttachment EntryInt110
73OCTTContract Template42AtcEntryAttachment EntryInt110
74OINSCustomer Equipment Card48AtcEntryAttachment EntryInt110
75OSCLService Calls86AtcEntryAttachment EntryInt110
76OSLTService Call Solutions14AtcEntryAttachment EntryInt110