/SAPSRM/S_SEARCHFIELDS SAP (Search Field References for Document Search) Structure details

Dictionary Type: Structure
Description: Search Field References for Document Search




ABAP Code to SELECT data from /SAPSRM/S_SEARCHFIELDS
Related tables to /SAPSRM/S_SEARCHFIELDS
Access table /SAPSRM/S_SEARCHFIELDS




Structure field list including key, data, relationships and ABAP select examples

/SAPSRM/S_SEARCHFIELDS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Search Field References for Document Search" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_/SAPSRM/S_SEARCHFIELDS TYPE /SAPSRM/S_SEARCHFIELDS.

The /SAPSRM/S_SEARCHFIELDS table consists of various fields, each holding specific information or linking keys about Search Field References for Document Search data available in SAP. These include STATUS (Object Status), EXCEPTION_STATUS (Character Field Length 1), SELECTION_DATE (Character Field Length 1), CREATE_DATE_FROM (Created on).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP /SAPSRM/S_SEARCHFIELDS structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
OBJECT_IDTransaction Number CRMT_OBJECT_ID_DBCHAR10ALPHACRM_OBJECT_ID
STATUSObject Status CRM_J_STATUSCHAR5CRM_J_STATUS
EXCEPTION_STATUSCharacter Field Length 1 CHAR01CHAR1CHAR1
SELECTION_DATECharacter Field Length 1 CHAR01CHAR1CHAR1
CREATE_DATE_FROMCreated on BBP_CREATE_DATEDATS8DATUM
CREATE_DATE_TOCreated on BBP_CREATE_DATEDATS8DATUM
OBJECT_NAMEName of SRM Document BBP_DOCNAMECHAR40TEXT40
REF_OBJECT_IDTransaction Number CRMT_OBJECT_ID_DBCHAR10ALPHACRM_OBJECT_ID
REF_OBJECT_NAMEName of SRM Document BBP_DOCNAMECHAR40TEXT40
SC_NAMEName of shopping cart BBP_DOC_NAMECHAR40TEXT40
ITEM_NAMEShort Text for Item BBP_ITEM_DESCRCHAR40TEXT40
PRODUCTProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
PARTNER_PRODProduct Number of Business Partner CRMT_ITEM_DESCR_PARTNERCHAR40PRSHTEXT40
CATEGORYProduct Category ID BBP_CATEGORY_IDCHAR20COM_CATEGORY_IDCOM_CAT
CREATORUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
VENDORBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
REQUESTORBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
RECIPIENTBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
LOCATIONBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
REF_DOC_NOReference Document Number BBP_XBLNRCHAR16XBLNR
SUBTYPESpecification of a Purchasing Doc.(e.g. Credit Memo/Invoice) BBP_H_SUBTYPECHAR2BBP_H_SUBTYPE
PURCH_GRPResponsible Purchasing Group BBP_PROC_GROUPCHAR14HROBJEC_14BBP_PROC_GROUP
PURCH_GRP_TEXTPurchasing Group BBP_PURCH_GRP_DESCCHAR40TEXT40
PURCH_ORGResponsible Purchasing Organization BBP_PROC_ORGCHAR14HROBJEC_14BBP_PROC_ORG
PURCH_ORG_TEXTPurchasing Organization BBP_PURCH_ORG_DESCCHAR40TEXT40
LOGICAL_SYSTEMLogical System CRMT_LOGSYSCHAR10Assigned to domainALPHALOGSYS
VENDOR_GUIDPartner Number CRMT_PARTNER_NOCHAR32CRM_PARTNER_NO
REQUESTOR_GUIDPartner Number CRMT_PARTNER_NOCHAR32CRM_PARTNER_NO
RESPONSIBLE_UIDPartner Number CRMT_PARTNER_NOCHAR32CRM_PARTNER_NO
RECIPIENT_GUIDPartner Number CRMT_PARTNER_NOCHAR32CRM_PARTNER_NO
LOCATION_GUIDPartner Number CRMT_PARTNER_NOCHAR32CRM_PARTNER_NO
PRODUCT_GUIDInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16SYSUUID
CATEGORY_GUIDCategory GUID COMT_CATEGORY_GUIDRAW16SYSUUID
EXT_DEMIDExternal Requirement Number BBP_EXT_DEMIDCHAR32CHAR32
DESKTOP_FUNCTIONCharacter Field Length 1 CHAR01CHAR1CHAR1
DEADLINE_DATECharacter Field Length 1 CHAR01CHAR1CHAR1
STATUS_MIXEDCharacter length 2 CHAR_02CHAR2CHAR02
CTR_HDR_NUMBERContract Number BBP_CTR_IDCHAR10ALPHACRM_OBJECT_IDBBPH_CTR_LOCAL
CTR_HDR_GUIDGUID Contract BBP_CTR_H_GUIDRAW16SYSUUID
CTR_HIER_IDContract Number BBP_CTR_IDCHAR10ALPHACRM_OBJECT_IDBBPH_CTR_LOCAL
DESVENDORBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
DESVENDOR_GUIDPartner Number CRMT_PARTNER_NOCHAR32CRM_PARTNER_NO
ACC_CATAccount Assignment Category in SRM BBP_ACC_CATCHAR5BBP_ACCCAT
ACC_STRGeneric Account Assignment BBP_ACC_GENERICCHAR64CHAR64
DELIVERY_DATE_FROMSystem Date SYDATUMDATS8SYDATS
DELIVERY_DATE_TOSystem Date SYDATUMDATS8SYDATS
COMPANYCharacter field, 8 characters long CHAR8CHAR8CHAR8
COMPANY_CODECompany Code BBP_COMPANY_CODECHAR20BBP_COMPANY_CODE
SUBSTITUTECheckbox XFELDCHAR1XFELD
INCOMPLETECheckbox XFELDCHAR1XFELD
WITH_CLOSEDCheckbox XFELDCHAR1XFELD
WITH_VERSIONCharacter Field Length 1 CHAR01CHAR1CHAR1
WITH_HIERARCHYCheckbox XFELDCHAR1XFELD
TEMPLATE_ONLYCharacter Field Length 1 CHAR01CHAR1CHAR1
START_DATECharacter Field Length 1 CHAR01CHAR1CHAR1
PROCESS_TYPEBusiness Transaction Type CRMT_PROCESS_TYPE_DBCHAR4Assigned to domainCRM_PROCESS_TYPE
MY_COMPANYCheckbox XFELDCHAR1XFELD
TREXCharacter 100 CHAR100CHAR100CHAR100
BILLFROMBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
BILLFROM_GUIDPartner Number CRMT_PARTNER_NOCHAR32CRM_PARTNER_NO
BIDDER_GUIDGlobally Unique Identifier in 32-Character Display BBP_GUID_32CHAR32SYSUUID_C
CONTACT_GUIDGlobally Unique Identifier in 32-Character Display BBP_GUID_32CHAR32SYSUUID_C
CONTRACT_HIERARCHYCharacter Field Length 1 CHAR01CHAR1CHAR1
PROCESSED_BYSingle-Character Indicator CHAR1CHAR1CHAR1
GROSS_AMOUNTGross invoice amount in document currency BBP_IV_AMOUNTCURR15(2) WERT8
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
POSTING_DATE_FROMPosting Date for a Business Transaction CRMT_POSTING_DATEDATS8
POSTING_DATE_TOPosting Date for a Business Transaction CRMT_POSTING_DATEDATS8
EXCEPTION_TYPEEvent BBP_EVENTCHAR32BBP_EVENT
SHOWONLYTEAMCARTSCheckbox XFELDCHAR1XFELD
TEAMMEMBERUser Name SYUNAMECHAR12SYCHAR12
SEL_ARCHIVCheckbox XFELDCHAR1XFELD
SEL_SYSTEMCheckbox XFELDCHAR1XFELD
DIST_INDSingle-Character Indicator CHAR1CHAR1CHAR1
SHOWMYTEAMCARTSCheckbox XFELDCHAR1XFELD
CO_CODECompany Code in FI System BBP_CO_CODECHAR4Assigned to domainBUKRS
GROSS_INV_AMOUNTGross invoice amount in document currency BBP_IV_AMOUNTCURR15(2) WERT8
BIDRNumber of Bids for a Bid Invitation BBP_NUM_QUOTINT410BBP_INT4V

Key field Non-key field



How do I retrieve data from SAP structure /SAPSRM/S_SEARCHFIELDS using ABAP code?

As /SAPSRM/S_SEARCHFIELDS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /SAPSRM/S_SEARCHFIELDS as there is no data to select.

How to access SAP table /SAPSRM/S_SEARCHFIELDS

Within an ECC or HANA version of SAP you can also view further information about /SAPSRM/S_SEARCHFIELDS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!