CRMT_LOCA_STR_SALES_ITEM SAP (Field Catalog: Fields for Sales Display: Item View) Structure details
Description: Field Catalog: Fields for Sales Display: Item View
Related tables to CRMT_LOCA_STR_SALES_ITEM
Access table CRMT_LOCA_STR_SALES_ITEM
Structure field list including key, data, relationships and ABAP select examples
CRMT_LOCA_STR_SALES_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 "Field Catalog: Fields for Sales Display: Item View" 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_CRMT_LOCA_STR_SALES_ITEM TYPE CRMT_LOCA_STR_SALES_ITEM.
The CRMT_LOCA_STR_SALES_ITEM table consists of various fields, each holding specific information or linking keys about Field Catalog: Fields for Sales Display: Item View data available in SAP. These include OBJECT_ID (Transaction ID), DESCRIPTION (Transaction Description), PROCESS_TYPE (Business Transaction Type), PROCESS_TYPE_TXT (Text Description for Transaction Category).. 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 (character-type or numeric)
SAP CRMT_LOCA_STR_SALES_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 |
OBJECT_ID | Transaction ID | CRMT_OBJECT_ID | CHAR | 10 | ALPHA | CRM_OBJECT_ID | CRM_OBJECT_ID | CRM_ORDER_OBJECT_ID | |
DESCRIPTION | Transaction Description | CRMT_PROCESS_DESCRIPTION | CHAR | 40 | CRM_PROCESS_DESCRIPTION | ||||
PROCESS_TYPE | Business Transaction Type | CRMT_PROCESS_TYPE | CHAR | 4 | Assigned to domain | CRM_PROCESS_TYPE | CRM_PROCESS_TYPE | CRM_PROCESS_TYPE | |
PROCESS_TYPE_TXT | Text Description for Transaction Category | CRMT_REPORT_PROCESS_TYPE_TXT | CHAR | 60 | DDTEXT | ||||
CONCATSTAT | System status line | J_STEXT | CHAR | 40 | TEXT40 | ||||
CONCATSTATUSER | System status line | J_STEXT | CHAR | 40 | TEXT40 | ||||
NUMBER_INT | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
NUMBER_EXT | External Item Number | CRMT_ITEM_NO_EXT | NUMC | 10 | |||||
ORDERED_PROD | Product Name Entered | CRMT_ORDERED_PROD | CHAR | 54 | CRM_ORDERED_PROD | CRM_ORDERED_PRODUCT | |||
DESCRIPTION_UC | Product Description in Uppercase for F4 Help | COMT_PRSHTEXTG | CHAR | 40 | PRSHTEXTG40 | ||||
PARTNER_PROD | Product Number of Business Partner | CRMT_ITEM_DESCR_PARTNER | CHAR | 40 | PRSHTEXT40 | ||||
CHANGED_AT | Time of Last Change to the Transaction | CRMT_CHANGED_AT | DEC | 15 | TSTPS | BCOS_TSTMP | |||
CREATED_AT | Transaction was Created at this Time | CRMT_CREATED_AT | DEC | 15 | TSTPS | BCOS_TSTMP | |||
CHANGED_AT_DATE | Date on Which Transaction Was Last Changed | CRMT_CHANGED_AT_DATE | DATS | 8 | SYDATS | ||||
CREATED_AT_DATE | Transaction Was Created on This Date | CRMT_CREATED_AT_DATE | DATS | 8 | SYDATS | ||||
CREATED_BY | User that Created the Transaction | CRMT_CREATED_BY | CHAR | 12 | UNAME | USER_ADDR | |||
SALES_ORG | Sales Organization | CRMT_SALES_ORG | CHAR | 14 | HROBJEC_14 | CRM_ORGMAN_SALES_ORG | |||
DIS_CHANNEL | Distribution Channel | CRMT_DISTRIBUTION_CHANNEL | CHAR | 2 | Assigned to domain | CRM_DISTRIBUTION_CHANNEL | CRM_ORGMAN_DIS_CHANNEL | ||
DIVISION | Division | CRMT_DIVISION | CHAR | 2 | Assigned to domain | CRM_DIVISION | CRM_DIVISION | ||
SALES_OFFICE | Sales Office | CRMT_SALES_OFFICE | CHAR | 14 | HROBJEC_14 | CRM_ORGMAN_SALES_OFFICE | |||
SALES_GROUP | Sales Group | CRMT_SALES_GROUP | CHAR | 14 | HROBJEC_14 | CRM_ORGMAN_SALES_GROUP | |||
SOLD_TO_PARTY | Sold-To Party | CRMT_SOLD_TO_PART | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
SHIP_TO_PARTY | Ship-To Party | CRMT_SHIP_TO_PART | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
BILL_TO_PARTY | Bill-To Party | CRMT_BILL_TO_PART | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
PAYER | Payer | CRMT_RP_PAYER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
SOLD_TO_PARTY_LIST | Sold-To Party | CRMT_SOLD_TO_PART_LIST | CHAR | 80 | TEXT80 | ||||
SHIP_TO_PARTY_LIST | Ship-To Party: Name | CRMT_SHIP_TO_PART_LIST | CHAR | 80 | TEXT80 | ||||
BILL_TO_PARTY_LIST | Bill-To Party: Name | CRMT_BILL_TO_PART_LIST | CHAR | 80 | TEXT80 | ||||
PAYER_LIST | Payer: Name | CRMT_RP_PAYER_LIST | CHAR | 80 | TEXT80 | ||||
CONTACT_PERSON | Customer Contact Person | CRMT_CONTACT_PERSON | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
PMNTTRMS | Terms of Payment | CRMT_PMNTTRMS | CHAR | 4 | Assigned to domain | CRM_PMNTTRMS | |||
INCOTERMS1 | Incoterms (Part 1) | CRMT_INCOTERMS1 | CHAR | 3 | Assigned to domain | CRM_INCOTERMS1 | |||
INCOTERMS2 | Incoterms (Part 2) | CRMT_INCOTERMS2 | CHAR | 28 | CRM_INCOTERMS2 | ||||
SHIP_COND | Shipping Conditions | CRMT_SHIP_COND | CHAR | 2 | Assigned to domain | CRM_SHIP_COND | |||
PO_NUMBER_SOLD | Sold-To Party's External Reference Number | CRMT_PO_NUMBER_SOLD | CHAR | 35 | TEXT35 | ||||
YOUR_REF_SOLD | Sold-to Party Reference | CRMT_MASS_YOUR_REFERENCE_SOLD | CHAR | 12 | TEXT12 | ||||
PO_NUMBER_SHIP | Ship-To Party's External Reference Number | CRMT_PO_NUMBER_SHIP | CHAR | 35 | TEXT35 | ||||
PO_DATE_SHIP | Ship-To Party's Reference Document Date | CRMT_PO_DATE_SHIP | DATS | 8 | DATUM | ||||
YOUR_REF_SHIP | Ship-To Party Reference | CRMT_MASS_YOUR_REFERENCE_SHIP | CHAR | 12 | TEXT12 | ||||
PO_DATE_SOLD | Reference Document Date | CRMT_PO_DATE_SOLD | DATS | 8 | DATUM | ||||
SUBMISSION | Collective Number for Quotations | CRMT_SUBMISSION | CHAR | 10 | TEXT10 | ||||
PRODUCT_ID | Product Name Entered | CRMT_ORDERED_PROD | CHAR | 54 | CRM_ORDERED_PROD | CRM_ORDERED_PRODUCT | |||
CATEGORY_ID | Category ID | COMT_CATEGORY_ID | CHAR | 20 | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | ||
CATALOG_ID | Catalog ID, from Which the Line PPR Was Selected | CATALOG_PL | CHAR | 20 | Assigned to domain | KATALOGID | |||
CATALOG_ITEM | Catalog Item (Unique Key) | CRMT_CATALOGITEM | CHAR | 40 | CRM_CATALOGITEM | ||||
DESCRIPT_PARTNER_PUR | Product Number of Business Partner | CRMT_ITEM_DESCR_PARTNER | CHAR | 40 | PRSHTEXT40 | ||||
INSTALL_AT | Installed At | CRMT_INSTALL_AT_PART | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
INSTALL_AT_LIST | Installed At - Name | CRMT_INSTALL_AT_LIST | CHAR | 80 | CHAR80 | ||||
RESPONS_AT_PARTNER | Person Responsible at Partners (Channel Management) | CRMT_RESPONSIBLE_AT_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
END_CUSTOMER | End Customer (Channel Management) | CRMT_END_CUSTOMER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
RESP_AT_PART | Person Responsible at Partners (Channel Management) | CRMT_RESPONSIBLE_AT_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
REJECTION | Cancellation Reason Code | CRMT_REJECTION_CODE | CHAR | 2 | Assigned to domain | CRM_REJECTION_CODE | |||
QUANTITY | CRM Schedule Line Quantity | CRMT_SCHEDLIN_QUAN | QUAN | 13(3) | MENG13 | ||||
PROCESS_QTY_UNIT | Unit of Measure in Which the Product Is Sold | CRMT_PROCESS_QTY_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CONCATSTAT_I | System status line | J_STEXT | CHAR | 40 | TEXT40 | ||||
CONCATSTATUSER_I | User Status Line | J_ATEXT | CHAR | 40 | TEXT40 | ||||
PRC_GROUP1 | Product Group 1 | CRMT_PRC_GROUP1 | CHAR | 3 | Assigned to domain | CRM_PRC_GROUP1 | |||
PRC_GROUP2 | Product Group 2 | CRMT_PRC_GROUP2 | CHAR | 3 | Assigned to domain | CRM_PRC_GROUP2 | |||
PRC_GROUP3 | Product Group 3 | CRMT_PRC_GROUP3 | CHAR | 3 | Assigned to domain | CRM_PRC_GROUP3 | |||
PRC_GROUP4 | Product Group 4 | CRMT_PRC_GROUP4 | CHAR | 3 | Assigned to domain | CRM_PRC_GROUP4 | |||
PRC_GROUP5 | Product Group 5 | CRMT_PRC_GROUP5 | CHAR | 3 | Assigned to domain | CRM_PRC_GROUP5 | |||
REF_CURRENCY | Reference Currency | CRMT_REF_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | |||
CURRENCY | Currency | CRMT_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
NET_VALUE | Net Value | CRMT_NET_VALUE | CURR | 15(2) | WERTV8 | ||||
PROD_HIERARCHY | Product Category | CRMT_PROD_HIERARCHY | CHAR | 20 | COM_CATEGORY_ID | COM_CAT_SALES | |||
BASE_QTY_UNIT | Base Unit of Measure of Product | COMT_PRODUCT_BASE_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
NET_WEIGHT | Net Weight | CRMT_NET_WEIGHT | QUAN | 15(3) | MENG15 | ||||
WEIGHT_UNIT | Weight Unit | COMT_WEIGHT_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PRODUCT_CATEGORY_TEXT | Category Description | COMT_CATEGORY_TEXT | CHAR | 80 | TEXT80 | ||||
NET_VALUE_MAN | Total Expected Net Value Products in Document Currency | CRMT_NET_VALUE_MAN | CURR | 15(2) | WERTV8 | ||||
BUAG_ID | Number of the Business Agreement | CRMT_BUAG_ID | CHAR | 12 | ALPHA | CRMT_BUAG_ID | CRM_BUAG | ||
BUAG_TEXT | Text for Business Agreement | CRMT_BUAG_TEXT | CHAR | 30 | CHAR30LOW | ||||
CUSTOMER_INT | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
CUSTOMER_EXT | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY |
Key field | Non-key field |
How do I retrieve data from SAP structure CRMT_LOCA_STR_SALES_ITEM using ABAP code?
As CRMT_LOCA_STR_SALES_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 CRMT_LOCA_STR_SALES_ITEM as there is no data to select.How to access SAP table CRMT_LOCA_STR_SALES_ITEM
Within an ECC or HANA version of SAP you can also view further information about CRMT_LOCA_STR_SALES_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