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

183 columns | Print definition?ERP 6.0  | SWENR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item103SWENRSite Numbernvarchar80
2/OPT/VIM_TITEMDocument Item103SWENRSite Numbernvarchar80
3REMOB_T_CONDAssign Condition Type & Measurement Type3SWENRSite Numbernvarchar80
4REMOB_T_LOGVisit History4SWENRSite Numbernvarchar80
5VIYCEXPITEMExpense Items59SWENRValid Sitenvarchar80
6VIYCPGParticipation Group for CAM3SWENRValid Sitenvarchar80
7VIYCSETTLSettlement Identification with Log Reference25SWENRSite Numbernvarchar80
8YVIM_1ITEMDocument Item103SWENRSite Numbernvarchar80
9ZEIM_VBAKSales Document: Header Data124SWENRBusiness Entity Numbernvarchar80
TOPBasic Data
10VIBDBEBusiness Entity4SWENRSite Numbernvarchar80
11VIBDBUBuilding4SWENRSite Numbernvarchar80
12VIBDPLANOBJPlan Pooled Space5SWENRSite Numbernvarchar80
13VIBDPLANPSPlan Pooled Spaces3SWENRSite Numbernvarchar80
14VIBDPRLand4SWENRSite Numbernvarchar80
15VIBDRORental Object4SWENRSite Numbernvarchar80
16VIBDROOCCOccupancy History10SWENRSite Numbernvarchar80
TOPDunning
17MHNKDunning data (account entries)55SWENRSite Numbernvarchar80
TOPFinancial Accounting
18/OPT/VIM_1ITEMDocument Item103SWENRSite Numbernvarchar80
19KMZEIFI: Account Assignment Model Item Information80SWENRSite Numbernvarchar80
20KOMUAccount Assignment Templates for G/L Account Items80SWENRSite Numbernvarchar80
TOPFlexible Real Estate Management
21VIAKHO13WEG-Verwaltung: Umlage Eigentümerabrechnung11SWENRNummer der Wirtschaftseinheitnvarchar80
22VIAKHO20WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung4SWENRNummer der Wirtschaftseinheitnvarchar80
23VIAKHO21Mandatsverwaltung: Gesplittete Abrechnungsgrößen3SWENRNummer der Wirtschaftseinheitnvarchar80
24VIAKHOIRWEG-Verwaltung: Stammdaten Bank/ Instandhaltungsrücklage6SWENRNummer der Wirtschaftseinheitnvarchar80
25VIAKHOPOWEG-Verwaltung: Jahresübersicht Umlage Bank/Rücklagen9SWENRNummer der Wirtschaftseinheitnvarchar80
26VICAINTRENOAssignment of INTRENO / OBJNR / IMKEY9SWENRSite Numbernvarchar80
27VIFANLALUM: Flurstück - Zugeordnete Anlagenstammsätze5SWENRNummer der Wirtschaftseinheitnvarchar80
28VIFANLA_LOGLUM: Flurstück - Integration Anlagenbuchhaltung4SWENRNummer der Wirtschaftseinheitnvarchar80
29VIFFLAECHENLUM: Flurstück - Flächen Bestand/Nutzung/Anlagen7SWENRNummer der Wirtschaftseinheitnvarchar80
30VIFWEFLAECHEGISLUM: Flurstück - Zugeordn. WE-Flächen im GIS Anlagensicht4SWENRNummer der Wirtschaftseinheitnvarchar80
31VIXCSCCHTAPEHeader Data for External Heating Expenses Settlement7SWENRValid Sitenvarchar80
32VIXCSCCHTPITEMItem Data for External Heating Expenses Settlement5SWENRValid Sitenvarchar80
33VIXCSCCHTPSHARDistribution for External Heating Expenses Settlement4SWENRValid Sitenvarchar80
TOPInput Tax Treatment
34VIBECOMEMietobjekte zum Berichtigungsobjekt (Optionssatzermittlung)4SWENRNummer der Wirtschaftseinheitnvarchar80
TOPLogistics - General
35CHBSPRPReports offered at the pre-sales tool3SWENRSite Numbernvarchar80
36CHBSPRPTText table to CHBSPRP4SWENRSite Numbernvarchar80
37HBSAFFAffected building in Home Building Solution3SWENRSite Numbernvarchar80
38HBSAUTHelper table for auto generation ...3SWENRSite Numbernvarchar80
39HBSCMPCommunity Plan Data within Home Building Solution3SWENRSite Numbernvarchar80
40HBSFLSFit-List3SWENRSite Numbernvarchar80
41HBSFSPHelp dummy table3SWENRSite Numbernvarchar80
42HBSPPHPermitted Development Phases3SWENRSite Numbernvarchar80
43HBSRLCCharacteristics for Rules3SWENRSite Numbernvarchar80
44HBSRLSAffected Building List3SWENRSite Numbernvarchar80
45HBSSPHPermitted Sales Phases3SWENRSite Numbernvarchar80
TOPMigration
46VIGWARARFLSchlüssel archivierter arch. Flächen3SWENRTalousyksikön numeronvarchar80
47VIGWARARRASchlüssel archivierter arch. Räume3SWENRTalousyksikön numeronvarchar80
48VIGWARFLImmobilien gew.: Architektonische Fläche (statischer Teil)16SWENRTalousyksikön numeronvarchar80
49VIGWARRAImmobilien gew.: Architektonischer Raum (statischer Teil)15SWENRTalousyksikön numeronvarchar80
50VIGWARVMFLSchlüssel archivierter Mietflächen und -räume3SWENRTalousyksikön numeronvarchar80
51VIGWFLGGZUImmobilien gew.: Fl.-Zuordnung zu Gebäude oder Grundstück7SWENRTalousyksikön numeronvarchar80
52VIGWRAGEZUImmobilien gew.: Ra-Zuordnung zu Gebäude oder Gebäudeteil7SWENRTalousyksikön numeronvarchar80
53VIGWVMFLZImmobilien gew.:Stammdaten Vermietfldche (zeitabh.Teil)7SWENRTalousyksikön numeronvarchar80
54VIGWVOBWImmobilien gew.: Vorbelegung d.Konditionen f. BuKr/WE/GE/G3SWENRTalousyksikön numeronvarchar80
55VIGWVOBW_UPDImmobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.3SWENRTalousyksikön numeronvarchar80
56VIGW_VOBWCRE Ph.2.1 neu: Vorbelegung d.Konditionen f. BuKr/WE/GE/GR3SWENRTalousyksikön numeronvarchar80
57VIGW_VOBW_UPDImmobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.3SWENRTalousyksikön numeronvarchar80
TOPProfit Center Accounting
58KE1_WU_IM_ITEMPCA Where-Used List: Itemization for Real Estate13SWENRSite Numbernvarchar80
TOPReal Estate Localization Czech Republic
59/CEERE/SDANAProperty tax return - items14SWENRSite Numbernvarchar80
60/CEERE/SDANJEDNProperty tax - units4SWENRSite Numbernvarchar80
61/CEERE/SDANPProperty tax - master5SWENRSite Numbernvarchar80
62/CEERE/SDANPARCProperty tax - plots of land4SWENRSite Numbernvarchar80
TOPReal Estate Management
63ONRIACalculation unit object number index4SWENRSite Numbernvarchar80
64ONRIMRental unit object number index4SWENRSite Numbernvarchar80
65ONRIVRental agreement item object number index5SWENRSite Numbernvarchar80
66S401RE standard analysis partner14SWENRSite Numbernvarchar80
67S402Business entities74SWENRSite Numbernvarchar80
68S404Properties74SWENRSite Numbernvarchar80
69S405Building14SWENRSite Numbernvarchar80
70S406Rental units16SWENRSite Numbernvarchar80
71S407Rental agreements148SWENRSite Numbernvarchar80
72S408Land registers88SWENRSite Numbernvarchar80
73VIAK01History of acct settlement runs3SWENRSite Numbernvarchar80
74VIAK02Settlement Participation for Service Charge Settlement4SWENRSite Numbernvarchar80
75VIAK03Settlement Unit Master Record3SWENRValid business entitynvarchar80
76VIAK04Allocation of Settlement Variants to Settlement Unit3SWENRSite Numbernvarchar80
77VIAK05Allocation of rental units to calculation unit3SWENRSite Numbernvarchar80
78VIAK06Calculation unit relations6SWENRSite Numbernvarchar80
79VIAK07Calculation unit option rate3SWENRSite Numbernvarchar80
80VIAK08DME Settlement Units Master Data4SWENRSite Numbernvarchar80
81VIAK09Assignment of Heating Systems to Calculation Units6SWENRSite Numbernvarchar80
82VIAK11Inclusion of acct settlement results from D-tape4SWENRSite Numbernvarchar80
83VIAK13Apportionment Result for List Evaluation (SCSettlement)10SWENRSite Numbernvarchar80
84VIAK14RA credit memo/receivable:now only used as structure!4SWENRSite Numbernvarchar80
85VIAK17Interface for settlement / transfer of advance payments5SWENRSite Numbernvarchar80
86VIAK18Management fee surcharge for service charges settlement5SWENRSite Numbernvarchar80
87VIAK19Costs Directly Assigned to Lease-Out12SWENRSite Numbernvarchar80
88VIAK20RA credit memo/receivable (incid.exp.sttlmnt created)4SWENRSite Numbernvarchar80
89VIAK21Split settlement factors for settlement variant3SWENRSite Numbernvarchar80
90VIAK22Heat.oil supply3SWENRSite Numbernvarchar80
91VIAK22THeat.oil supply texts3SWENRSite Numbernvarchar80
92VIAK24Service charges settlement: Allocate RU to set of part. RUs5SWENRSite Numbernvarchar80
93VIAK25Cost collector for SU (per settlement period)3SWENRValid business entitynvarchar80
94VIAK26Master Settlement Unit: Participating Settlement Units3SWENRValid business entitynvarchar80
95VIAKBSEGDocument Line Item from SCS for Interface98SWENRSite Numbernvarchar80
96VIAKT5Rental units allocation ID4SWENRSite Numbernvarchar80
97VIARMVKey for archived lease-outs4SWENRSite Numbernvarchar80
98VIAROBJArchived real estate objects10SWENRSite Numbernvarchar80
99VIBEMEAssign rental units to correction items4SWENRSite Numbernvarchar80
100VIBEPPFlow data - Planned items for real estate management9SWENRSite Numbernvarchar80
101VIGBSTDReal estate register of land register17SWENRSite Numbernvarchar80
102VILICICI Historical Data6SWENRSite Numbernvarchar80
103VILIDICI Historical Data of D-Building5SWENRSite Numbernvarchar80
104VILIRIRE Historical data7SWENRSite Numbernvarchar80
105VIMI01Rental unit - Master data3SWENRSite Numbernvarchar80
106VIMI02Fixtures and Fittings Characteristics of a Rental Unit3SWENRSite Numbernvarchar80
107VIMI04Old. replaced in 3.0 with VIMIMV4SWENRSite Numbernvarchar80
108VIMI07Reported Sales for Sales-Based Lease-Out4SWENRSite Numbernvarchar80
109VIMI08Apportionment units per rental unit3SWENRSite Numbernvarchar80
110VIMI09Graded Lease-Out4SWENRSite Numbernvarchar80
111VIMI10Rental agreement additional text5SWENRSite Numbernvarchar80
112VIMI14RA: Adjustment block for terms types4SWENRSite Numbernvarchar80
113VIMI16RE: Records of a Rent Adjustment Run4SWENRSite Numbernvarchar80
114VIMI18Rent Adjustment History for Lease-Out4SWENRSite Numbernvarchar80
115VIMI20Compar.accommod.:Assign RU or ext. comp.aprtmnt to accommod.6SWENRSite Numbernvarchar80
116VIMI21Alloc. rental unit - comparative accomm. for rent adjustment3SWENRSite Numbernvarchar80
117VIMI22Assignment / Rental unit - rental request offers3SWENRSite Numbernvarchar80
118VIMI23Determination of Year and Percent for Sls-Bsd LO4SWENRSite Numbernvarchar80
119VIMI24Percentage for Sales for Sales-Based Lease-Out4SWENRSite Numbernvarchar80
120VIMI25Sales reports4SWENRSite Numbernvarchar80
121VIMI26Notice of rental agreement4SWENRSite Numbernvarchar80
122VIMI28Sales settlement histories4SWENRSite Numbernvarchar80
123VIMI31Allocation of rental units to modernization measure4SWENRSite Numbernvarchar80
124VIMI32Other collateral4SWENRSite Numbernvarchar80
125VIMI33Offers for a rental unit (-> VIMIMV)4SWENRSite Numbernvarchar80
126VIMI34Determine year and percent for sales-based agreement (offer)4SWENRSite Numbernvarchar80
127VIMI35Percent for sales for sales-based rental agrmnt (offer)4SWENRSite Numbernvarchar80
128VIMI36Index-Linked Lease-Out Offer4SWENRSite Numbernvarchar80
129VIMI37RA offer: Adjustment block for term types4SWENRSite Numbernvarchar80
130VIMI39Tenant change; data for apartment inspection4SWENRSite Numbernvarchar80
131VIMI40Tenant change: Data on release of rental deposits4SWENRSite Numbernvarchar80
132VIMI43Allocation of expert opinion to rental units4SWENRSite Numbernvarchar80
133VIMI47Tenant change: Alloc.of maint.orders to sec.deposit release4SWENRSite Numbernvarchar80
134VIMIMVLease-Out5SWENRSite Numbernvarchar80
135VIMITHRental agreement number and doc.number for printing invoices3SWENRSite Numbernvarchar80
136VIOB01Business entities3SWENRSite Numbernvarchar80
137VIOB02Property master data3SWENRSite Numbernvarchar80
138VIOB03Real estate building master3SWENRSite Numbernvarchar80
139VIOB04Buildings: Fixtures and fittings characteristics3SWENRSite Numbernvarchar80
140VIOB05Building option rate3SWENRSite Numbernvarchar80
141VIOB06Property option rate3SWENRSite Numbernvarchar80
142VIOB07Business entity option rate3SWENRSite Numbernvarchar80
143VIOB08Room3SWENRSite Numbernvarchar80
144VIOB09Areas for each Rental Unit (Obsolete)3SWENRSite Numbernvarchar80
145VIOB10Number of rooms per rental unit3SWENRSite Numbernvarchar80
146VIOB14Areas for Building (Obsolete)3SWENRSite Numbernvarchar80
147VIOB15Areas for properties3SWENRSite Numbernvarchar80
148VIOB20Fixtures and fittings objects for building3SWENRSite Numbernvarchar80
149VIOB22Rooms6SWENRSite Numbernvarchar80
150VIOB24Rental units per usage type (plan)3SWENRSite Numbernvarchar80
151VIOB27Relationship between properties and buildings3SWENRSite Numbernvarchar80
152VIOB28OLD, replaced by VIOB39 for 3.06SWENRSite Numbernvarchar80
153VIOB29OLD, replaced by VIOB39 for 3.06SWENRSite Numbernvarchar80
154VIOB35Productive Holdings6SWENRSite Numbernvarchar80
155VIOB38Relationship between Real Estate objects and SAP-PS6SWENRSite Numbernvarchar80
156VIOB39Relationship between Real Estate objects and SAP-PM6SWENRSite Numbernvarchar80
157VIROZReal Estate: IPD reporting additional fields3SWENRSite Numbernvarchar80
158VIRPS405Building14SWENRSite Numbernvarchar80
159VIRPS406Rental units16SWENRSite Numbernvarchar80
160VIRPS407Rental agreements148SWENRSite Numbernvarchar80
161VIVW05Management contract: Managed objects9SWENRSite Numbernvarchar80
162VIVW08Events for management contracts10SWENRSite Numbernvarchar80
163VIWB10Mieteinheitenzuordnung der Wirtschaftlichkeitsberechnung4SWENRNummer der Wirtschaftseinheitnvarchar80
164VIWB52WB: Laufende Aufwendungen II - ME-Zuordnung zu Bewirtschaft.6SWENRNummer der Wirtschaftseinheitnvarchar80
165VIWEGBRelation table between buildings and assets3SWENRSite Numbernvarchar80
166VIWEGRRelation table between property and assets3SWENRSite Numbernvarchar80
167VIWI01Cost Efficiency Analysis Total Costs3SWENRSite Numbernvarchar80
168VIWI02Cost Efficiency Analysis Finance Plan3SWENRSite Numbernvarchar80
169VIWI03Cost Efficiency Analysis Current Expenditure3SWENRSite Numbernvarchar80
170VIWI04Cost Efficiency Analysis Average Rent/Charges3SWENRSite Numbernvarchar80
171VIWI05Cost Efficiency Analysis Current Expenditure3SWENRSite Numbernvarchar80
172VIWIGKCost Efficiency Analysis Total Costs3SWENRSite Numbernvarchar80
173VIWIRTCost Efficiency Analysis Basic Table3SWENRSite Numbernvarchar80
174VIWIV1Simplified CEA: Property and Building Description3SWENRSite Numbernvarchar80
175VIWIV2Simplified CEA: Calculation of Total Costs3SWENRSite Numbernvarchar80
176VIWIV3Simplified CEA: Finance Plan Outside Funds3SWENRSite Numbernvarchar80
177VIWIV4Simplified CEA: Finance Plan Internal Activities3SWENRSite Numbernvarchar80
178VIZNRNAssignment: Real Estate numbers <-> IMKEY <-> INTRENO5SWENRSite Numbernvarchar80
TOPReal Estate Slovakia
179VIXCSKSDANPProperty Tax - Master data5SWENRSite Numbernvarchar80
180VIXCSKTAXRET_PProperty Tax Return SK - Items - Sections II,III,IV7SWENRSite Numbernvarchar80
TOPSales
181VBAKSales Document: Header Data124SWENRBusiness Entity Numbernvarchar80
TOPService Charge Settlement
182VISCPGParticipation Group4SWENRValid Sitenvarchar80
183VISCSUSettlement unit4SWENRValid Sitenvarchar80