SAP /1CRMES/CRM_OBJECT_Q Table in S/4 HANA - /1CRMES/CRM_OBJECT_Q
/1CRMES/CRM_OBJECT_Q is a standard SAP Table which is used to store /1CRMES/CRM_OBJECT_Q data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP /1CRMES/CRM_OBJECT_Q table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Structure
Database Table: /1CRMES/CRM_OBJECT_Q
/1CRMES/CRM_OBJECT_Q table structure field list
Below is the full /1CRMES/CRM_OBJECT_Q field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
ALL_ATTRIBUTES_SEARCH_STRING | String for Node Name | CRM_ES_STRING | STRG | 0(0) | ||||||
ADDR_SHORT | One-line short form of formatted address | AD_LINE_S | CHAR | 80(0) | CHAR80 | |||||
ADDR_SHORT1 | One-line short form of formatted address | AD_LINE_S | CHAR | 80(0) | CHAR80 | |||||
ADDR_SHORT2 | One-line short form of formatted address | AD_LINE_S | CHAR | 80(0) | CHAR80 | |||||
ADDR_SHORT3 | One-line short form of formatted address | AD_LINE_S | CHAR | 80(0) | CHAR80 | |||||
ALTID_TYPE | ID Type for Alternative IDs | COMT_ALTID_TYPE | CHAR | 16(0) | CHAR16 | COM_ALTID | COM_PROD_ALTID | ID_TYPE | ||
ALTID_TYPE_ID_TYPE_TEXT | Description of Alternative ID Type | COMT_ALTID_TYPE_TEXT | CHAR | 40(0) | COMT_TXT40 | |||||
ALTID_VALUE | Concatenated Value of Alternative ID Fields | COMT_ALTID_FIELDSTRING | CHAR | 255(0) | CHAR255 | |||||
BP_NUMBER | Business Partner Number | BU_PARTNER | CHAR | 10(0) | ALPHA | BU_PARTNER | BPA | BUPA | PARTNER | |
BUILDING_P | Building (number or code) | AD_BLDNG_P | CHAR | 10(0) | TEXT10 | |||||
BUILDING_P1 | Building (number or code) | AD_BLDNG_P | CHAR | 10(0) | TEXT10 | |||||
BUILEMP_BP_NUMBER | Business Partner Number | BU_PARTNER | CHAR | 10(0) | ALPHA | BU_PARTNER | BPA | BUPA | PARTNER | |
BUILEMP_FIRSTNAME | First name of business partner (person) | BU_NAMEP_F | CHAR | 40(0) | BU_NAME | |||||
BUILHEADER_ACCOUNT_NAME | Short name of business partner | BU_DESCRIP | CHAR | 50(0) | BU_TEXT50 | |||||
BUILHEADER_BP_CATEGORY | Business Partner Category | BU_TYPE | CHAR | 1(0) | BU_TYPE | BPY | ||||
BUILHEADER_BP_NUMBER | Business Partner Number | BU_PARTNER | CHAR | 10(0) | ALPHA | BU_PARTNER | BPA | BUPA | PARTNER | |
BUILHEADER_CITY | City | AD_CITY1 | CHAR | 40(0) | TEXT40 | CLCITYNAME | CITY_NAME | |||
BUILHEADER_COUNTRY | Country Key | LAND1 | CHAR | 3(0) | LAND1 | LND | ||||
BUILHEADER_CP_PROGRAM | Channel Management - Channel Partner Programm | CHM_PARTNER_PROGRAM | CHAR | 4(0) | CHM_PARTNER_PROGRAM | |||||
BUILHEADER_CP_STATUS | Channel Management - Channel Partner Status | CHM_PARTNER_STATUS | CHAR | 4(0) | CHM_PARTNER_STATUS | |||||
BUILHEADER_CP_TYPE | Channel Management - Channel Partner Type | CHM_PARTNER_TYPE | CHAR | 4(0) | CHM_PARTNER_TYPE | |||||
BUILHEADER_CRITERION_DESCRI001 | Responsibility Criterion (Description) | CRMT_CHM_RESP_CRIT_DESCR | CHAR | 30(0) | TEXT30 | |||||
BUILHEADER_EMAIL_SRCH | E-Mail Address Search Field | AD_SMTPAD2 | CHAR | 20(0) | CHAR20 | |||||
BUILHEADER_E_MAIL | E-Mail Address | AD_SMTPADR | CHAR | 241(0) | SXIDN | AD_SMTPADR | ||||
BUILHEADER_E_MAIL001 | E-Mail Address | AD_SMTPADR | CHAR | 241(0) | SXIDN | AD_SMTPADR | ||||
BUILHEADER_FIRSTNAME | First name of business partner (person) | BU_NAMEP_F | CHAR | 40(0) | BU_NAME | |||||
BUILHEADER_FIRST_NAME | ICM BP Alternative Identity - Name (Other name or Last name) | CRM_ICM_BP_AID_NAME | CHAR | 80(0) | TEXT80 | |||||
BUILHEADER_HOUSE_NO | House Number | AD_HSNM1 | CHAR | 10(0) | TEXT10 | |||||
BUILHEADER_IDENTIFICATIONNU001 | Identification Number | BU_ID_NUMBER | CHAR | 60(0) | CHAR60 | |||||
BUILHEADER_IDENTIFICATIONTY001 | Identification Type | BU_ID_TYPE | CHAR | 6(0) | BU_ID_TYPE | |||||
BUILHEADER_LASTNAME | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40(0) | BU_NAME | |||||
BUILHEADER_NAME001 | ICM BP Alternative Identity - Name (Other name or Last name) | CRM_ICM_BP_AID_NAME | CHAR | 80(0) | TEXT80 | |||||
BUILHEADER_NAME1 | Name 1 of organization | BU_NAMEOR1 | CHAR | 40(0) | BU_NAME | |||||
BUILHEADER_NAME2 | Name 2 of organization | BU_NAMEOR2 | CHAR | 40(0) | BU_NAME | |||||
BUILHEADER_PARTNERROLE | BP Role | BU_PARTNERROLE | CHAR | 6(0) | BU_ROLE | BUPA_ROLE | RLTYP | |||
BUILHEADER_PARTNERROLECATEG001 | BP Role Category | BU_PARTNERROLECAT | CHAR | 6(0) | BU_ROLECAT | |||||
BUILHEADER_POSTL_COD1 | City postal code | AD_PSTCD1 | CHAR | 10(0) | CHAR10 | |||||
BUILHEADER_RATING_TEXT | Scale Proficiency Text | PROFC_TEXT | CHAR | 40(0) | TEXT40 | |||||
BUILHEADER_REGION | Region (State, Province, County) | REGIO | CHAR | 3(0) | REGIO | |||||
BUILHEADER_SEARCHTERM1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20(0) | BU_SORT1 | |||||
BUILHEADER_STEXT | Object Name | STEXT | CHAR | 40(0) | TEXT40 | |||||
BUILHEADER_STREET | Street | AD_STREET | CHAR | 60(0) | TEXT60 | CLSTRTNAME | STREET | |||
BUILHEADER_TDLINE | Concatenated Text Lines | CRMDT_CONC_TEXTLINES | STRG | 0(0) | ||||||
BUILHEADER_TEL_NO | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30(0) | CHAR30 | |||||
BUILHEADER_TEL_NO001 | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30(0) | CHAR30 | |||||
BUILHEADER_TEL_NO002 | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30(0) | CHAR30 | |||||
BUILHEADER_URI | URI, e.g. Homepage or ftp Address | AD_URISCR | CHAR | 132(0) | AD_URISCR | |||||
BUILHEADER_URI001 | URI, e.g. Homepage or ftp Address | AD_URISCR | CHAR | 132(0) | AD_URISCR | |||||
BUILHEADER_VALUE_DESCRIPTIO001 | Responsibility Criterion Value Description | CRMT_CHM_RESP_CRITVALUE_DESCR | CHAR | 90(0) | TEXT90 | |||||
CATEGORY_GUID | Category GUID | COMT_CATEGORY_GUID | RAW | 16(0) | SYSUUID | |||||
CATEGORY_GUID001 | Category GUID | COMT_CATEGORY_GUID | RAW | 16(0) | SYSUUID | |||||
CATEGORY_ID001 | Category ID | COMT_CATEGORY_ID | CHAR | 20(0) | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | CATEGORY_ID | ||
CITY | City | AD_CITY1 | CHAR | 40(0) | TEXT40 | CLCITYNAME | CITY_NAME | |||
CONC_LINES | Concatenated Text Lines | CRMDT_CONC_TEXTLINES | STRG | 0(0) | ||||||
CONP_NUMBER | Business Partner Number | BU_PARTNER | CHAR | 10(0) | ALPHA | BU_PARTNER | BPA | BUPA | PARTNER | |
COUNTRY | Country Key | LAND1 | CHAR | 3(0) | LAND1 | LND | ||||
COUNTRY_LANDX50 | Country Name (Max. 50 Characters) | LANDX50 | CHAR | 50(0) | TEXT50 | |||||
CRMC_ICM_NTYP_T_TYPE_TXT | Alternative Identification Description | CRM_ICM_LOC_OTHNTYPE_T | CHAR | 80(0) | TEXT80 | |||||
DEPARTMENT | Department | BU_ABTNR | CHAR | 4(0) | BU_ABTNR | |||||
DEPARTMENT1 | Department | AD_DPRTMNT | CHAR | 40(0) | TEXT40 | |||||
DEPARTMENT2 | Department | AD_DPRTMNT | CHAR | 40(0) | TEXT40 | |||||
DNSSUFFIX | DNS Suffix | CRMT_IT_DNS_SUFFIX_UI | CHAR | 40(0) | CRMT_IT_DNS_SUFFIX_UI | |||||
DOM | Domain | CRMT_IT_DOMAIN_UI | CHAR | 15(0) | CRMT_IT_DOMAIN_UI | |||||
E_MAILSMT | E-Mail Address | AD_SMTPADR | CHAR | 241(0) | SXIDN | AD_SMTPADR | ||||
E_MAILSMT1 | E-Mail Address | AD_SMTPADR | CHAR | 241(0) | SXIDN | AD_SMTPADR | ||||
E_MAILSMT2 | E-Mail Address | AD_SMTPADR | CHAR | 241(0) | SXIDN | AD_SMTPADR | ||||
E_MAILSMT3 | E-Mail Address | AD_SMTPADR | CHAR | 241(0) | SXIDN | AD_SMTPADR | ||||
FAX_NOFAX | Complete number: dialling code+number+extension | AD_FXNRLNG | CHAR | 30(0) | CHAR30 | |||||
FAX_NOFAX1 | Complete number: dialling code+number+extension | AD_FXNRLNG | CHAR | 30(0) | CHAR30 | |||||
FUNCTION | Function of partner | BU_PAFKT | CHAR | 4(0) | BU_PAFKT | |||||
FUNCTION1 | Function | AD_FNCTN | CHAR | 40(0) | TEXT40 | |||||
FUNCTION2 | Function | AD_FNCTN | CHAR | 40(0) | TEXT40 | |||||
GATEWAY | Gateway | CRMT_IT_GATEWAY_UI | CHAR | 15(0) | ITIPA | CRMT_IT_GATEWAY_UI | ||||
HOSTNAME | Host Name | CRMT_IT_HOSTNAME_UI | CHAR | 15(0) | CRMT_IT_HOSTNAME_UI | |||||
HOUSE_NO | House Number | AD_HSNM1 | CHAR | 10(0) | TEXT10 | |||||
IMPACT | Impact | CRMT_IT_IMPACT_UI | NUMC | 2(0) | CRM_SRQM_IMPACT | |||||
INHOUSE_ML | Internal Mail Postal Code | AD_IH_MAIL | CHAR | 10(0) | TEXT10 | |||||
INHOUSE_ML1 | Internal Mail Postal Code | AD_IH_MAIL | CHAR | 10(0) | TEXT10 | |||||
IPADDR | IP Address | CRMT_IT_IP_ADDRESS_UI | CHAR | 15(0) | ITIPA | CRMT_IT_IP_ADDRESS_UI | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10(0) | ALPHA | KOSTL | KOS | |||
LASTNAME | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40(0) | BU_NAME | |||||
MAC_ADDR | MAC Address | CRMT_IT_MAC_ADDRESS_UI | CHAR | 17(0) | MACAD | CRMT_IT_MAC_ADDRESS_UI | ||||
MANAGER | Full Name | BU_NAME1TX | CHAR | 80(0) | TEXT80 | |||||
NAME001 | Name 1 | AD_NAME1 | CHAR | 40(0) | TEXT40 | |||||
NAME002 | Other Name | PSIC_OTHERNAME_UI | CHAR | 40(0) | PSIC_OTHERNAME_UI | |||||
OBJECT_FAMILY | Object Family | COMT_PRODUCT_OBJECT_FAMILY | CHAR | 4(0) | COM_PRODUCT_OBJECT_FAMILY | COM_OBJFAM_PRTYP | OBJECT_FAMILY | |||
OBJECT_FAMILY_DESCRIPTION | Description of Object Family | COMT_PRODUCT_OBJECT_FAMILY_DES | CHAR | 40(0) | TEXT40 | |||||
OPSYS | Operating System (OS) | CRMT_IT_OS_UI | CHAR | 4(0) | CHAR4 | |||||
OPSYS_V | Operating System Version | CRMT_IT_OS_VERSION_UI | CHAR | 4(0) | CRMT_IT_OS_VERSION_UI | |||||
PARTNER1 | Business Partner Number | BU_PARTNER | CHAR | 10(0) | ALPHA | BU_PARTNER | BPA | BUPA | PARTNER | |
PARTNER11 | Business Partner Number | BU_PARTNER | CHAR | 10(0) | ALPHA | BU_PARTNER | BPA | BUPA | PARTNER | |
PARTNER2 | Business Partner Number | BU_PARTNER | CHAR | 10(0) | ALPHA | BU_PARTNER | BPA | BUPA | PARTNER | |
PARTNER21 | Business Partner Number | BU_PARTNER | CHAR | 10(0) | ALPHA | BU_PARTNER | BPA | BUPA | PARTNER | |
PERNR | Personnel Number | PERNR_D | NUMC | 8(0) | PERNR | PER | ||||
POSTL_COD1 | City postal code | AD_PSTCD1 | CHAR | 10(0) | CHAR10 | |||||
PRODUCT_ALTID_TYPE | ID Type for Alternative IDs | COMT_ALTID_TYPE | CHAR | 16(0) | CHAR16 | COM_ALTID | COM_PROD_ALTID | ID_TYPE | ||
PRODUCT_ALTID_VALUE | Concatenated Value of Alternative ID Fields | COMT_ALTID_FIELDSTRING | CHAR | 255(0) | CHAR255 | |||||
PRODUCT_CATEGORY001 | Warranty Category | CRMT_WTY_CATEGORY_UI | CHAR | 1(0) | CRMT_WTY_CATEGORY_UI | |||||
PRODUCT_CATEGORY_GUID | Category GUID | COMT_CATEGORY_GUID | RAW | 16(0) | SYSUUID | |||||
PRODUCT_CATEGORY_GUID001 | Category GUID | COMT_CATEGORY_GUID | RAW | 16(0) | SYSUUID | |||||
PRODUCT_CATEGORY_ID001 | Category ID | COMT_CATEGORY_ID | CHAR | 20(0) | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | CATEGORY_ID | ||
PRODUCT_CONC_LINES | Concatenated Text Lines | CRMDT_CONC_TEXTLINES | STRG | 0(0) | ||||||
PRODUCT_DURA | Warranty Period | CRMT_WTY_DURATION_UI | DEC | 13(0) | CRMT_WTY_DURATION_UI | |||||
PRODUCT_ID | Product ID | COMT_PRODUCT_ID | CHAR | 40(0) | PRID1 | COM_PRODUCT_ID | COM_PR_COLLECTION | PRODUCT_ID | ||
PRODUCT_PRODUCT_ID | Product ID | COMT_PRODUCT_ID | CHAR | 40(0) | PRID1 | COM_PRODUCT_ID | COM_PR_COLLECTION | PRODUCT_ID | ||
PRODUCT_PRODUCT_TYPE | Product Type | COMT_PRODUCT_TYPE | CHAR | 2(0) | COM_PRODUCT_TYPE | COM_PRODUCT_TYPE | COM_PR_TYPE_ACTIVE | PRODUCT_TYPE | ||
PRODUCT_REFERENCE | Warranty Basis | CRMT_WTY_REFERENCE_UI | CHAR | 1(0) | CRMT_WTY_REFERENCE_UI | |||||
PRODUCT_SHORT_TEXT | Product Description | COMT_PRSHTEXTX | CHAR | 40(0) | PRSHTEXT40 | |||||
PRODUCT_TYPE | Product Type | COMT_PRODUCT_TYPE | CHAR | 2(0) | COM_PRODUCT_TYPE | COM_PRODUCT_TYPE | COM_PR_TYPE_ACTIVE | PRODUCT_TYPE | ||
PRODUCT_TYPE_DESCRIPTION | Product Type Description | COMT_PR_TYPE_DESC | CHAR | 40(0) | TEXT40 | |||||
R3LIC_NO | License Number | CRMT_IT_LICENSENO_UI | CHAR | 50(0) | CRMT_IT_LICENSENO_UI | |||||
REGION | Region (State, Province, County) | REGIO | CHAR | 3(0) | REGIO | |||||
REGION_BEZEI | Description | BEZEI20 | CHAR | 20(0) | TEXT20 | |||||
SEARCHTERM1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20(0) | BU_SORT1 | |||||
SEARCHTERM2 | Search term 2 for business partner | BU_SORT2 | CHAR | 20(0) | BU_SORT1 | |||||
SHORT_TEXT | Product Description | COMT_PRSHTEXTX | CHAR | 40(0) | PRSHTEXT40 | |||||
SORT1 | Search Term 1 | AD_SORT1 | CHAR | 20(0) | CHAR20 | |||||
SORT2 | Search Term 2 | AD_SORT2 | CHAR | 20(0) | CHAR20 | |||||
STREET | Street | AD_STREET | CHAR | 60(0) | TEXT60 | CLSTRTNAME | STREET | |||
SUBNET | Subnet Mask | CRMT_IT_SUBNET_MASK_UI | CHAR | 15(0) | ITIPA | CRMT_IT_SUBNET_MASK_UI | ||||
TEL_NOMOB | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30(0) | CHAR30 | |||||
TEL_NOMOB1 | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30(0) | CHAR30 | |||||
TEL_NOTEL | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30(0) | CHAR30 | |||||
TEL_NOTEL1 | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30(0) | CHAR30 | |||||
TEL_NOTEL2 | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30(0) | CHAR30 | |||||
TEL_NOTEL3 | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30(0) | CHAR30 | |||||
TYPE002 | Other Name Type | PSIC_NAMETYPE_UI | CHAR | 4(0) | CRM_ICM_LOC_OTHNTYPE | |||||
USERNAME | User Name | SYUNAME | CHAR | 12(0) | SYCHAR12 |
Search for further information about these or an SAP related objects