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

31 columns | Print definition?ERP 6.0  | ACKEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPCollectionsDisbursements
1TKKVIACTProcessing Contracts w. Acct Bal. Int. Calc. - Activities4ACKEYActivitynvarchar40
2TKKVIACTDEFProcessing IO w. Acct Bal. Int. Calc. - Activity Definition2ACKEYActivitynvarchar40
3TKKVIACTDEFTCurr. Chge Acct Bal. Int. Calc. - Def. of Activities (Texts)3ACKEYActivitynvarchar40
4TVS010IIS-IS Scheduling: Assignment of Activities to Posting Event5ACKEYActivity With Payment Plan Postingnvarchar40
5TVS010JIS-IS Scheduling: Assignment of Activities to Change Event6ACKEYActivity When Changing a Payment Plan Itemnvarchar40
6TVS020DIS-IS Scheduling: Activities for Paymt Plan Change6ACKEYActivitynvarchar40
7TVS030AIS-IS Scheduling: Activity Definition for Paymt Plan Change2ACKEYActivitynvarchar40
8TVS030ATIS-IS Scheduling: Activity Definition for Paymt Plan Change3ACKEYActivitynvarchar40
9TVS030CIS-IS Scheduling: Activity Def. Payment Plan Posting Events2ACKEYActivity With Payment Plan Postingnvarchar40
10TVS030CTIS-IS Scheduling: Activity Def. Payment Plan Posting Events3ACKEYActivity With Payment Plan Postingnvarchar40
11TVS030EIS-IS Scheduling: Activity Def. Payment Plan Change Events2ACKEYActivity When Changing a Payment Plan Itemnvarchar40
12TVS030ETIS-IS Scheduling: Activity Def. Payment Plan Change Events3ACKEYActivity When Changing a Payment Plan Itemnvarchar40
TOPContract Accounts Receivable and Payable
13DFKKCOMAKTCorrespondence Dunning Activities6ACKEYActivitynvarchar40
14DFKKWLIWork Items22ACKEYActivitynvarchar40
15DFKKWLIAWork Items (Work Item Type)22ACKEYActivitynvarchar40
16FKKMACTIVITIESDunning Activities8ACKEYActivitynvarchar40
17TFK047LFI-CA Dunning: Definition of dunning activities2ACKEYActivitynvarchar40
18TFK047LTFI-CA Dunning: Definition of dunning activities (texts)3ACKEYActivitynvarchar40
19TFK047MFI-CA Dunning: Dunning Activities8ACKEYActivitynvarchar40
20TFK047VFI-CA Dunning: Dunning Activities4ACKEYActivitynvarchar40
21TFK052ACollection Work Item: Customizing2ACKEYActivitynvarchar40
22TFKCMCAPCapacity Restriction for Dunning Activities (Customizing)2ACKEYActivitynvarchar40
TOPInternal Collection Procedure
23UHC_CASE_ALISTActions in Collection Case4ACKEYTechnical Key for the Actionnvarchar40
24UHC_T001Actions - Definition of Actions2ACKEYTechnical Key for the Actionnvarchar40
25UHC_T001_APrerequisite Actions2ACKEYTechnical Key for the Actionnvarchar40
26UHC_T001_BDo Not Execute Action - Prerequisite Case Status2ACKEYTechnical Key for the Actionnvarchar40
27UHC_T001_TActions - Definition of Actions (Texts)3ACKEYTechnical Key for the Actionnvarchar40
28UHC_T002_BActions in Action List4ACKEYTechnical Key for the Actionnvarchar40
TOPLease Accounting
29/LSIERP/WLIWork Items8ACKEYActivitynvarchar40
TOPSAP Utilities
30TEAMI_DUNN_MTMPLAssignment of AMI message templates to dunning activity2ACKEYActivitynvarchar40
TOPSweden
31T5S0CAbsence conditions - SE5ACKEYAbsence condition keynvarchar10