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

27 columns | Print definition?ERP 6.0  | ACTVT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBusiness Planning and Simulation
1UPC_DISPATCHERDispatcher in SEM-BPS8ACTVTActivitynvarchar20
TOPCollaborative Cross Applications
2/POA/D_BUI_ACCBUI PST Access Control5ACTVTActivity Name for BUI Persistence Authorization Checksnvarchar200
TOPCollectionsDisbursements
3VKKICDRPOSTTrigger Table for Posting ICDRs3ACTVTPosting Activitynvarchar10
TOPConstruction Equipment Management
4/SAPCEM/TACTDirectory of Activities that can be Protected1ACTVTActivitynvarchar20
5/SAPCEM/TACTTDescription for Activities that can be Protected2ACTVTActivitynvarchar20
TOPError and Conflict Handler
6FEHC_PE_INTF_AUTFEH: Interface-Specific Authorizations4ACTVTActivity to Checknvarchar20
TOPFramework for the Principle of Dual Control
7BCA_REL_LOG_DDetail Data of Log Table for Release8ACTVTActivitynvarchar20
TOPFunds Management
8FMTACTActivities which can be Protected1ACTVTActivity: Authorization checknvarchar20
9FMTACTTActivities that can be protected2ACTVTActivity: Authorization checknvarchar20
10FMTACTZFM: Valid Activities per Authorization Object (same TACTZ)2ACTVTActivity: Authorization checknvarchar20
TOPFunds Management-Specific Postings
11PSOTYPayment Request Document Categories (Local Authority)3ACTVTActivitynvarchar20
TOPGoods Issue Process
12/SPE/XHU_LOCK_01Handling Unit Lock Structure - with VENUM2ACTVTSingle-Character Indicatornvarchar10
13/SPE/XHU_LOCK_02Handling Unit Lock Structure - w/o venum2ACTVTSingle-Character Indicatornvarchar10
TOPOverhead Cost Controlling
14COACTVAssign transaction, activity to CO_ACTION3ACTVTActivitynvarchar20
TOPPublic Sector Contract Accounts Receivable and Payable
15DFMCA_BUPR_TAData Table for Tax Advisor Relationships4ACTVTActivity Type for TRMnvarchar20
TOPSchedule Manager
16KPEP_WL_SStep Data in the Worklist for the Schedule Manager5ACTVTBusiness Transactionnvarchar40
TOPTask Resource Management
17LACTYActivity catalog3ACTVTActivitynvarchar20
18LACTYTActivity catalog - description4ACTVTActivitynvarchar20
19LAGACAssign Activity to Activity Groups4ACTVTActivitynvarchar20
TOPTransaction Management
20ATRELE2Transaction release: Release procedure for detail parameters6ACTVTTransaction release: Permitted activitiesnvarchar20
21VTBMDEXCFM: Mirror Transaction - Initial Table5ACTVTActivitynvarchar20
22VTBMDINFKTCFM: Mirror Transaction Mapping Functions8ACTVTActivitynvarchar20
TOPTREX ABAP JAVA API
23TREX_ACTTREX Activities that can be protected1ACTVTTREX Activity which is subject to the authorization checknvarchar20
24TREX_ACTTTREX Activities that can be protected2ACTVTTREX Activity which is subject to the authorization checknvarchar20
TOPUser and Authorization Management
25TACTActivities which can be Protected1ACTVTActivitynvarchar20
26TACTTActivities that can be protected2ACTVTActivitynvarchar20
27TACTZValid activities for each authorization object2ACTVTActivitynvarchar20