SAP ABAP View M_WSOHC (Generated view for matchcode ID WSOH -C)
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_WSOHC | |
| Short Description | Generated view for matchcode ID WSOH -C | |
| Root table | WSOH | Assortment Modules SAP Retail |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | WSOH |
WSOH | ||
| 2 | WAKH |
|||
| 3 | TWAT |
|||
| 4 | WAKT |
|||
| 5 | TWATT |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | WAKH |
MANDT | JL | EQ | 0 | 1 | STYPB | |||
| 2 | WSOH |
MANDT | JR | EQ | AND | 0 | 1 | STYPB | ||
| 3 | WAKH |
AKTNR | JL | EQ | 0 | 1 | STYPB | |||
| 4 | WSOH |
AKTIO | JR | EQ | AND | 0 | 1 | STYPB | ||
| 5 | TWAT |
MANDT | JL | EQ | 0 | 1 | STYPB | |||
| 6 | WSOH |
MANDT | JR | EQ | AND | 0 | 1 | STYPB | ||
| 7 | TWAT |
AKTHE | JL | EQ | 0 | 1 | STYPB | |||
| 8 | WSOH |
THEMA | JR | EQ | AND | 0 | 1 | STYPB | ||
| 9 | WAKH |
MANDT | JL | EQ | 0 | 1 | STYPB | |||
| 10 | WAKT |
MANDT | JR | EQ | AND | 0 | 1 | STYPB | ||
| 11 | WAKH |
AKTNR | JL | EQ | 0 | 1 | STYPB | |||
| 12 | WAKT |
AKTNR | JR | EQ | AND | 0 | 1 | STYPB | ||
| 13 | TWAT |
MANDT | JL | EQ | 0 | 1 | STYPB | |||
| 14 | TWATT |
MANDT | JR | EQ | AND | 0 | 1 | STYPB | ||
| 15 | TWAT |
AKTHE | JL | EQ | 0 | 1 | STYPB | |||
| 16 | TWATT |
AKTHE | JR | EQ | AND | 0 | 1 | STYPB | ||
| 17 | WSOH |
LVORM | NE | 'X' | AND | 0 | 1 | LVORM | ||
| 18 | WSOH |
STYPB | EQ | '2' | 0 | 1 | STYPB | |||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
WSOH |
MANDT | MANDT | Client | |||
| 2 | AKTIO |
WSOH |
AKTIO | WAKTION | Promotion | |||
| 3 | SPRASAK |
WAKT |
SPRAS | SPRAS | Language Key | |||
| 4 | AKTKT |
WAKT |
AKTKT | AKTBEZ | Promotion description | |||
| 5 | THEMA |
WSOH |
THEMA | W_AKTHE | Promotion theme | |||
| 6 | SPRASTH |
TWATT |
SPRAS | SPRAS | Language Key | |||
| 7 | AKTTT |
TWATT |
AKTTT | BEZEI20 | Description | |||
| 8 | DATAB |
WSOH |
DATAB | DATAB | Valid-From Date | |||
| 9 | DATUB |
WSOH |
DATUB | DATBI | Valid To Date | |||
| 10 | STAT1 |
WSOH |
STAT1 | W_SSTAT | Status (active/inactive) | |||
| 11 | SKOPF |
WSOH |
SKOPF | W_SORTK | Assortment Module | |||
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 | 20130529 |
| SAP Release Created in |
