SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

VIRPS407 Table in SAP | Rental agreements Table & Fields List

VIRPS407 is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of VIRPS407 in SAP.

  • Table description : Rental agreements
  • Module : CRM
  • Parent Module : CRM
  • Package : FVVI
  • Software Component : BBPCRM
VIRPS407 table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP VIRPS407 Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
SSOURStatistic(s) originSSOURSSOUR
VRSIOVersion number in the information structureVRSIOVRSIO
SPMONPeriod to analyze - monthSPMONMCPERIOD
SPTAGPeriod to analyze - current dateSPTAGDATUM
SPWOCPeriod to analyze - weekSPWOCMCPERIOD
SPBUPPeriod to analyze - posting periodSPBUPMCPERIOD
BUKRS_01Company CodeBUKRSBUKRS
GSBER_02Business AreaGSBERGSBER
SWENR_03Business Entity NumberSWENRSWENR
SGRNR_04Land Number for BESGRNRSGRNR
SGENR_05Building NumberSGENRSGENR
SMENR_06Number of Rental UnitSMENRSMENR
SMIVE_07Lease-Out NumberSMIVEVVSMIVE
PERIVFiscal Year VariantPERIVPERIV
VWDATPointer to administrative dataVWDATVWDAT
USRUNITUser field: Unit for quantity fieldsUSRUNITMEINS
USRCUKYUser field: Unit for value fieldsUSRCUKYWAERS
WAERSCurrency KeyWAERSWAERS
FEINSArea unitFEINSMEINS
DERSTDRDate When the Lease-Out was First PrintedVVDERSTDRDATUM
PROFLSettlement profile for costsVVAPROFAPROF
ABNNRSettlement firm: numberVVABNNRTEXT20
STECHEMSettlement firm: Evaluation groupVVSTECHEMSTECHEM
ABNUNRSettlement company: subnumberVVABNUNRNUM3
XNNPARTABWAlternative payer: surnameVVNNPARTBATEXT20
XPARTNRABWAlternative payer: nameVVXPARTNRACHAR35
XORTAddress: CityVVXORTTEXT35
XPLZAddress: Postal codeVVXPLZPSTLZ
XSTRASSEAddress: Street/house numberVVXSTRASSETEXT35
ANKUENNotification until (for renewal of contract)ANKUENNUMC2
XMVANARTLease-out primary adjustment typeVVXMVANPPRCHAR15
XMVANART44Lease-Out Secondary Adjustment TypeVVXMVANARTXKBEZ
DASPVONAdjustment block as fromVVDASPVONDATUM
DASPBISAdjustment block untilVVDASPBISDATUM
ANZMVNo. of lease-outsVVAMVVVDEC6
AZIMMNumber of roomsVVAZIMMDEC6
AHALBZINumber of half roomsVVAHALBZIDEC6
SKUEFRType of notice periodSKUEFRSKUEFR
SAUSTKLFixtures and fittings categorySAUSKLSAUSKL
BANKKSBank KeysBANKKBANKK
DBKERHCash deposit received onVVDBKERHDATUM
MEINSBase Unit of MeasureMEINSMEINS
XBELEGNGRU occupancy by LO (used by third-prty/private/corp.grp)VVSBELEGN2CHAR30
SBELEGNGRU occupancy by LO (used by third-prty/private/corp.grp)VVSBELEGNGVVSBELEGNG
USR02User-defined field 1 for 10 charactersUSRCHAR101USRCHAR10
USR03User-defined field 2 for 10 charactersUSRCHAR102USRCHAR10
USR00User-defined field 1 for 20 charactersUSRCHAR201USRCHAR20
USR01User field 2 for 20 charactersUSRCHAR202USRCHAR20
USR08User field 1 for dateUSRDATE1USRDATE
USR09User field 2 for dateUSRDATE2USRDATE
USRUNIT1User field: Unit for quantity fieldsUSRUNITMEINS
USRCUKY2User field: Unit for value fieldsUSRCUKYWAERS
USRCUKY1User field: Unit for value fieldsUSRCUKYWAERS
USRUNIT2User field: Unit for quantity fieldsUSRUNITMEINS
USR10User field 1 indicator for evaluationsUSRFLAG1FLAG
USR11User field 2 indicator for evaluationsUSRFLAG2FLAG
USR04User field 1 for set (length 10,3)USRQUAN131USRQUAN13
USR05User field 2 for set (length 10.3)USRQUAN132USRQUAN13
USR06User field 1 for values (length 10.3)USRCURR131USRCURR13
USR07User field 2 for values (length 10.3)USRCURR132USRCURR13
JBETRSTSecurity deposit grantedJBETRSTJANEI
BKONDQMCurrency amount per area unitBKONDQMWRTV7
FBEZUGReference area for calculation of amounts per area unitVVFBEZUGVVFBEZUG
BUKRSCompany CodeBUKRSBUKRS
DERZAHLDate: 1st debit positionVVDERZADDAT
DAKTVDate: ActivationVVDAKTVDATUM
DAUSZGDate: Move-outVVDAUSZG2DATS
DEINZGDate: Move-inVVDEINZG2DATS
DKUEZUDate: NoticeVVDKUZU2DATS
DMIBEGDate: Start of rentVVDMIBEDDAT
DMIENDDate: rental endVVDMIENDDAT
DUNTBISDate: Provisional agreement fromVVDUNBIDDAT
ZUSPKUNNRCustomer NumberKUNNRKUNNR
BABRESettlement unitsVVBABREVVBABRE
PERHOEPercentage rate increaseVVPERHOEDEC8_2
FKONDFLAArea for condition typeVVFKONDFLAVVFKONDFLA
SGENRBuilding NumberSGENRSGENR
XGEBTBuilding: partVVXGEBTCHAR15
SGEBTPart of BuildingSGEBTSGEBT
GERSTDJurisdictionVVXGERSTDTEXT35
SSTOCKWFloorVVSSTOCKWVVSSTOCKW
XSTOCKWFloor (text)VVXSTOCKWCHAR15
GSBERBusiness AreaGSBERGSBER
XASPGRDReason for adjustment block (text)VVXASPGRDXTEXT30
XMANSPDunning block reasonVVXMANSPCHAR30
SASPGRDReason for adjustment blockVVSASPGRDVVSASPGRD
SGRNRLand Number for BESGRNRSGRNR
KUNNRMain tenant: Customer numberVVRDEBIHV2KUNNR
XNNPARTMaster tenant: last nameVVNNPARTBTEXT20
XPARTNRMaster tenant: nameVVXPARTNRCHAR35
INTRENOInternal Real Estate Master Data CodeVVINTRENOVVINTRENO
DKAUFOPTPurchase option: dateVVDKAUFOPTDDAT
JKAUFOPTPurchase option: indicatorVVJKAUFOPTJANEI
BKAUTIONDeposit: amountVVBKAUTARTWRTV7
JMFREICondition is not checkedVVJMFREIJANE
DGULTABCondition: effective fromVVDKONDDDAT
SKOARTCondition Type (Smallest Subdivision of Condition Records)SKOARTSKOART
BKONDCondition item currency amountBKONDWERTV7
KOSTLCost center: nameVVXKOSTLKOSTL
DATABCost center: effective from_VVDKOSTLDATUM
XKUEFRType of notice periodVVXKUEFRCHAR30
DKUEFRNotice period: monthsVVAKUEFR2DEC06
XLGESCHLocation in floor (text)VVXLGESCHCHAR15
RLGESCHLocation on FloorRLGESCHRLGESCH
SLAGKLocation classSLAGKSLAGK
MANSPDunning blockMANSPMANSP
JMAHNMSPDunning block indicator - no longer used!JMASPJANE
MABERDunning: areaVVMABERMABER
MADATDate of last dunning letterVVDMADATDATUM
MANSTDunning: levelVVMAHNSMAHNS
BMWSTValue-added tax amount includedBMWSTWRTV7
AMELDINSales reporting intervalAMELDININTVJ
SMENRNumber of Rental UnitSMENRSMENR
XMBEZReason for rent reductionVVMMXMBEZXMBEZ
SKAUTARTType of Rental CollateralSKAUASKAUA
XKAUTARTDeposit: typeVVXKAUTARTCHAR15
XAUSTKLRepresent. list of rents: Fixture/fitting categoryVVXXAUSTKLCHAR15
XLAGKRepresentative list of rents: locat.classVVXLAGKXMBEZ
XMIETSPRepresentative list of rents: allocationVVXMIETSPCHAR15
SMIETSPRepresentative list of rents assignmentSMIETSPSMIETSP
SMIVELease-Out NumberSMIVEVVSMIVE
XMVARTLease out: TypeVVXMVARTCHAR15
FLG_MITARBEmployee indicatorVVSMITARB2XFELD
OBJNRObject numberJ_OBJNRJ_OBJNR
SPARTNRPartner numberSPARTNRSPARTNR
SMVANARTRental agreement primary adjustment typeSMVAR04SMVAR
PRCTRProfit CenterPRCTRPRCTR
JBKRZCash deposit instalment paymentVVJBKRZJANEI
REINSUnit for cubic volumeREINSMEINS
JRMSCHPRTenant service charge settlement?VVJRMSCHPRXFELD
DGABANRT44Secondary adjustment type valid fromVVDGABANR2DATUM
DBISANRT44Secondary adjustment type valid untilVVDBISANR2DATUM
SMVANART44Rental agreement secondary adjustment typeSMVAR44SMVAR
SICHGEBGuarantorVVXSICHGEBTEXT30
JSKUENDSpecial right of noticeJSKUENDJANEI
STTXT_EXTStatus: Set by userVVXSTXTEXTCHAR40
STTXT_INTStatus: Set by systemVVXSTTXTINCHAR40
DGABDate when the apportionment factor becomes validVVDUMLGADDAT
SABRGApportionment unitSABRGSABRG
PPROZ0Sales: minimum percentageVVPPROZ0DEC3_2
BMINUMSSales: minimumVVBUMSATZ1WRTV7
BUMSPROJSales: planVVBUMSPROJWRTV7
DVMUNContract signed by landlordVVDVMUNDATUM
VERLGContract renewal by ... monthsVERLGNUMC3
SMVARTExternal Real Estate contract typeSMVARTSMVART
JVERLContract renewalJVERLVVVERL
SWENRBusiness Entity NumberSWENRSWENR
XGZLSCHPayment method for credit memosVVXGZLSCHCHAR30
ZLSCHPayment methodDZLSCHZLSCH
XZLSCHPayment methodVVXZLSCHCHAR30
GZLSCHPayment method for credit memosVVGZLSCHZLSCH
PZUABSPSurcharge or reduction for representative list of rentsVVPZUABSPDEC8_2
PROZTEILSubsidy percentage rateVVPZUSPDECV5_2
DGUELTABDate as from when subsidy validVVDZUSPABDATUM
DGUELBISDate up to when subsidy validVVDZUSPBISDATUM
DFAELLSubsidy due dateVVDZUSPFAEDATUM
BZUBETRSubsidy/allowance amountVVZUBETRWERTV7
XZUSPKUNNRSubsidizerVVXZUSPPRTCHAR35
ZUSPSubsidies available, indicatorVVZUSPJANE
SPARTNRABWAlternative payer (partner number)VVRPARTABWSPARTNR
DAENDDRDate When the Lease-Out was Changed and Printed OutVVDAENDDRDATUM
DMIENKUEEnd Date of Lease-OutVVDMIENKUEDATS

VIRPS407 related tables

TableNote
CACS_TGAGRTarget Agreements: Individual Rules for Target Agreements
S407Rental agreements
VIRPS407Rental agreements
VIMI22Assignment / Rental unit - rental request offers
AGR_MEM_INITIALAgreements: Buffer for Intial Upload
BEAC_RPF_AR_R1Archiving Control: Agreements
BKKTERMPPRCTerm Agreements in Postprocessing Status
BON_MAPC_INF_DNLAgreements Exchange: Temporary Management Data
CACS_STAGASSLink of Standard Agreements to Standard Contracts
CACS_STCRERURule Characteristics for Flat-Rate Agreements in Std Ctrct
CACS_STTGAGRTgt Agmts: Assignment of Target Types to Standard Agreements
CACS_TGACVTarget Agreements: Indiv. Actual/Correction/Target Values
CACS_TGLOGObsolete (Target Agreements: Log)
CACS_TGMEMTarget Agreements: Table for Shared Memory (Internal)
CACS_TGRATVTarget Agreements: Generic Actual/Target Values
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com