SAP CRMST_QUERY_PRVMA_BTIL table - Master Agreement – Search Criteria (BTIL) details in SAP


SAP CRMST_QUERY_PRVMA_BTIL table summary

Object Name: CRMST_QUERY_PRVMA_BTIL
Dictionary Type: Structure
Description: Master Agreement – Search Criteria (BTIL)


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

Details
CRMST_QUERY_PRVMA_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_PRVMA_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_PRVMA_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_PRVMA_BTIL-CATEGORY_ID table field - Product Category

Description: Product Category
Field Name: CATEGORY_ID
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 CATEGORY_ID

CRMST_QUERY_PRVMA_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_PRVMA_BTIL-SHIP_TO_PARTY table field - Ship-to Party ID

Description: Ship-to Party ID
Field Name: SHIP_TO_PARTY
Data Element: CRMT_SHIP_TO_PARTY_ID
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID:
AppClass:
SHLP: BUPA
SHLP Field: PARTNER
ConvExit: ALPHA

See all SAP tables containing field SHIP_TO_PARTY

CRMST_QUERY_PRVMA_BTIL-EMPLOYEE_RESP table field - Employee Responsible

Description: Employee Responsible
Field Name: EMPLOYEE_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 EMPLOYEE_RESP

CRMST_QUERY_PRVMA_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_PRVMA_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_PRVMA_BTIL-DESCRIPTION_UC table field - Transaction Description (Uppercase)

Description: Transaction Description (Uppercase)
Field Name: DESCRIPTION_UC
Data Element: CRMT_PROCESS_DESCRIPTION_UC
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CRM_PROCESS_DESCRIPTION_UC
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DESCRIPTION_UC

CRMST_QUERY_PRVMA_BTIL-PO_NUMBER_UC table field - Sold-to Party's External Reference No. (in Capital Letters)

Description: Sold-to Party's External Reference No. (in Capital Letters)
Field Name: PO_NUMBER_UC
Data Element: CRMT_PO_NUMBER_UC
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: CHAR35
MemoryID:
AppClass: MW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_NUMBER_UC

CRMST_QUERY_PRVMA_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_PRVMA_BTIL-SOLD_TO_PARTY table field - Sold-To Party ID

Description: Sold-To Party ID
Field Name: SOLD_TO_PARTY
Data Element: CRMT_SOLD_TO_PARTY_ID
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID:
AppClass:
SHLP: BUPA
SHLP Field: PARTNER
ConvExit: ALPHA

See all SAP tables containing field SOLD_TO_PARTY

CRMST_QUERY_PRVMA_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_PRVMA_BTIL-VALID_FROM table field - 'Valid From' Date

Description: 'Valid From' Date
Field Name: VALID_FROM
Data Element: CRMT_BSP_VALID_FROM
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 VALID_FROM

CRMST_QUERY_PRVMA_BTIL-VALID_TO table field - 'Valid To' Date

Description: 'Valid To' Date
Field Name: VALID_TO
Data Element: CRMT_BSP_VALID_TO
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 VALID_TO

CRMST_QUERY_PRVMA_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_PRVMA_BTIL-SOLD_TO_PARTY_NAME table field - Sold-To Party Name

Description: Sold-To Party Name
Field Name: SOLD_TO_PARTY_NAME
Data Element: CRMT_UIU_SOLD_TO_PARTY_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 SOLD_TO_PARTY_NAME

CRMST_QUERY_PRVMA_BTIL-SHIP_TO_PARTY_NAME table field - Ship-To Party Name

Description: Ship-To Party Name
Field Name: SHIP_TO_PARTY_NAME
Data Element: CRMT_UIU_SHIP_TO_PARTY_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 SHIP_TO_PARTY_NAME

CRMST_QUERY_PRVMA_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_PRVMA_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_PRVMA_BTIL-CHANNEL_PARTNER table field - Sales Partner ID

Description: Sales Partner ID
Field Name: CHANNEL_PARTNER
Data Element: CRMT_UIU_SALES_PARTNER
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 CHANNEL_PARTNER

CRMST_QUERY_PRVMA_BTIL-CHANNEL_PARTNER_NAME table field - Sales Partner Name

Description: Sales Partner Name
Field Name: CHANNEL_PARTNER_NAME
Data Element: CRMT_UIU_SALES_PARTNER_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 CHANNEL_PARTNER_NAME

CRMST_QUERY_PRVMA_BTIL-RESP_CHAN_PARTNER_FIRSTNAME table field - Employee Resp. at Channel Partner First Name

