SAP ABAP Table SMOCAPVIS (Customer Opening / Public Hours)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOCAPVIS	Table Relationship Diagram
Short Description	Customer Opening / Public Hours

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	SFACAPVIS	☑	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	SFAKNVV	☐	SMO_SFAKNV	SMO_GUID	CHAR	32	0	SFA Key of Customer Sales Area
4	SFAKNA1	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
5	SFAADRC	☐	SMO_SFAADC	SMO_GUID	CHAR	32	0	SFA Key of Address
6	SFAPOSORG	☐	SMO_SFAPOG	SMO_GUID	CHAR	32	0	Position/ Org.Unit (GUID)
7	VKORG	☐	SMO3VKORG	SMO3VKORG	CHAR	14	0	Sales organization
8	VTWEG	☐	SMO3VTWEG	SMO3VTWEG	CHAR	2	0	Distribution channel
9	SPART	☐	SMO3SPART	SMO3SPART	CHAR	2	0	Division
10	PHLINE	☐	SMO_PHLINE	SMO_TXT20	CHAR	20	0	Pharmaceutical: BU Line
11	KVOPTYP	☐	SMO_KVOPTP	SMO_TXT3	CHAR	3	0	Open Hour Type
12	NON_GUID	☐	SMO_NGUID	SMO_NGUID	DEC	1	0	Not Guided Record
13	.INCLUDE	☐				0	0	Opening Hours
14	MONGEN	☐	SMO_MONGEN	SMO_LOGICL	CHAR	1	0	Opened on Mondays
15	MOMOFR	☐	SMO_MORNFR	SMO_OPNHRS	TIMS	6	0	In the morning opened from...
16	MOMOUN	☐	SMO_MORNTO	SMO_OPNHRS	TIMS	6	0	In the morning opened until...
17	MOAFFR	☐	SMO_AFTFR	SMO_OPNHRS	TIMS	6	0	In the afternoon opened from...
18	MOAFUN	☐	SMO_AFTTO	SMO_OPNHRS	TIMS	6	0	In the afternoon opened until...
19	TUEGEN	☐	SMO_TUEGEN	SMO_LOGICL	CHAR	1	0	Opened on Tuesdays
20	TUMOFR	☐	SMO_MORNFR	SMO_OPNHRS	TIMS	6	0	In the morning opened from...
21	TUMOUN	☐	SMO_MORNTO	SMO_OPNHRS	TIMS	6	0	In the morning opened until...
22	TUAFFR	☐	SMO_AFTFR	SMO_OPNHRS	TIMS	6	0	In the afternoon opened from...
23	TUAFUN	☐	SMO_AFTTO	SMO_OPNHRS	TIMS	6	0	In the afternoon opened until...
24	WEDGEN	☐	SMO_WEDGEN	SMO_LOGICL	CHAR	1	0	Opened on Wednesdays
25	WEMOFR	☐	SMO_MORNFR	SMO_OPNHRS	TIMS	6	0	In the morning opened from...
26	WEMOUN	☐	SMO_MORNTO	SMO_OPNHRS	TIMS	6	0	In the morning opened until...
27	WEAFFR	☐	SMO_AFTFR	SMO_OPNHRS	TIMS	6	0	In the afternoon opened from...
28	WEAFUN	☐	SMO_AFTTO	SMO_OPNHRS	TIMS	6	0	In the afternoon opened until...
29	THUGEN	☐	SMO_THUGEN	SMO_LOGICL	CHAR	1	0	Opened on Thursdays
30	THMOFR	☐	SMO_MORNFR	SMO_OPNHRS	TIMS	6	0	In the morning opened from...
31	THMOUN	☐	SMO_MORNTO	SMO_OPNHRS	TIMS	6	0	In the morning opened until...
32	THAFFR	☐	SMO_AFTFR	SMO_OPNHRS	TIMS	6	0	In the afternoon opened from...
33	THAFUN	☐	SMO_AFTTO	SMO_OPNHRS	TIMS	6	0	In the afternoon opened until...
34	FRIGEN	☐	SMO_FRIGEN	SMO_LOGICL	CHAR	1	0	Opened on Fridays
35	FRMOFR	☐	SMO_MORNFR	SMO_OPNHRS	TIMS	6	0	In the morning opened from...
36	FRMOUN	☐	SMO_MORNTO	SMO_OPNHRS	TIMS	6	0	In the morning opened until...
37	FRAFFR	☐	SMO_AFTFR	SMO_OPNHRS	TIMS	6	0	In the afternoon opened from...
38	FRAFUN	☐	SMO_AFTTO	SMO_OPNHRS	TIMS	6	0	In the afternoon opened until...
39	SATGEN	☐	SMO_SATGEN	SMO_LOGICL	CHAR	1	0	Opened on Saturdays
40	SAMOFR	☐	SMO_MORNFR	SMO_OPNHRS	TIMS	6	0	In the morning opened from...
41	SAMOUN	☐	SMO_MORNTO	SMO_OPNHRS	TIMS	6	0	In the morning opened until...
42	SAAFFR	☐	SMO_AFTFR	SMO_OPNHRS	TIMS	6	0	In the afternoon opened from...
43	SAAFUN	☐	SMO_AFTTO	SMO_OPNHRS	TIMS	6	0	In the afternoon opened until...
44	SUNGEN	☐	SMO_SUNGEN	SMO_LOGICL	CHAR	1	0	Opened on Sundays
45	SUMOFR	☐	SMO_MORNFR	SMO_OPNHRS	TIMS	6	0	In the morning opened from...
46	SUMOUN	☐	SMO_MORNTO	SMO_OPNHRS	TIMS	6	0	In the morning opened until...
47	SUAFFR	☐	SMO_AFTFR	SMO_OPNHRS	TIMS	6	0	In the afternoon opened from...
48	SUAFUN	☐	SMO_AFTTO	SMO_OPNHRS	TIMS	6	0	In the afternoon opened until...
49	KVHOLFR	☐	SMO_HOLDAY	SMO_HOLDAY	DATS	8	0	Holiday from / to
50	KVHOLUN	☐	SMO_HOLDAY	SMO_HOLDAY	DATS	8	0	Holiday from / to
51	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	*
52	.INCLUDE	☐				0	0	Record Modification Fields for Mobile Sales/Service
53	ERFASS	☐	SMO_CREATE	SMO_DATE	DATS	8	0	Date of Creation.
54	GEAEND	☐	SMO_MODIFY	SMO_DATE	DATS	8	0	Date last Modified
55	BEARB	☐	SMO_BEARB	SMO_BEARB	CHAR	15	0	Record Edited by User Name
56	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
57	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
58	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
59	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
60	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
61	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
62	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
63	TERRID	☐	NTERRID	CHAR_30	CHAR	30	0	Territory ID 30 Character length
64	SFATERR	☐	SMO_SFATR	SMO_GUID	CHAR	32	0	SFA Key of Territories

History

Last changed by/on	SAP	20110908
SAP Release Created in