/SAPSRM/S_CLL_AUC_ITEM SAP (AUC Item Data) Structure details
Description: AUC Item Data
Related tables to /SAPSRM/S_CLL_AUC_ITEM
Access table /SAPSRM/S_CLL_AUC_ITEM
Structure field list including key, data, relationships and ABAP select examples
/SAPSRM/S_CLL_AUC_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 "AUC 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_AUC_ITEM TYPE /SAPSRM/S_CLL_AUC_ITEM.
The /SAPSRM/S_CLL_AUC_ITEM table consists of various fields, each holding specific information or linking keys about AUC 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_AUC_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 | |||||
PRODUCT | Product GUID | BBP_PRODUCT | RAW | 16 | SYSUUID | ||||
DESCRIPTION | Item Description | BBP_ITEM_DESC | CHAR | 40 | TEXT40 | ||||
CATEGORY | Category GUID | COMT_CATEGORY_GUID | RAW | 16 | SYSUUID | ||||
CATEGORY_ID | Category ID | COMT_CATEGORY_ID | CHAR | 20 | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | ||
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 | ||||
MANU_PROD | Manufacturer Part Number | MFRPN | CHAR | 40 | CHAR40 | ||||
MFR_NO_EXT | External manufacturer code name or number | EMNFR | CHAR | 10 | CHAR10 | ||||
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 | |||||
QUANTITY | Quantity in Order Unit | BBP_MNG | QUAN | 13(3) | MENG13 | ||||
UNIT | Unit of Measurement | BBP_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DEL_IND | Deletion Indicator SRM Purchasing Document | BBP_DEL_IND | CHAR | 1 | XFELD | ||||
ORDERED_PROD | Product Name Entered | CRMT_ORDERED_PROD_DB | CHAR | 54 | CRM_ORDERED_PROD | ||||
PRODUCT_SRC_SYS | Business Document Service: ID of Logical System | BBP_LOGSYS | CHAR | 10 | CHAR10 | ||||
PRICE | Net Price | BBP_PRICE | CURR | 13(2) | WERT7 | ||||
PRICE_UNIT | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
SUBTYPE | Specification Purchase Item (e.g. Direct Material/Hierarch.) | BBP_I_SUBTYPE | CHAR | 2 | BBP_I_SUBTYPE | ||||
GROUPING_LEVEL | Specifies How Hierarchy Positions are to be Managed | BBP_GROUPING_LEVEL | CHAR | 1 | BBP_GROUPING_LEVEL | ||||
DEL_DATCAT | Date type (day, week, month, interval) | LPEIN_INT | CHAR | 1 | PRGRS | ||||
START_PRICE | Auction Start Price | BBP_START_PRICE | CURR | 13(2) | WERT7 | ||||
RESERVED_PRICE | Reserve Price of an Auction | BBP_RESERVE_PRICE | CURR | 13(2) | WERT7 | ||||
BID_DECR_AMOUNT | Absolute Bid Decrement | BBP_DECREMENT_AMOUNT | CURR | 13(2) | WERT7 | ||||
BID_DECR_PERCENT | Percentage Bid Decrement | BBP_DECREMENT_PERCENT | DEC | 5(2) | BBP_PERCNT_PI | ||||
REFERENCE_PRICE | Reference Price of an Item in Auctions | BBP_REF_PRICE | CURR | 13(2) | WERT7 | ||||
DELIV_DATE | Item Delivery Date | EINDT | DATS | 8 | DATUM | ||||
DELIV_TIME | Delivery Time of the Item | BBP_DELIV_TIME | TIMS | 6 | TIME | ||||
EXT_DEMID | External Requirement Number | BBP_EXT_DEMID | CHAR | 32 | CHAR32 | ||||
EXT_DEM_POSID | External Requirement Tracking Number | BBP_EXT_DEM_POSID | CHAR | 32 | CHAR32 | ||||
DP_STGE_LOC | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
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 | ||||
PRODUCT_TYPE | Product Type | COMT_PRODUCT_TYPE | CHAR | 2 | Assigned to domain | COM_PRODUCT_TYPE | COM_PRODUCT_TYPE | COM_PR_TYPE_ACTIVE | |
VPER_START | Timeframe From | BBP_VPER_START | DATS | 8 | DATUM | ||||
VPER_END | Timeframe To | BBP_VPER_END | DATS | 8 | DATUM | ||||
VPER_TYPE | Delivery Date Type (From-Date, To-Date, Timeframe ...) | BBP_VPER_TYPE | CHAR | 2 | /SAPSRM/VPER_TYPE | ||||
DUMMY_EEW_PDISS_AUC | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
ICC_BR_STEUC | Brazilian NCM Code | ITL_NCM | CHAR | 16 | CRMC_TAX_TCODE | CHAR16 | |||
ICC_BR_MATUSE | Material Usage | ITL_MAT_USAGE | CHAR | 1 | ITL_MAT_USAGE | ||||
ICC_BR_MATORG | Origin of the material | ITL_NF_MATORG | CHAR | 1 | ITL_NF_MATORG | ||||
ICC_BR_OWNPRO | Produced in-house | ITL_OWNPRO | CHAR | 1 | XFELD | ||||
ICC_BR_INDUST | Material CFOP category | ITL_NF_INDUS3 | CHAR | 2 | ITL_NF_INDUS3 | ||||
.INCLU--AP | 0 | ||||||||
ICC_BR_TAXCODE | Tax Code for Brazil | ITL_TCODE | CHAR | 2 | CHAR2 | BBP_ICC_TCODE_CTRY | |||
ICC_BR_TAXAMT | Tax Amount | BBP_TAX_AMOUNT | CURR | 15(2) | WERT8 | ||||
ICC_BR_TAXDES | Enterprise Buyer: Tax Code Description | BBPTAX_DES | CHAR | 50 | TEXT50 | ||||
DUMMY_EEW_PDISC_AUC | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
ACTUAL_EXTENSION | Current Number of Extensions to an Auction /Auction Item | BBP_EXT_CURRENT | INT4 | 10 | INT4 | ||||
END_TIME | Time Stamp f. Submissn Deadline | BBP_END_TIMESTP | DEC | 15 | TSTPS | BCOS_TSTMP | |||
SELECTED_FOR_ACTION | Indicator: If Item is Selected on UI | BBP_SELECTED_FOR_ACTION | CHAR | 1 | CHAR1 | ||||
COPY_OF_GUID | GUID Object is a Copy of | BBP_COPY_OF_GUID | RAW | 16 | SYSUUID | ||||
PRICE_INCREMENT | Price increment | BBP_PRICE_INCREMENT | CURR | 13(2) | WERT7 | ||||
TIME_INCREMENT | Time Increment | BBP_TIME_INCREMENT | INT4 | 10 | INT4 | ||||
CEILING_PRICE | Ceiling Price | BBP_CEILING_PRICE | CURR | 13(2) | WERT7 | ||||
ACTIVE_TIME | Auction Active Time | BBP_ACTIVE_TIME | DEC | 21(7) | TZNTSTMPL | ||||
PAUSE_TIME | Time Stamp for Pause/Resume Time | BBP_PAUSE_TIMESTP | DEC | 15 | TSTPS | BCOS_TSTMP | |||
EXLIN | Configurable Line Item Number | /SAPSRM/EXLIN | CHAR | 40 | /SAPSRM/EXLIN | ||||
REV_LEV | Revision Level | CC_REVLV | CHAR | 2 | NUMCV | CC_REVLV | RVS | ||
VALUE | Net Value | BBP_VALUE | CURR | 15(2) | WERT8 | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
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_AUC | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
DUMMY_EEW_PD_IT_CSD_AUC | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
P_GUID | Globally Unique identifier | BBP_GUID | RAW | 16 | SYSUUID | ||||
NUMBER_ATTACHMENTS | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
NUMBER_NOTES | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
PRODUCT_TYPE_DESC | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
CATEGORY_DESC | Category Description | COMT_CATEGORY_TEXT | CHAR | 80 | TEXT80 | ||||
UNIT_DESC | Description of Unit of Measurement | BBP_UNIT_DESC | CHAR | 40 | CHAR40 | ||||
VPER_TYPE_DESC | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
LOT_INDI | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
POS_TYPE_CELL_VAR | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
ITEM_CATEGORY_KEY | Item Category Key for Auction | /SAPSRM/D_ITEM_CATEGORY_KEY | CHAR | 2 | /SAPSRM/ITEM_CATEGORY_KEY | ||||
ITEM_LEVEL_CELL_VAR | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
PRODUCT_ID | Product Name Entered | CRMT_ORDERED_PROD_DB | CHAR | 54 | CRM_ORDERED_PROD | ||||
LOT_MARK | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1 | BOOLE | ||||
NUMBER_ATTACH_BDR | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
NUMBER_NOTES_BDR | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
NUMBER_ATTACH_ALL | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
NUMBER_NOTES_ALL | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
VENDOR_PN | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
ITEM_VALUE | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
REVLV | Revision Level | CC_REVLV | CHAR | 2 | NUMCV | CC_REVLV | RVS | ||
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 | ||||
NOT_SELECTABLE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1 | BOOLE | ||||
SH_LOGSYS | Original System | COMT_LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | COM_LOGSYS | COM_PRODUCT_LOGSYS |
CELL_VAR_DEL_DATE | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure /SAPSRM/S_CLL_AUC_ITEM using ABAP code?
As /SAPSRM/S_CLL_AUC_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_AUC_ITEM as there is no data to select.How to access SAP table /SAPSRM/S_CLL_AUC_ITEM
Within an ECC or HANA version of SAP you can also view further information about /SAPSRM/S_CLL_AUC_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