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

44 columns | Print definition?ERP 6.0  | BHWHR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAccounting
1VDIOA_CALC_DETProgress (Interest) of Model Account IOA Calculation60BHWHRAmount in local currencydecimal132
TOPBack Office
2TPMT_DEDOC_LOTPODerivatives Document: Document Item Per Lot14BHWHRAmount in local currencydecimal132
3TPMT_DEDOC_POSDerivatives Document: Document Item14BHWHRAmount in local currencydecimal132
4TPMT_DEPAL_FLOWSListed Futures: Price Gain Records29BHWHRAmount in local currencydecimal132
TOPBasic Functions
5FDD1Cash mgmt and forecast-Loan line items-Memo records16BHWHRAmount in local currencydecimal132
6FDI1Cash Management Line Item for RE Classic Planning Records16BHWHRAmount in local currencydecimal132
7FDW1Cash Mgt and Forecast - Securities Line Items- Planned Flows17BHWHRAmount in local currencydecimal132
TOPFinancial Services
8VDBIW_DATAExtractor Flow Data - Data of Last Extraction16BHWHRAmount in local currencydecimal132
TOPFlexible Real Estate Management
9VIAKHO20WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung16BHWHRBetrag in Hauswährungdecimal132
TOPGermany
10VZBAVZStock totals for PRF-O13BHWHRPosition amount in local currencydecimal132
TOPLoans Management
11TRDC_RECSummarization of Loan Document Items: Carryforward Records56BHWHRAmount in local currencydecimal132
12TRLET_LOAN_FLOWOBSOLETE: Previous Solution: Loans Flows Transferred21BHWHRAmount in local currencydecimal132
13TTONFTVZZBEPPTest neue FIMA: VZZBEPP49BHWHRBetrag in Hauswährungdecimal132
14VDARC_DOC_RECCarryforward Records for Reorganization of Loan Doc. Items58BHWHRAmount in local currencydecimal132
15VDARC_DOC_REC_EUCarry-Forward Recs of Loan Doc. Item Reorg. bef. EURO Convsn14BHWHRAmount in local currencydecimal132
16VDAUSZDrawings on Disbursement46BHWHRAmount in local currencydecimal132
17VDBEPIPosted line items for document header14BHWHRAmount in local currencydecimal132
18VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)14BHWHRAmount in local currencydecimal132
19VDBEPPFlow Data - Planned Item43BHWHRAmount in local currencydecimal132
20VDBOBEPPBusiness Operation: Entered and Activated Flow Data43BHWHRAmount in local currencydecimal132
21VDCFWAREHOUSECash Flow Management61BHWHRAmount in local currencydecimal132
22VDORDERBorrower's note loan order data29BHWHRAmount in local currencydecimal132
23VDREPAYMENTPayoff Master Data35BHWHRPayoff Amount in Local Currencydecimal132
24VDVORTRLoan carry-forward totals7BHWHRTotals storage for group valuesdecimal152
25VZFZE_VDAUSZCentral Entry Table for Release Procedure48BHWHRAmount in local currencydecimal132
26VZFZE_VDBEPPCentral Entry Table for Release Procedure46BHWHRAmount in local currencydecimal132
TOPMaster Data
27VDDISBTEMPDisbursements That Were Not Released30BHWHRAmount in local currencydecimal132
TOPReal Estate Management
28VIAK14RA credit memo/receivable:now only used as structure!15BHWHRAmount in local currencydecimal132
29VIAK20RA credit memo/receivable (incid.exp.sttlmnt created)15BHWHRAmount in local currencydecimal132
30VIBEPPFlow data - Planned items for real estate management15BHWHRAmount in local currencydecimal132
TOPTransaction Data Pool
31JBDBEWEPosition Flows Generated by Position Changes13BHWHRAmount in Local Currencydecimal172
32JBDBSTWPosition Values16BHWHRSAP Banking: Aquisition Value in Local Currencydecimal172
TOPTransaction Manager
33IDCFM_BST_HISTHistory table for balance sheet transfer for Brazil13BHWHRAmount in local currencydecimal132
34TERTVWBWERTRTM-PM: Flow Table for Executable Rights36BHWHRAmount in local currencydecimal132
35TRQT_VWVORTR_LOT(obsolete)8BHWHRTotals storage for group valuesdecimal152
36VWBEPITreasury Securities: Actual Flows - Item25BHWHRAmount in local currencydecimal132
37VWBEPPTreasury Securities: Planned Flows33BHWHRAmount in local currencydecimal132
38VWBWKMTRTM-PM: Flow table for corporate actions35BHWHRAmount in local currencydecimal132
39VWORDEOrder Data33BHWHRAmount in local currencydecimal132
40VWVORTRSecurities: Carry-Forward Totals7BHWHRTotals storage for group valuesdecimal152
TOPValue Adjustment
41/IBS/TRB_UERBD RBD Individual Documents40BHWHRRBD: Amount in Local Currencydecimal232
42/IBS/TRB_UE_HISTRBD RBD History of Individual Documents41BHWHRRBD: Amount in Local Currencydecimal232
43/IBS/TRB_UIRBD: RBD Record Data Table (Actual)31BHWHRRBD: Amount in Local Currencydecimal232
44/IBS/TRB_UPRBD RBD Record Data Table (PLANNED)17BHWHRRBD: Amount in Local Currencydecimal232