SAP ABAP Table SMOPRGH (Product Grouping)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ SMO3 (Package) Consolidated Database

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOPRGH	Table Relationship Diagram
Short Description	Product Grouping

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	SFAPRGH	☑	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	VKORG	☐	SMO3VKORG	SMO3VKORG	CHAR	14	0	Sales organization
4	VTWEG	☐	SMO3VTWEG	SMO3VTWEG	CHAR	2	0	Distribution channel
5	SPART	☐	SMO3SPART	SMO3SPART	CHAR	2	0	Division
6	PGRNAME	☐	SMO_TXT50	SMO_TXT50	CHAR	50	0	Text 50
7	PRODH	☐	SMO3PRODH	SMO3PRODH	CHAR	20	0	Product hierarchy
8	MVGR1	☐	SMO3MVGR1	SMO3MVGR1	CHAR	3	0	Material group 1
9	MVGR2	☐	SMO3MVGR2	SMO3MVGR2	CHAR	3	0	Material group 2
10	MVGR3	☐	SMO3MVGR3	SMO3MVGR3	CHAR	3	0	Material group 3
11	MVGR4	☐	SMO3MVGR4	SMO3MVGR4	CHAR	3	0	Material group 4
12	MVGR5	☐	SMO3MVGR5	SMO3MVGR5	CHAR	3	0	Material group 5
13	BONUS	☐	SMO3BONUS	SMO3BONUS	CHAR	2	0	Volume rebate group
14	PROVG	☐	SMO3PROVG	SMO3PROVG	CHAR	2	0	Commission group
15	KONDM	☐	SMO3KONDM	SMO3KONDM	CHAR	2	0	Material Pricing Group
16	SPRSP	☐	SMO_SPRSP	SMO_CURRCY	CURR	28	9	Suggested Promotional RSP
17	APRSP	☐	SMO_APRSP	SMO_CURRCY	CURR	28	9	Actual Promotional RSP
18	CASERATE	☐	SMO_CASERT	SMO_CURRCY	CURR	28	9	Case rate: Discount Amount
19	PERDISC	☐	SMO_PERDSC	SMO_NUM3	DEC	3	0	Discount in Percentage
20	FIXCP	☐	SMO_PRICE	SMO_CURRCY	CURR	28	9	Fixed Costs Planned
21	VARCP	☐	SMO_PRIC2	SMO_CURRCY	CURR	28	9	Variable Costs planned
22	OFFINV	☐	SMO_OFFINV	SMO_CURRCY	CURR	28	9	Off Invoice
23	VARAMT	☐	SMO_VARAMT	SMO_CURRCY	CURR	28	9	Variable Bill Back
24	FIXAMT	☐	SMO_FIXAMT	SMO_CURRCY	CURR	28	9	Fixed Fee Allocation / Products
25	PREPAY	☐	SMO_PREPAY	SMO_CURRCY	CURR	28	9	Pre-Payment
26	PRICSUB	☐	SMO3KSCHL	SMO3KSCHL	CHAR	4	0	Condition type
27	CONDVAL	☐	SMO_DMBTR		CURR	28	9	Amount in local currency
28	PRCSTAT	☐	SMO_PRCSTT	SMO_CURRCY	CURR	28	9	Pricing Status settled amount for deal types
29	WAERS	☐	SMO3WAERS	WAERS	CUKY	5	0	Currency key	*
30	TOTNUM	☐	SMO_CONUMD	SMO_QUAN	QUAN	13	0	Consumption Scan
31	UNIT2	☐	SMO3MEINS	MEINS	UNIT	3	0	Base unit of measure	*
32	SFAKNA1	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
33	PRICEDIFF	☐	SMO_PRCDIF	SMO_LOGICL	CHAR	1	0	Price in the Brand-size is different than any one of the SKU
34	.INCLUDE	☐				0	0	Record Modification Fields for Mobile Sales/Service
35	ERFASS	☐	SMO_CREATE	SMO_DATE	DATS	8	0	Date of Creation.
36	GEAEND	☐	SMO_MODIFY	SMO_DATE	DATS	8	0	Date last Modified
37	BEARB	☐	SMO_BEARB	SMO_BEARB	CHAR	15	0	Record Edited by User Name
38	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
39	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
40	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
41	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
42	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
43	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
44	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object

History

Last changed by/on	SAP	20030214
SAP Release Created in