SAP ABAP Table CDBD_BUSHOURS (BP Master Data: Business Hours)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ CDB (Package) new CDB tables for new BDocs for CRM 3.0

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CDBD_BUSHOURS	Table Relationship Diagram
Short Description	BP Master Data: Business 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	SFABUSHOURS	☑	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	SFAKNA1	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
4	SFAKVBEZ6	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
5	SOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
6	KVOPTYP	☐	SMO_KVOPTP	SMO_TXT3	CHAR	3	0	Open Hour Type
7	SCHEDULE_TYPE	☐	BU_SCHEDULE_TYPE	BU_SCHEDULE_TYPE	CHAR	1	0	Schedule Type
8	VKORG	☐	SMO3VKORG	SMO3VKORG	CHAR	14	0	Sales organization
9	VTWEG	☐	SMO3VTWEG	SMO3VTWEG	CHAR	2	0	Distribution channel
10	SPART	☐	SMO3SPART	SMO3SPART	CHAR	2	0	Division
11	PARTNER	☐	SMO_PARTNR	SMO_PARTNR	CHAR	10	0	ZGP-Partner Number
12	DFAULT	☐	SMO_DFLT	SMO_LOGICL	CHAR	1	0	This is the default record / value (T/F)
13	TYPE	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
14	START_DATE	☐	SCSTARTDAT	DATUM	DATS	8	0	Start Date for Rule Period
15	END_DATE	☐	SCENDDATE	DATUM	DATS	8	0	End Date for Rule Period
16	CONFLICTS	☐	SCCONFLICT	CHAR1	CHAR	1	0	Exception Rule for Non-Working Days
17	FCALID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
18	HCALID	☐	HIDENT	HIDENT	CHAR	2	0	Public Holiday Calendar	*
19	INFO_DEL	☐	SC_MAINTID	CHAR1	CHAR	1	0	Maintenance identifier
20	WEEKS	☐	SC_RULEWNO	CHAR2	CHAR	2	0	Number of weeks in the week rule
21	MONDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
22	TUESDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
23	WEDNESDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
24	THURSDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
25	FRIDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
26	SATURDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
27	SUNDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
28	MONDA_FROM	☐	SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
29	TUESD_FROM	☐	SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
30	WEDNE_FROM	☐	SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
31	THURS_FROM	☐	SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
32	FRIDA_FROM	☐	SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
33	SATUR_FROM	☐	SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
34	SUNDA_FROM	☐	SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
35	MONDAY_TO	☐	SC_RULEWTO	TIME	TIMS	6	0	Finish time of this weekday
36	TUESDAY_TO	☐	SC_RULEWTO	TIME	TIMS	6	0	Finish time of this weekday
37	WEDNESD_TO	☐	SC_RULEWTO	TIME	TIMS	6	0	Finish time of this weekday
38	THURSDA_TO	☐	SC_RULEWTO	TIME	TIMS	6	0	Finish time of this weekday
39	FRIDAY_TO	☐	SC_RULEWTO	TIME	TIMS	6	0	Finish time of this weekday
40	SATURDA_TO	☐	SC_RULEWTO	TIME	TIMS	6	0	Finish time of this weekday
41	SUNDAY_TO	☐	SC_RULEWTO	TIME	TIMS	6	0	Finish time of this weekday
42	MOND_TZONE	☐	SC_RULEWTZ	TZNZONE	CHAR	6	0	Time zone for this weekday	*
43	TUES_TZONE	☐	SC_RULEWTZ	TZNZONE	CHAR	6	0	Time zone for this weekday	*
44	WEDN_TZONE	☐	SC_RULEWTZ	TZNZONE	CHAR	6	0	Time zone for this weekday	*
45	THUR_TZONE	☐	SC_RULEWTZ	TZNZONE	CHAR	6	0	Time zone for this weekday	*
46	FRID_TZONE	☐	SC_RULEWTZ	TZNZONE	CHAR	6	0	Time zone for this weekday	*
47	SATU_TZONE	☐	SC_RULEWTZ	TZNZONE	CHAR	6	0	Time zone for this weekday	*
48	SUND_TZONE	☐	SC_RULEWTZ	TZNZONE	CHAR	6	0	Time zone for this weekday	*
49	MONDY_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
50	TUESD_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
51	WEDNE_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
52	THURS_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
53	FRIDA_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
54	SATUR_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
55	SUNDA_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
56	TERRID	☐	NTERRID	CHAR_30	CHAR	30	0	Territory ID 30 Character length
57	SFATERR	☐	SMO_SFATR	SMO_GUID	CHAR	32	0	SFA Key of Territories
58	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
59	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
60	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
61	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
62	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
63	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
64	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
65	DAYSD	☐	SCDAYS	CHAR3	CHAR	3	0	Number of Days Between Appointments
66	MONTHM1	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
67	DAYSM1	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
68	DAY_NR	☐	DAY_NUMBER	DAY_NR	CHAR	5	0	Day number monthly rule
69	WEEKDAY_NR	☐	WOTNR	CHAR1	CHAR	1	0	Calendar: Number of day
70	MONTHM3	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
71	YEAR_FROM	☐	SC_YEAR	CHAR4	CHAR	4	0	Year
72	MONTH_FROM	☐	SC_MONTH	CHAR2	CHAR	2	0	Month in year
73	DAY_FROM	☐	SC_DAY	CHAR2	CHAR	2	0	Day in the month
74	YEAR_TO	☐	SC_YEAR	CHAR4	CHAR	4	0	Year
75	MONTH_TO	☐	SC_MONTH	CHAR2	CHAR	2	0	Month in year
76	DAY_TO	☐	SC_DAY	CHAR2	CHAR	2	0	Day in the month
77	SFAKNBP	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner

History

Last changed by/on	SAP	20130604
SAP Release Created in	400