SAP Table TRCOT_CTY_MASTER
Commodity master data
TRCOT_CTY_MASTER (Commodity master data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TRCOT_CTY_MASTER to other SAP tables.
TRCOT_CTY_MASTER table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||
|
COMMODITY_ID
Commodity ID
|
TRCO_COMM_ID |
CHAR
|
18 | 0 | ||||||||
|
COMMODITY_CAT
Commodity Category
|
TPM_CTY_CAT | TRCOTS_CTY_CAT |
CHAR
|
3 | 0 | |||||||
|
COMMODITY_TYPE
Type of Commodity
|
TPM_CTY_TYPE |
CHAR
|
3 | 0 | ||||||||
|
COMMODITY_NAME
Name of the Commodity
|
TPM_CTY_NAME |
CHAR
|
40 | 0 | ||||||||
|
COMMODITY_UOM
Unit of Measure for the Commodity
|
TPM_CTY_UOM | T006 |
UNIT
|
3 | 0 | |||||||
|
CURRENCY_UNIT
Currency Unit for Commodity
|
TCR_CTY_CURRUNIT | TZUNI |
CHAR
|
5 | 0 | |||||||
|
DEFAULT_CURRENCY
Currency for the Commodity Deal
|
TPM_CTY_DEFAULT_CURR | TCURC |
CUKY
|
5 | 0 | |||||||
|
ACTIVE
Indicates whether the commodity is active
|
TPM_CTY_ACTIVE |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
GROUP1
Commodity Group1
|
TPM_CTY_GP1 |
CHAR
|
3 | 0 | ||||||||
|
GROUP2
Commodity Group2
|
TPM_CTY_GP2 |
CHAR
|
3 | 0 | ||||||||
|
QUOTNAME
Commodities: Quotation Name
|
TCR_CTY_QUOTNAME | TRCOCC_QUOTNAM |
CHAR
|
18 | 0 | |||||||
|
ENTERED_BY
Entered by
|
TB_CRUSER |
CHAR
|
12 | 0 | ||||||||
|
ENTERED_DATE
Entered On
|
TB_DCRDAT |
DATS
|
8 | 0 | ||||||||
|
ENTERED_TIME
Entry Time
|
TB_TCRTIM |
TIMS
|
6 | 0 | ||||||||
|
CHANGED_BY
Last Changed by
|
TB_UPUSER |
CHAR
|
12 | 0 | ||||||||
|
CHANGED_DATE
Changed on
|
TB_DUPDAT |
DATS
|
8 | 0 | ||||||||
|
CHANGED_TIME
Time changed
|
TB_TUPTIM |
TIMS
|
6 | 0 | ||||||||
|
LOCATION
Pricing Location
|
TPM_DEL_LOCATION | TRCOT_CTY_DELLOC |
CHAR
|
4 | 0 | |||||||
|
COMMODITY_KIND
Commodity Kind
|
TPM_CTY_KIND |
INT1
|
3 | 0 | ||||||||
|
||||||||||||
|
PARENT_CTY_ID
Parent Commodity ID
|
TPM_PARENT_CTY_ID | TRCOT_CTY_MASTER |
CHAR
|
18 | 0 | |||||||
|
REF_COMMODITY_ID
Reference Commodity ID
|
TPM_COMM_ID_REF |
CHAR
|
18 | 0 | ||||||||
|
INCOTERMS
International Commercial Terms
|
TPM_INCOTERMS | TRCOC_INCOTERMS |
CHAR
|
3 | 0 | |||||||
|
PHYSCOMM
Physical Commodity
|
TBA_STOEFFCHEN | TBAC_PHYSCOMM |
CHAR
|
18 | 0 | |||||||
TRCOT_CTY_MASTER foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TRCOT_CTY_MASTER | COMMODITY_CAT | TRCOT_CTY_MASTER | COMMODITY_CAT |
TRCOTS_CTY_CAT
Commodity category
|
COMMODITY_CAT |
| TRCOT_CTY_MASTER | COMMODITY_UOM | TRCOT_CTY_MASTER | MANDT |
T006
Units of Measurement
|
MANDT |
| TRCOT_CTY_MASTER | COMMODITY_UOM | TRCOT_CTY_MASTER | COMMODITY_UOM |
T006
Units of Measurement
|
MSEHI |
| TRCOT_CTY_MASTER | CURRENCY_UNIT | TRCOT_CTY_MASTER | CURRENCY_UNIT |
TZUNI
Currency units
|
SRUNIT |
| TRCOT_CTY_MASTER | CURRENCY_UNIT | TRCOT_CTY_MASTER | MANDT |
TZUNI
Currency units
|
MANDT |
| TRCOT_CTY_MASTER | DEFAULT_CURRENCY | TRCOT_CTY_MASTER | MANDT |
TCURC
Currency Codes
|
MANDT |
| TRCOT_CTY_MASTER | DEFAULT_CURRENCY | TRCOT_CTY_MASTER | DEFAULT_CURRENCY |
TCURC
Currency Codes
|
WAERS |
| TRCOT_CTY_MASTER | INCOTERMS | TRCOT_CTY_MASTER | MANDT |
TRCOC_INCOTERMS
International Commercial Terms (InCoTerms)
|
MANDT |
| TRCOT_CTY_MASTER | INCOTERMS | TRCOT_CTY_MASTER | INCOTERMS |
TRCOC_INCOTERMS
International Commercial Terms (InCoTerms)
|
INCOTERMS |
| TRCOT_CTY_MASTER | LOCATION | TRCOT_CTY_MASTER | MANDT |
TRCOT_CTY_DELLOC
Pricing Location Table
|
MANDT |
| TRCOT_CTY_MASTER | LOCATION | TRCOT_CTY_MASTER | LOCATION |
TRCOT_CTY_DELLOC
Pricing Location Table
|
DEL_LOCATION |
| TRCOT_CTY_MASTER | PARENT_CTY_ID | TRCOT_CTY_MASTER | MANDT |
TRCOT_CTY_MASTER
Commodity master data
|
MANDT |
| TRCOT_CTY_MASTER | PARENT_CTY_ID | TRCOT_CTY_MASTER | PARENT_CTY_ID |
TRCOT_CTY_MASTER
Commodity master data
|
COMMODITY_ID |
| TRCOT_CTY_MASTER | PHYSCOMM | TRCOT_CTY_MASTER | MANDT |
TBAC_PHYSCOMM
Customizing table for physical commodities
|
CLIENT |
| TRCOT_CTY_MASTER | PHYSCOMM | TRCOT_CTY_MASTER | PHYSCOMM |
TBAC_PHYSCOMM
Customizing table for physical commodities
|
COMMODITY |
| TRCOT_CTY_MASTER | QUOTNAME | TRCOT_CTY_MASTER | MANDT |
TRCOCC_QUOTNAM
Commodities: Quotation Names
|
MANDT |
| TRCOT_CTY_MASTER | QUOTNAME | TRCOT_CTY_MASTER | QUOTNAME |
TRCOCC_QUOTNAM
Commodities: Quotation Names
|
CTY_QUOT_NAME |