SAP BBPS_BE_SOS_AVL AVLs Found in Sourcing Table data and field list

BBPS_BE_SOS_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 "AVLs Found in Sourcing" 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_BBPS_BE_SOS_AVL TYPE BBPS_BE_SOS_AVL.

The BBPS_BE_SOS_AVL table consists of various fields, each holding specific information or linking keys about AVLs Found in Sourcing data available in SAP. These include AVL_ITEM_NUMBER (Item Number in Document), BE_VENDOR_ID (Account Number of Vendor or Creditor), VENDOR_NAME (Short name of business partner), CTR_HDR_NUMBER (Transaction Number)... 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. .

BBPS_BE_SOS_AVL structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP BBPS_BE_SOS_AVL structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BBPS_BE_SOS_AVL table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
AVL_HDR_NUMBER	Transaction Number	CRMT_OBJECT_ID_DB	CHAR	10		ALPHA	CRM_OBJECT_ID
AVL_ITEM_NUMBER	Item Number in Document	CRMT_ITEM_NO	NUMC	10			CRM_ITEM_NO
BE_VENDOR_ID	Account Number of Vendor or Creditor	LIFNR	CHAR	10	Assigned to domain	ALPHA	LIFNR	LIF	KRED_C
VENDOR_NAME	Short name of business partner	BU_DESCRIP	CHAR	50			BU_TEXT50
CTR_HDR_NUMBER	Transaction Number	CRMT_OBJECT_ID_DB	CHAR	10		ALPHA	CRM_OBJECT_ID
CTR_ITEM_NUMBER	Item Number in Document	CRMT_ITEM_NO	NUMC	10			CRM_ITEM_NO
DESCRIPTION	Product Description	COMT_PRSHTEXTX	CHAR	40			PRSHTEXT40
CATEGORY_ID	Product Category ID	BBP_CATEGORY_ID	CHAR	20			COM_CATEGORY_ID		COM_CAT
ORDERED_PROD	Product ID	COMT_PRODUCT_ID	CHAR	40		PRID1	COM_PRODUCT_ID		COM_PR_COLLECTION
FLAG_MATCH	Checkbox	XFELD	CHAR	1			XFELD
FLAG_DEVIATION	Indicator: Customer-Spec. Sourcing Criteria Are Different	BBP_FLAG_DEVIATION	CHAR	1			XFELD
QUOTA_BASE_AMT	Quota Base Quantity	BBP_QUOTA_BASE_AMOUNT	QUAN	13(3)			MENG13
BASE_UNIT	Unit of Measure in Quota Arrangement	BBP_QA_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
TARGET_PERCENT	Target Percentage in Quota Arrangement	BBP_TARGET_PERCENTAGE	DEC	5(2)			BBP_VPROZ
BASE_UNIT_ISO	ISO Code for Unit of Measurement	BBP_UNIT_ISO	CHAR	3	Assigned to domain		ISOCD_UNIT
DUMMY_EEW_IDXSSF	Dummy function in length 1	DUMMY	CHAR	1			DUMMY
.INCLU--AP				0
PS_MQP_I_DAYS	Duration of Initial Period in Days	/SAPPSSRM/_MQP_I_DAYS	NUMC	5			NUM05
.INCLU--AP				0
PS_PO_HDR_GUID	Purchaser Order Header GUID	/SAPPSSRM/_PO_HDR_GUID	RAW	16			SYSUUID
PS_PO_HDR_NUM	Purchase Order Number	/SAPPSSRM/_PO_HDR_NUM	CHAR	10		ALPHA	CRM_OBJECT_ID
PS_PO_ITM_GUID	Purchaser Order Item GUID	/SAPPSSRM/_PO_ITM_GUID	RAW	16			SYSUUID
PS_PO_ITM_NUM	Purchaser Order Item Number	/SAPPSSRM/_PO_ITM_NUM	NUMC	10			CRM_ITEM_NO
PS_PO_LOG_SYS	Logical System (of the Purchase Order)	/SAPPSSRM/_PO_LOG_SYS	CHAR	10	Assigned to domain	ALPHA	LOGSYS
PS_PO_DELIV_DATE	Purchase Order Item Delivery Date	/SAPPSSRM/_PO_DELIV_DATE	DATS	8			DATUM
PS_PO_DELIV_TIME	Delivery Time of a Purchase Order Item	/SAPPSSRM/_PO_DELIV_TIME	TIMS	6			TIME
PS_PO_OPEN_QUAN	Open Quantity of a Purchase Order	/SAPPSSRM/_PO_OPEN_QUAN	QUAN	15(3)			MENG15
PS_PO_QUAN_UNIT	Purchase Order Unit	/SAPPSSRM/_PO_QUAN_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
.INCLU--AP				0
PS_O_BO_OBJ_ID	Transaction Number	CRMT_OBJECT_ID_DB	CHAR	10		ALPHA	CRM_OBJECT_ID
PS_O_BO_OBJ_TY	Object Type	SWO_OBJTYP	CHAR	10	Assigned to domain		OJ_NAME	OBJ
PS_O_BO_DESC	Name of SRM Document	BBP_DOCNAME	CHAR	40			TEXT40
PS_O_BO_GUID	Globally Unique identifier	BBP_GUID	RAW	16			SYSUUID
PS_O_BO_ITM_NO	Item Number in Document	CRMT_ITEM_NO	NUMC	10			CRM_ITEM_NO
PS_O_BO_DRAFT	R/2 table	CHAR5	CHAR	5			CHAR5
PS_O_BO_DOC_TY	Character field, length 32	CHAR32	CHAR	32			CHAR32
.INCLU--AP				0
PS_PRIO_CODE	Delivery Priority	/SAPPSSRM/_PRIO_CODE	NUMC	2	Assigned to domain		/SAPPSSRM/_PRIO_CODE		/SAPPSSRM/H_PRIO_CODE
.INCLU--AP				0
PS_REASON_CODE	Reason Code	/SAPPSSRM/_GR_REASON_CODE	CHAR	4			/SAPPSSRM/_GR_REASON_CODE		/SAPPSSRM/H_REASON_CODE
DUMMY_EEW_IDXCSF	Dummy function in length 1	DUMMY	CHAR	1			DUMMY

Key field

Non-key field

< BBPS_BE_OBJECT - Identifies a BE Object BBPS_BE_SOS_CONTRACTS - Contracts Found in Sourcing >

How do I retrieve data from SAP structure BBPS_BE_SOS_AVL using ABAP code?

As BBPS_BE_SOS_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 BBPS_BE_SOS_AVL as there is no data to select.

How to access SAP table BBPS_BE_SOS_AVL

Within an ECC or HANA version of SAP you can also view further information about BBPS_BE_SOS_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).