VMCAR01 SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from VMCAR01
Related tables to VMCAR01
Access table VMCAR01




Table View field list including key, data, relationships and ABAP select examples

VMCAR01 is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The VMCAR01 table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include SIDLDEMAND (Rental Request Identification (Local ID)), NAME1 (Name 1 (surname for persons, otherwise company name)), NAME2 (Name 2 (Continuation of NAME 1)), MC_NAME1 (Field NAME1 in Upper Case).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP VMCAR01 table view fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
SIDGDEMANDRental Request Identification (Global ID) RESADSGDEMANDCHAR20ALPHARESADSGDEMANDREARMCAR01
SIDLDEMANDRental Request Identification (Local ID) RESADSLDEMANDCHAR35RESADSLIDENT
NAME1Name 1 (surname for persons, otherwise company name) BP_NAME1CHAR40TEXT40
NAME2Name 2 (Continuation of NAME 1) BP_NAME2CHAR40TEXT40
MC_NAME1Field NAME1 in Upper Case BP_MC_NAM1CHAR25CHAR25
MC_NAME2Field NAME2 in Upper Case BP_MC_NAM2CHAR25CHAR25
BIRTH_DATEDate of Birth of Business Partner BP_BIRTHDDATS8DATUM
PARTNRBusiness Partner Number BP_PARTNR_OLDCHAR10ALPHABP_PARTNRBPN
XMEMOTEXTMemo Text For The Request (User-Defined Text) RESADXMEMOTEXTCHAR85RESADXMEMOTEXT
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
SOBJGROUPRental object group RESADSOBJGROUPNUMC2TIVAR02RESADSOBJGROUP
DFREEFROMOccup.as from RESADDFREEFROMDEDATS8DATS
DFREETILLLimited lease in until RESADDFREETILLDEDATS8DATS
CURRKEYCurrency RESADCURRKEYCUKY5TCURCWAERS
AREAKEYArea unit RESADAREAKEYUNIT3T006CUNITMEINS
PRENTEXCLTotal Net Monthly Rent RESADPRENTEXCLCURR13(2) RESADPRENTALL
PRENTINCLTotal Gross Monthly Rent RESADPRENTINCLCURR13(2) RESADPRENTALL
PRENTAREAEXCLNet Rent per Area Unit and Year RESADPRENTAREAEXCLCURR13(2) RESADPRENTAREA
PRENTAREAINCLGross Rent per Area Unit and Year RESADPRENTAREAINCLCURR13(2) RESADPRENTAREA
PSIZEALLTotal area RESADPSIZEALLQUAN14(4) VVBFLART
PSIZEUSEResidential/Usable Space RESADPSIZEUSEQUAN14(4) VVBFLART
NROOMFULLNumber of Full Rooms RESADNROOMFULLNUMC2RESADNROOMFULL
NROOMHALFNumber of Half Rooms RESADNROOMHALFNUMC1RESADNROOMHALF
SLOCALGRPDistrict Location Group Rental Request RESADSLOCALGRPNUMC1TIVAR14RESADSLOCALGRP
STRAFFROUTransport connections RESADSTRAFFROUNUMC1TIVAR06
SAGEGROUPBuilding Age Class RESADSAGEGROUPCHAR1RESADSNEWBUILD
SPARKGRPGroup of Real Estate Object Parking Spaces RESADSPARKGRPNUMC2TIVAR12RESADSPARKGRP
OCCUPOBLIGOOccupancy obligation key RBELBINDCHAR4TIV31RBELBIND
SCOUNTRYCountry Key LAND1CHAR3T005LAND1LND
SREGIOSTATE (State, Province, County) REGIOCHAR3T005SREGIO
SCOUNCCounty Code COUNCCHAR3T005ECOUNC
SCITYCCity Code CITYCCHAR4T005GCITYC
ZIPSTRINGCharacter String With Zip Code Details For Rental Request RESADZIPSTRINGCHAR35RESADZIPSTRING
LOCATIONCity ORT01_GPCHAR35TEXT35
SUBLOCATDistrict ORT02_GPCHAR35TEXT35
STREETHouse number and street STRAS_GPCHAR35TEXT35
AUTHGRPAuthorization group VVBERGRPCHAR40VVBERGRP
PROCESSMARKProcessing Indicator for Rental Request VVIBEARKZCHAR4TIVC1CHAR4
PRESELECTIONPreselection Indicator for Rental Request VVIVORMKZCHAR4TIVC2CHAR4
PROCESSSTATRental Request Processing Status VVIBSTATCHAR4TIVC3CHAR4
PARTFROMSource of Prospect VVIPARTFROMCHAR4TIVP1CHAR4
PARTWHYReason for Acquisition VVIPARTWHYCHAR4TIVP2CHAR4
PARTWAYEnquiry method VVIWAYCHAR4TIVP3CHAR4
DAPPLYDate application was received DEINBDATS8DDAT
SCRDSTNDGCredit standing application SBONINUMC2TIV62SBONI
DWBSAccommodation entitlement certificate from WBSDATUMDATS8DATUM
DWBSVALIDAccommodation entitlement certificate valid to WBSGUELTDATS8DATUM
WBSPRIORITYPriority for accommodation entitlement certificate VVWBSDRINGCHAR4TIVB7CHAR4
WBSPERSONAccomm.entitlement certif: Special group of people WBSPERSCHAR4TIVB8CHAR4
WBSAPPENDAdditional information for accomm.entitlemnt certif. WBSZUSCHAR8TIVB9CHAR8
WBSNROOMFULLNo. of rooms acc.to accommodation entitlement certificate WBSAZIMMDEC3DEC3
WBSNROOMHALFHalf room acc.to accommodation entitlement certificate WBSAHALBZIDEC2DEC2
WBSAREAKEYArea unit FEINSUNIT3T006CUNITMEINSFEH
WBSPSIZEArea factor acc.to accommodation entitlement certificate WBSFQMQUAN14(4) VVBFLART
INCOME_CURCurrency of Net Income VVINCOME_CURCUKY5TCURCWAERS
NET_INCOMEAnnual Net Income VVNET_INCOMECURR15(2) WERTV8
NATIONNationality VVNATIONCHAR3T005LAND1

Key field Non-key field



How do I retrieve data from SAP table VMCAR01 using ABAP code

The following ABAP code Example will allow you to do a basic selection on VMCAR01 to SELECT all data from the table
DATA: WA_VMCAR01 TYPE VMCAR01.

SELECT SINGLE *
FROM VMCAR01
INTO CORRESPONDING FIELDS OF WA_VMCAR01
WHERE...

How to access SAP table VMCAR01

Within an ECC or HANA version of SAP you can also view further information about VMCAR01 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!