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

34 columns | Print definition?ERP 6.0  | KEYZ1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKPDCFI-CA: Postdated Checks13KEYZ1Payment Lotnvarchar120
2DFKK_TRIGX_PAYOutbound Interface: New Trigger Table for Payment Info11KEYZ1Payment Lotnvarchar120
TOPCollectionsDisbursements
3ITAGCYBNKTRTRIGGTrigger Table Bank Deposits for Agencies2KEYZ1Payment Lotnvarchar120
4VVKKKDTRIGTrigger for Cust. Field Check DME Media2KEYZ1Payment Lotnvarchar120
TOPContract Accounts Receivable and Payable
5DFK006BNote to Payee - Texts19KEYZ1Payment Lotnvarchar120
6DFK006BXNote to Payee - Texts19KEYZ1Payment Lotnvarchar120
7DFK006ENote to Payee - Accounts12KEYZ1Payment Lotnvarchar120
8DFK006EXNote to Payee - Accounts New10KEYZ1Payment Lotnvarchar120
9DFKKCDLOTSLot Management for Cash Desk and External Cash Desk Services2KEYZ1Payment Lotnvarchar120
10DFKKCFZSTClarification Cases from Payment Lot2KEYZ1Payment Lotnvarchar120
11DFKKCJTTransaction Data for Cash Journal13KEYZ1Cash Journal: Number of Special Posting Documentnvarchar120
12DFKKCOLLPAYMLINKAssignment of Collection Payments to Collection Units16KEYZ1Payment Lotnvarchar120
13DFKKEXCExternal Payment Information26KEYZ1Payment Lotnvarchar120
14DFKKZFPayment lot: Reconciliation key2KEYZ1Payment Lotnvarchar120
15DFKKZKPayment lot: Header data2KEYZ1Payment Lotnvarchar120
16DFKKZNPayment Lot: Notes for Clarification2KEYZ1Payment Lotnvarchar120
17DFKKZPPayment lot: Data for payment2KEYZ1Payment Lotnvarchar120
18DFKKZPEPayment lot: Error message for payment item2KEYZ1Payment Lotnvarchar120
19DFKKZPTPayment Lot: Data for Partial Clearing of a Payment2KEYZ1Payment Lotnvarchar120
20DFKKZP_ARCINDLink between Document Number and Archived Payment Lot3KEYZ1Payment Lotnvarchar120
21DFKKZSPayment lot: Further selections2KEYZ1Payment Lotnvarchar120
22DFKKZVPayment Lot: Enhancement of Note to Payee2KEYZ1Payment Lotnvarchar120
23DFKK_TRIGGER_PAYOutbound Interface: Trigger Table for Payment Information10KEYZ1Payment Lotnvarchar120
24FKKBSTMVAcct Statement Transfer: Admin. Records10KEYZ1Last Payment Lot to Which Data was Transferred (Restart)nvarchar120
TOPIntercompany Data Exchange
25IUEEDPPLOTATHEADDistribution Lot Header2KEYZ1Distribution Lotnvarchar120
26IUEEDPPLOTATREFDistr. Aggr. Payments: Ref. btwn MR and Distributed Objects2KEYZ1Payment Lotnvarchar120
27IUEEDPPLOTATREF1Distr. Aggr. Payments: Ref. Between Pymt St. and Aggr. Pymt2KEYZ1Payment Lotnvarchar120
28IUEEDPPLOTATREF2Distribution of Aggr. Payments: Special Distribution Lot2KEYZ1Distribution Lotnvarchar120
TOPLease Accounting
29/LSIERP/TQ_P_DETPayment Details and Test Results for Cost Estimate2KEYZ1Payment Lotnvarchar120
30/LSIERP/TQ_P_HDRPayment Status2KEYZ1Payment Lotnvarchar120
TOPMedia Sales and Distribution
31/NAM/PAY_CCWorkload for Credit Card Payment11KEYZ1Payment Lotnvarchar120
32/NAM/PAY_CHWorkload for Check Payments11KEYZ1Payment Lotnvarchar120
33/NAM/PAY_LKWorkload for Lockbox kick-outs11KEYZ1Payment Lotnvarchar120
TOPProduction Orders
34T496ZCIM order: Table-controlled table access7KEYZ1Field Namenvarchar100