SAP CRMS_QUERY_SOMMR_B table - Mass Run - Element B Filter Query details in SAP


SAP CRMS_QUERY_SOMMR_B table summary

Object Name: CRMS_QUERY_SOMMR_B
Dictionary Type: Structure
Description: Mass Run - Element B Filter Query


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

Details
CRMS_QUERY_SOMMR_B-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

CRMS_QUERY_SOMMR_B-PO_NUMBER_UC table field - Sold-To Party's External Reference Number

Description: Sold-To Party's External Reference Number
Field Name: PO_NUMBER_UC
Data Element: CRMT_PO_NUMBER_SOLD
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: TEXT35
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_NUMBER_UC

CRMS_QUERY_SOMMR_B-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

CRMS_QUERY_SOMMR_B-BU_PARTNER table field - Partner Number for Usage Within BSP

Description: Partner Number for Usage Within BSP
Field Name: BU_PARTNER
Data Element: CRMT_BSP_PARTNER_NUMBER
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 BU_PARTNER

CRMS_QUERY_SOMMR_B-SOLD_TO_PARTY table field - Sold-To Party

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

CRMS_QUERY_SOMMR_B-PRODUCT_ID table field - Product Name Entered

Description: Product Name Entered
Field Name: PRODUCT_ID
Data Element: CRMT_ORDERED_PROD
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

CRMS_QUERY_SOMMR_B-POSTING_DATE table field - Posting Date Free Selection

Description: Posting Date Free Selection
Field Name: POSTING_DATE
Data Element: CRMT_UIU_POSTING_DATE_RANGE
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

CRMS_QUERY_SOMMR_B-POSTING_DATE_PERIOD table field - Posting Date Period

Description: Posting Date Period
Field Name: POSTING_DATE_PERIOD
Data Element: CRMT_UIU_POSTING_DATE_PERIOD
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: CRMT_DATE_RANGE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTING_DATE_PERIOD

CRMS_QUERY_SOMMR_B-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

CRMS_QUERY_SOMMR_B-PARTNER_COMB table field - Partner In Partner Function

Description: Partner In Partner Function
Field Name: PARTNER_COMB
Data Element: CRMT_UIU_PARTNER_TO_PARTNERFCT
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 PARTNER_COMB

CRMS_QUERY_SOMMR_B-A3EXTREF table field - IS-T Contract Number

Description: IS-T Contract Number
Field Name: A3EXTREF
Data Element: IST_EXT_REF
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine: ALPHA
Domain Name: IST_EXT_REF
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field A3EXTREF

CRMS_QUERY_SOMMR_B-A3SELTYPE table field - Product Selection Type

Description: Product Selection Type
Field Name: A3SELTYPE
Data Element: IST_SELECTION_TYPE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: IST_SELECTION_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field A3SELTYPE

CRMS_QUERY_SOMMR_B-TR_OBJ_ID table field - Technical Resource ID

Description: Technical Resource ID
Field Name: TR_OBJ_ID
Data Element: CRMT_TECH_RES_ID
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: CRM_TC_TECH_RES_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TR_OBJ_ID

CRMS_QUERY_SOMMR_B-STAT_ACTIVATION table field - Activation Status of Subscription Order/Contract

Description: Activation Status of Subscription Order/Contract
Field Name: STAT_ACTIVATION
Data Element: CRMS4_STAT_ACTIVATION
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRMS4_STAT_ACTIVATION
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STAT_ACTIVATION

CRMS_QUERY_SOMMR_B-VALID_FROM table field - Start Date

Description: Start Date
Field Name: VALID_FROM
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 VALID_FROM

CRMS_QUERY_SOMMR_B-VALID_TO table field - End Date

Description: End Date
Field Name: VALID_TO
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 VALID_TO

CRMS_QUERY_SOMMR_B-MA_ID table field - Transaction ID

Description: Transaction ID
Field Name: MA_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 MA_ID

CRMS_QUERY_SOMMR_B-MA_PROD_ID table field - Custom Specific ID for Product or Product Range

Description: Custom Specific ID for Product or Product Range
Field Name: MA_PROD_ID
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 MA_PROD_ID

CRMS_QUERY_SOMMR_B-MA_ITEM_REF table field - GUID of a CRM Order Object

Description: GUID of a CRM Order Object
Field Name: MA_ITEM_REF
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 MA_ITEM_REF

CRMS_QUERY_SOMMR_B-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

CRMS_QUERY_SOMMR_B-POOL_AGR_REF table field - Reference to Sharing Contract

Description: Reference to Sharing Contract
Field Name: POOL_AGR_REF
Data Element: CRM_POOL_AGREEMENT
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine: ALPHA
Domain Name: IST_EXT_REF
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field POOL_AGR_REF

CRMS_QUERY_SOMMR_B-DOCUMENT_PURPOSE table field - Document Purpose

Description: Document Purpose
Field Name: DOCUMENT_PURPOSE
Data Element: CRMT_ISX_DOCUMENT_PURPOSE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRMT_ISX_DOCUMENT_PURPOSE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DOCUMENT_PURPOSE

CRMS_QUERY_SOMMR_B-MR_STATUS table field - Mass Run Element Status

Description: Mass Run Element Status
Field Name: MR_STATUS
Data Element: CRM_ISX_MR_E_STATUS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRM_ISX_MR_E_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MR_STATUS

CRMS_QUERY_SOMMR_B-MR_VERIFICATION table field - Verification Status for Manual Checks of Mass Run Element

Description: Verification Status for Manual Checks of Mass Run Element
Field Name: MR_VERIFICATION
Data Element: CRM_ISX_MR_E_CHECK_STATUS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CRM_ISX_MR_E_CHECK_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MR_VERIFICATION

CRMS_QUERY_SOMMR_B-MR_HEADER_GUID table field - SOM Mass Run GUID

Description: SOM Mass Run GUID
Field Name: MR_HEADER_GUID
Data Element: CRMS4_SOM_MR_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 MR_HEADER_GUID


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table