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

54 columns | Print definition?ERP 6.0  | TOTAL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVA_CCD_ANA_CNTCount table for the scanned objects in CNVA_CCD_ANA packag5TOTALNatural Numberint100
2CNVA_CCD_ANA_RESResult table for CC deletion downtime Analysis6TOTALNatural Numberint100
3CNVCMIS_A_20_RESAnalysis results of Cross-Client Customizing Comparison20TOTALNumber of Table Entriesint100
4CNVCMIS_A_20_WLWork list table for Cross-Client Customizing Comparison16TOTALNumber of Table Entriesint100
5CNV_20551_PERCDetermine percentage of data to be deleted5TOTALConversion: total number of table recordsdecimal150
6CNV_20551_RESULTFound relevant objects for deletion (statistics)5TOTALConversion: total number of table recordsdecimal150
7CRRREPLAYTRACKCRR Replay Track Information5TOTALNatural Numberint100
8DFKK_TRIGX_PAYOutbound Interface: New Trigger Table for Payment Info13TOTALAmount in Transaction Currency with +/- Signdecimal132
9IUUC_INCR_COUNTIUUC: Persitenz for incremental count5TOTALint100
10IUUC_TRACKIUUC: Tracking for Delta Replay5TOTALMWB: Number of Recordsdecimal120
11IUUC_TRACK_HDRIUUC: Tracking for Delta Replay4TOTALMWB: Number of Recordsdecimal120
12J_1UF_TP_RESOPRInformation of Notification. Operations35TOTALTotal Amountdecimal3113
13J_3RF_TP_LIST1BInformation of Notification. List 1B30TOTALTotal Amount (140)decimal172
14LXE_PPAT_RUNPPAT Run8TOTALNatural Numberint100
15LXE_WRK_LOGWorklist Run Log5TOTALNatural Numberint100
16P05T_WCR_SIMUWCR Simulation34TOTALHR Payroll: Amountdecimal152
17P2BR_BRCUMWorking days (PRS)11TOTALNumberdecimal72
18P2TN_TWDCPayroll Structure TWDC Taiwan11TOTALTotal Debt Amountdecimal132
19T7GR4TSMTSMEDE table28TOTALTSMEDE Total Contributionsdecimal122
20T7QAPBS33Education qualification for promotion(No use)8TOTALTotal Senioritydecimal30
21T7QAPBS34Education qualification for promotion7TOTALTotal Senioritydecimal30
TOPBasic Functions
22FEBPIPolling Statement Line Item Information19TOTALTotal Amount of Presentmentdecimal132
23QSTRLST_CRITGroup.Criteria for List Config. for Ext.W/holding Tax Report12TOTALDisplay a totals row?nvarchar10
TOPBI Content Analyzer
24RSCONTENTCHECK_AArchiving Table for Object Status5TOTALCounter for Object Statusint100
TOPBudget Management
25HRP1520DB Table for Infotype 152023TOTALTotal allocation amountdecimal162
TOPBusiness Planning and Simulation
26UPP_DOCPlanning: Layout Builder Info about Document17TOTALSingle-Character Indicatornvarchar10
TOPClaims Management
27ICLITEMClaim Item29TOTALTotal Number of Benefitsnvarchar30
28ICSITEMClaim Item29TOTALTotal Number of Benefitsnvarchar30
TOPCommunication Services Mail, Fax, SMS, Telephony
29BCSD_STATUSERBCS: User statistics data9TOTALNatural Numberint100
TOPContract Accounts Receivable and Payable
30DFKK_TRIGGER_PAYOutbound Interface: Trigger Table for Payment Information12TOTALAmount in Transaction Currency with +/- Signdecimal132
TOPData Staging
31RSDELDONEBW: Selection Table for Deletion with Full Update Scheduler13TOTALSingle-Character Indicatornvarchar10
32RSLDPDELBW: Selection Table for Deleting with Full Update Scheduler14TOTALSingle-Character Indicatornvarchar10
33RSLDPDELSHBW: Selection Table for Deletion with Full Update Scheduler13TOTALSingle-Character Indicatornvarchar10
TOPFinancial Accounting
34J_1GWTC0Withholding tax certificates data23TOTALTotal invoice valuedecimal132
TOPFrance
35PA0098Infotype 0098 (Profit Sharing - France)27TOTALAnnual paydecimal92
36T5F3BCalculation Bases for Profit Sharing6TOTALProfit sharing reservedecimal152
TOPFunds Management
37FMCOPICO-FM: Plan Data Transfer - Annual/Overall Values17TOTALTotal Value in Transaction Currencydecimal152
TOPGRC Access Control Plug-In
38/VIRSA/MGMTANLYSAnalysis Results4TOTAL# of entities considered for analysis based on analysis typenvarchar60
TOPItaly
39T5ITBSBonus Straordinario9TOTALTotale Redditi riferiti al nucleo familiaredecimal122
TOPliveCache Applications
40/SAPAPO/OMPRORECTable for holding profiling sessions14TOTALProfiled total execution timedecimal150
41LCA_PRORECProfiling-Sessions ext14TOTALTotal Execution Timedecimal150
TOPProcess Controls
42GRPCEVENT1AGGREvent Monitoring Aggregation10TOTALTotal number of deficiencyint100
43GRPCEVENTAGGROBSOLETE Event Monitoring Aggregation11TOTALTotal number of deficiencyint100
44GRPCVIOLATIONEvent Monitoring: Violations14TOTALTotal number of deficiencyint100
TOPSAP Retail Store
45WOSCR_GRP_004SRS Convenience Retailing - Breakdown of Accounts7TOTALIndicator for Totals in Account Breakdownnvarchar10
TOPService Station Retailing
46OIRHCHSTRNSMNClearing House Transmission-Message log(IS-OIL, SSR)16TOTALTotaldecimal162
TOPTaiwan
47PA3223HR Master Record: Infotype 3223 (Deduction TW)25TOTALTotal Debt Amountdecimal132
TOPTransaction Manager
48TRQT_ASSIGNMENTTreasury: Assignment Rule3TOTALDistribution Key for Lot Assignmentdecimal256
TOPTranslation Tools
49LXE_LOG_DATA_TRPExport/import log10TOTALint100
TOPTransport Management System
50TMSBUFCNTTMS Manager: Total Number of Requests in Transport Buffer6TOTAL10 digit numbernvarchar100
TOPUpgrade - General
51RSJOBTABMTable for Background Job Control Data4TOTALint100
TOPUpgrade Tools
52DDCSTADD: Conversion, number of table lines6TOTALNumber of Table Rowsint100
TOPWorkbench Tools Editors, Painters, Modelers
53COVMVDATTable for Storing Coverage Results from Coverage Analyzer19TOTALNumber of Processing Blocksdecimal200
54COVMVHISTable for Storing the History from Coverage Analyzer22TOTALNumber of Processing Blocksdecimal200