Description: Employee Resp. at Channel Partner First Name
Field Name: RESP_CHAN_PARTNER_FIRSTNAME
Data Element: CRMT_UIU_RESP_AT_CHAN_PART_FN
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 RESP_CHAN_PARTNER_FIRSTNAME

CRMST_QUERY_PRVMA_BTIL-RESP_CHAN_PARTNER_LASTNAME table field - Employee Resp. at Channel Partner Last Name

Description: Employee Resp. at Channel Partner Last Name
Field Name: RESP_CHAN_PARTNER_LASTNAME
Data Element: CRMT_UIU_RESP_AT_CHAN_PART_LN
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 RESP_CHAN_PARTNER_LASTNAME

CRMST_QUERY_PRVMA_BTIL-RESP_CHAN_PARTNER table field - Responsible at Channel Partner

Description: Responsible at Channel Partner
Field Name: RESP_CHAN_PARTNER
Data Element: CRMT_RESP_AT_CHANNEL_PARTNER
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 RESP_CHAN_PARTNER

CRMST_QUERY_PRVMA_BTIL-BILL_TO_PARTY_NAME table field - Bill-To Party Name

Description: Bill-To Party Name
Field Name: BILL_TO_PARTY_NAME
Data Element: CRMT_UIU_BILL_TO_PARTY_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 BILL_TO_PARTY_NAME

CRMST_QUERY_PRVMA_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_PRVMA_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_PRVMA_BTIL-PAYER table field - Payer ID

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

See all SAP tables containing field PAYER

CRMST_QUERY_PRVMA_BTIL-PAYER_NAME table field - Payer Name

Description: Payer Name
Field Name: PAYER_NAME
Data Element: CRMT_UIU_PAYER_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 PAYER_NAME

CRMST_QUERY_PRVMA_BTIL-BU_PARTNER_NAME table field - Partner Name

Description: Partner Name
Field Name: BU_PARTNER_NAME
Data Element: CRMT_UIU_PARTNER_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 BU_PARTNER_NAME

CRMST_QUERY_PRVMA_BTIL-BILL_TO_PARTY table field - Bill-To Party

Description: Bill-To Party
Field Name: BILL_TO_PARTY
Data Element: CRMT_UIU_BILL_TO_PARTY
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 BILL_TO_PARTY

CRMST_QUERY_PRVMA_BTIL-PRODUCT_ID_MA table field - Custom Specific ID for Product or Product Range

Description: Custom Specific ID for Product or Product Range
Field Name: PRODUCT_ID_MA
Data Element: CRMT_ISX_PRVMA_PROD_ID
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CRMT_ISX_PRVMA_PROD_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRODUCT_ID_MA

CRMST_QUERY_PRVMA_BTIL-STAT_LIFECYCLE table field - Life Cycle Status

Description: Life Cycle Status
Field Name: STAT_LIFECYCLE
Data Element: CRMS4_STAT_LIFECYCLE
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: CRMS4_STAT_LIFECYCLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STAT_LIFECYCLE

CRMST_QUERY_PRVMA_BTIL-STAT_RELEASED table field - Release Status

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

See all SAP tables containing field STAT_RELEASED

CRMST_QUERY_PRVMA_BTIL-STAT_CANCELLED table field - Cancellation Status

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

See all SAP tables containing field STAT_CANCELLED

CRMST_QUERY_PRVMA_BTIL-STAT_OPEN table field - Status 'Open'

Description: Status 'Open'
Field Name: STAT_OPEN
Data Element: CRMS4_STAT_OPEN_UI
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRMS4_STAT_OPEN_UI
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STAT_OPEN

CRMST_QUERY_PRVMA_BTIL-MAGR_H_DUMMY_PS table field - Single-Character Flag

Description: Single-Character Flag
Field Name: MAGR_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 MAGR_H_DUMMY_PS

CRMST_QUERY_PRVMA_BTIL-MAGR_I_DUMMY_PS table field - Single-Character Flag

Description: Single-Character Flag
Field Name: MAGR_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 MAGR_I_DUMMY_PS

CRMST_QUERY_PRVMA_BTIL-CUSTHIER_NODE table field - Customer Hierarchy Node

Description: Customer Hierarchy Node
Field Name: CUSTHIER_NODE
Data Element: CRMS4_CUSTHIER_NODE
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CRMS4_CUSTHIER_NODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CUSTHIER_NODE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table