TRCOT_CTY_MASTER SAP (Commodity master data) Table details

Dictionary Type: Table
Description: Commodity master data




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




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

TRCOT_CTY_MASTER is a standard SAP Table which is used to store Commodity master data data and is available within R/3 SAP systems depending on the version and release level.

The TRCOT_CTY_MASTER table consists of various fields, each holding specific information or linking keys about Commodity master data data available in SAP. These include COMMODITY_ID (Commodity ID), COMMODITY_CAT (Commodity Category), COMMODITY_TYPE (Type of Commodity), COMMODITY_NAME (Name of the Commodity).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP TRCOT_CTY_MASTER table 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
COMMODITY_CATCommodity Category TPM_CTY_CATCHAR3TRCOTS_CTY_CATALPHATPM_CTY_CAT
COMMODITY_TYPEType of Commodity TPM_CTY_TYPECHAR3Assigned to domainALPHATPM_CTY_TYPEF4_CTY_TYPE
COMMODITY_NAMEName of the Commodity TPM_CTY_NAMECHAR40TPM_CTY_NAME
COMMODITY_UOMUnit of Measure for the Commodity TPM_CTY_UOMUNIT3T006CUNITMEINS
CURRENCY_UNITCurrency Unit for Commodity TCR_CTY_CURRUNITCHAR5TZUNIVVSRUNIT
DEFAULT_CURRENCYCurrency for the Commodity Deal TPM_CTY_DEFAULT_CURRCUKY5TCURCWAERS
ACTIVEIndicates whether the commodity is active TPM_CTY_ACTIVECHAR1BOOLE
GROUP1Commodity Group1 TPM_CTY_GP1CHAR3ALPHATPM_CTY_GP1F4_CTY_GROUP1
GROUP2Commodity Group2 TPM_CTY_GP2CHAR3ALPHATPM_CTY_GP2F4_CTY_GROUP2
QUOTNAMECommodities: Quotation Name TCR_CTY_QUOTNAMECHAR18TRCOCC_QUOTNAMTCR_CTY_QUOTNAME
ENTERED_BYEntered by TB_CRUSERCHAR12SYCHAR12
ENTERED_DATEEntered On TB_DCRDATDATS8DATUM
ENTERED_TIMEEntry Time TB_TCRTIMTIMS6UZEIT
CHANGED_BYLast Changed by TB_UPUSERCHAR12SYCHAR12
CHANGED_DATEChanged on TB_DUPDATDATS8DATUM
CHANGED_TIMETime changed TB_TUPTIMTIMS6UZEIT
LOCATIONPricing Location TPM_DEL_LOCATIONCHAR4TRCOT_CTY_DELLOCTPM_DEL_LOCATION
COMMODITY_KINDCommodity Kind TPM_CTY_KINDINT13TPM_CTY_KIND
PARENT_CTY_IDParent Commodity ID TPM_PARENT_CTY_IDCHAR18TRCOT_CTY_MASTERTPM_CTY_ID
REF_COMMODITY_IDReference Commodity ID TPM_COMM_ID_REFCHAR18TPM_CTY_ID
INCOTERMSInternational Commercial Terms TPM_INCOTERMSCHAR3TRCOC_INCOTERMSTPM_INCOTERMS
PHYSCOMMPhysical Commodity TBA_STOEFFCHENCHAR18TBAC_PHYSCOMMTBA_STOEFFCHEN

Key field Non-key field



How do I retrieve data from SAP table TRCOT_CTY_MASTER using ABAP code

The following ABAP code Example will allow you to do a basic selection on TRCOT_CTY_MASTER to SELECT all data from the table
DATA: WA_TRCOT_CTY_MASTER TYPE TRCOT_CTY_MASTER.

SELECT SINGLE *
FROM TRCOT_CTY_MASTER
INTO CORRESPONDING FIELDS OF WA_TRCOT_CTY_MASTER
WHERE...

How to access SAP table TRCOT_CTY_MASTER

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