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

57 columns | Print definition?ERP 6.0  | BBWHR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/TRB_ECI_CFRBD ECF - Cash Flow Import Table10BBWHRRBD: Amount of Cash Flow Position (Installment)decimal232
2/IBS/TRB_ECI_CORBD ECF - Import Table for Collateral10BBWHRRBD: Amount of Cash Flow Position (Installment)decimal232
3VIYCADVPAYAdvance Payments19BBWHRAmount which changes positiondecimal232
TOPAccounting
4VDIOA_CALC_DETProgress (Interest) of Model Account IOA Calculation57BBWHRAmount in position currencydecimal132
5VDIOA_CALC_HEADCalculation Details for Interest on Arrears Calculation13BBWHRInterest on Arrears Calculateddecimal132
TOPBack Office
6TPMT_DEDOC_LOTPODerivatives Document: Document Item Per Lot12BBWHRAmount in position currencydecimal132
7TPMT_DEDOC_POSDerivatives Document: Document Item12BBWHRAmount in position currencydecimal132
8TPMT_DEPAL_FLOWSListed Futures: Price Gain Records27BBWHRAmount in position currencydecimal132
TOPFinancial Services
9VDBIW_DATAExtractor Flow Data - Data of Last Extraction15BBWHRAmount in position currencydecimal132
TOPGermany
10TZBCKVWBEPIBackup: Flow data - Position/Actual9BBWHRAmount in position currencydecimal132
TOPLoans Management
11BCKTRLET_LOAN_FLTreasury: Loans Transferred8BBWHRAmount in position currencydecimal132
12TDESRVDINVIHCML Corr.: Invoice Header21BBWHRAmount in position currencydecimal132
13TDESRVDINVIPCML Corr.: Invoice Positions21BBWHRAmount in position currencydecimal132
14TRDC_RECSummarization of Loan Document Items: Carryforward Records53BBWHRAmount in position currencydecimal132
15TRLET_LOAN_FLOWOBSOLETE: Previous Solution: Loans Flows Transferred19BBWHRAmount in position currencydecimal132
16TTONFTVZZBEPPTest neue FIMA: VZZBEPP46BBWHRBetrag in Bestandswährungdecimal132
17VDARC_DOC_RECCarryforward Records for Reorganization of Loan Doc. Items54BBWHRAmount in position currencydecimal132
18VDARC_DOC_REC_EUCarry-Forward Recs of Loan Doc. Item Reorg. bef. EURO Convsn10BBWHRAmount in position currencydecimal132
19VDBEPIPosted line items for document header10BBWHRAmount in position currencydecimal132
20VDBEPI_EUFlow Data / Actual Position Before EURO Conversion7BBWHRAmount in position currencydecimal132
21VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)10BBWHRAmount in position currencydecimal132
22VDBEPPFlow Data - Planned Item39BBWHRAmount in position currencydecimal132
23VDBEPP_EUFlow Data / Planned Items Before EURO Changeover9BBWHRAmount in position currencydecimal132
24VDBOBEPPBusiness Operation: Entered and Activated Flow Data39BBWHRAmount in position currencydecimal132
25VDBOBEPP_EUFlow Data / Planned Items Before EURO Changeover10BBWHRAmount in position currencydecimal132
26VDCFWAREHOUSECash Flow Management58BBWHRAmount in position currencydecimal132
27VDORDERBorrower's note loan order data25BBWHRAmount in position currencydecimal132
28VDORDER_EUOrder Data for Borrower's Note Loans Before EURO Conversion7BBWHRAmount in position currencydecimal132
29VDSDV5Collateral in securities in acc. with BAV/PRF538BBWHRAmount in position currencydecimal132
30VDVORTRLoan carry-forward totals9BBWHRTotals storage for group valuesdecimal152
31VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity70BBWHRAmount in position currencydecimal132
32VZFZE_VDBEPPCentral Entry Table for Release Procedure42BBWHRAmount in position currencydecimal132
TOPReal Estate Contract
33VICDCFOBJObject-Related Cash Flow15BBWHRAmount which changes positiondecimal232
34VICDCFPAYPayment-Related Cash Flow15BBWHRAmount which changes positiondecimal232
TOPReal Estate Management
35VIBEPPFlow data - Planned items for real estate management17BBWHRAmount in position currencydecimal132
TOPRemaining Beverage - Obsolete Objects
36/BEV3/CHABEWEALTTest Transfer Structure: Flow Records in Cash Flow Calcul.10BBWHRAmount which changes positiondecimal232
TOPRisk Analysis
37JBRDBBEWEGRM: DB Table BEWEG Extended Category of Primary Transaction30BBWHRAmount in transaction currencydecimal172
38JBRHBEWEGRM: Version Table BEWEG for Extended Cat. of Primary Trans.31BBWHRAmount in transaction currencydecimal172
39JBRSVBEWEGRM: Flow Table for Cat. of Prim. Trans. for Saved Datasets31BBWHRAmount in transaction currencydecimal172
TOPTransaction Data Pool
40JBDBEWEPosition Flows Generated by Position Changes12BBWHRAmount in Position Currencydecimal172
41JBDBSTWPosition Values15BBWHRAcquisition Value in Position Currencydecimal172
TOPTransaction Management
42TCHT_HD_BEWEG_CFSFGDT FGET Cashflows Table30BBWHRAmount in transaction currencydecimal172
TOPTransaction Manager
43BCKVWBEPIBackup: Flow data - Position/Actual9BBWHRAmount in position currencydecimal132
44BCKVWBEPPBACKUP: Flow data - Position/Planned12BBWHRAmount in position currencydecimal132
45BCKVWBWKMBACKUP: Flow table for corporate actions10BBWHRAmount in position currencydecimal132
46BCKVWORDEBACKUP: Order data11BBWHRAmount in position currencydecimal132
47BCKVWVORTRBACKUP: Carryover totals - securities9BBWHRTotals storage for group valuesdecimal152
48IDCFM_BST_HISTHistory table for balance sheet transfer for Brazil11BBWHRAmount in position currencydecimal132
49TERTVWBWERTRTM-PM: Flow Table for Executable Rights34BBWHRAmount in position currencydecimal132
50TRQT_VWVORTR_LOT(obsolete)10BBWHRTotals storage for group valuesdecimal152
51VWBEPITreasury Securities: Actual Flows - Item23BBWHRAmount in position currencydecimal132
52VWBEPPTreasury Securities: Planned Flows31BBWHRAmount in position currencydecimal132
53VWBWKMTRTM-PM: Flow table for corporate actions33BBWHRAmount in position currencydecimal132
54VWORDEOrder Data31BBWHRAmount in position currencydecimal132
55VWVORTRSecurities: Carry-Forward Totals9BBWHRTotals storage for group valuesdecimal152
TOPValue Adjustment
56/IBS/TRB_IASCOLRBD IAS-GATE Collateral Data15BBWHRRBD: Amount of Cash Flow Position (Installment)decimal232
57/IBS/TRB_IASGPORBD IAS-GATE Position Data9BBWHRRBD: Amount of Cash Flow Position (Installment)decimal232