VIBEPP

Flow data - Planned items for real estate management | #transactional | Component: Real Estate Management
Column Name Description
MANDT FK Client
IMKEY Internal Key for Real Estate Object
DTRANS Flow data key: System date
TTRANS Transaction data key: system time
NTRANS Transaction data key: Consecutive number
Column Name Description
πŸ’² Settlement Currency (SCWHR):
BCWHR Settlement Amount
BMWST Value-added tax amount included
πŸ’² Currency Key (T001.WAERS):
BHWHR Amount in local currency
πŸ’² Position Currency (Currency of Position Amount) (SBWHR):
BBWHR Amount in position currency
BBASIS Calculation Base Amount
πŸ’² Currency of nominal amount (SNWHR):
BNWHR Nominal amount
Column Name Description
Column Name Description
DTRANS Flow data key: System date
TTRANS Transaction data key: system time
DFAELL Due date
DDISPO Payment Date
DVALUT Calculation Date
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DBERVON Start of Calculation Period
DBERBIS End of Calculation Period
DTRANSREF Flow data key: System date
TTRANSREF Transaction data key: system time
BUDAT Posting Date in the Document
Column Name Description
MWART Tax Type Show values
SPLANIST Plan/actual record/record to be released indicator Show values
SSOLHAB Debit/credit indicator Show values
SSTORNO Reversal indicator Show values
FDUPD Flag as to whether record enters cash management + forecast Show values
JONLAEN Indicator for fixing a flow record Show values
SZBMETH Interest Calculation Method Show values
SABGVERF Accrual/deferral procedure Show values
XCROSS Gross amount indicator Show values
Column Name Description Domain name
SBEWART Flow Type SBEWART
SMIVE Lease-Out Number VVSMIVE
SSTATI Status of data record STATI
SXBLNR Debit position identification -> Acctng reference doc. no. XBLNR1
RSOLL Account for debit posting SAKNR
RHABEN Account for credit posting SAKNR
RBANKK Bank account SAKNR
KUNNR Customer Number KUNNR
KOSTL Cost Center KOSTL
BVTYP Partner bank type BVTYP
SANLF Product Category VVSANLF
GSBER Business Area GSBER
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
SWOHER Source of flow record CHAR1
SSORTZIT Sort indicator for interest/repayment schedule calculations CHAR1
NFOLGE Display sequence of condition types within the group VVNFOLGE
ATAGE Number of Days INT6
ABASTAGE Number of base days in a calculation period INT6
SREFBEW Reference flow type SBEWART
NTRANSREF Transaction data key: Consecutive number NUMC4
SVWNR Management Contract Number VVSVWNR
INTRENO Internal Real Estate Master Data Code VVINTRENO
AWTYP Reference procedure AWTYP
AWKEY Reference Key AWKEY
IMKEY2 Second Real Estate object for property management postings IMKEY
INTRENO2 Second real estate object for property management postings VVINTRENO
LIFNR Account Number of Supplier LIFNR
SGRNR Land Number for BE SGRNR
SGENR Building Number SGENR
JLOESCH Record planned for Real Estate archiving JLOESCH
SRECHNGNR Rent Invoice: Invoice Number VVRECHNGNR
TXJCD Tax Jurisdiction TXJCD
RECNNR Real Estate Contract Number RECNNR
GFZLSCH Payment method for credit memos ZLSCH
ZLSPR Payment Block Key ZAHLS
NFZLSCH Payment Method ZLSCH
Master Data Relations Join Conditions
Company Code of Real Estate object
  • VIBEPP.MANDT == T001.MANDT
  • VIBEPP.BUKRS == T001.BUKRS
Planning Level
  • VIBEPP.MANDT == T036.MANDT
  • VIBEPP.FDLEV == T036.EBENE
Business transaction type
  • Product Type
  • Client
  • VIBEPP.GSART == TZPA.GSART
  • VIBEPP.MANDT == TZPA.MANDT
Client VIBEPP.MANDT == T000.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • VIBEPP.MANDT == T007A.MANDT
  • VIBEPP.[column in domain "KALSM_D"] == T007A.KALSM
  • VIBEPP.MWSKZ == T007A.MWSKZ
Flow Category VIBEPP.SBEWZITI == TZB03.SBEWZITI
Position Currency (Currency of Position Amount)
  • VIBEPP.MANDT == TCURC.MANDT
  • VIBEPP.SBWHR == TCURC.WAERS
Settlement Currency
  • VIBEPP.MANDT == TCURC.MANDT
  • VIBEPP.SCWHR == TCURC.WAERS
Condition Type
  • Condition Type (Smallest Subdivision of Condition Records)
  • ?
  • VIBEPP.MANDT == TZK01.MANDT
  • VIBEPP.SKOART == TZK01.SKOART
  • VIBEPP.[column in domain "RANTYP"] == TZK01.RANTYP
Number of Rental Unit
  • Company Code
  • Business Entity Number
  • Number of Rental Unit
Currency of Nominal Amount
  • VIBEPP.MANDT == TCURC.MANDT
  • VIBEPP.SNWHR == TCURC.WAERS
Business Entity Number
  • Company Code
  • Business Entity Number
Block Key for Payment
  • Block Key for Payment
  • Client
  • VIBEPP.ZAHLS == T008.ZAHLS
  • VIBEPP.MANDT == T008.MANDT
Payment Method
  • Payment Method
  • ?
  • VIBEPP.MANDT == T042Z.MANDT
  • VIBEPP.ZLSCH == T042Z.ZLSCH
  • VIBEPP.[column in domain "LAND1"] == T042Z.LAND1