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

91 columns | Print definition?ERP 6.0  | SMENR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/AT_APPR_HISApproval History for Level Based Approvals49SMENRNumber of Rental Unitnvarchar80
2/OPT/AT_LBA_LOGApproval History for Level Based Approvals50SMENRNumber of Rental Unitnvarchar80
3/OPT/VIM_1ITEM_SDocument Item53SMENRNumber of Rental Unitnvarchar80
4/OPT/VIM_TITEMDocument Item53SMENRNumber of Rental Unitnvarchar80
5REMOB_T_CONDAssign Condition Type & Measurement Type6SMENRNumber of Rental Objectnvarchar80
6REMOB_T_LOGVisit History7SMENRNumber of Rental Objectnvarchar80
7YVIM_1ITEMDocument Item53SMENRNumber of Rental Unitnvarchar80
8ZEIM_VBAKSales Document: Header Data125SMENRNumber of Sales Unitnvarchar80
TOPBasic Data
9VIBDPLANOBJPlan Pooled Space6SMENRNumber of Rental Objectnvarchar80
10VIBDPLANPSPlan Pooled Spaces4SMENRNumber of Rental Objectnvarchar80
11VIBDRORental Object5SMENRNumber of Rental Objectnvarchar80
12VIBDROOCCOccupancy History11SMENRNumber of Rental Objectnvarchar80
TOPDunning
13MHNKDunning data (account entries)56SMENRNumber of Rental Unitnvarchar80
TOPFinancial Accounting
14/OPT/VIM_1ITEMDocument Item53SMENRNumber of Rental Unitnvarchar80
15KMZEIFI: Account Assignment Model Item Information83SMENRNumber of Rental Unitnvarchar80
16KOMUAccount Assignment Templates for G/L Account Items83SMENRNumber of Rental Unitnvarchar80
TOPFlexible Real Estate Management
17VIAKHO13WEG-Verwaltung: Umlage Eigentümerabrechnung12SMENRNummer der Mieteinheitnvarchar80
18VIAKHO20WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung5SMENRNummer der Mieteinheitnvarchar80
19VIAKHOPOWEG-Verwaltung: Jahresübersicht Umlage Bank/Rücklagen10SMENRNummer der Mieteinheitnvarchar80
20VICAINTRENOAssignment of INTRENO / OBJNR / IMKEY12SMENRNumber of Rental Objectnvarchar80
21VIXCSCCHTPITEMItem Data for External Heating Expenses Settlement6SMENRNumber of Rental Objectnvarchar80
TOPInput Tax Treatment
22VIBECOMEMietobjekte zum Berichtigungsobjekt (Optionssatzermittlung)5SMENRNummer der Mieteinheitnvarchar80
TOPProfit Center Accounting
23KE1_WU_IM_ITEMPCA Where-Used List: Itemization for Real Estate16SMENRNumber of Rental Unitnvarchar80
TOPReal Estate Management
24ONRIMRental unit object number index5SMENRNumber of Rental Unitnvarchar80
25ONRIVRental agreement item object number index6SMENRNumber of Rental Unitnvarchar80
26S401RE standard analysis partner17SMENRNumber of Rental Unitnvarchar80
27S406Rental units19SMENRRental unit: numbernvarchar80
28S407Rental agreements114SMENRNumber of Rental Unitnvarchar80
29VIAK02Settlement Participation for Service Charge Settlement5SMENRNumber of Rental Unitnvarchar80
30VIAK11Inclusion of acct settlement results from D-tape5SMENRNumber of Rental Unitnvarchar80
31VIAK13Apportionment Result for List Evaluation (SCSettlement)11SMENRNumber of Rental Unitnvarchar80
32VIAK14RA credit memo/receivable:now only used as structure!5SMENRNumber of Rental Unitnvarchar80
33VIAK17Interface for settlement / transfer of advance payments6SMENRNumber of Rental Unitnvarchar80
34VIAK18Management fee surcharge for service charges settlement6SMENRNumber of Rental Unitnvarchar80
35VIAK20RA credit memo/receivable (incid.exp.sttlmnt created)5SMENRNumber of Rental Unitnvarchar80
36VIAK24Service charges settlement: Allocate RU to set of part. RUs6SMENRNumber of Rental Unitnvarchar80
37VIAKBSEGDocument Line Item from SCS for Interface101SMENRNumber of Rental Unitnvarchar80
38VIARMVKey for archived lease-outs5SMENRNumber of Rental Unitnvarchar80
39VIAROBJArchived real estate objects13SMENRNumber of Rental Unitnvarchar80
40VIBEMEAssign rental units to correction items5SMENRNumber of Rental Unitnvarchar80
41VIBEPPFlow data - Planned items for real estate management10SMENRNumber of Rental Unitnvarchar80
42VILICICI Historical Data7SMENRNumber of Rental Unitnvarchar80
43VILIDICI Historical Data of D-Building6SMENRNumber of Rental Unitnvarchar80
44VILIRIRE Historical data8SMENRNumber of Rental Unitnvarchar80
45VIMI01Rental unit - Master data4SMENRNumber of Rental Unitnvarchar80
46VIMI02Fixtures and Fittings Characteristics of a Rental Unit4SMENRNumber of Rental Unitnvarchar80
47VIMI04Old. replaced in 3.0 with VIMIMV5SMENRNumber of Rental Unitnvarchar80
48VIMI07Reported Sales for Sales-Based Lease-Out5SMENRNumber of Rental Unitnvarchar80
49VIMI08Apportionment units per rental unit4SMENRNumber of Rental Unitnvarchar80
50VIMI09Graded Lease-Out5SMENRNumber of Rental Unitnvarchar80
51VIMI10Rental agreement additional text6SMENRNumber of Rental Unitnvarchar80
52VIMI14RA: Adjustment block for terms types5SMENRNumber of Rental Unitnvarchar80
53VIMI16RE: Records of a Rent Adjustment Run5SMENRNumber of Rental Unitnvarchar80
54VIMI18Rent Adjustment History for Lease-Out5SMENRNumber of Rental Unitnvarchar80
55VIMI20Compar.accommod.:Assign RU or ext. comp.aprtmnt to accommod.7SMENRNumber of Rental Unitnvarchar80
56VIMI21Alloc. rental unit - comparative accomm. for rent adjustment4SMENRNumber of Rental Unitnvarchar80
57VIMI22Assignment / Rental unit - rental request offers4SMENRNumber of Rental Unitnvarchar80
58VIMI23Determination of Year and Percent for Sls-Bsd LO5SMENRNumber of Rental Unitnvarchar80
59VIMI24Percentage for Sales for Sales-Based Lease-Out5SMENRNumber of Rental Unitnvarchar80
60VIMI25Sales reports5SMENRNumber of Rental Unitnvarchar80
61VIMI26Notice of rental agreement5SMENRNumber of Rental Unitnvarchar80
62VIMI28Sales settlement histories5SMENRNumber of Rental Unitnvarchar80
63VIMI31Allocation of rental units to modernization measure5SMENRNumber of Rental Unitnvarchar80
64VIMI32Other collateral5SMENRNumber of Rental Unitnvarchar80
65VIMI33Offers for a rental unit (-> VIMIMV)5SMENRNumber of Rental Unitnvarchar80
66VIMI34Determine year and percent for sales-based agreement (offer)5SMENRNumber of Rental Unitnvarchar80
67VIMI35Percent for sales for sales-based rental agrmnt (offer)5SMENRNumber of Rental Unitnvarchar80
68VIMI36Index-Linked Lease-Out Offer5SMENRNumber of Rental Unitnvarchar80
69VIMI37RA offer: Adjustment block for term types5SMENRNumber of Rental Unitnvarchar80
70VIMI39Tenant change; data for apartment inspection5SMENRNumber of Rental Unitnvarchar80
71VIMI40Tenant change: Data on release of rental deposits5SMENRNumber of Rental Unitnvarchar80
72VIMI43Allocation of expert opinion to rental units5SMENRNumber of Rental Unitnvarchar80
73VIMI47Tenant change: Alloc.of maint.orders to sec.deposit release5SMENRNumber of Rental Unitnvarchar80
74VIMIMVLease-Out6SMENRNumber of Rental Unitnvarchar80
75VIMITHRental agreement number and doc.number for printing invoices4SMENRNumber of Rental Unitnvarchar80
76VIOB08Room5SMENRNumber of Rental Unitnvarchar80
77VIOB09Areas for each Rental Unit (Obsolete)4SMENRNumber of Rental Unitnvarchar80
78VIOB10Number of rooms per rental unit4SMENRNumber of Rental Unitnvarchar80
79VIOB11Assignment of rooms to rental units4SMENRNumber of Rental Unitnvarchar80
80VIOB28OLD, replaced by VIOB39 for 3.09SMENRNumber of Rental Unitnvarchar80
81VIOB29OLD, replaced by VIOB39 for 3.09SMENRNumber of Rental Unitnvarchar80
82VIOB38Relationship between Real Estate objects and SAP-PS9SMENRNumber of Rental Unitnvarchar80
83VIOB39Relationship between Real Estate objects and SAP-PM9SMENRNumber of Rental Unitnvarchar80
84VIRPS406Rental units19SMENRRental unit: numbernvarchar80
85VIRPS407Rental agreements114SMENRNumber of Rental Unitnvarchar80
86VIVW05Management contract: Managed objects12SMENRNumber of Rental Unitnvarchar80
87VIVW08Events for management contracts13SMENRNumber of Rental Unitnvarchar80
88VIWB10Mieteinheitenzuordnung der Wirtschaftlichkeitsberechnung5SMENRNummer der Mieteinheitnvarchar80
89VIWB52WB: Laufende Aufwendungen II - ME-Zuordnung zu Bewirtschaft.7SMENRNummer der Mieteinheitnvarchar80
90VIZNRNAssignment: Real Estate numbers <-> IMKEY <-> INTRENO8SMENRNumber of Rental Unitnvarchar80
TOPSales
91VBAKSales Document: Header Data125SMENRNumber of Sales Unitnvarchar80