SAP table TWSSO (Space management profile)
SAP table TWSSO has 2 primary key fields being MANDT,SSOPT_PRO.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| SSOPT_PRO | Space management profile | CHAR | 4 | 0 | SSOPT_PRO | ||
| PUR_PRICE | Read purchase price | CHAR | 1 | 0 | PUR_PRICE | ||
| CALC_USE | Read purchase price from pricing document | CHAR | 1 | 0 | CALC_USE | ||
| RET_PRICE | Read sales price | CHAR | 1 | 0 | RET_PRICE | ||
| TURN_READ | Read sales data | CHAR | 1 | 0 | TURN_READ | ||
| SELV_TURN | Selection variant for dyn. reading of bus. vol. info struct. | CHAR | 12 | 0 | MCWSVK | SELV_TURN | |
| FLD_TURNV | Info structure field for business volume value | CHAR | 30 | 0 | * | FLD_TURNV | |
| FLD_TURNQ | Info structure field for business volume quantity | CHAR | 30 | 0 | * | FLD_TURNQ | |
| PERIOD_NUM | Number of periods for reading business volume data | NUMC | 2 | 0 | PERIOD_NUM | ||
| STOC_READ | Read stock data | CHAR | 1 | 0 | STOC_READ | ||
| SELV_STOC | Selection variant for dyn. reading of stock info structure | CHAR | 12 | 0 | MCWSVK | SELV_STOC | |
| FLD_STOCQ | Info structure field for stock | CHAR | 30 | 0 | * | FLD_STOCQ | |
| FUNCNAME | Function Module for Calling External Space Management | CHAR | 30 | 0 | * | SSO_FNAME | |
| RST_FUNC | Function Module for Viewing Planograms on Internet | CHAR | 30 | 0 | * | RST_FNAME | |
| BW_READ | Indicator for Reading Out of BW or Not | CHAR | 1 | 0 | ROP_BW_READ | ||
| TURNMETH | Sales Selection Method | CHAR | 16 | 0 | TMCW_AA_METH | WPLG_TURNMETH | |
| TURNSTEP | Step Number in Selection Method | NUMC | 3 | 0 | TMCW_AA_METH_DAT | WPLG_AA_STEP | |
| AAFLD_TURNV | BW Query Field for Business Volume Value | CHAR | 30 | 0 | * | WPLG_AAFLD_TURNV | |
| AAFLD_TURNQ | BW Query Field for Business Volume Quantity | CHAR | 30 | 0 | * | WPLG_AAFLD_TURNQ | |
| STOCMETH | Stock Selection Methods | CHAR | 16 | 0 | TMCW_AA_METH | WPLG_STOCMETH | |
| STOCSTEP | Step Number in Selection Method | NUMC | 3 | 0 | TMCW_AA_METH_DAT | WPLG_AA_STEP | |
| AAFLD_STOCQ | Field for BW Query Info Structure for Stock | CHAR | 30 | 0 | * | WPLG_AAFLD_STOCQ |
TWSSO foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TWSSO | SELV_STOC | MCWSVK | Selection Variant f. Reading IS Dynamically: Header Data | MANDT |
| 0 TWSSO | SELV_STOC | MCWSVK | Selection Variant f. Reading IS Dynamically: Header Data | SVAPPGRP |
| 0 TWSSO | SELV_STOC | MCWSVK | Selection Variant f. Reading IS Dynamically: Header Data | SVARI |
| 1 TWSSO | SELV_TURN | MCWSVK | Selection Variant f. Reading IS Dynamically: Header Data | MANDT |
| 1 TWSSO | SELV_TURN | MCWSVK | Selection Variant f. Reading IS Dynamically: Header Data | SVAPPGRP |
| 1 TWSSO | SELV_TURN | MCWSVK | Selection Variant f. Reading IS Dynamically: Header Data | SVARI |
| 0 TWSSO | STOCMETH | TMCW_AA_METH | MCCW_AA: Methods for Analytical Applications | MANDT |
| 0 TWSSO | STOCMETH | TMCW_AA_METH | MCCW_AA: Methods for Analytical Applications | AA_APP |
| 1 TWSSO | STOCSTEP | TMCW_AA_METH_DAT | MCCW_AA: Methods for Analytical Applications | MANDT |
| 1 TWSSO | STOCSTEP | TMCW_AA_METH_DAT | MCCW_AA: Methods for Analytical Applications | AA_APP |
| 0 TWSSO | TURNMETH | TMCW_AA_METH | MCCW_AA: Methods for Analytical Applications | MANDT |
| 0 TWSSO | TURNMETH | TMCW_AA_METH | MCCW_AA: Methods for Analytical Applications | AA_APP |
| 1 TWSSO | TURNSTEP | TMCW_AA_METH_DAT | MCCW_AA: Methods for Analytical Applications | MANDT |
| 1 TWSSO | TURNSTEP | TMCW_AA_METH_DAT | MCCW_AA: Methods for Analytical Applications | AA_APP |