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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

53 columns | Print definition?ERP 6.0  | ATAGE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1VIYCADVPAYAdvance Payments37ATAGENumber of Daysint100
TOPAccounting
2VDIOA_CALC_DETProgress (Interest) of Model Account IOA Calculation44ATAGENumber of daysnvarchar60
3VDIOA_CALC_HEADCalculation Details for Interest on Arrears Calculation28ATAGENumber of daysnvarchar60
TOPBack Office
4TRST_CLASFLOCFM: Class Flows in Securities Account75ATAGENumber of Daysint100
5TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account75ATAGENumber of Daysint100
TOPFlexible Real Estate Management
6VIAKHO13WEG-Verwaltung: Umlage Eigentümerabrechnung18ATAGEAnzahl Tagenvarchar60
TOPLoans Management
7TRDC_RECSummarization of Loan Document Items: Carryforward Records40ATAGENumber of daysnvarchar60
8TTONFTVZZBEPPTest neue FIMA: VZZBEPP68ATAGEAnzahl Tagenvarchar60
9VDARC_DOC_RECCarryforward Records for Reorganization of Loan Doc. Items41ATAGENumber of daysnvarchar60
10VDBEPIPosted line items for document header59ATAGENumber of daysnvarchar60
11VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)59ATAGENumber of daysnvarchar60
12VDBEPPFlow Data - Planned Item52ATAGENumber of daysnvarchar60
13VDBOBEPPBusiness Operation: Entered and Activated Flow Data52ATAGENumber of daysnvarchar60
14VDCFWAREHOUSECash Flow Management45ATAGENumber of daysnvarchar60
15VDORDERBorrower's note loan order data38ATAGENumber of daysnvarchar60
16VDVORKTable for preemption conditions11ATAGENumber of daysnvarchar60
17VZFZE_VDBEPPCentral Entry Table for Release Procedure55ATAGENumber of daysnvarchar60
TOPReal Estate Contract
18VICDCFOBJObject-Related Cash Flow33ATAGENumber of Daysint100
19VICDCFPAYPayment-Related Cash Flow33ATAGENumber of Daysint100
TOPReal Estate Management
20VIAK13Apportionment Result for List Evaluation (SCSettlement)17ATAGENumber of daysnvarchar60
21VIBEPPFlow data - Planned items for real estate management56ATAGENumber of daysnvarchar60
TOPRemaining Beverage - Obsolete Objects
22/BEV3/CHABEWEALTTest Transfer Structure: Flow Records in Cash Flow Calcul.32ATAGENumber of Daysint100
23/BEV3/CHABRSTZ_PCH Settlement Items - With Translations88ATAGENumber of Daysint100
24/BEV3/CHBDMDHSTHistory of Condit. Modifications from Temp. Settlement Items89ATAGENumber of Daysint100
25/BEV3/CHERGSTZ_PCH Settlement Items - With Translations88ATAGENumber of Daysint100
26/BEV3/CHERGSTZ_SCH Settlement Statistics89ATAGENumber of Daysint100
27/BEV3/CHEXCSTZ_PCH Settlement Items/Non-Posted Docs w/o Date Statistics88ATAGENumber of Daysint100
28/BEV3/CHRESSTZ_PCH Settlement Items - Reset Documents (2/Transaction)88ATAGENumber of Daysint100
29/BEV3/CHSHTSTZ_PCH Settlement Item88ATAGENumber of Daysint100
30/BEV3/CHSIMBDMDHCH simulation history of modifications caused by conditions89ATAGENumber of Daysint100
31/BEV3/CHSIMSTZ_PCH Simulation Items88ATAGENumber of Daysint100
32/BEV3/CHSIMSTZ_SCH Simulation Statistics89ATAGENumber of Daysint100
33/BEV3/CHTMPMDHSTTemp. history of cond. modifications from temp. settle. item89ATAGENumber of Daysint100
34/BEV3/CHTRMSTZ_PCH Date Item88ATAGENumber of Daysint100
35/BEV3/CHTRMSTZ_SCH Date Statistics89ATAGENumber of Daysint100
36/BEV3/CHVABRSTZSCH Settlement Statistics89ATAGENumber of Daysint100
TOPRisk Analysis
37JBRDBBEWEGRM: DB Table BEWEG Extended Category of Primary Transaction16ATAGENumber of Daysnvarchar60
38JBRHBEWEGRM: Version Table BEWEG for Extended Cat. of Primary Trans.17ATAGENumber of Daysnvarchar60
39JBRSVBEWEGRM: Flow Table for Cat. of Prim. Trans. for Saved Datasets17ATAGENumber of Daysnvarchar60
TOPSales Plan
40T445ZPeriod Split for Display of Time Axis3ATAGENumber of days in display format for daysnvarchar30
TOPSocial Insurance
41P01EE_DBFRData Module DBFR Entry Release from Work Illness of Child31ATAGETotal Number of Working Days with Release from Worknvarchar20
TOPTransaction Management
42TCHT_HD_BEWEG_CFSFGDT FGET Cashflows Table16ATAGENumber of Daysnvarchar60
TOPTransaction Manager
43OTC_CONV_FHAPOBackup Table for Financial Transaction Flows68ATAGENumber of daysnvarchar60
44OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows53ATAGENumber of daysnvarchar60
45TRDT_SEC_FLOWPersistent distributor flows: Part for BEPP adaptor34ATAGENumber of daysnvarchar60
46VTBFHAPOTransaction Flow68ATAGENumber of daysnvarchar60
47VTBFHAPO_MIGRMigrated Financial Flows68ATAGENumber of daysnvarchar60
48VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows68ATAGENumber of daysnvarchar60
49VTBPFHAPOTreasury: Flow Shells57ATAGENumber of daysnvarchar60
50VTIFHAPOUnderlying transaction flows53ATAGENumber of daysnvarchar60
51VWBEPITreasury Securities: Actual Flows - Item48ATAGENumber of daysnvarchar60
52VWBEPPTreasury Securities: Planned Flows86ATAGENumber of daysnvarchar60
53VWORDEOrder Data76ATAGENumber of daysnvarchar60