CRMT_SOURCING_WRK SAP (Sourcing Work Structure) Structure details

Dictionary Type: Structure
Description: Sourcing Work Structure




ABAP Code to SELECT data from CRMT_SOURCING_WRK
Related tables to CRMT_SOURCING_WRK
Access table CRMT_SOURCING_WRK




Structure field list including key, data, relationships and ABAP select examples

CRMT_SOURCING_WRK 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 "Sourcing Work Structure" 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_SOURCING_WRK TYPE CRMT_SOURCING_WRK.

The CRMT_SOURCING_WRK table consists of various fields, each holding specific information or linking keys about Sourcing Work Structure data available in SAP. These include ITM_TYPE (Item Category), ITM_USAGE (Usage of Higher-Level Item), PRODUCT (Internal Unique ID of Product), CATEGORY_GUID (Product 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_SOURCING_WRK 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
GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
ITM_TYPEItem Category CRMT_ITEM_TYPECHAR4Assigned to domainCRM_ITEM_TYPECRM_ITEM_TYPE
ITM_USAGEUsage of Higher-Level Item CRMT_ITEM_USAGECHAR2CRM_ITEM_USAGE
PRODUCTInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16SYSUUID
CATEGORY_GUIDProduct Category CRMT_PROD_HIERARCHYCHAR20COM_CATEGORY_IDCOM_CAT_SALES
PROD_PR_GROUPProduct Group CRMT_PROD_PR_GROUPCHAR2Assigned to domainCRM_PROD_PR_GROUP
PRC_GROUP1Product Group 1 CRMT_PRC_GROUP1CHAR3Assigned to domainCRM_PRC_GROUP1
PRC_GROUP2Product Group 2 CRMT_PRC_GROUP2CHAR3Assigned to domainCRM_PRC_GROUP2
PRC_GROUP3Product Group 3 CRMT_PRC_GROUP3CHAR3Assigned to domainCRM_PRC_GROUP3
PRC_GROUP4Product Group 4 CRMT_PRC_GROUP4CHAR3Assigned to domainCRM_PRC_GROUP4
PRC_GROUP5Product Group 5 CRMT_PRC_GROUP5CHAR3Assigned to domainCRM_PRC_GROUP5
COMM_GROUPCommission Group CRMT_COMM_GROUPCHAR2Assigned to domainCRM_COMM_GROUP
REBATE_GROUPVolume Rebate Group CRMT_REBATE_GROUPCHAR2Assigned to domainCRM_REBATE_GROUP
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_TOSold-to Party GUID CRMT_SOLD_TO_PARTYRAW16SYSUUID
SHIP_TOShip-to Party GUID CRMT_SHIP_TO_PARTYRAW16SYSUUID
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10Assigned to domainZONE
REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
CUST_GROUP1Customer Group 1 CRMT_CUST_GROUP1CHAR3Assigned to domainCRM_CUST_GROUP1
CUST_GROUP2Customer Group 2 CRMT_CUST_GROUP2CHAR3Assigned to domainCRM_CUST_GROUP2
CUST_GROUP3Dishonour Reason CRMT_CUST_GROUP3CHAR3Assigned to domainCRM_CUST_GROUP3
CUST_GROUP4Customer Group 4 CRMT_CUST_GROUP4CHAR3Assigned to domainCRM_CUST_GROUP4
CUST_GROUP5Customer Group 5 CRMT_CUST_GROUP5CHAR3Assigned to domainCRM_CUST_GROUP5
QUANTITYCRM Schedule Line Quantity CRMT_SCHEDLIN_QUANQUAN13(3) MENG13
QUANTITY_UNITUnit of Measure in Which the Product Is Sold CRMT_PROCESS_QTY_UNITUNIT3Assigned to domainCUNITMEINS
FROM_TIMEStart Time Stamp: Date EV_FR_TIMEDEC15TSTPSBCOS_TSTMP
FROM_TIMEZONEStart Time Zone: Date EV_FR_TIMEZONECHAR6Assigned to domainTZNZONE
TO_TIMEEnd Time Stamp: Date EV_TO_TIMEDEC15TSTPSBCOS_TSTMP
TO_TIMEZONEEnd Time Zone: Date EV_TO_TIMEZONECHAR6Assigned to domainTZNZONE
INCOTERMS1Incoterms (Part 1) CRMT_INCOTERMS1CHAR3Assigned to domainCRM_INCOTERMS1
INCOTERMS2Incoterms (Part 2) CRMT_INCOTERMS2CHAR28CRM_INCOTERMS2
SHIP_CONDShipping Conditions CRMT_SHIP_CONDCHAR2Assigned to domainCRM_SHIP_COND
DLV_PRIODelivery Priority CRMT_DLV_PRIONUMC2Assigned to domainCRM_DLV_PRIOCRM_DELIVERY_PRIORITY
PART_DLVDelivery Control CRMT_PART_DLVCHAR1CRM_PART_DLV
DLV_GROUPDelivery Group (Items are Delivered Together) CRMT_DLV_GROUPNUMC3CRMT_DLV_GROUP

Key field Non-key field



How do I retrieve data from SAP structure CRMT_SOURCING_WRK using ABAP code?

As CRMT_SOURCING_WRK 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_SOURCING_WRK as there is no data to select.

How to access SAP table CRMT_SOURCING_WRK

Within an ECC or HANA version of SAP you can also view further information about CRMT_SOURCING_WRK 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!