SAP CRMST_QUERY_OPP_BTIL table - Business Trns. IL Structure for Opportunity: Search Criteria details in SAP

SAP CRMST_QUERY_OPP_BTIL table summary

Object Name: CRMST_QUERY_OPP_BTIL
Dictionary Type: Structure
Description: Business Trns. IL Structure for Opportunity: Search Criteria

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

Details

CRMST_QUERY_OPP_BTIL-OBJECT_ID table field - Transaction ID ▼

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

See all SAP tables containing field OBJECT_ID

CRMST_QUERY_OPP_BTIL-DESCRIPTION table field - Transaction Description ▼

Description: Transaction Description
Field Name: DESCRIPTION
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

CRMST_QUERY_OPP_BTIL-CREATED_BY table field - User that Created the Transaction ▼

Description: User that Created the Transaction
Field Name: CREATED_BY
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

CRMST_QUERY_OPP_BTIL-CURR_PHASE table field - Sales Stage ▼

Description: Sales Stage
Field Name: CURR_PHASE
Data Element: CRMT_CURR_PHASE
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CRM_PHASE
MemoryID:
AppClass:
SHLP: CRM_PHASE
SHLP Field: PHASE
ConvExit:

See all SAP tables containing field CURR_PHASE

CRMST_QUERY_OPP_BTIL-SALES_TEAM_MEMBER table field - Sales Team Member ▼

Description: Sales Team Member
Field Name: SALES_TEAM_MEMBER
Data Element: CRMT_BP_SLS_TEAM_MEMBER
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine: ALPHA
Domain Name: CRM_PARTNER_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field SALES_TEAM_MEMBER

CRMST_QUERY_OPP_BTIL-PRODUCT_ID table field - Product ID ▼

Description: Product ID
Field Name: PRODUCT_ID
Data Element: CRMT_PRODUCT_ID
Data Type: CHAR
length (Dec): 54(0)
Check table:
Conversion Routine:
Domain Name: CRM_ORDERED_PROD
MemoryID:
AppClass:
SHLP: CRM_ORDERED_PRODUCT
SHLP Field: PRODUCT_ID
ConvExit:

See all SAP tables containing field PRODUCT_ID

CRMST_QUERY_OPP_BTIL-OPP_TYPE table field - Opportunity Type ▼

Description: Opportunity Type
Field Name: OPP_TYPE
Data Element: CRMT_OPPORT_TYPE
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: CRM_OPPORT_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPP_TYPE

CRMST_QUERY_OPP_BTIL-OPP_SOURCE table field - Origin of Opportunity/Lead ▼

Description: Origin of Opportunity/Lead
Field Name: OPP_SOURCE
Data Element: CRMT_SOURCE
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CRM_SOURCE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPP_SOURCE

CRMST_QUERY_OPP_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_OPP_BTIL-PROCESS_TYPE table field - Business Transaction Type ▼

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

See all SAP tables containing field PROCESS_TYPE

CRMST_QUERY_OPP_BTIL-COMPETITOR_NAME table field - Description ▼

Description: Description
Field Name: COMPETITOR_NAME
Data Element: CRMT_DESCRIPTION
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMPETITOR_NAME

CRMST_QUERY_OPP_BTIL-PROSPECT_NAME table field - Description ▼

Description: Description
Field Name: PROSPECT_NAME
Data Element: CRMT_DESCRIPTION
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROSPECT_NAME

CRMST_QUERY_OPP_BTIL-SALESTEAM_FIRSTNAME table field - First name of business partner (person) ▼

Description: First name of business partner (person)
Field Name: SALESTEAM_FIRSTNAME
Data Element: BU_NAMEP_F
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: BU_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SALESTEAM_FIRSTNAME

CRMST_QUERY_OPP_BTIL-SALESTEAM_LASTNAME table field - Last name of business partner (person) ▼

Description: Last name of business partner (person)
Field Name: SALESTEAM_LASTNAME
Data Element: BU_NAMEP_L
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: BU_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SALESTEAM_LASTNAME

CRMST_QUERY_OPP_BTIL-RESPONS_AREA table field - Belonging To (Me, My Department, My Group) ▼

Description: Belonging To (Me, My Department, My Group)
Field Name: RESPONS_AREA
Data Element: CRMT_RESPONS_AREA_OIC
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRM_RESPONS_AREA_OIC
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RESPONS_AREA

CRMST_QUERY_OPP_BTIL-LEAD_ID table field - Transaction ID ▼

Description: Transaction ID
Field Name: LEAD_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 LEAD_ID

CRMST_QUERY_OPP_BTIL-LEAD_DES table field - Description ▼

Description: Description
Field Name: LEAD_DES
Data Element: CRMT_DESCRIPTION
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEAD_DES

CRMST_QUERY_OPP_BTIL-EMPLOYEE_RESP_LASTNAME table field - Employee Responsible Last Name ▼

Description: Employee Responsible Last Name
Field Name: EMPLOYEE_RESP_LASTNAME
Data Element: CRMT_UIU_EMPLOYEE_RESP_LASTNA
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CHAR40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMPLOYEE_RESP_LASTNAME

CRMST_QUERY_OPP_BTIL-EMPLOYEE_RESP_FIRSTNAME table field - Employee Responsible First Name ▼

Description: Employee Responsible First Name
Field Name: EMPLOYEE_RESP_FIRSTNAME
Data Element: CRMT_UIU_EMPLOYEE_RESP_FIRSTNA
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CHAR40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMPLOYEE_RESP_FIRSTNAME

CRMST_QUERY_OPP_BTIL-CONTACT_FIRSTNAME table field - Contact First Name ▼

Description: Contact First Name
Field Name: CONTACT_FIRSTNAME
Data Element: CRMT_UIU_CONTACT_FIRSTNAME
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CHAR40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONTACT_FIRSTNAME

CRMST_QUERY_OPP_BTIL-CONTACT_LASTNAME table field - Contact Last Name ▼

Description: Contact Last Name
Field Name: CONTACT_LASTNAME
Data Element: CRMT_UIU_CONTACT_LASTNAME
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CHAR40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONTACT_LASTNAME

CRMST_QUERY_OPP_BTIL-PRODUCT_NAME table field - Product Name ▼

Description: Product Name
Field Name: PRODUCT_NAME
Data Element: CRMT_UIU_PRODUCT_NAME
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CHAR40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRODUCT_NAME

CRMST_QUERY_OPP_BTIL-PARTNER_FCT table field - Partner func. ▼

Description: Partner func.
Field Name: PARTNER_FCT
Data Element: CRMT_PARTNER_FCT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: COM_PARTNER_FCT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTNER_FCT

CRMST_QUERY_OPP_BTIL-BU_PARTNER table field - Business Partner Number ▼

Description: Business Partner Number
Field Name: BU_PARTNER
Data Element: BU_PARTNER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID: BPA
AppClass:
SHLP: BUPA
SHLP Field: PARTNER
ConvExit: ALPHA

See all SAP tables containing field BU_PARTNER

CRMST_QUERY_OPP_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_OPP_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_OPP_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_OPP_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_OPP_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_OPP_BTIL-PROD_HIERARCHY table field - Product Category ▼

Description: Product Category
Field Name: PROD_HIERARCHY
Data Element: CRMT_PROD_HIERARCHY
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: COM_CATEGORY_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROD_HIERARCHY

CRMST_QUERY_OPP_BTIL-STARTDATE table field - Opportunity Start Date ▼

Description: Opportunity Start Date
Field Name: STARTDATE
Data Element: CRMT_STARTDATE
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 STARTDATE

CRMST_QUERY_OPP_BTIL-EXPECT_END table field - Expected Closing Date ▼

Description: Expected Closing Date
Field Name: EXPECT_END
Data Element: CRMT_EXPECT_END
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 EXPECT_END

CRMST_QUERY_OPP_BTIL-SALES_REP table field - Sales Rep ▼

Description: Sales Rep
Field Name: SALES_REP
Data Element: CRMS4_SALES_REP
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field SALES_REP

CRMST_QUERY_OPP_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:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field PERSON_RESP

CRMST_QUERY_OPP_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:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field CONTACT_PERSON

CRMST_QUERY_OPP_BTIL-SALES_PROSPECT table field - Sales Prospect ▼

Description: Sales Prospect
Field Name: SALES_PROSPECT
Data Element: CRMS4_SALES_PROSPECT
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field SALES_PROSPECT

CRMST_QUERY_OPP_BTIL-PAYER table field - Payer ▼

Description: Payer
Field Name: PAYER
Data Element: CRMT_RP_PAYER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field PAYER

CRMST_QUERY_OPP_BTIL-COMPETITOR table field - Competitor ▼

Description: Competitor
Field Name: COMPETITOR
Data Element: CRMS4_COMPETITOR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field COMPETITOR

CRMST_QUERY_OPP_BTIL-STAT_LIFECYCLE_OPPT table field - Opportunity Lifecycle Status ▼

Description: Opportunity Lifecycle Status
Field Name: STAT_LIFECYCLE_OPPT
Data Element: CRMS4_STAT_LIFECYCLE_OPPT
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: CRMS4_STAT_LIFECYCLE_OPPT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STAT_LIFECYCLE_OPPT

CRMST_QUERY_OPP_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

CRMST_QUERY_OPP_BTIL-OPPT_H_DUMMY_PS table field - Single-Character Flag ▼

Description: Single-Character Flag
Field Name: OPPT_H_DUMMY_PS
Data Element: CHAR1
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPPT_H_DUMMY_PS

CRMST_QUERY_OPP_BTIL-OPPT_I_DUMMY_PS table field - Single-Character Flag ▼

Description: Single-Character Flag
Field Name: OPPT_I_DUMMY_PS
Data Element: CHAR1
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPPT_I_DUMMY_PS

View list of all SAP tables(S4H/ECC)

Select data from SAP table