J_3GVERSI

Tax/Insurance Data | #masterdata | Component: Construction Equipment Management
Column Name Description
MANDT FK Client
EQUNR FK Equipment Number
J_3GVSART FK Insurance Type
J_3GANDAT Registration Date
Column Name Description
💲 Currency Key (J_3GVSWS):
J_3GVERSUM Amount Insured
💲 Currency Key (WAERS):
WRBTR Amount in Document Currency
Column Name Description
Column Name Description
J_3GANDAT Registration Date
J_3GABDAT Cancellation Date
J_3GERSDA Created On
J_3GLAEDA Date of Last Change
Column Name Description
J_3GPERIOD Period of Portion of Insurance Contribution Show values
J_3GDAUERB Indicator for Recurring Entry Document Show values
J_3GLOEKZ Deletion Indicator Show values
Column Name Description Domain name
J_3GORDNER File CHAR30
VSSTX Insurance Policy Number CHAR15
J_3GDGJAHR Fiscal Year of Recurring Entry GJAHR
J_3GDBELNR Number of Recurring Entry Document BELNR
J_3GERNAM Name of Person Responsible for Creating the Object USNAM
J_3GAENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Company Code
  • J_3GVERSI.MANDT == T001.MANDT
  • J_3GVERSI.BUKRS == T001.BUKRS
Equipment Number
  • Equipment Number
  • Client
  • J_3GVERSI.EQUNR == EQUI.EQUNR
  • J_3GVERSI.MANDT == EQUI.MANDT
Insurance Type
  • Insurance Type
  • Client
  • J_3GVERSI.J_3GVSART == T099.VSART
  • J_3GVERSI.MANDT == T099.MANDT
Currency Amount
  • J_3GVERSI.MANDT == TCURC.MANDT
  • J_3GVERSI.J_3GVSWS == TCURC.WAERS
Client J_3GVERSI.MANDT == T000.MANDT
Insurance Company
  • J_3GVERSI.MANDT == T099A.MANDT
  • J_3GVERSI.VSGES == T099A.VSGES
Currency Key
  • J_3GVERSI.MANDT == TCURC.MANDT
  • J_3GVERSI.WAERS == TCURC.WAERS