SAP ABAP Table /SAPSRM/V_SPO_SR (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | /SAPSRM/V_SPO_SR | Table Relationship Diagram |
Short Description | Generated Table for View |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
2 | GUID_I | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier | ||
3 | CATEGORY | BBP_CATEGORY_GUID_RAW | SYSUUID | RAW | 16 | 0 | Product Category GUID | ||
4 | CATEGORY_ID | BBP_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Product Category ID | ||
5 | PRODUCT_TYPE | BBP_PRODUCT_TYPE | COM_PRODUCT_TYPE | CHAR | 2 | 0 | Product Type | ||
6 | DELIV_DATE | EINDT | DATUM | DATS | 8 | 0 | Item delivery date | ||
7 | DELIV_TIME | BBP_DELIV_TIME | TIME | TIMS | 6 | 0 | Delivery Time of the Item | ||
8 | VPER_START | BBP_VPER_START | DATUM | DATS | 8 | 0 | Validity Period From | ||
9 | VPER_END | BBP_VPER_END | DATUM | DATS | 8 | 0 | Validity period | ||
10 | QUANTITY | BBP_MNG | MENG13 | QUAN | 13 | 3 | Quantity in Order Unit | ||
11 | UNIT | BBP_UNIT | MEINS | UNIT | 3 | 0 | Purchase Order Unit | ||
12 | GROSS_PRICE | BBP_GROSS_PRICE | WERT7 | CURR | 13 | 2 | Gross Price | ||
13 | PRICE | BBP_PRICE | WERT7 | CURR | 13 | 2 | Net Price | ||
14 | PRICE_UNIT | EPEIN | DEC5 | DEC | 5 | 0 | Price unit | ||
15 | PRICE_ORIGIN | BBP_PRICE_ORIGIN | BBP_PRICE_ORIGIN | CHAR | 1 | 0 | Original Price (Determination/Manual Input) | ||
16 | VALUE | BBP_VALUE | WERT8 | CURR | 15 | 2 | Net Value | ||
17 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | ||
18 | FINAL_INV | BBP_EREKZ | XFELD | CHAR | 1 | 0 | Final invoice indicator | ||
19 | FINAL_ENTRY | BBP_FINAL_ENTRY | XFELD | CHAR | 1 | 0 | Final Entry Indicator (Goods/Services) | ||
20 | VAL_ASN | BBP_ASN_VALUE | WERT8 | CURR | 15 | 2 | Ship Note Value Released | ||
21 | VAL_CF_E | BBP_CF_VALUE_E | WERT8 | CURR | 15 | 2 | Value of Entered Confirmations | ||
22 | VAL_CF | BBP_CF_VALUE | WERT8 | CURR | 15 | 2 | Value of Confirmations Released | ||
23 | VAL_IV_E | BBP_IV_VALUE_E | WERT8 | CURR | 15 | 2 | Entered Invoice Value | ||
24 | VAL_IV | BBP_IV_VALUE | WERT8 | CURR | 15 | 2 | Released Invoice Value | ||
25 | VAL_PO_E | BBP_PO_VALUE_E | WERT8 | CURR | 15 | 2 | Value of POs/Confirmations/Invoices Created for Contract | ||
26 | VAL_PO_E_AGG | BBP_AGG_VALUE_E | WERT8 | CURR | 15 | 2 | Value PO / Confirm. / Inv. for Contract Hierarchy | ||
27 | QUAN_ASN_E | BBP_ASN_QUANT_E | MENG15 | QUAN | 15 | 3 | Shipping Notification Quantity Entered | ||
28 | QUAN_ASN | BBP_ASN_QUANT | MENG15 | QUAN | 15 | 3 | Ship Note Quantity Releas'd | ||
29 | QUAN_CF_E | BBP_CF_QUANT_E | MENG15 | QUAN | 15 | 3 | Quantity of Entered Confirmation | ||
30 | QUAN_CF | BBP_CF_QUANT | MENG15 | QUAN | 15 | 3 | Quantity of Released Confirmations | ||
31 | QUAN_IV_E | BBP_IV_QUANT_E | MENG15 | QUAN | 15 | 3 | Entered Invoiced Quantity | ||
32 | QUAN_IV | BBP_IV_QUANT | MENG15 | QUAN | 15 | 3 | Released Invoiced Quantity | ||
33 | QUAN_PO_E | BBP_PO_QUANT_E | MENG15 | QUAN | 15 | 3 | Quantity of POs/Confirmations/Invoices Created for Contract | ||
34 | NUM_ASN | BBP_NUM_ASN | BBP_INT4V | INT4 | 10 | 0 | No. of Shipping Notifications Entered for a PO | ||
35 | NUM_CONF | BBP_NUM_CONF | BBP_INT4V | INT4 | 10 | 0 | Number of Entered Confirmations for a Purchase Order | ||
36 | NUM_INV | BBP_NUM_INV | BBP_INT4V | INT4 | 10 | 0 | Number of Entered Invoices for Purchase Order or Confirmat. | ||
37 | EXLIN | /SAPSRM/EXLIN | /SAPSRM/EXLIN | CHAR | 40 | 0 | Configurable Line Item Number | ||
38 | PRODUCT | CRMT_PRODUCT_GUID_DB | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
39 | ORDERED_PROD | CRMT_ORDERED_PROD_DB | CRM_ORDERED_PROD | CHAR | 54 | 0 | Product Name Entered | ||
40 | DESCRIPTION_I | CRMT_PRSHTEXTX_DB | CRM_PRSHTEXT40_DB | CHAR | 40 | 0 | Product Short Text | ||
41 | NUMBER_INT | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
42 | NUMBER_EXT | CRMT_ITEM_NO_EXT | NUMC | 10 | 0 | External Item Number | |||
43 | ITM_TYPE | CRMT_ITEM_TYPE_DB | CRM_ITEM_TYPE | CHAR | 4 | 0 | Item Category | ||
44 | GUID_H | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier | ||
45 | CLIENT1 | EC_CLIENT | MANDT | CLNT | 3 | 0 | Client | ||
46 | CLIENT2 | EC_CLIENT | MANDT | CLNT | 3 | 0 | Client | ||
47 | CLIENT3 | EC_CLIENT | MANDT | CLNT | 3 | 0 | Client | ||
48 | GUID_PS | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier | ||
49 | GUID_I2 | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
50 | CLIENT4 | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
51 | GUID_ORD_H | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
52 | OBJECT_ID | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID |
History
Last changed by/on | SAP | 20141013 |
SAP Release Created in |