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

22 columns | Print definition?ERP 6.0  | RBELKPFD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1VDSEPA_AUTODEBRecords for new auto debit (SEPA direct debit)15RBELKPFDDocument Number of Document Header (Loan)nvarchar100
2VDSEPA_AUTODEB_ORecords for new auto debit (SEPA direct debit) (up to 604)15RBELKPFDDocument Number of Document Header (Loan)nvarchar100
TOPAccounting
3VDIOA_CALC_CFOriginal Documents Without Model Account Int. on Arrears8RBELKPFDDocument Number of Document Header (Loan)nvarchar100
4VDIOA_CALC_HEADCalculation Details for Interest on Arrears Calculation25RBELKPFDDocument Number of Document Header (Loan)nvarchar100
TOPLoans Management
5BCKTRLET_LOAN_FLTreasury: Loans Transferred3RBELKPFDDocument Number of Document Header (Loan)nvarchar100
6TDESRVDINVIPCML Corr.: Invoice Positions17RBELKPFDDocument Number of Document Header (Loan)nvarchar100
7TRLET_LOAN_FLOWOBSOLETE: Previous Solution: Loans Flows Transferred3RBELKPFDDocument Number of Document Header (Loan)nvarchar100
8TTONFTVZZBEPPTest neue FIMA: VZZBEPP8RBELKPFDBelegnummer des Belegkopfes (Darlehen)nvarchar100
9VDARC_DOC_INDIndex Table for the Loan Document Data Archiving3RBELKPFDDocument Number of Document Header (Loan)nvarchar100
10VDBEKIFlow Data: Document Header for Actual Record3RBELKPFDDocument Number of Document Header (Loan)nvarchar100
11VDBEKI_SHADOWShadow Table for VDBEKI (Restrictions)3RBELKPFDDocument Number of Document Header (Loan)nvarchar100
12VDBELDocument relationship between FI and subledger document3RBELKPFDDocument Number of Document Header (Loan)nvarchar100
13VDBEPIPosted line items for document header3RBELKPFDDocument Number of Document Header (Loan)nvarchar100
14VDBEPI_EUFlow Data / Actual Position Before EURO Conversion3RBELKPFDDocument Number of Document Header (Loan)nvarchar100
15VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)3RBELKPFDDocument Number of Document Header (Loan)nvarchar100
16VDCHK_AWKEYStorage of unique links between FI and CML doc4RBELKPFDDocument Number of Document Header (Loan)nvarchar100
17VDCHK_DOC_IPPayments for Subsequent Posting3RBELKPFDDocument Number of Document Header (Loan)nvarchar100
18VDDABData Transfer - Loans - Flows - Actual Records5RBELKPFDDocument Number of Document Header (Loan)nvarchar100
19VDDASTTR-EDT: Transfer Loans8RBELKPFDDocument Number of Document Header (Loan)nvarchar100
20VZFZE_VDBEKICentral Entry Table for Release Procedure6RBELKPFDDocument Number of Document Header (Loan)nvarchar100
21VZFZE_VDNBZECentral Entry Table for Release Procedure24RBELKPFDDocument Number of Document Header (Loan)nvarchar100
TOPPortfolio
22VDBILL_ITEMSBilling Items5RBELKPFDDocument Number of Document Header (Loan)nvarchar100