CRMT_BSP_TOU_ITEM SAP (Tour items) Structure details

Dictionary Type: Structure
Description: Tour items




ABAP Code to SELECT data from CRMT_BSP_TOU_ITEM
Related tables to CRMT_BSP_TOU_ITEM
Access table CRMT_BSP_TOU_ITEM




Structure field list including key, data, relationships and ABAP select examples

CRMT_BSP_TOU_ITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Tour items" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CRMT_BSP_TOU_ITEM TYPE CRMT_BSP_TOU_ITEM.

The CRMT_BSP_TOU_ITEM table consists of various fields, each holding specific information or linking keys about Tour items data available in SAP. These include GUID (GUID of a CRM Order Object), TOUR_GUID (GUID of a CRM Order Object), SEQNUM (Visit Plan Item Sequence Number), BPSTARTTIME (Activity Time).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CRMT_BSP_TOU_ITEM structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
OBJECT_KEYObject Key CRMT_BSP_OBJECTKEYCHAR100
GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
TOUR_GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
SEQNUMVisit Plan Item Sequence Number CRMT_SEQUENCE_NUMNUMC10CRM_SEQUENCE_NUM
BPSTARTTIMEActivity Time CRMT_ACTIVITY_TIMETIMS6UZEIT
TOUBPSTARTTIMEStart Time CRMT_BSP_TOUACT_TIMECHAR6CHAR6
TOUBPSTARTTIMEVALUECharacter field of length 6 CHAR6CHAR6CHAR6
ACTCATEGORYActivity Category (Communication Type) CRMT_ACTIVITY_CATEGORYCHAR3Assigned to domainCRM_ACTIVITY_CATEGORY
TOURDURATIONVisit Plan Duration CRMT_TOUR_DURATIONNUMC5CRM_TOUR_DURATION
TOURDURATIONUNITVisit Plan Duration Unit CRMT_TOUR_DURN_UNITCHAR1CRM_TOUR_DURN_UNIT
TOURPREPTIMEVisit Plan Preparation Time CRMT_TOUR_PREPTIMENUMC5CRM_TOUR_DURATION
TOURPREPTIMEUNITVisit Plan Preparation Time Unit CRMT_TOUR_PREPTIME_UNITCHAR1CRM_TOUR_DURN_UNIT
WEEKDAYFROMDay of the week on which the activity is to be generated CRMT_TOUR_WEEKDAYNUMC1CRM_TOUR_WEEKDAY
WEEKDAYTODay of the week on which the activity is to be generated CRMT_TOUR_WEEKDAYNUMC1CRM_TOUR_WEEKDAY
DAYNUMBERFROMDay of the week on which the activity is to be generated CRMT_TOUR_DAY_NUMBERNUMC3CRM_TOUR_DAY_NUMBER
DAYNUMBERTODay of the week on which the activity is to be generated CRMT_TOUR_DAY_NUMBERNUMC3CRM_TOUR_DAY_NUMBER
WEEKNUMBERFROMNumber of the week on which the activity is to be generated CRMT_TOUR_WEEK_NUMBERNUMC3CRM_TOUR_WEEK_NUMBER
WEEKNUMBERTONumber of the week on which the activity is to be generated CRMT_TOUR_WEEK_NUMBERNUMC3CRM_TOUR_WEEK_NUMBER
PROCESS_TYPEBusiness Transaction Type CRMT_PROCESS_TYPECHAR4Assigned to domainCRM_PROCESS_TYPECRM_PROCESS_TYPECRM_PROCESS_TYPE
ALLDAYFLAGVisit Plan - All-day flag CRMT_ALL_DAY_FLAGCHAR1CRM_BOOLEAN
ACTTEMPLATEGUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
NOTIFICATIONTYPENotification Type CRMT_NOTIFICATION_TYPECHAR1CRM_NOTIFICATION_TYPE
BPGUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
CPGUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
BUSINESS_PARTNERVisit Plan Items - Business Partner CRMT_TOUR_BP_LISTCHAR80TEXT80
BPPARTNERNUMBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
CONTACT_PERSONVisit Plan Items - Contact Person CRMT_TOUR_CP_LISTCHAR80TEXT80
CPPARTNERNUMContact Person ID CRMT_CONTACTCHAR10Assigned to domainALPHABU_PARTNER
ACTTEMPLATEIDActivity Template ID CRMT_ACTTEMPLATEIDCHAR10ALPHACRM_OBJECT_ID
ACTTEMPLATE_DESCDescription CRMT_DESCRIPTIONCHAR40TEXT40

Key field Non-key field



How do I retrieve data from SAP structure CRMT_BSP_TOU_ITEM using ABAP code?

As CRMT_BSP_TOU_ITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CRMT_BSP_TOU_ITEM as there is no data to select.

How to access SAP table CRMT_BSP_TOU_ITEM

Within an ECC or HANA version of SAP you can also view further information about CRMT_BSP_TOU_ITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!