SAP ABAP View M_WSOHB (Generated view for matchcode ID WSOH -B)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ WSOR (Package) IS-R: Assortments
BBPCRM (Software Component) BBPCRM⤷
CRM (Application Component) Customer Relationship Management⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages⤷
WSOR (Package) IS-R: Assortments
Basic Data
| View Type | D | Database View |
| Database View | M_WSOHB | |
| Short Description | Generated view for matchcode ID WSOH -B | |
| Root table | WSOH | Assortment Modules SAP Retail |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | WSOH |
WSOH | ||
| 2 | WRS1 |
|||
| 3 | T023 |
|||
| 4 | T023T |
|||
| 5 | WRST |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | WRS1 |
MANDT | JL | EQ | 0 | 1 | STYPB | |||
| 2 | WSOH |
MANDT | JR | EQ | AND | 0 | 1 | STYPB | ||
| 3 | WRS1 |
ASORT | JL | EQ | 0 | 1 | STYPB | |||
| 4 | WSOH |
FILIA | JR | EQ | AND | 0 | 1 | STYPB | ||
| 5 | T023 |
MANDT | JL | EQ | 0 | 1 | STYPB | |||
| 6 | WSOH |
MANDT | JR | EQ | AND | 0 | 1 | STYPB | ||
| 7 | T023 |
MATKL | JL | EQ | 0 | 1 | STYPB | |||
| 8 | WSOH |
WAGRP | JR | EQ | AND | 0 | 1 | STYPB | ||
| 9 | T023 |
MANDT | JL | EQ | 0 | 1 | STYPB | |||
| 10 | T023T |
MANDT | JR | EQ | AND | 0 | 1 | STYPB | ||
| 11 | T023 |
MATKL | JL | EQ | 0 | 1 | STYPB | |||
| 12 | T023T |
MATKL | JR | EQ | AND | 0 | 1 | STYPB | ||
| 13 | WRS1 |
ASORT | JL | EQ | 0 | 1 | STYPB | |||
| 14 | WRST |
ASORT | JR | EQ | AND | 0 | 1 | STYPB | ||
| 15 | WRS1 |
MANDT | JL | EQ | 0 | 1 | STYPB | |||
| 16 | WRS1 |
MANDT | JR | EQ | AND | 0 | 1 | STYPB | ||
| 17 | T023T |
SPRAS | JL | EQ | 0 | 1 | STYPB | |||
| 18 | WRST |
SPRAS | JR | EQ | AND | 0 | 1 | STYPB | ||
| 19 | WSOH |
LVORM | NE | 'X' | AND | 0 | 1 | LVORM | ||
| 20 | WSOH |
STYPB | EQ | '4' | 0 | 1 | STYPB | |||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
WSOH |
MANDT | MANDT | Client | |||
| 2 | FILIA |
WSOH |
FILIA | W_SP_FIL | Assortment assignment (profile modules) | |||
| 3 | WAGRP |
WSOH |
WAGRP | MATKL | Material Group | |||
| 4 | WGBEZ |
T023T |
WGBEZ | WGBEZ | Material Group Description | |||
| 5 | SPRAS |
T023T |
SPRAS | SPRAS | Language Key | |||
| 6 | DATAB |
WSOH |
DATAB | DATAB | Valid-From Date | |||
| 7 | DATUB |
WSOH |
DATUB | DATBI | Valid To Date | |||
| 8 | SKOPF |
WSOH |
SKOPF | W_SORTK | Assortment Module | |||
| 9 | NAME1 |
WRST |
NAME1 | ASORTTEXT40 | Description of Assortments | |||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
| Last changed by/on | SAP | 20131127 |
| SAP Release Created in |
