/SAPSRM/S_CLL_WD_SEARCH_AVL SAP (AVL search criteria) Structure details

Dictionary Type: Structure
Description: AVL search criteria




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




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

/SAPSRM/S_CLL_WD_SEARCH_AVL 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 "AVL search criteria" 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_CLL_WD_SEARCH_AVL TYPE /SAPSRM/S_CLL_WD_SEARCH_AVL.

The /SAPSRM/S_CLL_WD_SEARCH_AVL table consists of various fields, each holding specific information or linking keys about AVL search criteria data available in SAP. These include DESCRIPTION (Name of SRM Document), PRODUCT (Product GUID), ORDERED_PROD (Product Name Entered), PRODUCT_TEXT (Product Description).. 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 (character-type or numeric)


SAP /SAPSRM/S_CLL_WD_SEARCH_AVL 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
DESCRIPTIONName of SRM Document BBP_DOCNAMECHAR40TEXT40
PRODUCTProduct GUID BBP_PRODUCTRAW16SYSUUID
ORDERED_PRODProduct Name Entered CRMT_ORDERED_PROD_DBCHAR54CRM_ORDERED_PROD
PRODUCT_TEXTProduct Description COMT_PRSHTEXTXCHAR40PRSHTEXT40
CATEGORYProduct Category GUID BBP_CATEGORY_GUID_RAWRAW16SYSUUID
CATEGORY_IDProduct Category ID BBP_CATEGORY_IDCHAR20COM_CATEGORY_IDCOM_CAT
CATEGORY_TEXTCategory Description COMT_CATEGORY_TEXTCHAR80TEXT80
PURCH_ORGPurchasing Organization BBP_PURCH_ORG_OMCHAR14HROBJEC_14
VENDOR_GUIDGUID for an Individual Partner CRMT_PARTNER_GUIDRAW16SYSUUID
VENDOR_NOBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
VENDOR_NAMESRM Business Partner Organization Name BBP_BP_NAME_ORGCHAR40BU_NAME
CONTRACT_GUIDGUID Contract BBP_CTR_H_GUIDRAW16SYSUUID
STATUSAVL Status as Search Criterium BBP_AVL_SEARCH_STATUSCHAR1BBP_AVL_SEARCH_STATUS
LAST_CHANGEDTimeframe for the AVL Search BBP_AVL_SEARCH_DATECHAR1BBP_AVL_SEARCH_DATE
CREATED_BY_MEGeneral Flag FLAGCHAR1FLAG
CREATED_BYUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
PURCH_ORG_GUIDGUID for an Individual Partner CRMT_PARTNER_GUIDRAW16SYSUUID
PURCH_ORG_BUPA_IDBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PURCH_ORG_NAMESRM Business Partner Organization Name BBP_BP_NAME_ORGCHAR40BU_NAME
SUBTYPESpecification of a Purchasing Doc.(e.g. Credit Memo/Invoice) BBP_H_SUBTYPECHAR2BBP_H_SUBTYPE
WITH_HIERARCHYGeneral Flag FLAGCHAR1FLAG
OBJECT_IDTransaction Number CRMT_OBJECT_ID_DBCHAR10ALPHACRM_OBJECT_ID
GUIDGlobally Unique identifier BBP_GUIDRAW16SYSUUID
P_GUIDParent GUID BBP_PGUIDRAW16SYSUUID
SH_PROD_IDProduct Name Entered CRMT_ORDERED_PROD_DBCHAR54CRM_ORDERED_PROD

Key field Non-key field



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

As /SAPSRM/S_CLL_WD_SEARCH_AVL 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_CLL_WD_SEARCH_AVL as there is no data to select.

How to access SAP table /SAPSRM/S_CLL_WD_SEARCH_AVL

Within an ECC or HANA version of SAP you can also view further information about /SAPSRM/S_CLL_WD_SEARCH_AVL 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!