VIMI28

Sales settlement histories | #transactional | Component: Real Estate Management
Column Name Description
MANDT Client
BUKRS FK Company Code
SMIVE Lease-Out Number
SWENR FK Business Entity Number
SMENR FK Number of Rental Unit
YUMSJ Sales year
UMSDATE Last sales settlement upto...
SKOART FK Condition: Type
Column Name Description
πŸ’² Currency of Condition Item (SWHRKOND):
BUMVR Sales settlement amount
BVZGM Customer advance payment of basic rent on sales-based lease
BMWSTSALDO Clearing balance tax amount
BMELD Reported sales
BMELD_REL Relevant sales for settlement
Column Name Description
πŸ“ Unit of measurement of sales reporting values (VIMIUH.UEINHEIT):
UBMELD Reported Sales in Units
UBMELD_REL Relevant sales in units for sales settlement
Column Name Description
UMSDATE Last sales settlement upto...
DMELDV Reporting Interval Start for Sales-Based Lease-Out
DMELDB End of Reporting Interval for Sales-Based Lease-Out
Column Name Description
Column Name Description Domain name
PPROZJ Sales year percentage rate DEC3_2
VVABBLN Settlement Identification ->Accounting Ref. Doc.Number XBLNR1
IMKEY Internal Key for Real Estate Object IMKEY
MON_PA Number of months NUM2
INTRENO Internal Real Estate Master Data Code VVINTRENO
BELNR Document Number of an Accounting Document BELNR
GJAHR Fiscal Year GJAHR
TXJCD Tax Jurisdiction TXJCD
Master Data Relations Join Conditions
Company code
  • VIMI28.MANDT == T001.MANDT
  • VIMI28.BUKRS == T001.BUKRS
VAT indicator for sales-based rent - History
  • ?
  • Tax on sales/purchases code
  • VIMI28.MANDT == T007A.MANDT
  • VIMI28.[column in domain "KALSM_D"] == T007A.KALSM
  • VIMI28.MWSKZ == T007A.MWSKZ
Condition: Type
  • Condition: Type
  • ?
  • VIMI28.MANDT == TZK01.MANDT
  • VIMI28.SKOART == TZK01.SKOART
  • VIMI28.[column in domain "RANTYP"] == TZK01.RANTYP
Rental unit for sales settlement history table
  • Company Code
  • Business Entity Number
  • Number of Rental Unit
Business entity for sales settlement history table
  • Company Code
  • Business Entity Number
Currency of amounts in sales settlement history table
  • VIMI28.MANDT == TCURC.MANDT
  • VIMI28.SWHRKOND == TCURC.WAERS