Below are the view tables, which gives the data from different tables into one table based on the unique available key. This makes easier for getting the data, instead of feeding seperately. It will be more helpful during data validation or for custom report preperation in Real Estate - Flexible area.
V_VIRADOCCFCN - View of RE Document with Contract and Cash Flow Data
==> VIRADOC - RE Document Header
==> VIRADOCITEM - RE Document Item
==> VICDCFPAY - Payment-Related Cash Flow
==> VICN01 - Real Estate Contract: Contract Data
V_BUILDING Rental Object With Criteria From Superior Tables
==> VIOB03 - Real estate building master
==> VIOB01 - Business entities
V_CONDPURP_ATTR RE: Attributes for Condition Purpose
==> TIVCDCOPUINT - Conditions - Internal Purpose
==> TIVCDCOPUEXT - Conditions - External Purpose
V_REBDBENOO Matchcode Business Entity for Order (Direct Allocation)
==> VIOBOV - Assignment Table for Real Estate to Standard Objects
==> VIOB01 - Business entities
==> AUFK - Order master data
V_REBDBUNOO Matchcode Building for Order (Direct Allocation)
==> VIOBOV - Assignment Table for Real Estate to Standard Objects
==> VIOB03 - Real estate building master
==> AUFK - Order master data
V_REBDPRNOO Matchcode Property for Order (Direct Allocation)
==> VIOBOV - Assignment Table for Real Estate to Standard Objects
==> VIOB02 - Property master data
==> AUFK - Order master data
V_REBDRONOMS Matchcode: REBDRONOMS (Rental Objects by Measurement)
==> VIMI01 - Rental unit - Master data
==> VIBDMEAS - Measurement
==> TIVBDMEAST - Measurement Types - Texts
V_REBDRONRB View for Matchcode ID REBDRONRB (Rental Objects)
==> VIMI01 - Rental unit - Master data
==> VIOB03 - Real estate building master
V_REBDRONRC Generated View for Matchcode ID MCME -C
==> VIMI01 - Rental unit - Master data
==> VIOB02 - Property master data
V_REBDRONRD Generated View for Matchcode ID MCME -D
==> VIMI01 - Rental unit - Master data
==> VIOB01 - Business entities
V_REBDRONROR Matchcode Rental Objects for Order (Direct Assignment)
==> VIOBOV - Assignment Table for Real Estate to Standard Objects
==> VIMI01 - Rental unit - Master data
==> AUFK - Order master data
V_REBDRONTP Matchcode Rental Objects for Functional Location
==> VIBDPMFL - Link from RE Object to Functional Location
==> IFLOT - Functional Location (Table)
==> VIMI01 - Rental unit - Master data
==> IFLOTX - Functional Location: Short Texts
V_RECNCNB View for Search Help RECNCNB
==> VICN01 - Real Estate Contract: Contract Data
==> JEST - Individual Object Status
V_RECNCND View for RECNCND Search Help
==> VICN01 - Real Estate Contract: Contract Data
==> VIBPOBJREL - Business Partner-Object Relationship
==> BUT020 - BP: Addresses
==> ADRC - Addresses (Business Address Services)
==> BUT000 - BP: General data I
==> TBZ0T - BDT Object Parts: Texts
V_RECNCNE View for RECNCNE Search Help
==> VICN01 - Real Estate Contract: Contract Data
==> VIOBOV - Assignment Table for Real Estate to Standard Objects
==> VIMI01 - Rental unit - Master data
V_RECNCNF View for RECNCNF Search Help
==> VICN01 - Real Estate Contract: Contract Data
==> VIOBOV - Assignment Table for Real Estate to Standard Objects
==> VIOB01 - Business entities
V_RECNCNG View for RECNCNG Search Help
==> VICN01 - Real Estate Contract: Contract Data
==> VIOBOV - Assignment Table for Real Estate to Standard Objects
==> VIOB02 - Property master data
V_RECNCNH View for RECNCNH Search Help
==> VICN01 - Real Estate Contract: Contract Data
==> VIOBOV - Assignment Table for Real Estate to Standard Objects
==> VIOB03 - Real estate building master
V_RECNCNI View for RECNCNI Search Help
==> VICN01 - Real Estate Contract: Contract Data
==> VICARSDATE - List of Dates from Resubmission Rule
V_RECNCNK View for Search Help RECNCNK
==> VICN01 - Real Estate Contract: Contract Data
==> VIAJTERM - Contract/Rental Object: Adjustment Term
V_RECNCNP View for RECNCNP Search Help
==> VICN01 - Real Estate Contract: Contract Data
==> VIBPOBJREL - Business Partner-Object Relationship
==> BUT000 - BP: General data I
V_RENTAL_OBJSP Rental Object With Criteria From Superior Tables
==> VIMI01 - Rental unit - Master data
==> VIOB01 - Business entities
V_RESCPGB Participation Groups Using Rental Object
==> VIMI01 - Rental unit - Master data
==> VIBDOBJREL - Object Relationship A/U Object <-==> A/U Object
==> VISCPG - Participation Group
V_RESCPGC Participation Groups via Use in Settlement Units
==> VIAK03 - Settlement Unit Master Record
==> VIBDOBJREL - Object Relationship A/U Object <-==> A/U Object
==> VISCPG - Participation Group
Author: VUPPALA VENKATA RAMANA
Hi Vuppala,
ReplyDeleteCan you tell me how to retrieve the data from the view tables above?
I am actually looking for way to link Contract and Customer Master Data and Condition. Hope you can give me the linkage.
Thanks,
Kon
Hi Kon,
ReplyDeleteGiven tables are view tables but you can use these tables in SE16N / any program logic. Given are standard and combination of tables mentioned.
Regards
SAP
Hi VUPPALA,
ReplyDeleteI would like to thank the author for the helpful information you have posted. It is hard to find the information related to REFx module on the internet.
Regards,
Abhijeet