VIVSTB

Document reference for input tax treatment | #transactional | Component: Real Estate Management
Column Name Description
MANDT Client
BUKRS Company Code
BELNR Document Number of an Accounting Document
GJAHR Fiscal Year
BUZEI Number of Line Item Within Accounting Document
Column Name Description
💲 Currency Key (WAERS):
WMWST Tax Amount in Document Currency
MWSTS Tax Amount in Local Currency
VNAVHW Non-Deductible Input Tax (in Local Currency)
VNAVFW Non-Deductible Input Tax (in Document Currency)
Column Name Description
Column Name Description
BUDAT Posting Date in the Document
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
Column Name Description
STFLG Reverse document indicator Show values
STOKZ Document Has Been Reversed Show values
SVORG Automatic Posting Run Activity Show values
SHKZG Debit/Credit Indicator Show values
MWART Tax Type Show values
RARTOPT Option rate calculation type Show values
Column Name Description Domain name
VBELNR Document Number of an Accounting Document BELNR
BGJAHR Fiscal Year GJAHR
VBUZEI Number of Line Item Within Accounting Document BUZEI
AKONTO Tax account SAKNR
POPTS Real Estate Option Rate POPTSATZ
SOLLID No. of debit position in fiscal year VVSSOLLID
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
STBLG Reverse Document Number BELNR
STJAH Fiscal Year of Reversal Document GJAHR
MONAT Fiscal period MONAT
IMKEY Internal Key for Real Estate Object IMKEY
HKONT General Ledger Account SAKNR
NASAKNR Acct for non-deductible input tax SAKNR
Master Data Relations Join Conditions
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • VIVSTB.MANDT == T007A.MANDT
  • VIVSTB.[column in domain "KALSM_D"] == T007A.KALSM
  • VIVSTB.MWSKZ == T007A.MWSKZ
Currency Key
  • VIVSTB.MANDT == TCURC.MANDT
  • VIVSTB.WAERS == TCURC.WAERS