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

37 columns | Print definition?ERP 6.0  | PROCESSGUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPFlexible Real Estate Management
1VICAPROCESSIDProcess2PROCESSGUIDGeneric Key of Processvarbinary160
2VICASTEPSTATUSStatus of Process Step2PROCESSGUIDGeneric Key of Processvarbinary160
3VIITTCCALCInput Tax Correction: Header Information7PROCESSGUIDGeneric Key of Processvarbinary160
4VIXCAJRECCH01Adjustment Record CH013PROCESSGUIDGeneric Key of Processvarbinary160
TOPInput Tax Treatment
5VIITTAXDSITEMDistributed Tax Document Item (VIITTAXDSITEM)14PROCESSGUIDGeneric Key of Processvarbinary160
TOPLocalization
6VIXCAJTHREADSAdjustment: processing threads3PROCESSGUIDGeneric Key of Processvarbinary160
7VIXCFRPROCIDLocalized Process2PROCESSGUIDGeneric Key of Processvarbinary160
8VIXCFRSRULOGLog of SRU Postings6PROCESSGUIDGeneric Key of Processvarbinary160
TOPRent Adjustment
9VIAJRECCOMPAdjustment Record COMP3PROCESSGUIDGeneric Key of Processvarbinary160
10VIAJRECCOMPOBJAdjustment Record COMPOBJ4PROCESSGUIDGeneric Key of Processvarbinary160
11VIAJRECFREEAdjustment Record FREE3PROCESSGUIDGeneric Key of Processvarbinary160
12VIAJRECINDXAdjustment Record INDX3PROCESSGUIDGeneric Key of Processvarbinary160
13VIAJRECORDAdjustment record3PROCESSGUIDGeneric Key of Processvarbinary160
14VIAJRECRLRAAdjustment Record RLRA3PROCESSGUIDGeneric Key of Processvarbinary160
15VIAJRECRLRAFFAdjustment Record RLRAFF4PROCESSGUIDGeneric Key of Processvarbinary160
16VIAJRECRLRAVARAdjustment Record RLRAVAR4PROCESSGUIDGeneric Key of Processvarbinary160
17VIAJRECTASKAdjustment Record TASK3PROCESSGUIDGeneric Key of Processvarbinary160
18VIAJRECTASKOBJAdjustment Record TASKOBJ4PROCESSGUIDGeneric Key of Processvarbinary160
TOPRental Accounting
19VIRAACRITEMAccrual Item7PROCESSGUIDGeneric Key of Processvarbinary160
20VIRAADVPAYOBSOLETE: Advance Payment8PROCESSGUIDGeneric Key of Processvarbinary160
21VIRAADVPAYPROCAdvance Payments per Settlement8PROCESSGUIDGeneric Key of Processvarbinary160
22VIRADOCRE Document Header5PROCESSGUIDGeneric Key of Processvarbinary160
23VIRADOCITEMRE Document Item9PROCESSGUIDGeneric Key of Processvarbinary160
24VIRAINVRE Invoice Header6PROCESSGUIDGeneric Key of Processvarbinary160
TOPRoom Reservations and Seating Arrangements
25VIORRSCOSTReservation - Costs3PROCESSGUIDGeneric Key of Processvarbinary160
TOPSales-Based Rent and Settlement
26VISRCALCCTFCAmounts in Foreign Currency11PROCESSGUIDGeneric Key of Processvarbinary160
27VISRCALCREFCFLink Between Sales-Based Settlement and Cash Flow5PROCESSGUIDGeneric Key of Processvarbinary160
28VISRCALCSUMCalculation Results per Sales Rule10PROCESSGUIDGeneric Key of Processvarbinary160
29VISRCRSPLITSplit Receivable5PROCESSGUIDGeneric Key of Processvarbinary160
30VISRMODIRESULTChanged Sales-Based Settlement Results3PROCESSGUIDGeneric Key of Processvarbinary160
31VISRMOSPLITSplit Receivable5PROCESSGUIDGeneric Key of Processvarbinary160
32VISRSETTLSettlement Identification with Log Reference2PROCESSGUIDGeneric Key of Processvarbinary160
33VISRSTATUSStatus per Contract and Sales Rule (Dependent on Version)10PROCESSGUIDGeneric Key of Processvarbinary160
TOPService Charge Settlement
34VISCACCRUALAccrual/Deferral8PROCESSGUIDGeneric Key of Processvarbinary160
35VISCAJROAdjustment Record SCSE per Rental Object5PROCESSGUIDGeneric Key of Processvarbinary160
36VISCMAPPROCSCSMapping Process to Settlement Hierarchy3PROCESSGUIDGeneric Key of Processvarbinary160
37VISCS_SU_SUMSum of All Costs and Measurement Amounts for Settlment Unit47PROCESSGUIDGeneric Key of Processvarbinary160