SAP Table
WRS1 Assortment
SAP table WRS1 has 2 primary key fields being MANDT,ASORT.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
WRS1 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
| KeyASORT | Assortment | CHAR | 10 | 0 | ASORT | ||||||||
| STATU | Status of assortment | CHAR | 1 | 0 | W_S_STATUS | ||||||||
|
|||||||||||||
| KZLIK | Listing Conditions for Assortments | CHAR | 1 | 0 | KZLIK | ||||||||
| NLMATFB | ID: Carry out subsequent listing | CHAR | 1 | 0 | NLMATFB | ||||||||
|
|||||||||||||
| VKORG | Sales Organization | CHAR | 4 | 0 | TVKO | VKORG | |||||||
| VTWEG | Distribution Channel | CHAR | 2 | 0 | TVTW | VTWEG | |||||||
| LSTFL | Listing procedure | CHAR | 2 | 0 | TWLV | LSTVF | |||||||
| DATAB | Valid-From Date | DATS | 8 | 0 | DATAB | ||||||||
| DATBI | Valid To Date | DATS | 8 | 0 | DATBI | ||||||||
| KOPRO | All material groups can be listed - even if there are errors | CHAR | 1 | 0 | W_S_KOPRO | ||||||||
| LAYPR | Listing check: only use layout defined for the assortment | CHAR | 1 | 0 | W_S_LAYPR | ||||||||
| SOTYP | Assortment Category | CHAR | 1 | 0 | W_SOTYP | ||||||||
|
|||||||||||||
| LAYVR | Layout | CHAR | 10 | 0 | TWGV | LAYVAR | |||||||
| POSDS | No data should be sent to assortment user POS systems | CHAR | 1 | 0 | W_POS_DS | ||||||||
| EXCLU | Existence of Exclusion Listing Conditions | CHAR | 1 | 0 | W_S_EXCLU | ||||||||
| CATEGORY | Category Nodes | CHAR | 18 | 0 | CAT_NODE | ||||||||
| LAY_LIST_UTIME | Time the layout module was last processed | CHAR | 14 | 0 | LAYOUT_LISTING_UPDTTIME | ||||||||
| HIER_ID | Hierarchy | CHAR | 2 | 0 | WRF_MATGRP_HIER | WRF_HIER_CNT | |||||||
| ASSORTYP | Assortment Type | CHAR | 4 | 0 | WRFST_TYP | WRFDE_ASSORTYP | |||||||
| ASSORDIMVAL1 | Value in an Assortment Dimension | CHAR | 4 | 0 | WRFV_TYPDIMVAL1 | WRFDE_ASSORDIMVAL | |||||||
| ASSORDIMVAL2 | Value in an Assortment Dimension | CHAR | 4 | 0 | WRFV_TYPDIMVAL2 | WRFDE_ASSORDIMVAL | |||||||
| ASSORDIMVAL3 | Value in an Assortment Dimension | CHAR | 4 | 0 | WRFV_TYPDIMVAL3 | WRFDE_ASSORDIMVAL | |||||||
| LAYGR | Layout Module | CHAR | 10 | 0 | TWML | LAYGR | |||||||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||||||||
/ Relationships
WRS1 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| WRS1 | ASSORDIMVAL1 | WRFV_TYPDIMVAL1 | Generated Table for View | ASSORDIM1 |
| WRS1 | ASSORDIMVAL2 | WRFV_TYPDIMVAL2 | Generated Table for View | ASSORDIM2 |
| WRS1 | ASSORDIMVAL3 | WRFV_TYPDIMVAL3 | Generated Table for View | ASSORDIM3 |
| WRS1 | ASSORTYP | WRFST_TYP | Assortment Types | MANDT |
| WRS1 | HIER_ID | WRF_MATGRP_HIER | Article Hierarchy Properties | MANDT |
| WRS1 | HIER_ID | WRF_MATGRP_HIER | Article Hierarchy Properties | HIER_ID |
| WRS1 | LAYGR | TWML | Layout module | MANDT |
| WRS1 | LAYGR | TWML | Layout module | LAYGR |
| WRS1 | LAYVR | TWGV | Layout | MANDT |
| WRS1 | LAYVR | TWGV | Layout | LAYVR |
| WRS1 | LSTFL | TWLV | Listing procedure, assortments | MANDT |
| WRS1 | LSTFL | TWLV | Listing procedure, assortments | LSTFL |
| WRS1 | MANDT | T000 | Clients | MANDT |
| WRS1 | VKORG | TVKO | Organizational Unit: Sales Organizations | MANDT |
| WRS1 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| WRS1 | VTWEG | TVTW | Organizational Unit: Distribution Channels | MANDT |
| WRS1 | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |