SAP CRMST_QUERY_ACT_AC_BTIL table - BTIL structure for Activities - Search criteria details in SAP

SAP CRMST_QUERY_ACT_AC_BTIL table summary

Object Name: CRMST_QUERY_ACT_AC_BTIL
Dictionary Type: Structure
Description: BTIL structure for Activities - Search criteria

Field list for CRMST_QUERY_ACT_AC_BTIL table on an S/4 SAP system

Details

CRMST_QUERY_ACT_AC_BTIL-OBJTYPE_H table field - Business Trans. Cat. ▼

Description: Business Trans. Cat.
Field Name: OBJTYPE_H
Data Element: CRMT_SUBOBJECT_CATEGORY_DB
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CRM_OJ_NAME_PROCESS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJTYPE_H

CRMST_QUERY_ACT_AC_BTIL-OBJECT_ID table field - Transaction ID ▼

Description: Transaction ID
Field Name: OBJECT_ID
Data Element: CRMT_OBJECT_ID_DB
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: CRM_OBJECT_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field OBJECT_ID

CRMST_QUERY_ACT_AC_BTIL-CATEGORY table field - Activity Category (Communication Type) ▼

Description: Activity Category (Communication Type)
Field Name: CATEGORY
Data Element: CRMT_ACTIVITY_CATEGORY
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CRM_ACTIVITY_CATEGORY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CATEGORY

CRMST_QUERY_ACT_AC_BTIL-CLASS table field - Activity Class ▼

Description: Activity Class
Field Name: CLASS
Data Element: CRMT_ACTIVITY_CLASS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRM_ACTIVITY_CLASS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLASS

CRMST_QUERY_ACT_AC_BTIL-PROCESS_TYPE table field - Business Transaction Type ▼

Description: Business Transaction Type
Field Name: PROCESS_TYPE
Data Element: CRMT_PROCESS_TYPE_DB
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: CRM_PROCESS_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROCESS_TYPE

CRMST_QUERY_ACT_AC_BTIL-POSTING_DATE table field - Posting Date for a Business Transaction ▼

Description: Posting Date for a Business Transaction
Field Name: POSTING_DATE
Data Element: CRMT_POSTING_DATE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTING_DATE

CRMST_QUERY_ACT_AC_BTIL-DESCRIPTION_H table field - Transaction Description ▼

Description: Transaction Description
Field Name: DESCRIPTION_H
Data Element: CRMT_PROCESS_DESCRIPTION
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CRM_PROCESS_DESCRIPTION
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DESCRIPTION_H

CRMST_QUERY_ACT_AC_BTIL-DIS_CHANNEL table field - Distribution Channel ▼

Description: Distribution Channel
Field Name: DIS_CHANNEL
Data Element: CRMT_DISTRIBUTION_CHANNEL
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: VTWEG
MemoryID:
AppClass: MG
SHLP: CRM_ORGMAN_DIS_CHANNEL
SHLP Field: DIS_CHANNEL
ConvExit:

See all SAP tables containing field DIS_CHANNEL

CRMST_QUERY_ACT_AC_BTIL-DIVISION table field - Division ▼

Description: Division
Field Name: DIVISION
Data Element: CRMT_DIVISION
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: SPART
MemoryID:
AppClass: V
SHLP: CRM_DIVISION
SHLP Field: DIVISION
ConvExit:

See all SAP tables containing field DIVISION

CRMST_QUERY_ACT_AC_BTIL-SALES_ORG table field - Sales Organization ID ▼

Description: Sales Organization ID
Field Name: SALES_ORG
Data Element: CRMT_SALES_ORG
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: HROBJEC_14
MemoryID:
AppClass:
SHLP: CRM_ORGMAN_SALES_ORG
SHLP Field: SALES_ORG
ConvExit:

See all SAP tables containing field SALES_ORG

CRMST_QUERY_ACT_AC_BTIL-SERVICE_ORG table field - Service Organization ▼

