CRMT_SALES_FIELDCAT_ITEM SAP (Collective Sales Item Fields for Locator) Structure details

Dictionary Type: Structure
Description: Collective Sales Item Fields for Locator




ABAP Code to SELECT data from CRMT_SALES_FIELDCAT_ITEM
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_INTItem Number in Document CRMT_ITEM_NONUMC10CRM_ITEM_NO
NUMBER_EXTExternal Item Number CRMT_ITEM_NO_EXTNUMC10
ORDERED_PRODProduct Name Entered CRMT_ORDERED_PRODCHAR54CRM_ORDERED_PRODCRM_ORDERED_PRODUCT
DESCRIPTION_UCProduct Description in Uppercase for F4 Help COMT_PRSHTEXTGCHAR40PRSHTEXTG40
PARTNER_PRODProduct Number of Business Partner CRMT_ITEM_DESCR_PARTNERCHAR40PRSHTEXT40
CHANGED_ATTime of Last Change to the Transaction CRMT_CHANGED_ATDEC15TSTPSBCOS_TSTMP
CREATED_ATTransaction was Created at this Time CRMT_CREATED_ATDEC15TSTPSBCOS_TSTMP
CHANGED_AT_DATEDate on Which Transaction Was Last Changed CRMT_CHANGED_AT_DATEDATS8SYDATS
CREATED_AT_DATETransaction Was Created on This Date CRMT_CREATED_AT_DATEDATS8SYDATS
CREATED_BYUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
SALES_ORGSales Organization CRMT_SALES_ORGCHAR14HROBJEC_14CRM_ORGMAN_SALES_ORG
DIS_CHANNELDistribution Channel CRMT_DISTRIBUTION_CHANNELCHAR2Assigned to domainCRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNEL
DIVISIONDivision CRMT_DIVISIONCHAR2Assigned to domainCRM_DIVISIONCRM_DIVISION
SALES_OFFICESales Office CRMT_SALES_OFFICECHAR14HROBJEC_14CRM_ORGMAN_SALES_OFFICE
SALES_GROUPSales Group CRMT_SALES_GROUPCHAR14HROBJEC_14CRM_ORGMAN_SALES_GROUP
SOLD_TO_PARTYSold-To Party CRMT_SOLD_TO_PARTCHAR10Assigned to domainALPHABU_PARTNER
SHIP_TO_PARTYShip-To Party CRMT_SHIP_TO_PARTCHAR10Assigned to domainALPHABU_PARTNER
BILL_TO_PARTYBill-To Party CRMT_BILL_TO_PARTCHAR10Assigned to domainALPHABU_PARTNER
PAYERPayer CRMT_RP_PAYERCHAR10Assigned to domainALPHABU_PARTNER
SOLD_TO_PARTY_LISTSold-To Party CRMT_SOLD_TO_PART_LISTCHAR80TEXT80
SHIP_TO_PARTY_LISTShip-To Party: Name CRMT_SHIP_TO_PART_LISTCHAR80TEXT80
BILL_TO_PARTY_LISTBill-To Party: Name CRMT_BILL_TO_PART_LISTCHAR80TEXT80
PAYER_LISTPayer: Name CRMT_RP_PAYER_LISTCHAR80TEXT80
CONTACT_PERSONCustomer Contact Person CRMT_CONTACT_PERSONCHAR10Assigned to domainALPHABU_PARTNER
PMNTTRMSTerms of Payment CRMT_PMNTTRMSCHAR4Assigned to domainCRM_PMNTTRMS
INCOTERMS1Incoterms (Part 1) CRMT_INCOTERMS1CHAR3Assigned to domainCRM_INCOTERMS1
INCOTERMS2Incoterms (Part 2) CRMT_INCOTERMS2CHAR28CRM_INCOTERMS2
SHIP_CONDShipping Conditions CRMT_SHIP_CONDCHAR2Assigned to domainCRM_SHIP_COND
PO_NUMBER_SOLDSold-To Party's External Reference Number CRMT_PO_NUMBER_SOLDCHAR35TEXT35
YOUR_REF_SOLDSold-to Party Reference CRMT_MASS_YOUR_REFERENCE_SOLDCHAR12TEXT12
PO_NUMBER_SHIPShip-To Party's External Reference Number CRMT_PO_NUMBER_SHIPCHAR35TEXT35
PO_DATE_SHIPShip-To Party's Reference Document Date CRMT_PO_DATE_SHIPDATS8DATUM
YOUR_REF_SHIPShip-To Party Reference CRMT_MASS_YOUR_REFERENCE_SHIPCHAR12TEXT12
PO_DATE_SOLDReference Document Date CRMT_PO_DATE_SOLDDATS8DATUM
SUBMISSIONCollective Number for Quotations CRMT_SUBMISSIONCHAR10TEXT10
PRODUCT_IDProduct Name Entered CRMT_ORDERED_PRODCHAR54CRM_ORDERED_PRODCRM_ORDERED_PRODUCT
CATEGORY_IDCategory ID COMT_CATEGORY_IDCHAR20COM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIER
CATALOG_IDCatalog ID, from Which the Line PPR Was Selected CATALOG_PLCHAR20Assigned to domainKATALOGID
CATALOG_ITEMCatalog Item (Unique Key) CRMT_CATALOGITEMCHAR40CRM_CATALOGITEM
DESCRIPT_PARTNER_PURProduct Number of Business Partner CRMT_ITEM_DESCR_PARTNERCHAR40PRSHTEXT40
INSTALL_ATInstalled At CRMT_INSTALL_AT_PARTCHAR10Assigned to domainALPHABU_PARTNER
INSTALL_AT_LISTInstalled At - Name CRMT_INSTALL_AT_LISTCHAR80CHAR80
RESPONS_AT_PARTNERPerson Responsible at Partners (Channel Management) CRMT_RESPONSIBLE_AT_PARTNERCHAR10Assigned to domainALPHABU_PARTNER
END_CUSTOMEREnd Customer (Channel Management) CRMT_END_CUSTOMERCHAR10Assigned to domainALPHABU_PARTNER
RESP_AT_PARTPerson Responsible at Partners (Channel Management) CRMT_RESPONSIBLE_AT_PARTNERCHAR10Assigned to domainALPHABU_PARTNER
REJECTIONCancellation Reason Code CRMT_REJECTION_CODECHAR2Assigned to domainCRM_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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!