CRMT_SALES_FIELDCAT_ITEM SAP (Collective Sales Item Fields for Locator) Structure details
Description: Collective Sales Item Fields for Locator
Related tables to CRMT_SALES_FIELDCAT_ITEM
Access table CRMT_SALES_FIELDCAT_ITEM
Structure field list including key, data, relationships and ABAP select examples
CRMT_SALES_FIELDCAT_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 "Collective Sales Item Fields for Locator" 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_SALES_FIELDCAT_ITEM TYPE CRMT_SALES_FIELDCAT_ITEM.
The CRMT_SALES_FIELDCAT_ITEM table consists of various fields, each holding specific information or linking keys about Collective Sales Item Fields for Locator data available in SAP. These include NUMBER_EXT (External Item Number), ORDERED_PROD (Product Name Entered), DESCRIPTION_UC (Product Description in Uppercase for F4 Help), PARTNER_PROD (Product Number of Business Partner).. 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_SALES_FIELDCAT_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 |
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 |
Key field | Non-key field |
How do I retrieve data from SAP structure CRMT_SALES_FIELDCAT_ITEM using ABAP code?
As CRMT_SALES_FIELDCAT_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_SALES_FIELDCAT_ITEM as there is no data to select.How to access SAP table CRMT_SALES_FIELDCAT_ITEM
Within an ECC or HANA version of SAP you can also view further information about CRMT_SALES_FIELDCAT_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