SAP table TRCOT_CTY_MASTER (Commodity master data (obsolete))

SAP table TRCOT_CTY_MASTER has 2 primary key fields being MANDT,COMMODITY_ID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
COMMODITY_ID Commodity ID (obsolete) CHAR 18 0 TRCO_COMM_ID
COMMODITY_CAT Commodity Category CHAR 3 0 TRCOTS_CTY_CAT TPM_CTY_CAT
COMMODITY_TYPE Type of Commodity CHAR 3 0 TPM_CTY_TYPE
COMMODITY_NAME Name of the Commodity CHAR 40 0 TPM_CTY_NAME
COMMODITY_UOM Unit of Measure for the Commodity UNIT 3 0 T006 TPM_CTY_UOM
CURRENCY_UNIT Currency Unit for Commodity CHAR 5 0 TZUNI TCR_CTY_CURRUNIT
DEFAULT_CURRENCY Currency for the Commodity Deal CUKY 5 0 TCURC TPM_CTY_DEFAULT_CURR
ACTIVE Indicates whether the commodity is active CHAR 1 0 TPM_CTY_ACTIVE
GROUP1 Commodity Group1 CHAR 3 0 TPM_CTY_GP1
GROUP2 Commodity Group2 CHAR 3 0 TPM_CTY_GP2
QUOTNAME Commodities: Quotation Name CHAR 18 0 TRCOCC_QUOTNAM TCR_CTY_QUOTNAME
ENTERED_BY Entered By CHAR 12 0 TB_CRUSER
ENTERED_DATE Entered On DATS 8 0 TB_DCRDAT
ENTERED_TIME Entry Time TIMS 6 0 TB_TCRTIM
CHANGED_BY Last Changed By CHAR 12 0 TB_UPUSER
CHANGED_DATE Changed On DATS 8 0 TB_DUPDAT
CHANGED_TIME Time Changed TIMS 6 0 TB_TUPTIM
LOCATION Pricing Location CHAR 4 0 TRCOT_CTY_DELLOC TPM_DEL_LOCATION
COMMODITY_KIND Commodity Kind INT1 3 0 TPM_CTY_KIND
000 Abstract Commodity
001 Commodity
PARENT_CTY_ID Parent Commodity ID CHAR 18 0 TRCOT_CTY_MASTER TPM_PARENT_CTY_ID
REF_COMMODITY_ID Reference Commodity ID CHAR 18 0 TPM_COMM_ID_REF
INCOTERMS International Commercial Terms CHAR 3 0 TRCOC_INCOTERMS TPM_INCOTERMS
PHYSCOMM Commodity CHAR 18 0 TBAC_PHYSCOMM TBA_STOEFFCHEN

TRCOT_CTY_MASTER foreign key relationships

Table Field Check Table Check Field
0 TRCOT_CTY_MASTER COMMODITY_UOM T006 Units of Measurement MANDT
1 TRCOT_CTY_MASTER CURRENCY_UNIT TZUNI Currency units MANDT
1 TRCOT_CTY_MASTER CURRENCY_UNIT TZUNI Currency units SRUNIT
0 TRCOT_CTY_MASTER DEFAULT_CURRENCY TCURC Currency Codes MANDT
0 TRCOT_CTY_MASTER DEFAULT_CURRENCY TCURC Currency Codes WAERS
1 TRCOT_CTY_MASTER INCOTERMS TRCOC_INCOTERMS International Commercial Terms (InCoTerms) MANDT
0 TRCOT_CTY_MASTER LOCATION TRCOT_CTY_DELLOC Pricing Location Table MANDT
1 TRCOT_CTY_MASTER PARENT_CTY_ID TRCOT_CTY_MASTER Commodity master data (obsolete) COMMODITY_ID
0 TRCOT_CTY_MASTER PHYSCOMM TBAC_PHYSCOMM Customizing table for physical commodities COMMODITY