SAP ABAP Table SMOMARA (General Material Data)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOMARA	Table Relationship Diagram
Short Description	General Material Data

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	SFAMARA	☑	SMO_SFAMAR	SMO_GUID	CHAR	32	0	SFA Key of Material
3	MATNR	☐	SMO3MATNR	SMO3MATNR	CHAR	40	0	Material number
4	SOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
5	MTART	☐	SMO3MTART	SMO3MTART	CHAR	20	0	Material type
6	MATKL	☐	SMO3MATKL	SMO3MATKL	CHAR	20	0	Material group
7	MEINS	☐	SMO3MEINS	MEINS	UNIT	3	0	Base unit of measure	*
8	MBRSH	☐	SMO3MBRSH	SMO3MBRSH	CHAR	1	0	Industry sector
9	SPART	☐	SMO3SPART	SMO3SPART	CHAR	2	0	Division
10	PRDHA	☐	SMO3PRODH	SMO3PRODH	CHAR	20	0	Product hierarchy
11	PHREFNR	☐	SMO_PHREFN	SMO_TXT10	CHAR	10	0	Pharmaceutical Reference Number
12	SFAPOSORG	☐	SMO_SFAPOG	SMO_GUID	CHAR	32	0	Position/ Org.Unit (GUID)
13	EAN11	☐	SMO3EAN11	SMO3EAN11	CHAR	40	0	International Article Number (EAN/UPC)
14	NUMTP	☐	SMO3NUMTP	SMO3NUMTP	CHAR	2	0	Number category of International Article Number (EAN)
15	LVORM	☐	SMO3LVOMA	XFELD	CHAR	1	0	Flag Material for Deletion at Client Level
16	KZKFG	☐	SMO3KZKFG	XFELD	CHAR	1	0	Configurable Material
17	KUNNR	☐	SMO3WETTB	SMO3KUNNR	CHAR	10	0	Competitor
18	SFAKNA1	☐	SMO_SFKNCP	SMO_GUID	CHAR	32	0	ID of the competitor
19	SOURCE_C	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
20	PARTNER	☐	SMO_PARTNR	SMO_PARTNR	CHAR	10	0	ZGP-Partner Number
21	TRAGR	☐	SMO3TRAGR	SMO3TRAGR	CHAR	4	0	Transportation group
22	BEHVO	☐	SMO3BEHVO	SMO3BEHVO	CHAR	2	0	Container requirements
23	RAUBE	☐	SMO3RAUBE	SMO3RAUBE	CHAR	2	0	Storage conditions
24	TEMPB	☐	SMO3TEMPB	SMO3TEMPB	CHAR	2	0	Temperature conditions indicator
25	BISMT	☐	SMO3BISMT	SMO3BISMT	CHAR	18	0	Old material number
26	GROES	☐	SMO3GROES	CHAR32	CHAR	32	0	Size/dimensions
27	WRKST	☐	SMO_FING	TEXT14	CHAR	14	0	Person responsible for company area
28	NORMT	☐	SMO3NORMT	SMO3NORMT	CHAR	18	0	Standard Description (such as ANSI or ISO)
29	PMATA	☐	SMO3PMATN	SMO3MATNR	CHAR	40	0	Pricing reference material
30	XCHPF	☐	SMO3XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
31	KVMARKET	☐	SMO_MARKET	SMO_TXT4	CHAR	4	0	Market of Partner
32	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
33	NON_GUID	☐	SMO_NGUID	SMO_NGUID	DEC	1	0	Not Guided Record
34	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
35	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
36	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
37	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
38	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
39	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
40	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
41	SATNR	☐	SMO3SATNR	SMO3MATNR	CHAR	40	0	Cross-plant configurable material
42	SFAKMARA	☐	SMO_SFAMAR	SMO_GUID	CHAR	32	0	SFA Key of Material
43	MTPOS	☐	SMO3MTPOS	SMO3MTPOS	CHAR	4	0	Item category group from material master
44	MSTAV	☐	SMO3MSTAV	SMO3VMSTA	CHAR	5	0	Cross-distribution-chain material status
45	MSTDV	☐	SMO3MSTDV	DATUM	DATS	8	0	Date from which the X-distr.-chain material status is valid
46	PRODTYPE	☐	SMO_PRTYPE	TEXT2	CHAR	2	0	Product Type
47	DURATION	☐	SMO_DURAT	MENG13	QUAN	13	3	Duration
48	DURUOM	☐	SMO_DURUOM	MEINS	UNIT	3	0	Unit of Duration	*
49	SUBPROF	☐	SMOSUBPROF	SMO_TXT9	CHAR	9	0	Subject Profile
50	PRODSTAT	☐	SMO_PRSTAT	SMO_PRSTAT	CHAR	5	0	Product Status
51	OBJFAMILY	☐	SMO_OBJFAM	SMO_OBJFAM	CHAR	4	0	Product Object Family
52	MATNRLNG	☐	SMO3MATNR	SMO3MATNR	CHAR	40	0	Material number
53	COMP_PROD	☐	SMOCOMPPRD	SMOCOMPPRD	CHAR	1	0	Indicates Product as Competitor Product
54	SERIAL_NOP	☐	SERIALNO_PROCESSING	SERIALNO_PROCESSING	NUMC	1	0	Serial Number Processing
55	.INCLUDE	☐				0	0	Record Modification Fields for Mobile Sales/Service
56	ERFASS	☐	SMO_CREATE	SMO_DATE	DATS	8	0	Date of Creation.
57	GEAEND	☐	SMO_MODIFY	SMO_DATE	DATS	8	0	Date last Modified
58	BEARB	☐	SMO_BEARB	SMO_BEARB	CHAR	15	0	Record Edited by User Name

History

Last changed by/on	SAP	20041219
SAP Release Created in