SAP-tabelreferentie
WSOH
Assortment Modules SAP RetailBekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel WSOH.
SAP-tabel WSOH heeft 2 primaire sleutelvelden: MANDT,SKOPF.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
/ Velden
WSOH velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||
| Sleutel SKOPF | Assortment module | CHAR | 18 | 0 | W_SORTK | ||||||||||||||||
| DATAB | Valid-From Date | DATS | 8 | 0 | DATAB | ||||||||||||||||
| DATUB | Valid To Date | DATS | 8 | 0 | DATBI | ||||||||||||||||
| STYPB | Module type | CHAR | 1 | 0 | BAUSTYP | ||||||||||||||||
| |||||||||||||||||||||
| LVORM | Deletion indicator IS-R tables | CHAR | 1 | 0 | WLOEK | ||||||||||||||||
| |||||||||||||||||||||
| ERSDA | Created On | DATS | 8 | 0 | ERSDA | ||||||||||||||||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||||||||||||||||
| PFLKN | Assortment Priority | CHAR | 1 | 0 | * | W_PFLKN | |||||||||||||||
| STAT1 | Status (active/inactive) | CHAR | 1 | 0 | W_SSTAT | ||||||||||||||||
| STAT2 | Status assignment promotion | CHAR | 1 | 0 | W_ASTAT | ||||||||||||||||
| STAT3 | Status of assignment to assortments | CHAR | 1 | 0 | W_ZSTAT | ||||||||||||||||
| DATAE | Last Changed On | DATS | 8 | 0 | AEDAT | ||||||||||||||||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||||||||||||||||
| AKTIO | Promotion | CHAR | 10 | 0 | WAKH | WAKTION | |||||||||||||||
| THEMA | Promotion theme | CHAR | 4 | 0 | TWAT | W_AKTHE | |||||||||||||||
| FILIA | Assortment assignment (profile modules) | CHAR | 10 | 0 | WRS1 | W_SP_FIL | |||||||||||||||
| WAGRP | Material Group | CHAR | 9 | 0 | T023 | MATKL | |||||||||||||||
| LOKAL | Local assortment for a retail plant | CHAR | 10 | 0 | KNA1 | WLOKL | |||||||||||||||
| TYPIN | Local module for the inclusion of (automat.) relistings | CHAR | 1 | 0 | W_TYPINT | ||||||||||||||||
| WKLOK | Retail plant with a local assortment module | CHAR | 4 | 0 | T001W | WERKL | |||||||||||||||
| WKWAG | Retail plant with profile module assignment | CHAR | 4 | 0 | T001W | WERKF | |||||||||||||||
| LIFNR | Supplier Number of a Rack Jobber | CHAR | 10 | 0 | LFA1 | W_RACKJOB | |||||||||||||||
| RJPRO | Type of Rackjobber Processing | CHAR | 1 | 0 | RJPRO | ||||||||||||||||
| |||||||||||||||||||||
| LAYGR | Layout Module | CHAR | 10 | 0 | TWML | LAYGR | |||||||||||||||
| LAYMOD_VER | Layout Module Version | NUMC | 4 | 0 | WLMV | LAYMOD_VER | |||||||||||||||
/ Relaties
WSOH relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| WSOH | AKTIO | WAKH | Promotion Header Data, IS-R | MANDT |
| WSOH | AKTIO | WAKH | Promotion Header Data, IS-R | AKTNR |
| WSOH | FILIA | WRS1 | Assortment | MANDT |
| WSOH | FILIA | WRS1 | Assortment | ASORT |
| WSOH | LAYGR | TWML | Layout module | MANDT |
| WSOH | LAYGR | TWML | Layout module | LAYGR |
| WSOH | LAYMOD_VER | WLMV | Validity and Status of Layout Module Versions | MANDT |
| WSOH | LAYMOD_VER | WLMV | Validity and Status of Layout Module Versions | LAYGR |
| WSOH | LIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| WSOH | LIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| WSOH | LOKAL | KNA1 | General Data in Customer Master | MANDT |
| WSOH | LOKAL | KNA1 | General Data in Customer Master | KUNNR |
| WSOH | MANDT | T000 | Clients | MANDT |
| WSOH | THEMA | TWAT | Promotion themes, IS-R | MANDT |
| WSOH | THEMA | TWAT | Promotion themes, IS-R | AKTHE |
| WSOH | WAGRP | T023 | Material Groups | MATKL |
| WSOH | WKLOK | T001W | Plants/Branches | WERKS |
| WSOH | WKWAG | T001W | Plants/Branches | WERKS |