TRCOS_CTY_MASTER_DATA SAP (Commodity master data) Structure details
Description: Commodity master data
Related tables to TRCOS_CTY_MASTER_DATA
Access table TRCOS_CTY_MASTER_DATA
Structure field list including key, data, relationships and ABAP select examples
TRCOS_CTY_MASTER_DATA 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 "Commodity master 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_TRCOS_CTY_MASTER_DATA TYPE TRCOS_CTY_MASTER_DATA.
The TRCOS_CTY_MASTER_DATA table consists of various fields, each holding specific information or linking keys about Commodity master data data available in SAP. These include COMMODITY_NAME (Name of the Commodity), COMMODITY_KIND (Commodity Kind), COMMODITY_TYPE (Type of Commodity), COMMODITY_CAT (Commodity 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: Cannot Be Enhanced
SAP TRCOS_CTY_MASTER_DATA 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 |
| COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | ||
| COMMODITY_NAME | Name of the Commodity | TPM_CTY_NAME | CHAR | 40 | TPM_CTY_NAME | ||||
| COMMODITY_KIND | Commodity Kind | TPM_CTY_KIND_OUTPUT | CHAR | 20 | TEXT20 | ||||
| COMMODITY_TYPE | Type of Commodity | TPM_CTY_TYPE_OUTPUT | CHAR | 30 | TEXT30 | ||||
| COMMODITY_CAT | Commodity Category | TPM_CTY_CAT_OUTPUT | CHAR | 30 | TEXT30 | ||||
| COMMODITY_UOM | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| CURRENCY_UNIT | Currency Unit for Commodity | TCR_CTY_CURRUNIT | CHAR | 5 | Assigned to domain | VVSRUNIT | |||
| DEFAULT_CURRENCY | Currency for the Commodity Deal | TPM_CTY_DEFAULT_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
| STATUS | Commodity Status | TPM_CTY_STAT | CHAR | 20 | TPM_CTY_STAT | ||||
| LOCATION | Pricing Location Text (Short) | TPM_LOCATION_STEXT | CHAR | 20 | TEXT20 | ||||
| INCOTERMS | Incoterm Text | TPM_INCOTERMS_TEXT | CHAR | 60 | TEXT60 | ||||
| PARENT_CTY_ID | Parent Commodity ID | TPM_PARENT_CTY_ID | CHAR | 18 | TPM_CTY_ID | ||||
| PARENT_CTY_NAME | Name of the Commodity | TPM_CTY_NAME | CHAR | 40 | TPM_CTY_NAME | ||||
| GROUP1 | Commodity Group1 | TPM_CTY_GP1_OUTPUT | CHAR | 30 | TEXT30 | ||||
| GROUP2 | Commodity Group2 | TPM_CTY_GP2_OUTPUT | CHAR | 30 | TEXT30 | ||||
| QUOTNAME | Quotation Name | CPET_QUOTNAME | CHAR | 18 | CPE_QUOTNAME | CPE_QUOTNAME | |||
| ENTERED_BY | Entered by | TB_CRUSER | CHAR | 12 | SYCHAR12 | ||||
| ENTERED_DATE | Entered On | TB_DCRDAT | DATS | 8 | DATUM | ||||
| ENTERED_TIME | Entry Time | TB_TCRTIM | TIMS | 6 | UZEIT | ||||
| CHANGED_BY | Last Changed by | TB_UPUSER | CHAR | 12 | SYCHAR12 | ||||
| CHANGED_DATE | Changed on | TB_DUPDAT | DATS | 8 | DATUM | ||||
| CHANGED_TIME | Time changed | TB_TUPTIM | TIMS | 6 | UZEIT |
| Key field | Non-key field |
How do I retrieve data from SAP structure TRCOS_CTY_MASTER_DATA using ABAP code?
As TRCOS_CTY_MASTER_DATA 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 TRCOS_CTY_MASTER_DATA as there is no data to select.How to access SAP table TRCOS_CTY_MASTER_DATA
Within an ECC or HANA version of SAP you can also view further information about TRCOS_CTY_MASTER_DATA 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