/SAPSRM/V_SPO_SR SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




Table View field list including key, data, relationships and ABAP select examples

/SAPSRM/V_SPO_SR is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The /SAPSRM/V_SPO_SR table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include GUID_I (Globally Unique identifier), CATEGORY (Product Category GUID), CATEGORY_ID (Product Category ID), PRODUCT_TYPE (Product Type).. 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: Not classified


SAP /SAPSRM/V_SPO_SR table view 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
CLIENTClient MANDTCLNT3MANDT
GUID_IGlobally Unique identifier BBP_GUIDRAW16SYSUUID
CATEGORYProduct Category GUID BBP_CATEGORY_GUID_RAWRAW16SYSUUID
CATEGORY_IDProduct Category ID BBP_CATEGORY_IDCHAR20COM_CATEGORY_IDCOM_CAT
PRODUCT_TYPEProduct Type BBP_PRODUCT_TYPECHAR2COM_PRODUCT_TYPE
DELIV_DATEItem Delivery Date EINDTDATS8DATUM
DELIV_TIMEDelivery Time of the Item BBP_DELIV_TIMETIMS6TIME
VPER_STARTTimeframe From BBP_VPER_STARTDATS8DATUM
VPER_ENDTimeframe To BBP_VPER_ENDDATS8DATUM
QUANTITYQuantity in Order Unit BBP_MNGQUAN13(3) MENG13
UNITUnit of Measurement BBP_UNITUNIT3CUNITMEINS
GROSS_PRICEGross Price BBP_GROSS_PRICECURR13(2) WERT7
PRICENet Price BBP_PRICECURR13(2) WERT7
PRICE_UNITPrice Unit EPEINDEC5DEC5
PRICE_ORIGINOriginal Price (Determination/Manual Input) BBP_PRICE_ORIGINCHAR1BBP_PRICE_ORIGIN
VALUENet Value BBP_VALUECURR15(2) WERT8
CURRENCYCurrency Key WAERSCUKY5WAERSFWS
FINAL_INVFinal invoice indicator BBP_EREKZCHAR1XFELD
FINAL_ENTRYFinal Entry Indicator (Goods/Services) BBP_FINAL_ENTRYCHAR1XFELD
VAL_ASNShip Note Value Released BBP_ASN_VALUECURR15(2) WERT8
VAL_CF_EValue of Entered Confirmations BBP_CF_VALUE_ECURR15(2) WERT8
VAL_CFValue of Confirmations Released BBP_CF_VALUECURR15(2) WERT8
VAL_IV_EEntered Invoice Value BBP_IV_VALUE_ECURR15(2) WERT8
VAL_IVReleased Invoice Value BBP_IV_VALUECURR15(2) WERT8
VAL_PO_EValue of POs/Confirmations/Invoices Created for Contract BBP_PO_VALUE_ECURR15(2) WERT8
VAL_PO_E_AGGValue PO / Confirm. / Inv. for Contract Hierarchy BBP_AGG_VALUE_ECURR15(2) WERT8
QUAN_ASN_EShipping Notification Quantity Entered BBP_ASN_QUANT_EQUAN15(3) MENG15
QUAN_ASNShip Note Quantity Releas'd BBP_ASN_QUANTQUAN15(3) MENG15
QUAN_CF_EQuantity of Entered Confirmation BBP_CF_QUANT_EQUAN15(3) MENG15
QUAN_CFQuantity of Released Confirmations BBP_CF_QUANTQUAN15(3) MENG15
QUAN_IV_EEntered Invoiced Quantity BBP_IV_QUANT_EQUAN15(3) MENG15
QUAN_IVReleased Invoiced Quantity BBP_IV_QUANTQUAN15(3) MENG15
QUAN_PO_EQuantity of POs/Confirmations/Invoices Created for Contract BBP_PO_QUANT_EQUAN15(3) MENG15
NUM_ASNNo. of Shipping Notifications Entered for a PO BBP_NUM_ASNINT410BBP_INT4V
NUM_CONFNumber of Entered Confirmations for a Purchase Order BBP_NUM_CONFINT410BBP_INT4V
NUM_INVNumber of Entered Invoices for Purchase Order or Confirmat. BBP_NUM_INVINT410BBP_INT4V
EXLINConfigurable Line Item Number /SAPSRM/EXLINCHAR40/SAPSRM/EXLIN
PRODUCTInternal Unique ID of Product CRMT_PRODUCT_GUID_DBRAW16SYSUUID
ORDERED_PRODProduct Name Entered CRMT_ORDERED_PROD_DBCHAR54CRM_ORDERED_PROD
DESCRIPTION_IProduct Short Text CRMT_PRSHTEXTX_DBCHAR40CRM_PRSHTEXT40_DB
NUMBER_INTItem Number in Document CRMT_ITEM_NONUMC10CRM_ITEM_NO
NUMBER_EXTExternal Item Number CRMT_ITEM_NO_EXTNUMC10
ITM_TYPEItem Category CRMT_ITEM_TYPE_DBCHAR4CRM_ITEM_TYPE
GUID_HGlobally Unique identifier BBP_GUIDRAW16SYSUUID
CLIENT1Client EC_CLIENTCLNT3MANDT
CLIENT2Client EC_CLIENTCLNT3MANDT
CLIENT3Client EC_CLIENTCLNT3MANDT
GUID_PSGlobally Unique identifier BBP_GUIDRAW16SYSUUID
GUID_I2GUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
CLIENT4Client MANDTCLNT3MANDT
GUID_ORD_HGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
OBJECT_IDTransaction Number CRMT_OBJECT_ID_DBCHAR10ALPHACRM_OBJECT_ID

Key field Non-key field



How do I retrieve data from SAP table /SAPSRM/V_SPO_SR using ABAP code

The following ABAP code Example will allow you to do a basic selection on /SAPSRM/V_SPO_SR to SELECT all data from the table
DATA: WA_/SAPSRM/V_SPO_SR TYPE /SAPSRM/V_SPO_SR.

SELECT SINGLE *
FROM /SAPSRM/V_SPO_SR
INTO CORRESPONDING FIELDS OF WA_/SAPSRM/V_SPO_SR
WHERE...

How to access SAP table /SAPSRM/V_SPO_SR

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