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

51 columns | Print definition?ERP 6.0  | HERKF

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKEPRTLog for Inconsistent FI-CA Documents37HERKFDocument Origin Keynvarchar20
2DFKK_ACCADJAdjustment Postings when Implementing Acct Assgmt Chars12HERKFOrigin of Account Assignmentnvarchar10
3DFKK_NEWACCADJObsolete: See DFKK_ACCADJ12HERKFOrigin of Account Assignmentnvarchar10
4TFK007USTPDAllowed Origins for External Tax Interface per Document1HERKFDocument Origin Keynvarchar20
5TFK_DOCCLS_DETAssign Document Classes to Document Type sand Origin Keys4HERKFDocument Origin Keynvarchar20
6TFK_EXT_PROCTYPAssign customer extension Modules/Classes to Process Types4HERKFDocument Origin Keynvarchar20
7TFK_INT_PROCTYPAssign Countries to Process Types (internal only)3HERKFDocument Origin Keynvarchar20
TOPContract Accounts Receivable and Payable
8DFKKCMKManually Issued Checks Lot: Header Data6HERKFDocument Origin Keynvarchar20
9DFKKCMPManually Issued Checks Lot: Item Data11HERKFDocument Origin Keynvarchar20
10DFKKCRRepository For Checks2HERKFOrigin of Payment Informationnvarchar10
11DFKKCR2PCheck Repository: Additional Payees2HERKFOrigin of Payment Informationnvarchar10
12DFKKCRADDCR: Additional Information for Payment Medium2HERKFOrigin of Payment Informationnvarchar10
13DFKKCRCASHCR: Cashed Checks Not Yet Entered in Register2HERKFOrigin of Payment Informationnvarchar10
14DFKKCRCLTable for Checks To Be Clarified2HERKFOrigin of Payment Informationnvarchar10
15DFKKCRCL_DOCSTable for Checks To Be Clarified2HERKFOrigin of Payment Informationnvarchar10
16DFKKCRDELCR: Deleted Payment Medium / Basic Data2HERKFOrigin of Payment Informationnvarchar10
17DFKKCRDEL2PCR: Deleted Payment Medium / Payee Data2HERKFOrigin of Payment Informationnvarchar10
18DFKKCRDELADDCR: Deleted Payment Medium / Additional Data2HERKFOrigin of Payment Informationnvarchar10
19DFKKCRDELD2Check Register: Deleted Payment Media/Partial Encashments2HERKFOrigin of Payment Informationnvarchar10
20DFKKCRDELESCHCheck Register: Escheatment Data2HERKFOrigin of Payment Informationnvarchar10
21DFKKCRDOC2Check Management: Partial Encashments2HERKFOrigin of Payment Informationnvarchar10
22DFKKCRESCHCheck Register: Escheatment Data2HERKFOrigin of Payment Informationnvarchar10
23DFKKCRESCHCClarification Cases for Manual Escheatment Process2HERKFOrigin of Payment Informationnvarchar10
24DFKKCRFRecord of Creditworthiness: Fixed Interest Periods, Releases7HERKFOrigin of entry related to creditworthinessnvarchar20
25DFKKEXTTAXControl Table for Update of External Tax Systems10HERKFDocument Origin Keynvarchar20
26DFKKIP_GRPPayment Specification: Header Data42HERKFOrigin of Payment Specificationnvarchar20
27DFKKIP_GRPHPayment Specification: Payment Data (History)44HERKFOrigin of Payment Specificationnvarchar20
28DFKKKOHeader Data in Open Item Accounting Document6HERKFDocument Origin Keynvarchar20
29DFKKMKOHeader data for sample contract accounting document6HERKFDocument Origin Keynvarchar20
30DFKKRKReturns lot: Header data5HERKFDocument Origin Keynvarchar20
31DFKKTHITransfer Records for Invoice Issue by Third Party21HERKFDocument Origin Keynvarchar20
32DFKKTHPTransfer Records for Billing on Behalf of 3rd Party24HERKFDocument Origin Keynvarchar20
33DFKKWOHWrite-Off History15HERKFDocument Origin Keynvarchar20
34DFKKWOHTMPTemporary Write-Off History15HERKFDocument Origin Keynvarchar20
35DFKKZKPayment lot: Header data5HERKFDocument Origin Keynvarchar20
36IST_BTACTIS-T Disconnection Number: Disconnection Activity5HERKFDocument Origin Keynvarchar20
37IST_FILE_TELNRFile History of Payments/Dunning: Reconn./Disconn. Tel. No.4HERKFDocument Origin Keynvarchar20
38TEIISVORAssignment of Internal Transactions to Collective Bill Trans2HERKFDocument Origin Keynvarchar20
39TFK001Origin key1HERKFDocument Origin Keynvarchar20
40TFK001CUse of User-Specific Reconciliation Keys2HERKFOrigin key with reconciliation key for each usernvarchar20
41TFK001FReconciliation key per user3HERKFDocument Origin Keynvarchar20
42TFK001TOrigin key code2HERKFDocument Origin Keynvarchar20
43TFK005_MDOCResid.Time for Sample Documents Dependent on Document Origin2HERKFDocument Origin Keynvarchar20
44TFK005_MDOC_HRegistered Origins for Sample Document Archiving2HERKFDocument Origin Keynvarchar20
45TFK046BOrigin of an Entry Relating to Creditworthiness1HERKFOrigin of entry related to creditworthinessnvarchar20
46TFK046BTOrigin of an Entry Relating to Creditworthiness2HERKFOrigin of entry related to creditworthinessnvarchar20
47TFK090AMass Activity Types11HERKFDocument Origin Keynvarchar20
48TFK_EXTDOC_AR4Default Values for Branches in Argentina2HERKFDocument Origin Keynvarchar20
TOPPublic Sector Contract Accounts Receivable and Payable
49PS4SC_STATUS_RULSocial Services: Status - Message Document Rules5HERKFSocial Services: Origin Keynvarchar20
50PS4SD_STATUS_DOCSocial Services: Status - Trigger Table for Document Status6HERKFSocial Services: Origin Keynvarchar20
TOPSAP Credit Management
51DFKKCRPCreditworthiness Record: Generating Actions6HERKFOrigin of entry related to creditworthinessnvarchar20