VIWEGB

Relation table between buildings and assets | #masterdata | Component: Real Estate Management
Column Name Description
MANDT FK Client
BUKRS FK Company Code
SWENR Business Entity Number
SGENR Building Number
DANGEL Master record created on
Column Name Description
Column Name Description
Column Name Description
DANGEL Master record created on
Column Name Description
VVJKANLA Flag: No investment assigned Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Asset Subnumber
  • Asset Subnumber
  • Company Code
  • Main Asset Number
  • VIWEGB.MANDT == ANLA.MANDT
  • VIWEGB.ANLN2 == ANLA.ANLN2
  • VIWEGB.BUKRS == ANLA.BUKRS
  • VIWEGB.ANLN1 == ANLA.ANLN1
Company code
  • VIWEGB.MANDT == T001.MANDT
  • VIWEGB.BUKRS == T001.BUKRS
Client VIWEGB.MANDT == T000.MANDT