/SAPSRM/S_CLL_SUSCONF_ITEM SAP (SUS CONFIRMATION ITEM DATA) Structure details
Description: SUS CONFIRMATION ITEM DATA
Related tables to /SAPSRM/S_CLL_SUSCONF_ITEM
Access table /SAPSRM/S_CLL_SUSCONF_ITEM
Structure field list including key, data, relationships and ABAP select examples
/SAPSRM/S_CLL_SUSCONF_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 "SUS CONFIRMATION ITEM 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_CLL_SUSCONF_ITEM TYPE /SAPSRM/S_CLL_SUSCONF_ITEM.
The /SAPSRM/S_CLL_SUSCONF_ITEM table consists of various fields, each holding specific information or linking keys about SUS CONFIRMATION ITEM DATA data available in SAP. These include GUID (Globally Unique identifier), PARENT (Parent GUID), ITM_TYPE (Item Category), NUMBER_INT (Item 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_CLL_SUSCONF_ITEM 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 |
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 | |||
NUMBER_INT | Item Number | BBP_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
NUMBER_EXT | External Item Number | BBP_ITEM_NO_EXT | NUMC | 10 | |||||
ORDERED_PROD | Product Name Entered | CRMT_ORDERED_PROD_DB | CHAR | 54 | CRM_ORDERED_PROD | ||||
DESCRIPTION | Short Text | TXZ01 | CHAR | 40 | TEXT40 | ||||
VPER_START | Timeframe From | BBP_VPER_START | DATS | 8 | DATUM | ||||
VPER_END | Timeframe To | BBP_VPER_END | DATS | 8 | DATUM | ||||
TIME_FROM | Start Time | BBP_TIME_FROM | TIMS | 6 | TIME | ||||
TIME_TO | End Time | BBP_TIME_TO | TIMS | 6 | TIME | ||||
PARTNER_PROD | Product Number of Vendor | BBP_PARTNER_PROD | CHAR | 40 | PRSHTEXT40 | ||||
PRODUCT_TYPE | Product Type | COMT_PRODUCT_TYPE | CHAR | 2 | Assigned to domain | COM_PRODUCT_TYPE | COM_PRODUCT_TYPE | COM_PR_TYPE_ACTIVE | |
CTR_LOG_SYS | Logical System from Which the Contract Originates | BBP_CTR_LOG_SYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
CTR_ITEM_NUMBER | Number of Contract Item | BBP_CTR_ITEM | NUMC | 10 | CRM_ITEM_NO | ||||
CTR_HDR_NUMBER | Contract Number | BBP_CTR_ID | CHAR | 10 | ALPHA | CRM_OBJECT_ID | BBPH_CTR_LOCAL | ||
GTIN | Product ID GTIN | BBPT_CT_PRODUCT_ID_GTIN | CHAR | 40 | CHAR40 | ||||
ORDER_DATE | Posting Date | CRMT_ORDER_DATE | DEC | 15 | TSTPS | BCOS_TSTMP | |||
SUBST_REASON | Reason for Product Substitution | CRMT_ITEM_SUBSTITUTION | CHAR | 4 | Assigned to domain | CRM_ITEM_SUBSTITUTION | |||
ITM_USAGE | Usage of Higher-Level Item | CRMT_ITEM_USAGE | CHAR | 2 | CRM_ITEM_USAGE | ||||
ITM_TYPE_USAGE | Item Category Usage | CRMT_IT_TYPE_USAGE | CHAR | 4 | Assigned to domain | CRM_IT_TYPE_USAGE | |||
IR_IND | Invoice Receipt Indicator | REPOS | CHAR | 1 | XFELD | ||||
ERS | Evaluated Receipt Settlement (ERS) | BBP_XERSY | CHAR | 1 | XFELD | ||||
ALTERNATIVE | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | SYSUUID | ||||
ITM_LANGUAGE | Short Text Language for an Item | CRMT_ITEM_LANGU | LANG | 1 | ISOLA | SYLANGU | |||
MANU_PROD | Manufacturer Part Number | MFRPN | CHAR | 40 | CHAR40 | ||||
MFR_NO_EXT | External manufacturer code name or number | EMNFR | CHAR | 10 | CHAR10 | ||||
UNIT | Unit of Measurement | BBP_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
QUANTITY | Quantity in Order Unit | BBP_MNG | QUAN | 13(3) | MENG13 | ||||
PRICE | Net Price | BBP_PRICE | CURR | 13(2) | WERT7 | ||||
VALUE | Net Value | BBP_VALUE | CURR | 15(2) | WERT8 | ||||
PRICE_UNIT | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
GROSS_PRICE | Gross Price | BBP_GROSS_PRICE | CURR | 13(2) | WERT7 | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
TAX_CODE | Tax on Sales/Purchases Code | BBP_MWSKZ | CHAR | 2 | BBP_MWSKZ | ||||
DELIV_DATE | Item Delivery Date | EINDT | DATS | 8 | DATUM | ||||
DEL_IND | Deletion Indicator SRM Purchasing Document | BBP_DEL_IND | CHAR | 1 | XFELD | ||||
SRC_OBJECT_TYPE | Object Type of Reference Item | BBP_SRC_I_OBJ_TYP | CHAR | 10 | Assigned to domain | OJ_NAME | |||
SRC_GUID | Reference Item GUID | BBP_SRC_I_GUID | RAW | 16 | SYSUUID | ||||
FINAL_ENTRY | Final Entry Indicator (Goods/Services) | BBP_FINAL_ENTRY | CHAR | 1 | XFELD | ||||
DUMMY_EEW_PDISS_SUSCF | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
DUMMY_EEW_PDISC_SUSCF | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
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 | ||||
BE_LOG_SYSTEM | Logical System of Logistics Backend | BE_LOG_SYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
BE_OBJ_ITEM | Follow-On Object Item in Back-End System | BE_OBJ_ITEM | CHAR | 10 | BBP_REF_ITEM | ||||
BE_OBJECT_TYPE | Follow-On Document Object Type in Back-End System | BE_OBJECT_TYPE | CHAR | 10 | Assigned to domain | OJ_NAME | |||
BE_OBJECT_ID | Follow-On Document Object ID in Back-End System | BE_OBJECT_ID | CHAR | 20 | BBP_BE_OBJECT_ID | ||||
BE_REFOBJ_TYPE | Reference Object Type in Back-End System | BE_REFOBJ_TYPE | CHAR | 10 | Assigned to domain | OJ_NAME | |||
BE_REFOBJ | Reference Object in Back-End System | BE_REFOBJ | CHAR | 20 | BBP_BE_OBJECT_ID | ||||
BE_REFOBJ_ITEM | Reference Object Item in Back-End System | BE_REFOBJ_ITEM | CHAR | 10 | BBP_REF_ITEM | ||||
REV_LEV | Revision Level | CC_REVLV | CHAR | 2 | NUMCV | CC_REVLV | RVS | ||
ACCEPT_STAT_CODE | Acceptance Status | BBP_ACCEPT_STAT_CODE | CHAR | 1 | BBP_ACCEPT_STAT_CODE | ||||
CTR_SRV_NUM | Contract Service Number | BBP_CTR_SERVICE_NUMBER | CHAR | 20 | CHAR20 | ||||
PRC_CHG_IND | Price Change Indicator | BBP_PRICE_CHG_IND | CHAR | 1 | XFELD | ||||
LUMP_SUM_IND | Indicator for a Blanket Line | BBP_LUMP_SUM_IND | CHAR | 1 | XFELD | ||||
EXPSV_ITEM_TYPE | Item Variant | BBP_EXPRESSIVE_ITEM_TYPE | CHAR | 5 | BBP_EXPRESSIVE_ITEM_TYPE | ||||
COPY_OF_GUID | GUID Object is a Copy of | BBP_COPY_OF_GUID | RAW | 16 | SYSUUID | ||||
EXLIN | Configurable Line Item Number | /SAPSRM/EXLIN | CHAR | 40 | /SAPSRM/EXLIN | ||||
ACC_STAT_SUS | Acceptance Status for SUS | BBP_SUS_ACCEPT_STAT_CODE | CHAR | 1 | BBP_SUS_ACCEPT_STAT_CODE | ||||
PR_UNIT | Unit of Measurement | BBP_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
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 | Name of Person Responsible for Changing Object | BBP_CHNAM | CHAR | 12 | USNAM | ||||
CHANGED_AT | Time of Last Change to the Transaction | CRMT_CHANGED_AT | DEC | 15 | TSTPS | BCOS_TSTMP | |||
DUMMY_EEW_PD_IT_SWD_SUSCF | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
DUMMY_EEW_PD_IT_CSD_SUSCF | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
PO_REF_DOC_NO | Reference Document Number | BBP_XBLNR | CHAR | 16 | XBLNR | ||||
PO_ITEM_NUMBER | External Item Number | BBP_ITEM_NO_EXT | NUMC | 10 | |||||
GR_REF_DOC_NO | Reference Document Number | BBP_XBLNR | CHAR | 16 | XBLNR | ||||
GR_ITEM_NUMBER | External Item Number | BBP_ITEM_NO_EXT | NUMC | 10 | |||||
GR_QUANTITY | Quantity in Order Unit | BBP_MNG | QUAN | 13(3) | MENG13 | ||||
GR_UNIT | Unit of Measurement | BBP_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ORDERED_QUAN | 0 | ||||||||
ORDERED_UNIT | Unit of Measurement | BBP_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OPEN_QUAN | 0 | ||||||||
OPEN_UNIT | Unit of Measurement | BBP_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS |
Key field | Non-key field |
How do I retrieve data from SAP structure /SAPSRM/S_CLL_SUSCONF_ITEM using ABAP code?
As /SAPSRM/S_CLL_SUSCONF_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 /SAPSRM/S_CLL_SUSCONF_ITEM as there is no data to select.How to access SAP table /SAPSRM/S_CLL_SUSCONF_ITEM
Within an ECC or HANA version of SAP you can also view further information about /SAPSRM/S_CLL_SUSCONF_ITEM 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