SAP BBPS_EXTREQ_ITEM Item Data of External Requirement Table data and field list

BBPS_EXTREQ_ITEM 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 "Item Data of External Requirement" 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_EXTREQ_ITEM TYPE BBPS_EXTREQ_ITEM.

The BBPS_EXTREQ_ITEM table consists of various fields, each holding specific information or linking keys about Item Data of External Requirement data available in SAP. These include ITEM_NUMBER (Item Number), PARENT (Parent GUID (Mapping of Outlines)), DESCRIPTION (Short Text), LANGU_ISO (2-Character SAP Language Code)... 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_EXTREQ_ITEM 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_EXTREQ_ITEM 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_EXTREQ_ITEM 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
ITEM_GUIDItem Business Transaction (Char32 GUID) BBP_BP_ITEMCHAR32SYSUUID_C
ITEM_NUMBERItem Number BBP_ITEM_NONUMC10CRM_ITEM_NO
PARENTParent GUID (Mapping of Outlines) BAPI_PARENTCHAR32SYSUUID_C
DESCRIPTIONShort Text TXZ01CHAR40TEXT40
LANGU_ISO2-Character SAP Language Code LAISOCHAR2LAISO
METHODAction for Incoming External Requisition BBP_EXTREQ_METHODCHAR1BBP_EXTREQ_ACTION
PRODUCT_GUIDInternal Unique ID of Product COMT_PRODUCT_GUID_BAPICHAR32SYSUUID_C
PRODUCT_IDProduct Number BAPI_PRODUCT_IDCHAR40PRID1COM_PRODUCT_ID
PRODUCT_TYPEProduct Type COMT_PRODUCT_TYPECHAR2Assigned to domainCOM_PRODUCT_TYPECOM_PRODUCT_TYPECOM_PR_TYPE_ACTIVE
PARTNER_PRODProduct Number of Vendor BBP_PARTNER_PRODCHAR40PRSHTEXT40
MANU_PRODManufacturer Part Number BBP_MFRPNCHAR40CHAR40
MFR_NO_EXTExternal manufacturer code name or number EMNFRCHAR10CHAR10
CATEGORY_IDCategory ID COMT_CATEGORY_IDCHAR20COM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIER
SCHEMA_TYPEStandard Schema Type SCHEMA_TYPECHAR10Assigned to domainCOM_SCHEMA_TYPE
CT_CATEGORY_IDCategory Name BBP_CT_CATEGORY_IDCHAR60CHAR60
ITM_EX_CT_UN_IDUnique Key in External Category BBP_ITM_EX_CT_UN_IDCHAR40CHAR40
QUANTITYQuantity in Order Unit BBP_MNGQUAN13(3) MENG13
UNITUnit of Measurement BBP_UNITUNIT3Assigned to domainCUNITMEINS
UNIT_ISOISO Code for Unit of Measurement BBP_UNIT_ISOCHAR3Assigned to domainISOCD_UNIT
PRICENet Price BBP_BAPI_PRICEDEC23(4) BAPICURR
PRICE_UNITPrice Unit EPEINDEC5DEC5
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
DIRECT_PROCIndicator: Direct Material Possible BBP_DIRECT_PROCCHAR1XFELD
DELIV_DATEItem Delivery Date EINDTDATS8DATUM
EXT_DEMIDExternal Requirement Number BBP_EXT_DEMIDCHAR32CHAR32
EXT_DEM_POSIDExternal Requirement Tracking Number BBP_EXT_DEM_POSIDCHAR32CHAR32
PRODUCT_GTINGlobal Trade Item Number (GTIN) COMT_GTINCHAR40GTIN1COM_GTIN
CTR_NUMBERContract Number BBP_CTR_IDCHAR10ALPHACRM_OBJECT_IDBBPH_CTR_LOCAL
CTR_ITEM_NUMBERNumber of Contract Item BBP_CTR_ITEMNUMC10CRM_ITEM_NO
DP_STGE_LOCStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
ITEM_TYPEItem Category CRMT_ITEM_TYPE_DBCHAR4Assigned to domainCRM_ITEM_TYPE
ORIGIN_ORDER_IDOrigninal Customer's PO No. for Third Party Transaction BBP_ORIGIN_ORDER_IDCHAR35CHAR35
ORIGIN_ITEM_IDOrignl Customer Purchase Order Item No. - Third Party Trans. BBP_ORIGIN_ORDER_ITEM_IDNUMC10NUMC10
THIRD_PARTYFlag for Third-Party Order Processing BBP_THIRD_PARTYCHAR1XFELD
GROUPING_LEVELSpecifies How Hierarchy Positions are to be Managed BBP_GROUPING_LEVELCHAR1BBP_GROUPING_LEVEL
PERIOD_STARTTimeframe From BBP_VPER_STARTDATS8DATUM
PERIOD_ENDTimeframe To BBP_VPER_ENDDATS8DATUM
EXT_DEM_KEYTechnical Key of External Requirement BBP_EXT_DEMKEYRAW16SYSUUID
EXT_DEM_POSKEYTechnical Key of External Purchase Requisition BBP_EXT_DEM_POSKEYRAW16SYSUUID
PROJECT_IDProject Key BBP_PROJECT_IDCHAR32CHAR32
PROJECT_TASK_IDKey of Project Task BBP_PROJECT_TASK_IDCHAR32CHAR32
PROJECT_ROLE_IDKey of Project Role BBP_PROJECT_ROLE_IDCHAR32CHAR32
REV_LEVRevision Level CC_REVLVCHAR2NUMCVCC_REVLVRVS
SERVICE_ITEM_KEYNumeric Character Field, Length 10 NUMC10NUMC10NUMC10

Key field Non-key field



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

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

How to access SAP table BBPS_EXTREQ_ITEM

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

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