SAP Table VIAR02 - RE: REse@rch - RE Requests

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
SIDGDEMAND X RESADSGDEMAND CHAR 3 20 0 Rental Request Identification (Global ID)
RERF RERF CHAR 23 12 0 Entered by
DERF DERF DATS 35 8 0 First Entered on
TERF TERF TIMS 43 6 0 Time of Initial Entry
REHER REHER CHAR 49 10 0 Source of initial entry
RBEAR RBEAR CHAR 59 12 0 Employee ID
DBEAR DBEAR DATS 71 8 0 Last Edited on
TBEAR TBEAR TIMS 79 6 0 Last Edited at
RBHER RBHER CHAR 85 10 0 Editing Source
JDELETE JLOESCH CHAR 95 1 0 Real Estate Deletion Indicator/Flag
SPARTID RESADSPARTID CHAR 96 10 0 VIAR03 Identification of Offering/Searching Party (User ID)
SIDLDEMAND RESADSLDEMAND CHAR 106 35 0 Rental Request Identification (Local ID)
SOBJGROUP RESADSOBJGROUP NUMC 141 2 0 TIVAR02 Rental object group
XMEMOTEXT RESADXMEMOTEXT CHAR 143 85 0 Memo Text For The Request (User-Defined Text)
DFREEFROM RESADDFREEFROMDE DATS 228 8 0 Occup.as from
DFREETILL RESADDFREETILLDE DATS 236 8 0 Limited lease in until
CURRKEY RESADCURRKEY CUKY 244 5 0 TCURC Currency
AREAKEY RESADAREAKEY UNIT 249 3 0 T006 Area unit
SAQUISIT RESADSAQUISIT CHAR 252 1 0 Acquisition Form (Rent or Purchase)
PRENTEXCL RESADPRENTEXCL CURR 253 13 2 Total Net Monthly Rent
PRENTINCL RESADPRENTINCL CURR 260 13 2 Total Gross Monthly Rent
PRENTAREAEXCL RESADPRENTAREAEXCL CURR 267 13 2 Net Rent per Area Unit and Year
PRENTAREAINCL RESADPRENTAREAINCL CURR 274 13 2 Gross Rent per Area Unit and Year
PSIZEALL RESADPSIZEALL QUAN 281 14 4 Total area
PSIZEUSE RESADPSIZEUSE QUAN 289 14 4 Residential/Usable Space
NROOMFULL RESADNROOMFULL NUMC 297 2 0 Number of Full Rooms
NROOMHALF RESADNROOMHALF NUMC 299 1 0 Number of Half Rooms
SFLOORCOD RESADSFLOORCOD NUMC 300 1 0 Floor Selection
JFLOOREXC RESADJFLOOREXC CHAR 301 1 0 Exclude Floor
SLOCALGRP RESADSLOCALGRP NUMC 302 1 0 TIVAR14 District Location Group Rental Request
STRAFFROU RESADSTRAFFROU CHAR 303 1 0 Transport connections
DBUILDDAT RESADDBUILDDAT DATS 304 8 0 Building date
DRSTORDAT RESADRSTORDAT DATS 312 8 0 Modernization Date
SAGEGROUP RESADSAGEGROUP CHAR 320 1 0 Building Age Class
CFAFCODE RESADCFAFCODE CHAR 321 20 0 Fixtures and Fittings Characteristic String
SPARKGRP RESADSPARKGRP NUMC 341 2 0 TIVAR12 Group of Real Estate Object Parking Spaces
OCCUPOBLIGO RBELBIND CHAR 343 4 0 Occupancy obligation key
OCCUPOBLIGO2 RBELBIND CHAR 347 4 0 Occupancy obligation key
OCCUPOBLIGO3 RBELBIND CHAR 351 4 0 Occupancy obligation key
OCCUPOBLIGO4 RBELBIND CHAR 355 4 0 Occupancy obligation key
JISPUBLIC RESADJISPUBLIC CHAR 359 1 0 Offer is Available
JAUTOINFO RESADJAUTOINFO CHAR 360 1 0 Automatic Notification
ZIPSTRING RESADZIPSTRING CHAR 361 35 0 Character String With Zip Code Details For Rental Request
SCOUNTRY LAND1 CHAR 396 3 0 T005 Country Key
SREGIO REGIO CHAR 399 3 0 T005S Region (State, Province, County)
SCOUNC COUNC CHAR 402 3 0 County Code
SCITYC CITYC CHAR 405 4 0 City Code
ZIPCODE PSTLZ CHAR 409 10 0 Postal Code
LOCATION ORT01_GP CHAR 419 35 0 City
SUBLOCAT ORT02_GP CHAR 454 35 0 District
STREET STRAS_GP CHAR 489 35 0 House number and street
INTRENO VVINTRENO CHAR 524 13 0 Internal Real Estate Master Data Code
AUTHGRP VVBERGRP CHAR 537 40 0 Authorization group
PROCESSMARK VVIBEARKZ CHAR 577 4 0 Processing Indicator for Rental Request
PRESELECTION VVIVORMKZ CHAR 581 4 0 Preselection Indicator for Rental Request
PROCESSSTAT VVIBSTAT CHAR 585 4 0 Rental Request Processing Status
PARTFROM VVIPARTFROM CHAR 589 4 0 Source of Prospect
PARTWHY VVIPARTWHY CHAR 593 4 0 Reason for Acquisition
PARTWAY VVIWAY CHAR 597 4 0 Enquiry method
DAPPLY DEINB DATS 601 8 0 Date application was received
SCRDSTNDG SBONI NUMC 609 2 0 Credit standing application
XCRDSTNDG XWBONI CHAR 611 50 0 Reason for credit standing
NNUMPERS APERS DEC 661 3 0 Number of persons
XPASSPORT XPASSNR CHAR 663 18 0 Passport number
DPASSSUB DPASSV DATS 681 8 0 Date of submission of passport
JWBS JWBS CHAR 689 1 0 Indicator: Accommodation entitlement certificate exists
DWBS WBSDATUM DATS 690 8 0 Accommodation entitlement certificate from
DWBSVALID WBSGUELT DATS 698 8 0 Accommodation entitlement certificate valid to
DWBSREFUSE WBSABL DATS 706 8 0 Accommodation entitlement certificate refused on
WBSPRIORITY VVWBSDRING CHAR 714 4 0 Priority for accommodation entitlement certificate
WBSPERSON WBSPERS CHAR 718 4 0 Accomm.entitlement certif: Special group of people
WBSAPPEND WBSZUS CHAR 722 8 0 Additional information for accomm.entitlemnt certif.
WBSNROOMFULL WBSAZIMM DEC 730 3 0 No. of rooms acc.to accommodation entitlement certificate
WBSNROOMHALF WBSAHALBZI DEC 732 2 0 Half room acc.to accommodation entitlement certificate
WBSAREAKEY FEINS UNIT 734 3 0 T006 Area unit
WBSPSIZE WBSFQM QUAN 737 14 4 Area factor acc.to accommodation entitlement certificate
WBSREFERENCE WBSGS CHAR 745 20 0 Accommodation entitlement certificate reference no.
WBSMEMO WBSINFO CHAR 765 40 0 Memo on accommodation entitlement certificate
INCOME_CUR VVINCOME_CUR CUKY 805 5 0 TCURC Currency of Net Income
NET_INCOME VVNET_INCOME CURR 810 15 2 Annual Net Income
NATION VVNATION CHAR 818 3 0 T005 Nationality
PARTNR BP_PARTNR CHAR 821 10 0 Business Partner Number
SBWNR SBWNR NUMC 831 7 0 VIMI11 Application number
SMIWUNR SMIWUNR NUMC 838 3 0 VIMI12 Rent request number

889174LCC: Upgrading control table entries in 46C, 470 and 500