WRS1

Assortment

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table WRS1.

SAP table WRS1 has 2 primary key fields: MANDT,ASORT.

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

WRS1 fields.

25 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 T000 MANDT
Key ASORT AssortmentCHAR100 ASORT
STATU Status of assortmentCHAR10 W_S_STATUS
KZLIK Listing Conditions for AssortmentsCHAR10 KZLIK
NLMATFB ID: Carry out subsequent listingCHAR10 NLMATFB
VKORG Sales OrganizationCHAR40 TVKO VKORG
VTWEG Distribution ChannelCHAR20 TVTW VTWEG
LSTFL Listing procedureCHAR20 TWLV LSTVF
DATAB Valid-From DateDATS80 DATAB
DATBI Valid To DateDATS80 DATBI
KOPRO All material groups can be listed - even if there are errorsCHAR10 W_S_KOPRO
LAYPR Listing check: only use layout defined for the assortmentCHAR10 W_S_LAYPR
SOTYP Assortment CategoryCHAR10 W_SOTYP
LAYVR LayoutCHAR100 TWGV LAYVAR
POSDS No data should be sent to assortment user POS systemsCHAR10 W_POS_DS
EXCLU Existence of Exclusion Listing ConditionsCHAR10 W_S_EXCLU
CATEGORY Category NodesCHAR180 CAT_NODE
LAY_LIST_UTIME Time the layout module was last processedCHAR140 LAYOUT_LISTING_UPDTTIME
HIER_ID HierarchyCHAR20 WRF_MATGRP_HIER WRF_HIER_CNT
ASSORTYP Assortment TypeCHAR40 WRFST_TYP WRFDE_ASSORTYP
ASSORDIMVAL1 Value in an Assortment DimensionCHAR40 WRFV_TYPDIMVAL1 WRFDE_ASSORDIMVAL
ASSORDIMVAL2 Value in an Assortment DimensionCHAR40 WRFV_TYPDIMVAL2 WRFDE_ASSORDIMVAL
ASSORDIMVAL3 Value in an Assortment DimensionCHAR40 WRFV_TYPDIMVAL3 WRFDE_ASSORDIMVAL
LAYGR Layout ModuleCHAR100 TWML LAYGR
AEDAT Last Changed OnDATS80 AEDAT

WRS1 relationships.

17 relationships
TableFieldCheck tableDescriptionCheck field
WRS1ASSORDIMVAL1WRFV_TYPDIMVAL1Generated Table for ViewASSORDIM1
WRS1ASSORDIMVAL2WRFV_TYPDIMVAL2Generated Table for ViewASSORDIM2
WRS1ASSORDIMVAL3WRFV_TYPDIMVAL3Generated Table for ViewASSORDIM3
WRS1ASSORTYPWRFST_TYPAssortment TypesMANDT
WRS1HIER_IDWRF_MATGRP_HIERArticle Hierarchy PropertiesMANDT
WRS1HIER_IDWRF_MATGRP_HIERArticle Hierarchy PropertiesHIER_ID
WRS1LAYGRTWMLLayout moduleMANDT
WRS1LAYGRTWMLLayout moduleLAYGR
WRS1LAYVRTWGVLayoutMANDT
WRS1LAYVRTWGVLayoutLAYVR
WRS1LSTFLTWLVListing procedure, assortmentsMANDT
WRS1LSTFLTWLVListing procedure, assortmentsLSTFL
WRS1MANDTT000ClientsMANDT
WRS1VKORGTVKOOrganizational Unit: Sales OrganizationsMANDT
WRS1VKORGTVKOOrganizational Unit: Sales OrganizationsVKORG
WRS1VTWEGTVTWOrganizational Unit: Distribution ChannelsMANDT
WRS1VTWEGTVTWOrganizational Unit: Distribution ChannelsVTWEG
Back to SAP tables