TMFG is a standard SAP table in SAP ECC (or) S/4HANA which stores Material freight groups data. There are total 2 fields in TMFG table.This blog post provides key technical details of SAP table TMFG, including its availability across SAP S/4HANA versions and the list of CDS views for TMFG table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Full table is passed to buffer |
SAP TMFG Table Fields
The following is the list of fields that are available in SAP TMFG table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| MFRGR | Material freight group | MFRGR | MFRGR | CHAR (8) |
Availability
The SAP table TMFG is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for TMFG table
The following is the list of CDS views for TMFG table, which can also be used instead of TMFG table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_MATERIALFREIGHTGROUP | BASIC | Material Freight Group |
| I_TRANSPORTATIONORDERITEM | BASIC | Transportation Order: Items |
| I_TRANSPORTATIONORDERITEMENRCD | BASIC | Transportation Order Item enriched |
| I_FRTCOSTDISTRELMNTCNSLDTD | COMPOSITE | Freight Cost Distr Elements Consolidated |
| I_FRTCOSTDISTRELMNTENRCD | COMPOSITE | Freight Cost Distr Elements Enriched |
| I_FRTCOSTDISTRITMCNSLDTD | COMPOSITE | Freight Cost Distr Items Consolidated |
| I_FRTCOSTDISTRITMENRCD | COMPOSITE | Freight Cost Distr Items Enriched |
| I_FRTORDERITEM | COMPOSITE | Freight Order: Items |
| I_FRTUNITITEM | COMPOSITE | Freight Unit: Items |
| I_TRANSPBUSPERFMNTRORDDETC | COMPOSITE | Transp Bus Perf Mon Root Det – Cube |
| I_TRANSPORDDELIVERYRATIO | COMPOSITE | Transportation Order: Header Data for Delivery Creation |
| I_TRANSPORDDETANLYTSFORMNTR | COMPOSITE | TOR Root Detail Analytics for Cloud |
| I_TRANSPORDDETFORBUSDSHBRD | COMPOSITE | TOR Item Analytics for SAC Dashboard |
| I_TRANSPORDDETFORBUSDSHBRDC | COMPOSITE | TOR Det Analytics for SAC Dshbrd – Cube |
| I_TRANSPORDEXECANLYTSFORMNTR | COMPOSITE | TOR Execution Analytics for Cloud |
| I_TRANSPORDEXECANLYTSFORMNTR2 | COMPOSITE | TOR Execution Stage Analytics for Cloud |
| I_TRANSPORDITEMANALYTICS | COMPOSITE | Transportation Order Item Analytics |
| I_TRANSPORDITEMANLYTSDEXPREP | COMPOSITE | Transp Order Item Anlyts DEX Preparation |
| I_TRANSPORDITEMCARGO | COMPOSITE | Transportation Order: Cargo Items |
| I_TRANSPORDITEMDELIVRATIO | COMPOSITE | Transportation Order: Item Data for Delivery Creation |
| I_TRANSPORDROOTDELIVDOCREF | COMPOSITE | Transportation Order: Root Delivery Document Reference |
| P_TRANSPORDITMDELIVDOCREF | COMPOSITE | Transportation Order: Item Delivery Document Reference |
| C_FRTCOSTDISTRELMNT | CONSUMPTION | Freight Cost Distribution Elements |
| C_FRTCOSTDISTRITM | CONSUMPTION | Freight Cost Distribution Items |
| C_FRTORDACCRITEM | CONSUMPTION | Freight Order Items for Accruals |
| C_FRTORDEXECUTION | CONSUMPTION | Freight Orders Execution |
| C_FRTORDEXECUTIONITEM | CONSUMPTION | Freight Order Execution Item |
| C_FRTORDGENDATABASICFACTS | CONSUMPTION | Freight Order: General Data |
| C_FRTUNITGENDATABASICFACTS | CONSUMPTION | Freight Unit: General Data |
| C_TRANSPBUSPERFMNTRORDDETQ | CONSUMPTION | Transp. Bus. Perf. Mon. – Ord.Det. Query |
| C_TRANSPORDDETFORBUSDSHBRDQ | CONSUMPTION | Transp. Bus. Perf. Dshbrd. – Ord Det Qry |
| C_TRANSPORDITEMANLYTSDEX | CONSUMPTION | Data Extraction for Transp Order Anlyts Root and Item |