Description: Service Organization
Field Name: SERVICE_ORG
Data Element: CRMT_SERVICE_ORG
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: HROBJEC_14
MemoryID:
AppClass:
SHLP: CRM_ORGMAN_SERVICE_ORG
SHLP Field: SERVICE_ORG
ConvExit:

See all SAP tables containing field SERVICE_ORG

CRMST_QUERY_ACT_AC_BTIL-ACTIVITY_PARTNER table field - Activity Partner ▼

Description: Activity Partner
Field Name: ACTIVITY_PARTNER
Data Element: CRMT_ACTIVITY_PARTNER
Data Type: CHAR
length (Dec): 10(0)
Check table: BUT000
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ACTIVITY_PARTNER

CRMST_QUERY_ACT_AC_BTIL-CONTACT_PERSON table field - Customer Contact Person ▼

Description: Customer Contact Person
Field Name: CONTACT_PERSON
Data Element: CRMT_CONTACT_PERSON
Data Type: CHAR
length (Dec): 10(0)
Check table: BUT000
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field CONTACT_PERSON

CRMST_QUERY_ACT_AC_BTIL-PERSON_RESP table field - Employee Responsible ▼

Description: Employee Responsible
Field Name: PERSON_RESP
Data Element: CRMT_PERSON_RESP
Data Type: CHAR
length (Dec): 10(0)
Check table: BUT000
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field PERSON_RESP

CRMST_QUERY_ACT_AC_BTIL-PRIORITY table field - Activity Priority ▼

Description: Activity Priority
Field Name: PRIORITY
Data Element: CRMT_PRIORITY
Data Type: NUMC
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SC_PRIO
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRIORITY

CRMST_QUERY_ACT_AC_BTIL-OBJECTIVE table field - Goal of an Activity ▼

Description: Goal of an Activity
Field Name: OBJECTIVE
Data Element: CRMT_OBJECTIVE
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CRM_OBJECTIVE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECTIVE

CRMST_QUERY_ACT_AC_BTIL-DIRECTION table field - Direction of an Activity ▼

Description: Direction of an Activity
Field Name: DIRECTION
Data Element: CRMT_DIRECTION
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRM_DIRECTION
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DIRECTION

CRMST_QUERY_ACT_AC_BTIL-EXTERN_ACT_ID table field - External Business Transaction Number ▼

Description: External Business Transaction Number
Field Name: EXTERN_ACT_ID
Data Element: CRMT_EXTERNAL_ACTIVITY_ID
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CRM_EXTERNAL_ACTIVITY_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTERN_ACT_ID

CRMST_QUERY_ACT_AC_BTIL-ADDRESS_ID table field - Location where Activity takes place ▼

Description: Location where Activity takes place
Field Name: ADDRESS_ID
Data Element: CRMT_ADDRESS
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: AD_ADDRNUM
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ADDRESS_ID

CRMST_QUERY_ACT_AC_BTIL-PRIVATE_FLAG table field - Indicator: Task is Private ▼

Description: Indicator: Task is Private
Field Name: PRIVATE_FLAG
Data Element: CRMT_PRIVAT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRM_BOOLEAN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRIVATE_FLAG

CRMST_QUERY_ACT_AC_BTIL-COMPLETION table field - Completion Rate in Percent ▼

Description: Completion Rate in Percent
Field Name: COMPLETION
Data Element: CRMT_COMPLETION
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CRM_COMPLETION
MemoryID:
AppClass:
SHLP: CRM_ACT_COMPLETION
SHLP Field: COMPLETION
ConvExit:

See all SAP tables containing field COMPLETION

CRMST_QUERY_ACT_AC_BTIL-ACT_LOCATION table field - Location ▼

Description: Location
Field Name: ACT_LOCATION
Data Element: CRMT_ACTIVITY_LCTN
Data Type: CHAR
length (Dec): 100(0)
Check table:
Conversion Routine:
Domain Name: CRM_ACTIVITY_LOCATION
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACT_LOCATION

