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

53 columns | Print definition?ERP 6.0  | SBWHR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/TRB_ECI_CFRBD ECF - Cash Flow Import Table9SBWHRRBD: Currency of Cash Flow Positionnvarchar50
2/IBS/TRB_ECI_CORBD ECF - Import Table for Collateral9SBWHRRBD: Currency of Cash Flow Positionnvarchar50
TOPAccounting
3VDIOA_CALC_DETProgress (Interest) of Model Account IOA Calculation56SBWHRPosition Currency (Currency of Position Amount)nvarchar50
TOPBack Office
4TPMT_DEDOC_LOTPODerivatives Document: Document Item Per Lot11SBWHRPosition Currency (Currency of Position Amount)nvarchar50
5TPMT_DEDOC_POSDerivatives Document: Document Item11SBWHRPosition Currency (Currency of Position Amount)nvarchar50
6TPMT_DEPAL_FLOWSListed Futures: Price Gain Records28SBWHRPosition Currency (Currency of Position Amount)nvarchar50
TOPGermany
7TZBCKVWBEPIBackup: Flow data - Position/Actual7SBWHRPosition Currency (Currency of Position Amount)nvarchar50
8VZBAVZStock totals for PRF-O9SBWHRPosition Currency (Currency of Position Amount)nvarchar50
TOPInformation System
9FTI_BI_REP_ODSReparation Records for Inconsistent Data in ODS 0CFM_O01 /BW63SBWHRPosition Currency/Transaction Currencynvarchar50
10FTI_MARKET_VALSReporting: Buffer Table for Market Values - Position Crcy28SBWHRPosition Currency (Currency of Position Amount)nvarchar50
TOPLoans Management
11BCKTRLET_LOAN_FLTreasury: Loans Transferred9SBWHRPosition Currency (Currency of Position Amount)nvarchar50
12TDESRVDINVIHCML Corr.: Invoice Header11SBWHRPosition Currency (Currency of Position Amount)nvarchar50
13TDESRVDINVIPCML Corr.: Invoice Positions20SBWHRPosition Currency (Currency of Position Amount)nvarchar50
14TRDC_RECSummarization of Loan Document Items: Carryforward Records52SBWHRPosition Currency (Currency of Position Amount)nvarchar50
15TRLET_LOAN_FLOWOBSOLETE: Previous Solution: Loans Flows Transferred20SBWHRPosition Currency (Currency of Position Amount)nvarchar50
16TTONFTVZZBEPPTest neue FIMA: VZZBEPP45SBWHRBestandswährung (Währung des Bestandsbetrages)nvarchar50
17VDARC_DOC_RECCarryforward Records for Reorganization of Loan Doc. Items53SBWHRPosition Currency (Currency of Position Amount)nvarchar50
18VDARC_DOC_REC_EUCarry-Forward Recs of Loan Doc. Item Reorg. bef. EURO Convsn9SBWHRPosition Currency (Currency of Position Amount)nvarchar50
19VDBEPIPosted line items for document header11SBWHRPosition Currency (Currency of Position Amount)nvarchar50
20VDBEPI_EUFlow Data / Actual Position Before EURO Conversion8SBWHRPosition Currency (Currency of Position Amount)nvarchar50
21VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)11SBWHRPosition Currency (Currency of Position Amount)nvarchar50
22VDBEPPFlow Data - Planned Item40SBWHRPosition Currency (Currency of Position Amount)nvarchar50
23VDBEPP_EUFlow Data / Planned Items Before EURO Changeover10SBWHRPosition Currency (Currency of Position Amount)nvarchar50
24VDBOBEPPBusiness Operation: Entered and Activated Flow Data40SBWHRPosition Currency (Currency of Position Amount)nvarchar50
25VDBOBEPP_EUFlow Data / Planned Items Before EURO Changeover11SBWHRPosition Currency (Currency of Position Amount)nvarchar50
26VDCFWAREHOUSECash Flow Management57SBWHRPosition Currency (Currency of Position Amount)nvarchar50
27VDORDERBorrower's note loan order data26SBWHRPosition Currency (Currency of Position Amount)nvarchar50
28VDORDER_EUOrder Data for Borrower's Note Loans Before EURO Conversion8SBWHRPosition Currency (Currency of Position Amount)nvarchar50
29VDPOPOFile item20SBWHRPosition Currency (Currency of Position Amount)nvarchar50
30VDREPAYMENTPayoff Master Data16SBWHRPosition Currency (Currency of Position Amount)nvarchar50
31VDVORTRLoan carry-forward totals8SBWHRCurrency Keynvarchar50
32VZFZE_VDBEPPCentral Entry Table for Release Procedure43SBWHRPosition Currency (Currency of Position Amount)nvarchar50
TOPReal Estate Management
33VIBEPPFlow data - Planned items for real estate management16SBWHRPosition Currency (Currency of Position Amount)nvarchar50
TOPRisk Analysis
34JBRDBBEWEGRM: DB Table BEWEG Extended Category of Primary Transaction29SBWHRPosition Currency/Transaction Currencynvarchar50
35JBRHBEWEGRM: Version Table BEWEG for Extended Cat. of Primary Trans.30SBWHRPosition Currency/Transaction Currencynvarchar50
36JBRSVBEWEGRM: Flow Table for Cat. of Prim. Trans. for Saved Datasets30SBWHRPosition Currency/Transaction Currencynvarchar50
TOPTransaction Management
37TCHT_HD_BEWEG_CFSFGDT FGET Cashflows Table29SBWHRPosition Currency/Transaction Currencynvarchar50
TOPTransaction Manager
38BCKVWBEPIBackup: Flow data - Position/Actual7SBWHRPosition Currency (Currency of Position Amount)nvarchar50
39BCKVWBEPPBACKUP: Flow data - Position/Planned10SBWHRPosition Currency (Currency of Position Amount)nvarchar50
40BCKVWBWKMBACKUP: Flow table for corporate actions11SBWHRPosition Currency (Currency of Position Amount)nvarchar50
41BCKVWORDEBACKUP: Order data9SBWHRPosition Currency (Currency of Position Amount)nvarchar50
42BCKVWVORTRBACKUP: Carryover totals - securities8SBWHRCurrency Keynvarchar50
43IDCFM_BST_HISTHistory table for balance sheet transfer for Brazil12SBWHRPosition Currency (Currency of Position Amount)nvarchar50
44TERTVWBWERTRTM-PM: Flow Table for Executable Rights35SBWHRPosition Currency (Currency of Position Amount)nvarchar50
45TRGT_TRANS_REVALTable with Revaluation Structures for Transfer to TR Ledger15SBWHRPosition Currency (Currency of Position Amount)nvarchar50
46TRQT_VWVORTR_LOT(obsolete)9SBWHRCurrency Keynvarchar50
47VWBEPITreasury Securities: Actual Flows - Item17SBWHRPosition Currency (Currency of Position Amount)nvarchar50
48VWBEPPTreasury Securities: Planned Flows25SBWHRPosition Currency (Currency of Position Amount)nvarchar50
49VWBWKMTRTM-PM: Flow table for corporate actions34SBWHRPosition Currency (Currency of Position Amount)nvarchar50
50VWORDEOrder Data25SBWHRPosition Currency (Currency of Position Amount)nvarchar50
51VWVORTRSecurities: Carry-Forward Totals8SBWHRCurrency Keynvarchar50
TOPValue Adjustment
52/IBS/TRB_IASCOLRBD IAS-GATE Collateral Data14SBWHRRBD: Currency of Cash Flow Positionnvarchar50
53/IBS/TRB_IASGPORBD IAS-GATE Position Data8SBWHRRBD: Currency of Cash Flow Positionnvarchar50