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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||
| 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 |
Possible values
|
||||||
| 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 | MANDT | TZUNI | Currency units | MANDT |
| TRCOT_CTY_MASTER | CURRENCY_UNIT | TRCOT_CTY_MASTER | CURRENCY_UNIT | TZUNI | Currency units | SRUNIT |
| 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 | PARENT_CTY_ID | TRCOT_CTY_MASTER | Commodity master data | COMMODITY_ID |
| TRCOT_CTY_MASTER | PARENT_CTY_ID | TRCOT_CTY_MASTER | MANDT | TRCOT_CTY_MASTER | Commodity master data | MANDT |
| TRCOT_CTY_MASTER | PHYSCOMM | TRCOT_CTY_MASTER | PHYSCOMM | TBAC_PHYSCOMM | Customizing table for physical commodities | COMMODITY |
| TRCOT_CTY_MASTER | PHYSCOMM | TRCOT_CTY_MASTER | MANDT | TBAC_PHYSCOMM | Customizing table for physical commodities | CLIENT |
| 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 |