CRMST_QUERY_ACT_AC_BTIL-CALENDAR table field - Include Activity in Calendar ▼

Description: Include Activity in Calendar
Field Name: CALENDAR
Data Element: CRMT_CALENDAR
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRM_BOOLEAN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CALENDAR

CRMST_QUERY_ACT_AC_BTIL-TASK table field - Indicator: Activity is a Task ▼

Description: Indicator: Activity is a Task
Field Name: TASK
Data Element: CRMT_TASK
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRM_BOOLEAN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TASK

CRMST_QUERY_ACT_AC_BTIL-ORDERACT_FROM table field - Actual Start ▼

Description: Actual Start
Field Name: ORDERACT_FROM
Data Element: CRMS4_ACT_ORDERACT_FROM_DATS
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORDERACT_FROM

CRMST_QUERY_ACT_AC_BTIL-ORDERACT_TO table field - Actual End ▼

Description: Actual End
Field Name: ORDERACT_TO
Data Element: CRMS4_ACT_ORDERACT_TO_DATS
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORDERACT_TO

CRMST_QUERY_ACT_AC_BTIL-ORDERPLAN_FROM table field - Planned Start ▼

Description: Planned Start
Field Name: ORDERPLAN_FROM
Data Element: CRMS4_ACT_ORDERPLAN_FROM_DATS
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORDERPLAN_FROM

CRMST_QUERY_ACT_AC_BTIL-ORDERPLAN_TO table field - Planned End ▼

Description: Planned End
Field Name: ORDERPLAN_TO
Data Element: CRMS4_ACT_ORDERPLAN_TO_DATS
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORDERPLAN_TO

CRMST_QUERY_ACT_AC_BTIL-ACT_TOTAL_FROM table field - Actual Total Value of Duration ▼

Description: Actual Total Value of Duration
Field Name: ACT_TOTAL_FROM
Data Element: CRMS4_ACT_ACTUAL_TOTAL_DATS
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACT_TOTAL_FROM

CRMST_QUERY_ACT_AC_BTIL-ACT_TOTAL_UNIT table field - Actual Duration Unit of Measure ▼

Description: Actual Duration Unit of Measure
Field Name: ACT_TOTAL_UNIT
Data Element: CRMS4_ACT_DURATION_UNIT
Data Type: UNIT
length (Dec): 3(0)
Check table:
Conversion Routine: CUNIT
Domain Name: MEINS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: CUNIT

See all SAP tables containing field ACT_TOTAL_UNIT

CRMST_QUERY_ACT_AC_BTIL-HEADER_GUID table field - GUID of a CRM Order Object ▼

Description: GUID of a CRM Order Object
Field Name: HEADER_GUID
Data Element: CRMT_OBJECT_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HEADER_GUID

CRMST_QUERY_ACT_AC_BTIL-DESCR_LANGUAGE table field - Language Key of Description ▼

Description: Language Key of Description
Field Name: DESCR_LANGUAGE
Data Element: CRMT_PROCESS_DESCRIPTION_LANGU
Data Type: LANG
length (Dec): 1(0)
Check table:
Conversion Routine: ISOLA
Domain Name: SPRAS
MemoryID:
AppClass: STXD
SHLP:
SHLP Field:
ConvExit: ISOLA

See all SAP tables containing field DESCR_LANGUAGE

CRMST_QUERY_ACT_AC_BTIL-TEMPLATE_TYPE table field - Template Type of CRM Transaction ▼

Description: Template Type of CRM Transaction
Field Name: TEMPLATE_TYPE
Data Element: CRMT_TEMPLATE_TYPE_DB
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRM_TEMPLATE_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEMPLATE_TYPE

CRMST_QUERY_ACT_AC_BTIL-CREATED_AT_H table field - Start Date ▼

Description: Start Date
Field Name: CREATED_AT_H
Data Element: CRMT_DATES_START_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED_AT_H

CRMST_QUERY_ACT_AC_BTIL-CREATED_BY_H table field - User that Created the Transaction ▼

