/SAPSRM/S_CTR_IT_BD_DATA SAP (Contract Item Basic Data.) Structure details
Description: Contract Item Basic Data.
Related tables to /SAPSRM/S_CTR_IT_BD_DATA
Access table /SAPSRM/S_CTR_IT_BD_DATA
Structure field list including key, data, relationships and ABAP select examples
/SAPSRM/S_CTR_IT_BD_DATA 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 "Contract Item Basic Data." 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_CTR_IT_BD_DATA TYPE /SAPSRM/S_CTR_IT_BD_DATA.
The /SAPSRM/S_CTR_IT_BD_DATA table consists of various fields, each holding specific information or linking keys about Contract Item Basic Data. data available in SAP. These include NUMBER_EXT (External Item Number), DESCRIPTION (Item Description), CATEGORY_ID (Category ID), MANU_PROD (Manufacturer Part 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. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP /SAPSRM/S_CTR_IT_BD_DATA 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 |
NUMBER_INT | Item Number | BBP_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
NUMBER_EXT | External Item Number | BBP_ITEM_NO_EXT | NUMC | 10 | |||||
DESCRIPTION | Item Description | BBP_ITEM_DESC | CHAR | 40 | TEXT40 | ||||
CATEGORY_ID | Category ID | COMT_CATEGORY_ID | CHAR | 20 | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | ||
MANU_PROD | Manufacturer Part Number | MFRPN | CHAR | 40 | CHAR40 | ||||
MFR_NO_EXT | External manufacturer code name or number | EMNFR | CHAR | 10 | CHAR10 | ||||
QUANTITY | Target Quantity for Contract Item | BBP_ITEM_TARGET_QUANTITY | QUAN | 13(3) | MENG13 | ||||
UNIT | Unit of Measurement | BBP_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ORDERED_PROD | Product Name Entered | CRMT_ORDERED_PROD_DB | CHAR | 54 | CRM_ORDERED_PROD | ||||
PRICE | Net Price | BBP_PRICE | CURR | 13(2) | WERT7 | ||||
PRICE_UNIT | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
PARTNER_PROD | Product Number of Vendor | BBP_PARTNER_PROD | CHAR | 40 | PRSHTEXT40 | ||||
VALUE | Target Value | BBP_ITEM_TARGET_VALUE | CURR | 15(2) | WERT8 | ||||
DELIV_DAYS | Delivery Time in Days | BBP_DELIV_DAYS | NUMC | 3 | NUMC3 | ||||
INCOTERM_KEY | Incoterm Key | BBP_INCOTERM_KEY | CHAR | 3 | Assigned to domain | BBP_INCOTERM_KEY | |||
INCOTERM_LOC | Incoterm Location | BBP_INCOTERM_LOCATION | CHAR | 28 | BBP_INCOTERM_LOCATION | ||||
MIN_ORDER_VALUE | Minimum Order Value | BBP_MIN_ORDER_VALUE | CURR | 15(2) | WERT8 | ||||
MIN_ORDER_QUAN | Minimum Order Quantity | BBP_MIN_ORDER_QUANTITY | QUAN | 13(3) | MENG13 | ||||
UOM_DENOMINATOR | Denominator for Conversion to Base Unit of Measure | BBP_UOM_DENOMINATOR | INT4 | 10 | INT4 | ||||
UOM_NUMERATOR | Counter for Conversion to Base Unit of Measure | BBP_UOM_NUMERATOR | INT4 | 10 | INT4 | ||||
PS_EXSNR | External Sort Number | /SAPPSSRM/_EXSNR | NUMC | 5 | NUMC5 | ||||
PS_IPT | Public Sector Item Type | /SAPPSSRM/_IPT | CHAR | 10 | Assigned to domain | /SAPPSSRM/_IPT | |||
TAR_IVAL | Relationship of Release Value to Target Value (in Percent) | BBP_PER_IVAL | DEC | 3 | DEC3 | ||||
TAR_QTY | Relationship of Release Quantity to Target Quantity (in Per) | BBP_PER_QTY | DEC | 3 | DEC3 | ||||
CATALOG_IND | Document (Contract) Transferred to Catalog | BBP_CATALOG_IND | CHAR | 1 | XFELD | ||||
PMNTTRMS | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
EXLIN | Configurable Line Item Number | /SAPSRM/EXLIN | CHAR | 40 | /SAPSRM/EXLIN | ||||
REV_LEV | Revision Level | CC_REVLV | CHAR | 2 | NUMCV | CC_REVLV | RVS | ||
PERCENT_LOW | Lower Limit Percentage | BBP_PERCENT_LOW | DEC | 5(2) | BBP_PERCNT_PI | ||||
PERCENT_HIGH | Upper Limit Percentage | BBP_PERCENT_HIGH | DEC | 5(2) | BBP_PERCNT_PI | ||||
UNLIMITED | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
UNIT_DESC | Description of Unit of Measurement | BBP_UNIT_DESC | CHAR | 40 | CHAR40 | ||||
ITEM_TYPE_DESC_TEXT | Terms of Payment | BBP_TEXT1_052 | CHAR | 50 | TEXT50 | ||||
PRODUCT_TYPE_DESC | Product Type | /SAPSRM/S_CLL_PRODUCT_TYPE | CHAR | 4 | /SAPSRM/S_CLL_PRODUCT_TYPE | ||||
DISTRIBUTION_FLAG | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
ITM_RELEASED | Status of Item | BBP_ITM_RELEASED | CHAR | 1 | BBP_ITM_RELEASED | ||||
LOCAL_SOURCING | Block Local Sourcing Indicator | BBP_LOCAL_SOURCE_IND | CHAR | 1 | XFELD | ||||
SH_CATEGORY_TEXT | Category Description | COMT_CATEGORY_TEXT | CHAR | 80 | TEXT80 | ||||
CATEGORY_TXT | Category Description | BBP_BW_CATEGORY_TEXT | CHAR | 80 | TEXT80 | ||||
PMNTTRMS_TXT | Terms of Payment | BBP_TEXT1_052 | CHAR | 50 | TEXT50 | ||||
PRODUCT_TYPE | Product Type | BBP_PRODUCT_TYPE | CHAR | 2 | Assigned to domain | COM_PRODUCT_TYPE |
Key field | Non-key field |
How do I retrieve data from SAP structure /SAPSRM/S_CTR_IT_BD_DATA using ABAP code?
As /SAPSRM/S_CTR_IT_BD_DATA 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_CTR_IT_BD_DATA as there is no data to select.How to access SAP table /SAPSRM/S_CTR_IT_BD_DATA
Within an ECC or HANA version of SAP you can also view further information about /SAPSRM/S_CTR_IT_BD_DATA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects