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

29 columns | Print definition?ERP 6.0  | SEMPSL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item96SEMPSLSettlement Unitnvarchar50
2/OPT/VIM_TITEMDocument Item96SEMPSLSettlement Unitnvarchar50
3YVIM_1ITEMDocument Item96SEMPSLSettlement Unitnvarchar50
TOPFinancial Accounting
4/OPT/VIM_1ITEMDocument Item96SEMPSLSettlement Unitnvarchar50
TOPFlexible Real Estate Management
5VIAKHO21Mandatsverwaltung: Gesplittete Abrechnungsgrößen5SEMPSLAbrechnungseinheitnvarchar50
6VICAINTRENOAssignment of INTRENO / OBJNR / IMKEY16SEMPSLSettlement Unitnvarchar50
7VIXCSCCHTAPEHeader Data for External Heating Expenses Settlement9SEMPSLSettlement Unitnvarchar50
8VIXCSCCHTPSHARDistribution for External Heating Expenses Settlement6SEMPSLSettlement Unitnvarchar50
TOPProfit Center Accounting
9KE1_WU_IM_ITEMPCA Where-Used List: Itemization for Real Estate18SEMPSLSettlement Unitnvarchar50
TOPReal Estate Management
10ONRIACalculation unit object number index6SEMPSLSettlement Unitnvarchar50
11VIAK01History of acct settlement runs5SEMPSLSettlement Unitnvarchar50
12VIAK03Settlement Unit Master Record5SEMPSLSettlement Unitnvarchar50
13VIAK04Allocation of Settlement Variants to Settlement Unit5SEMPSLSettlement Unitnvarchar50
14VIAK05Allocation of rental units to calculation unit5SEMPSLSettlement Unitnvarchar50
15VIAK06Calculation unit relations4SEMPSLSettlement Unitnvarchar50
16VIAK07Calculation unit option rate5SEMPSLSettlement Unitnvarchar50
17VIAK08DME Settlement Units Master Data24SEMPSLSettlement Unitnvarchar50
18VIAK09Assignment of Heating Systems to Calculation Units5SEMPSLSettlement Unitnvarchar50
19VIAK19Costs Directly Assigned to Lease-Out14SEMPSLSettlement Unitnvarchar50
20VIAK21Split settlement factors for settlement variant5SEMPSLSettlement Unitnvarchar50
21VIAK22Heat.oil supply5SEMPSLSettlement Unitnvarchar50
22VIAK22THeat.oil supply texts5SEMPSLSettlement Unitnvarchar50
23VIAK25Cost collector for SU (per settlement period)5SEMPSLSettlement Unitnvarchar50
24VIAK26Master Settlement Unit: Participating Settlement Units5SEMPSLSettlement Unitnvarchar50
25VIAKBSEGDocument Line Item from SCS for Interface103SEMPSLSettlement Unitnvarchar50
26VIAKT5Rental units allocation ID6SEMPSLSettlement Unitnvarchar50
27VIAROBJArchived real estate objects18SEMPSLSettlement Unitnvarchar50
28VIZNRNAssignment: Real Estate numbers <-> IMKEY <-> INTRENO12SEMPSLSettlement Unitnvarchar50
TOPService Charge Settlement
29VISCSUSettlement unit6SEMPSLSettlement Unitnvarchar50