SAP ABAP Table WSD_SALES_STY (Sales data)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ SD-MD-MM-CS (Application Component) Additional Material Functions
⤷ WSD_CS_DDIC (Package) DDIC Enhanced Material Search
⤷ SD-MD-MM-CS (Application Component) Additional Material Functions
⤷ WSD_CS_DDIC (Package) DDIC Enhanced Material Search
Basic Data
Table Category | INTTAB | Structure |
Structure | WSD_SALES_STY | Table Relationship Diagram |
Short Description | Sales data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
2 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
3 | .INCLUDE | 0 | 0 | Data Division MVKE | |||||
4 | LVORM | LVOVK | XFELD | CHAR | 1 | 0 | Ind.: Flag material for deletion at distribution chain level | ||
5 | VERSG | STGMA | STGMA | CHAR | 1 | 0 | Material statistics group | TVSM | |
6 | BONUS | BONUS | BONUS | CHAR | 2 | 0 | Volume rebate group | TVBO | |
7 | PROVG | PROVG | PROVG | CHAR | 2 | 0 | Commission group | TVPR | |
8 | SKTOF | SKTOF | XFELD | CHAR | 1 | 0 | Cash discount indicator | ||
9 | VMSTA | VMSTA | VMSTA | CHAR | 2 | 0 | Distribution-chain-specific material status | TVMS | |
10 | VMSTD | VMSTD | DATUM | DATS | 8 | 0 | Date from which distr.-chain-spec. material status is valid | ||
11 | AUMNG | MINAU | MENG13 | QUAN | 13 | 3 | Minimum order quantity in base unit of measure | ||
12 | LFMNG | MINLF | MENG13 | QUAN | 13 | 3 | Minimum delivery quantity in delivery note processing | ||
13 | EFMNG | MINEF | MENG13 | QUAN | 13 | 3 | Minimum make-to-order quantity | ||
14 | SCMNG | SCHRT | MENG13 | QUAN | 13 | 3 | Delivery unit | ||
15 | SCHME | SCHME | MEINS | UNIT | 3 | 0 | Unit of measure of delivery unit | T006 | |
16 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
17 | MTPOS | MTPOS | MTPOS | CHAR | 4 | 0 | Item category group from material master | TPTM | |
18 | DWERK | DWERK_EXT | WERKS | CHAR | 4 | 0 | Delivering Plant (Own or External) | TVKWZ | |
19 | PRODH | PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | T179 | |
20 | PMATN | PMATN | MATNR | CHAR | 18 | 0 | Pricing Reference Material | MARA | |
21 | KONDM | KONDM | KONDM | CHAR | 2 | 0 | Material Pricing Group | T178 | |
22 | KTGRM | KTGRM | KTGRM | CHAR | 2 | 0 | Account assignment group for this material | TVKM | |
23 | MVGR1 | MVGR1 | MVGR1 | CHAR | 3 | 0 | Material group 1 | TVM1 | |
24 | MVGR2 | MVGR2 | MVGR2 | CHAR | 3 | 0 | Material group 2 | TVM2 | |
25 | MVGR3 | MVGR3 | MVGR3 | CHAR | 3 | 0 | Material group 3 | TVM3 | |
26 | MVGR4 | MVGR4 | MVGR4 | CHAR | 3 | 0 | Material group 4 | TVM4 | |
27 | MVGR5 | MVGR5 | MVGR5 | CHAR | 3 | 0 | Material group 5 | TVM5 | |
28 | .INCLUDE | 0 | 0 | Data Part MWLI | |||||
29 | SSTUF | SSTUF | SSTUF | CHAR | 2 | 0 | Assortment grade | TWSS | |
30 | PFLKS | PFLKS | PFLKS | CHAR | 1 | 0 | External assortment priority | TWSP | |
31 | LSTFL | LSTFL | LSTFL | CHAR | 2 | 0 | Listing procedure for store or other assortment categories | TWLV | |
32 | LSTVZ | LSTVZ | LSTFL | CHAR | 2 | 0 | Listing procedure for distr. center assortment categories | TWLV | |
33 | LSTAK | LSTAK | LSTAK | CHAR | 1 | 0 | Listing functions (assortments) are active | ||
34 | LDVFL | LDVFL | DATS | DATS | 8 | 0 | Date from which listed in the store | ||
35 | LDBFL | LDBFL | DATS | DATS | 8 | 0 | Date to which listed in the store | ||
36 | LDVZL | LDVZL | DATS | DATS | 8 | 0 | Date from which listed in the distribution center | ||
37 | LDBZL | LDBZL | DATS | DATS | 8 | 0 | Date to which listed in the central warehouse/distr. center | ||
38 | VDVFL | VDVFL | DATS | DATS | 8 | 0 | Date from which sold in the store | ||
39 | VDBFL | VDBFL | DATS | DATS | 8 | 0 | Date to which sold in the store | ||
40 | VDVZL | VDVZL | DATS | DATS | 8 | 0 | Date from which sold in the distribution center | ||
41 | VDBZL | VDBZL | DATS | DATS | 8 | 0 | Date to which sold in the distribution center | ||
42 | PRAT1 | PRAT1 | PRATA | CHAR | 1 | 0 | ID for product attribute 1 | ||
43 | PRAT2 | PRAT2 | PRATA | CHAR | 1 | 0 | ID for product attribute 2 | ||
44 | PRAT3 | PRAT3 | PRATA | CHAR | 1 | 0 | ID for product attribute 3 | ||
45 | PRAT4 | PRAT4 | PRATA | CHAR | 1 | 0 | ID for product attribute 4 | ||
46 | PRAT5 | PRAT5 | PRATA | CHAR | 1 | 0 | ID for product attribute 5 | ||
47 | PRAT6 | PRAT6 | PRATA | CHAR | 1 | 0 | ID for product attribute 6 | ||
48 | PRAT7 | PRAT7 | PRATA | CHAR | 1 | 0 | ID for product attribute 7 | ||
49 | PRAT8 | PRAT8 | PRATA | CHAR | 1 | 0 | ID for product attribute 8 | ||
50 | PRAT9 | PRAT9 | PRATA | CHAR | 1 | 0 | ID for product attribute 9 | ||
51 | PRATA | PRATA | PRATA | CHAR | 1 | 0 | ID for product attribute 10 | ||
52 | RDPRF | RDPRF | RDPRF | CHAR | 4 | 0 | Rounding Profile | RDPR | |
53 | MEGRU | MEGRU | MEGRU | CHAR | 4 | 0 | Unit of Measure Group | TWMEG | |
54 | LFMAX | MAXLF | MENG13 | QUAN | 13 | 3 | Maximum delivery quantity in store order processing | ||
55 | RJART | RJART | XFELD | CHAR | 1 | 0 | Flag rackjobber material | ||
56 | PBIND | PBIND | PBIND | CHAR | 1 | 0 | Indicator for price fixing | ||
57 | VAVME | VAVME | XFELD | CHAR | 1 | 0 | Variable Sales Unit Not Allowed | ||
58 | MATKC | MATKC | MATKC | CHAR | 1 | 0 | Competition characterization of a material | ||
59 | PVMSO | PVMSO | PVMSO | NUMC | 8 | 0 | Material sorting in product proposal | * | |
60 | .INCLU--AP | 0 | 0 | Append for Empties Management | |||||
61 | .INCLUDE | 0 | 0 | Include Structure for Empties | |||||
62 | /BEV1/EMLGRP | /BEV1/EMLGGRP | /BEV1/EMLGGRP | CHAR | 4 | 0 | Empties Group | /BEV1/EMGRP | |
63 | /BEV1/EMDRCKSPL | /BEV1/EMPRTCOL | /BEV1/EMPRTCOL | NUMC | 1 | 0 | Print Column Empties Returns Block | ||
64 | .INCLU--AP | 0 | 0 | Assignment of UoM to Totals Flds in Transportation Planning | |||||
65 | .INCLUDE | 0 | 0 | Assignment of UoM to Totals Flds in Transportation Planning | |||||
66 | /BEV1/RPBEZME | /BEV1/RPBEZME | MEINS | UNIT | 3 | 0 | Base Unit of Measure for Statistics Totals List/Planning | * | |
67 | /BEV1/RPSNS | /BEV1/RPSNS | /BEV1/RPJANEIN | CHAR | 1 | 0 | No Allocation to Totals Field (Do not Total) | ||
68 | /BEV1/RPSFA | /BEV1/RPSFA | /BEV1/RPJANEIN | CHAR | 1 | 0 | Assignment to Totals Field Category 1 | ||
69 | /BEV1/RPSKI | /BEV1/RPSKI | /BEV1/RPJANEIN | CHAR | 1 | 0 | Assignment to Totals Field Category 2 | ||
70 | /BEV1/RPSCO | /BEV1/RPSCO | /BEV1/RPJANEIN | CHAR | 1 | 0 | Assignment to Totals Field Category 3 | ||
71 | /BEV1/RPSSO | /BEV1/RPSSO | /BEV1/RPJANEIN | CHAR | 1 | 0 | Assignment to Totals Field Category 4 | ||
72 | .INCLU--AP | 0 | 0 | MVKE Extension with New Fields - Seasonal Procurement | |||||
73 | .INCLUDE | 0 | 0 | MVKE Extension with New Fields - Seasonal Procurement | |||||
74 | PLGTP | WRF_PLGTP | PLGTP | CHAR | 2 | 0 | Price Band Category | TWPT |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | WSD_SALES_STY | /BEV1/EMLGRP | /BEV1/EMGRP | LGGRP | |||
2 | WSD_SALES_STY | BONUS | TVBO | BONUS | |||
3 | WSD_SALES_STY | DWERK | TVKWZ | WERKS | |||
4 | WSD_SALES_STY | KONDM | T178 | KONDM | |||
5 | WSD_SALES_STY | KTGRM | TVKM | KTGRM | |||
6 | WSD_SALES_STY | LSTFL | TWLV | LSTFL | |||
7 | WSD_SALES_STY | LSTVZ | TWLV | LSTFL | |||
8 | WSD_SALES_STY | MEGRU | TWMEG | MEGRU | KEY | C | CN |
9 | WSD_SALES_STY | MTPOS | TPTM | MTPOS | |||
10 | WSD_SALES_STY | MVGR1 | TVM1 | MVGR1 | |||
11 | WSD_SALES_STY | MVGR2 | TVM2 | MVGR2 | |||
12 | WSD_SALES_STY | MVGR3 | TVM3 | MVGR3 | |||
13 | WSD_SALES_STY | MVGR4 | TVM4 | MVGR4 | |||
14 | WSD_SALES_STY | MVGR5 | TVM5 | MVGR5 | |||
15 | WSD_SALES_STY | PFLKS | TWSP | PFLKS | |||
16 | WSD_SALES_STY | PLGTP | TWPT | PLGTP | |||
17 | WSD_SALES_STY | PMATN | MARA | MATNR | |||
18 | WSD_SALES_STY | PRODH | T179 | PRODH | |||
19 | WSD_SALES_STY | PROVG | TVPR | PROVG | |||
20 | WSD_SALES_STY | RDPRF | RDPR | RDPRF | KEY | C | CN |
21 | WSD_SALES_STY | SCHME | T006 | MSEHI | |||
22 | WSD_SALES_STY | SSTUF | TWSS | SSTUF | |||
23 | WSD_SALES_STY | VERSG | TVSM | STGMA | |||
24 | WSD_SALES_STY | VMSTA | TVMS | VMSTA | |||
25 | WSD_SALES_STY | VRKME | T006 | MSEHI |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 700 |