/SAPSRM/S_CTR_IT_BD SAP (Contract Item Basic Data.) Structure details
Dictionary Type: Structure
Description: Contract Item Basic Data.
Description: Contract Item Basic Data.
ABAP Code to SELECT data from /SAPSRM/S_CTR_IT_BD
Related tables to /SAPSRM/S_CTR_IT_BD
Access table /SAPSRM/S_CTR_IT_BD
Related tables to /SAPSRM/S_CTR_IT_BD
Access table /SAPSRM/S_CTR_IT_BD
Structure field list including key, data, relationships and ABAP select examples
/SAPSRM/S_CTR_IT_BD 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 TYPE /SAPSRM/S_CTR_IT_BD.
The /SAPSRM/S_CTR_IT_BD table consists of various fields, each holding specific information or linking keys about Contract Item Basic Data. data available in SAP. These include NUMBER_INT (Item Number), NUMBER_EXT (External Item Number), DESCRIPTION (Item Description), CATEGORY_ID (Category ID).. 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 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 | |||
| GUID | Globally Unique identifier | BBP_GUID | RAW | 16 | SYSUUID | ||||
| PARENT | Parent GUID | BBP_PGUID | RAW | 16 | SYSUUID | ||||
| ITM_TYPE | Item Category | CRMT_ITEM_TYPE_DB | CHAR | 4 | Assigned to domain | CRM_ITEM_TYPE | |||
| PRODUCT | Product GUID | BBP_PRODUCT | RAW | 16 | SYSUUID | ||||
| CATEGORY | Category GUID | COMT_CATEGORY_GUID | RAW | 16 | SYSUUID | ||||
| SCHEMA_TYPE | Standard Schema Type | SCHEMA_TYPE | CHAR | 10 | Assigned to domain | COM_SCHEMA_TYPE | |||
| CT_CATEGORY_ID | Category Name | BBP_CT_CATEGORY_ID | CHAR | 60 | CHAR60 | ||||
| ITM_EX_CT_UN_ID | Unique Key in External Category | BBP_ITM_EX_CT_UN_ID | CHAR | 40 | CHAR40 | ||||
| CATALOGID | Catalog ID from which the line was selected | CATALOG | CHAR | 20 | BBP_WS_SERVICE_ID | ||||
| CATALOGITEM | Catalog Item (Unique Key) | CATALOGITEM | CHAR | 40 | CATALOGITEM | ||||
| EXT_QUOTE_ID | Number of an External RFx Response | BBP_EXT_QUOTE_ID | CHAR | 35 | |||||
| EXT_QUOTE_ITEM | Item of an External RFx Response | BBP_EXT_QUOTE_ITEM | NUMC | 10 | |||||
| DEL_IND | Deletion Indicator SRM Purchasing Document | BBP_DEL_IND | CHAR | 1 | XFELD | ||||
| PRODUCT_SRC_SYS | Business Document Service: ID of Logical System | BBP_LOGSYS | CHAR | 10 | CHAR10 | ||||
| SUBTYPE | Specification Purchase Item (e.g. Direct Material/Hierarch.) | BBP_I_SUBTYPE | CHAR | 2 | BBP_I_SUBTYPE | ||||
| SRC_OBJECT_TYPE | Object Type of Reference Item | BBP_SRC_I_OBJ_TYP | CHAR | 10 | Assigned to domain | OJ_NAME | |||
| SRC_ITM_ID | Unique ID of a Template Item | BBP_SRC_ITM_ID | CHAR | 20 | BBP_SRC_ITM_ID | ||||
| SRC_LOG_SYS | Logical System of Template Document (Vacant if in Loc. Sys.) | BBP_SRC_LOG_SYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| SRC_GUID | Reference Item GUID | BBP_SRC_I_GUID | RAW | 16 | SYSUUID | ||||
| SELECTED_FOR_ACTION | Indicator: If Item is Selected on UI | BBP_SELECTED_FOR_ACTION | CHAR | 1 | CHAR1 | ||||
| CO_CODE | Company Code in FI System | BBP_CO_CODE | CHAR | 4 | Assigned to domain | BUKRS | |||
| LOGSYS_FI | Logical System of FI System | BBP_LOGSYS_FI | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | BBP_BACKEND_DESTINATION_F4 | |
| GUARANTEED_MIN | Guaranteed Purchase Value (Public Sector ONLY!!) | BBP_GUARANTEED_MIN | CURR | 15(2) | WERT8 | ||||
| DUMMY_EEW_PDISS_CTR | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
| PS_HL_ITEM | Higher-Level Item GUID | /SAPPSSRM/_HL_ITEM | RAW | 16 | SYSUUID | ||||
| PS_HANDLE_ITM | Globally Unique identifier | BBP_GUID | RAW | 16 | SYSUUID | ||||
| PS_CTRL_KEY | Item Process Type Control Key | /SAPPSSRM/_PS_CTRL_KEY | CHAR | 4 | Assigned to domain | /SAPPSSRM/_PS_CTRL_KEY | /SAPPSSRM/H_PS_CTRL_KEY | ||
| PS_VALUE_RU | Net Value | BBP_VALUE | CURR | 15(2) | WERT8 | ||||
| PS_EXLIN_IND | EXLIN Indicator | /SAPPSSRM/_EXLIN_IND | CHAR | 1 | /SAPPSSRM/_EXLIN_IND | ||||
| DUMMY_EEW_PDISC_CTR | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
| ITEM_PROCESS_TYP | Item Process Type | /SAPSRM/PDO_ITEM_PROCESS_TYPE | CHAR | 10 | Assigned to domain | /SAPSRM/PDO_ITEM_PROCESS_TYPE | |||
| VAL_PO_E | Value of POs/Confirmations/Invoices Created for Contract | BBP_PO_VALUE_E | CURR | 15(2) | WERT8 | ||||
| QUAN_PO_E | Quantity of POs/Confirmations/Invoices Created for Contract | BBP_PO_QUANT_E | QUAN | 15(3) | MENG15 | ||||
| HEADER | Globally Unique identifier | BBP_GUID | RAW | 16 | SYSUUID | ||||
| CREATED_BY | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
| CREATED_AT | Transaction was Created at this Time | CRMT_CREATED_AT | DEC | 15 | TSTPS | BCOS_TSTMP | |||
| CHANGED_BY | Time of Last Change to the Transaction | CRMT_CHANGED_AT | DEC | 15 | TSTPS | BCOS_TSTMP | |||
| DUMMY_EEW_PD_IT_SWD_CTR | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
| ACTIVE_ITEM | Globally Unique identifier | BBP_GUID | RAW | 16 | SYSUUID | ||||
| VERSION_TYPE | Version Type (Active Document, 'Normal', Work Version) | BBP_VERSION_TYPE | CHAR | 1 | BBP_VERSION_TYPE | ||||
| P_GUID | Globally Unique identifier | BBP_GUID | RAW | 16 | SYSUUID | ||||
| PRICE_DESC | Description of Unit of Measurement | BBP_UNIT_DESC | CHAR | 40 | CHAR40 | ||||
| PRICE_PER | Description of Unit of Measurement | BBP_UNIT_DESC | CHAR | 40 | CHAR40 | ||||
| ALERT_REL_QTY | Target Quantity for Contract Item | BBP_ITEM_TARGET_QUANTITY | QUAN | 13(3) | MENG13 | ||||
| STATUS_DESC | Text for status | EDI_STADES | CHAR | 50 | EDI_CHAR50 | ||||
| STATUS_INDCATOR | Indicator: Status Is Inactive | J_INACT | CHAR | 1 | J_INACT | ||||
| ITEM_TYPE_DESC | Item Category | /SAPSRM/S_CLL_ITEM_TYPE | CHAR | 5 | /SAPSRM/S_CLL_ITEM_TYPE | ||||
| TREE_PARENT | Globally Unique identifier | BBP_GUID | RAW | 16 | SYSUUID | ||||
| TREE_ITEM | Globally Unique identifier | BBP_GUID | RAW | 16 | SYSUUID | ||||
| LEAF | Element Without Subelements | /SAPSRM/LEAF | CHAR | 1 | BOOLE | ||||
| EXPANDED | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1 | BOOLE | ||||
| CHILDREN_LOADED | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1 | BOOLE | ||||
| CALC_DESCRIPTION | Calculated description for a hierarchical item | /SAPSRM/CLL_CALC_DESCRIPTION | STRG | 0 | /SAPSRM/CLL_CALC_DESCRIPTION | ||||
| NUMBER_ATTACHMENTS | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
| NUMBER_NOTES | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
| NOT_SELECTABLE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1 | BOOLE | ||||
| PRICE_VARIANT | Price Variant Key (Only for Purchase Order) | /SAPSRM/S_CLL_PRICE_VAR | CHAR | 1 | /SAPSRM/S_CLL_PRICE_VARIANT | ||||
| ITEM_GUID | Globally Unique identifier | BBP_GUID | RAW | 16 | SYSUUID | ||||
| ITEM_APPROVAL_STATUS | Status of Item in Approval Process | /SAPSRM/PDO_APPROVALSTATUS | CHAR | 8 | /SAPSRM/PDO_APPROVALSTATUS | ||||
| SH_ORDERED_PROD | Product Name Entered | CRMT_ORDERED_PROD_DB | CHAR | 54 | CRM_ORDERED_PROD | ||||
| SH_CATEGORY_ID | Category ID | COMT_CATEGORY_ID | CHAR | 20 | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | ||
| SH_LOGSYS | Original System | COMT_LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | COM_LOGSYS | COM_PRODUCT_LOGSYS |
| MODEL | 0 |
| Key field | Non-key field |
How do I retrieve data from SAP structure /SAPSRM/S_CTR_IT_BD using ABAP code?
As /SAPSRM/S_CTR_IT_BD 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 as there is no data to select.How to access SAP table /SAPSRM/S_CTR_IT_BD
Within an ECC or HANA version of SAP you can also view further information about /SAPSRM/S_CTR_IT_BD 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