Description: User that Created the Transaction
Field Name: CREATED_BY_H
Data Element: CRMT_CREATED_BY
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: UNAME
MemoryID:
AppClass: TEST
SHLP: USER_ADDR
SHLP Field: BNAME
ConvExit:

See all SAP tables containing field CREATED_BY_H

CRMST_QUERY_ACT_AC_BTIL-CHANGED_AT_H table field - End Date ▼

Description: End Date
Field Name: CHANGED_AT_H
Data Element: CRMT_DATES_END_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGED_AT_H

CRMST_QUERY_ACT_AC_BTIL-CHANGED_BY_H table field - Transaction Last Changed By ▼

Description: Transaction Last Changed By
Field Name: CHANGED_BY_H
Data Element: CRMT_CHANGED_BY
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: UNAME
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGED_BY_H

CRMST_QUERY_ACT_AC_BTIL-BTX_CLASS table field - CRM Business Transaction Classification ▼

Description: CRM Business Transaction Classification
Field Name: BTX_CLASS
Data Element: CRMT_TRANSACTION_CLASSIFICATN
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRM_TRANSACTION_CLASSIFICATION
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BTX_CLASS

CRMST_QUERY_ACT_AC_BTIL-AUTH_SCOPE table field - Authorization Scope ▼

Description: Authorization Scope
Field Name: AUTH_SCOPE
Data Element: CRM_AUTH_SCOPE
Data Type: NUMC
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: CRM_AUTH_SCOPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTH_SCOPE

CRMST_QUERY_ACT_AC_BTIL-SALES_OFFICE table field - Sales Office ▼

Description: Sales Office
Field Name: SALES_OFFICE
Data Element: CRMT_SALES_OFFICE
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: HROBJEC_14
MemoryID:
AppClass:
SHLP: CRM_ORGMAN_SALES_OFFICE
SHLP Field: SALES_OFFICE
ConvExit:

See all SAP tables containing field SALES_OFFICE

CRMST_QUERY_ACT_AC_BTIL-SALES_GROUP table field - Sales Group ▼

Description: Sales Group
Field Name: SALES_GROUP
Data Element: CRMT_SALES_GROUP
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: HROBJEC_14
MemoryID:
AppClass:
SHLP: CRM_ORGMAN_SALES_GROUP
SHLP Field: SALES_GROUP
ConvExit:

See all SAP tables containing field SALES_GROUP

CRMST_QUERY_ACT_AC_BTIL-SALES_ORG_RESP table field - Organizational Unit (Sales) ▼

Description: Organizational Unit (Sales)
Field Name: SALES_ORG_RESP
Data Element: CRMT_SALES_ORG_RESP
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: HROBJEC_14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SALES_ORG_RESP

CRMST_QUERY_ACT_AC_BTIL-SERVICE_ORG_RESP table field - Organizational Unit (Service) ▼

Description: Organizational Unit (Service)
Field Name: SERVICE_ORG_RESP
Data Element: CRMT_SERVICE_ORG_RESP
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: HROBJEC_14
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SERVICE_ORG_RESP

CRMST_QUERY_ACT_AC_BTIL-STAT_CANCELLED table field - Cancellation Status ▼

Description: Cancellation Status
Field Name: STAT_CANCELLED
Data Element: CRMS4_STAT_CANCELLED
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRMS4_STAT_CANCELLED
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STAT_CANCELLED

CRMST_QUERY_ACT_AC_BTIL-STAT_RELEASED table field - Release Status ▼

Description: Release Status
Field Name: STAT_RELEASED
Data Element: CRMS4_STAT_RELEASED
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRMS4_STAT_RELEASED
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STAT_RELEASED

CRMST_QUERY_ACT_AC_BTIL-STAT_ERROR table field - Error Status ▼

Description: Error Status
Field Name: STAT_ERROR
Data Element: CRMS4_STAT_ERROR
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRMS4_STAT_ERROR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STAT_ERROR

View list of all SAP tables(S4H/ECC)

Select data from SAP table