SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

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