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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

49 columns | Print definition?ERP 6.0  | DVALUT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1RDPT_CONDITIONCondition within Redemption Schedule21DVALUTCalculation Datenvarchar80
2VIYCADVPAYAdvance Payments27DVALUTCalculation Datenvarchar80
TOPAccounting
3VDIOA_CALC_DETProgress (Interest) of Model Account IOA Calculation36DVALUTCalculation Datenvarchar80
TOPBack Office
4TRST_CLASFLOCFM: Class Flows in Securities Account67DVALUTCalculation Datenvarchar80
5TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account67DVALUTCalculation Datenvarchar80
TOPBank Components
6JBAFOKOPOCondition Items8DVALUTValue Datenvarchar80
7JBASTCPStandard Conditions: Condition Item10DVALUTValue Datenvarchar80
TOPLoans Management
8TRDC_RECSummarization of Loan Document Items: Carryforward Records31DVALUTCalculation Datenvarchar80
9TTONFTVVZZKOPOTest neue Fima: VVZZKOPO25DVALUTBerechnungstagnvarchar80
10TTONFTVZZBEPPTest neue FIMA: VZZBEPP62DVALUTBerechnungstagnvarchar80
11VDARC_DOC_RECCarryforward Records for Reorganization of Loan Doc. Items32DVALUTCalculation Datenvarchar80
12VDBEPIPosted line items for document header19DVALUTCalculation Datenvarchar80
13VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)19DVALUTCalculation Datenvarchar80
14VDBEPPFlow Data - Planned Item46DVALUTCalculation Datenvarchar80
15VDBOBEPPBusiness Operation: Entered and Activated Flow Data46DVALUTCalculation Datenvarchar80
16VDCFWAREHOUSECash Flow Management36DVALUTCalculation Datenvarchar80
17VDORDERBorrower's note loan order data32DVALUTCalculation Datenvarchar80
18VDVORTRLoan carry-forward totals15DVALUTCalculation Datenvarchar80
19VZFZE_VDBEPPCentral Entry Table for Release Procedure49DVALUTCalculation Datenvarchar80
TOPMaster Data
20VDESCROWKOPO0TEMPORARY USE: Escrow Condition Items24DVALUTCalculation Datenvarchar80
TOPReal Estate Contract
21VICDCFOBJObject-Related Cash Flow23DVALUTCalculation Datenvarchar80
22VICDCFPAYPayment-Related Cash Flow23DVALUTCalculation Datenvarchar80
TOPReal Estate Management
23VIBEPPFlow data - Planned items for real estate management22DVALUTCalculation Datenvarchar80
TOPRemaining Beverage - Obsolete Objects
24/BEV3/CHABEWEALTTest Transfer Structure: Flow Records in Cash Flow Calcul.20DVALUTCalculation Datenvarchar80
25/BEV3/CHAKONDALTTest transfer structure cash flow for conditions36DVALUTCalculation Datenvarchar80
TOPTransaction Data Pool
26JBCFBEWEGCash Flow Transaction: Flows11DVALUTCalculation Datenvarchar80
27JBCFZSTRBEWEGCash Flow Transaction: Flow Data for Cash Flow12DVALUTCalculation Datenvarchar80
28JBDBEWEPosition Flows Generated by Position Changes6DVALUTInterest Value Date/Calculation Datenvarchar80
29JBDKOPOCondition Items13DVALUTValue Datenvarchar80
30JBDKUMSTurnovers for Business Partner Accounts6DVALUTValue Datenvarchar80
31JBDVTCPVariable Transaction - Condition Items9DVALUTValue Datenvarchar80
TOPTransaction Management
32TCHT_HD_CONDInstrument Conditions12DVALUTCalculation Datenvarchar80
TOPTransaction Manager
33OTC_CONV_FHAPOBackup Table for Financial Transaction Flows84DVALUTCalculation Datenvarchar80
34OTC_CONV_FINKOBackup Table for Financial Transaction Conditions36DVALUTCalculation Datenvarchar80
35OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows67DVALUTCalculation Datenvarchar80
36OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions35DVALUTCalculation Datenvarchar80
37TERTVWBWERTRTM-PM: Flow Table for Executable Rights26DVALUTCalculation Datenvarchar80
38VTBFHAPOTransaction Flow84DVALUTCalculation Datenvarchar80
39VTBFHAPO_MIGRMigrated Financial Flows84DVALUTCalculation Datenvarchar80
40VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows84DVALUTCalculation Datenvarchar80
41VTBFINKOTransaction Condition36DVALUTCalculation Datenvarchar80
42VTBPFHAPOTreasury: Flow Shells75DVALUTCalculation Datenvarchar80
43VTIFHAPOUnderlying transaction flows67DVALUTCalculation Datenvarchar80
44VTIFINKOUnderlying transaction conditions35DVALUTCalculation Datenvarchar80
45VWBEPITreasury Securities: Actual Flows - Item28DVALUTInterest Value Date/Calculation Datenvarchar80
46VWBEPPTreasury Securities: Planned Flows37DVALUTInterest Value Date/Calculation Datenvarchar80
47VWBWKMTRTM-PM: Flow table for corporate actions26DVALUTCalculation Datenvarchar80
48VWORDEOrder Data37DVALUTInterest Value Date/Calculation Datenvarchar80
TOPTreasury
49VZZKOPOTable condition items27DVALUTCalculation Datenvarchar80