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

41 columns | Print definition?ERP 6.0  | COKEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_05_COKEYTDMS Fill Header table for COKEY3COKEYChar 36 for TDMS Fill Headernvarchar360
2CNVTDMS_05_DFKCFI-CA correspondence Header TDMS for ISU4COKEYChar 36 for TDMS Fill Headernvarchar360
3CNVTDMS_05_DFKKHFill Header table for DFKK*4COKEYChar 36 for TDMS Fill Headernvarchar360
4DFKKPRNHSEPA: Direct Debit Pre-Notifications (FI-CA)20COKEYCorrespondence keynvarchar360
5HRPAD530Additional Data for PAD53019COKEYCorrespondence keynvarchar360
6PIQPROC_ADM_DTActivity Document: Admission Detailed Data22COKEYCorrespondence keynvarchar360
TOPClaims Management
7ICLDOCDocument to be Sent in Claim16COKEYCorrespondence keynvarchar360
8ICSDOCDocument in Claim16COKEYCorrespondence keynvarchar360
TOPContract Accounts Receivable and Payable
9DFKKCFDUNTELTelephone List for Dunning26COKEYCorrespondence keynvarchar360
10DFKKCOMACorrespondence Dunning4COKEYCorrespondence keynvarchar360
11DFKKCOMAKTCorrespondence Dunning Activities4COKEYCorrespondence keynvarchar360
12DFKKCRDELESCHACheck Register: Escheatment Data: Correspondence7COKEYCorrespondence keynvarchar360
13DFKKCRESCHACheck Register: Escheatment Data: Correspondence4COKEYCorrespondence keynvarchar360
14DFKKDDADebit Memo Notification15COKEYCorrespondence keynvarchar360
15DFKKDOC_CONFKKDMS: Links Between Application Objects and Documents7COKEYCorrespondence keynvarchar360
16DFKKWLI_CORRCorrespondence - Not Used - Attachm. Stored in DFKKDOC_CON10COKEYCorrespondence keynvarchar360
17DFKKWRTOFF_WFFI-CA Data for Write-Off in Workflow23COKEYCO Account Assignment Keynvarchar100
18FKKMAKODunning History Header62COKEYCorrespondence keynvarchar360
19TE761_COKEYControl CO-PA Posting Acc. to Consumption Months per COKEY2COKEYCO account assignment key, IS-U contractnvarchar100
20TECODIS-U: CO account assignment key / allocation2COKEYCO account assignment key, IS-U contractnvarchar100
21TECOKCO account assignment key IS-U contract2COKEYCO account assignment key, IS-U contractnvarchar100
22TECOKTIS-U: CO account assignment key (name)3COKEYCO account assignment key, IS-U contractnvarchar100
23TFK020BShort Account Assignments for Transfer Postings to Cash Desk7COKEYCO Account Assignment Keynvarchar100
24TFK020CShort Acct Assignments for Write-Offs from Clarif. Worklist6COKEYCO Account Assignment Keynvarchar100
25TFK020KShort Account Assignments for Transfer Postings7COKEYCO Account Assignment Keynvarchar100
26TFKCODFI-CA: CO Account Assignment Key/Allocation2COKEYCO Account Assignment Keynvarchar100
27TFKCOKFI-CA: CO Account Assignment Key2COKEYCO Account Assignment Keynvarchar100
28TFKCOTFI-CA: CO Account Assignment Key (Name)3COKEYCO Account Assignment Keynvarchar100
TOPCorrespondence Tool
29DFKKCODCorrespondence - Correspondence Data3COKEYCorrespondence keynvarchar360
30DFKKCODCLUSTCorrespondence - Correspondence Cluster Data3COKEYCorrespondence keynvarchar360
31DFKKCOHCorrespondence - Correspondence Header3COKEYCorrespondence keynvarchar360
32DFKKCOHARCSAP ArchiveLink - Object Identifiers2COKEYCorrespondence keynvarchar360
33DFKKCOHICorrespondence - Correspondence History5COKEYCorrespondence keynvarchar360
34DFKKCOHINCORRCorrespondence - Data for Inbound Correspondence2COKEYCorrespondence keynvarchar360
35DFKKCOH_ARCFI-CA Correspondence - Correspondence Header3COKEYCorrespondence keynvarchar360
36DFKKCOPCorrespondence - Document Part List2COKEYCorrespondence keynvarchar360
TOPIncentive and Commission Management ICM
37CACS_DFKKCOH_REFReference Table Between ICM Corresp.Container and Corr.Cont.3COKEYCorrespondence Key in Correspondence Containernvarchar360
TOPInvoicing
38EABPJVL_CORRCorrespondence Print: Bud. Bill. Plan Header and YAP Info.2COKEYCorrespondence keynvarchar360
39EABPS_CORRSub Budget Billing Plan for Correspondence Print2COKEYCorrespondence keynvarchar360
TOPMaster Data
40EVERIS-U Cont.65COKEYCO account assignment key, IS-U contractnvarchar100
TOPRepetitive Manufacturing
41T437XCost Collector Strategy4COKEYSearch logic for cost collectornvarchar20