SAP ABAP Table SMOMVKE (Sales Data for Material)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MSA (Application Component) Mobile Sales
⤷ SMO3 (Package) Consolidated Database
⤷ CRM-MSA (Application Component) Mobile Sales
⤷ SMO3 (Package) Consolidated Database
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | SMOMVKE | Table Relationship Diagram |
Short Description | Sales Data for Material |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | SFAMVKE | SMO_SFAMVK | SMO_GUID | CHAR | 32 | 0 | SFA Key of Material Sales Data | ||
3 | SFAMARA | SMO_SFAMAR | SMO_GUID | CHAR | 32 | 0 | SFA Key of Material | ||
4 | MATNR | SMO3MATNR | SMO3MATNR | CHAR | 40 | 0 | Material number | ||
5 | SOURCE | SMO_SOURCE | SMO_SOURCE | CHAR | 3 | 0 | Source of an object | ||
6 | VKORG | SMO3VKORG | SMO3VKORG | CHAR | 14 | 0 | Sales organization | ||
7 | VTWEG | SMO3VTWEG | SMO3VTWEG | CHAR | 2 | 0 | Distribution channel | ||
8 | BONUS | SMO3BONUS | SMO3BONUS | CHAR | 2 | 0 | Volume rebate group | ||
9 | PROVG | SMO3PROVG | SMO3PROVG | CHAR | 2 | 0 | Commission group | ||
10 | VMSTA | SMO3VMSTA | SMO3VMSTA | CHAR | 5 | 0 | Distribution-chain-specific material status | ||
11 | VMSTD | SMO3VMSTD | DATUM | DATS | 8 | 0 | Date from which distr.-chain-spec. material status is valid | ||
12 | AUMNG | SMO3MINAU | MENG13 | QUAN | 13 | 3 | Minimum order quantity in base unit of measure | ||
13 | LFMNG | SMO3MINLF | MENG13 | QUAN | 13 | 3 | Minimum delivery quantity in delivery note processing | ||
14 | SCMNG | SMO3SCHRT | MENG13 | QUAN | 13 | 3 | Delivery unit | ||
15 | SCHME | SMO3SCHME | MEINS | UNIT | 3 | 0 | Unit of measure of delivery unit | * | |
16 | VRKME | SMO3VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
17 | MTPOS | SMO3MTPOS | SMO3MTPOS | CHAR | 4 | 0 | Item category group from material master | ||
18 | DWERK | SMO3DWERK | SMO3WERKS | CHAR | 4 | 0 | Delivering plant | ||
19 | PRODH | SMO3PRODH | SMO3PRODH | CHAR | 20 | 0 | Product hierarchy | ||
20 | PMATN | SMO3PMATN | SMO3MATNR | CHAR | 40 | 0 | Pricing reference material | ||
21 | KONDM | SMO3KONDM | SMO3KONDM | CHAR | 2 | 0 | Material Pricing Group | ||
22 | KTGRM | SMO3KTGRM | SMO3KTGRM | CHAR | 2 | 0 | Account assignment group for this material | ||
23 | MVGR1 | SMO3MVGR1 | SMO3MVGR1 | CHAR | 3 | 0 | Material group 1 | ||
24 | MVGR2 | SMO3MVGR2 | SMO3MVGR2 | CHAR | 3 | 0 | Material group 2 | ||
25 | MVGR3 | SMO3MVGR3 | SMO3MVGR3 | CHAR | 3 | 0 | Material group 3 | ||
26 | MVGR4 | SMO3MVGR4 | SMO3MVGR4 | CHAR | 3 | 0 | Material group 4 | ||
27 | MVGR5 | SMO3MVGR5 | SMO3MVGR5 | CHAR | 3 | 0 | Material group 5 | ||
28 | PHLINE | SMO_PHLINE | SMO_TXT20 | CHAR | 20 | 0 | Pharmaceutical: BU Line | ||
29 | SFAPOSORG | SMO_SFAPOG | SMO_GUID | CHAR | 32 | 0 | Position/ Org.Unit (GUID) | ||
30 | NON_GUID | SMO_NGUID | SMO_NGUID | DEC | 1 | 0 | Not Guided Record | ||
31 | .INCLUDE | 0 | 0 | Record Modification Fields for Mobile Sales/Service | |||||
32 | ERFASS | SMO_CREATE | SMO_DATE | DATS | 8 | 0 | Date of Creation. | ||
33 | GEAEND | SMO_MODIFY | SMO_DATE | DATS | 8 | 0 | Date last Modified | ||
34 | BEARB | SMO_BEARB | SMO_BEARB | CHAR | 15 | 0 | Record Edited by User Name | ||
35 | .INCLUDE | 0 | 0 | Communication Fields for Mobile Sales/Service | |||||
36 | TR_USER | SMO_TR_USR | SMO_TR_USR | CHAR | 32 | 0 | Transaction User | ||
37 | TR_ID | SMO_TR_ID | SMO_TR_ID | CHAR | 32 | 0 | Transaction Identifier | ||
38 | TR_STATUS | SMO_TR_STS | SMO_TR_STS | CHAR | 4 | 0 | Status of Transaction | ||
39 | TIMESTAMP | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
40 | DELETED | SMO_DELETD | SMO_DELETD | CHAR | 1 | 0 | Mobile Sales Deleted | ||
41 | TR_ROOTID | SMO_RTGUID | SMO_GUID | CHAR | 32 | 0 | Identifier of BDoc Root object | ||
42 | SFAPMATNR | SMO_SFAMAR | SMO_GUID | CHAR | 32 | 0 | SFA Key of Material | ||
43 | LVORM | LVORM | XFELD | CHAR | 1 | 0 | Deletion Indicator | ||
44 | SKTOF | SMO3SKTOF | DEFAULT | CHAR | 1 | 0 | Cash Discount Indicator | ||
45 | CATG_SALES | SFACATGT | SMO_GUID | CHAR | 32 | 0 | GUID of Product Category Text | ||
46 | LOC_BUPA | SMO_PARTNR | SMO_PARTNR | CHAR | 10 | 0 | ZGP-Partner Number | ||
47 | NO_SA_DATA | SMODATAFLG | CHKFLAG | CHAR | 1 | 0 | Flag Data Available |
History
Last changed by/on | SAP | 20050115 |
SAP Release Created in |