WRSZ

Assignment of assortment user to assortment | #masterdata | Component: Listing
Column Name Description
MANDT FK Client
ASORT FK Assortment
LFDNR Sequence Number
Column Name Description
Column Name Description
Column Name Description
DATAB Valid-From Date
DATBI Valid To Date
ERZET Entry time
AEDAT Last Changed On
AEZET Time last change was made
Column Name Description
SONUT Category of assortment user Show values
RANGF Ranking for assortment assignment Show values
LIGRD Basic listing rule for assortments Show values
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Assortment
  • Assortment
  • Client
  • WRSZ.ASORT == WRS1.ASORT
  • WRSZ.MANDT == WRS1.MANDT
Customer Number
  • WRSZ.MANDT == KNA1.MANDT
  • WRSZ.KUNNR == KNA1.KUNNR
Customer Number for Plant
  • WRSZ.MANDT == KNA1.MANDT
  • WRSZ.LOCNR == KNA1.KUNNR
Client WRSZ.MANDT == T000.MANDT
Division
  • WRSZ.MANDT == TSPA.MANDT
  • WRSZ.SPART == TSPA.SPART
Sales Organization
  • WRSZ.MANDT == TVKO.MANDT
  • WRSZ.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • WRSZ.VTWEG == TVTW.VTWEG
  • WRSZ.MANDT == TVTW.MANDT