MAKT
Material Descriptions
MAKT is an SAP database table in S/4HANA. Material Descriptions. It contains 5 fields. 63 CDS views read from this table.
CDS Views using this table (63)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /merp/mm_Material_Plant | view | left_outer | CDS View: Material Plant View | |
| /merp/pm_Wo_Component | view | left_outer | CDS View: Maintenance Order Components | |
| /SCWM/PROD_FUZZY_SEARCH_S4 | view | left_outer | Product for Fuzzy Search | |
| Arun_I_So_1 | view | left_outer | SO Item level Data selection | |
| Arun_I_Sto_1 | view | left_outer | STO Item level Data selection | |
| Arun_Sto_Req1 | view | left_outer | STO Requirement - Initial join | |
| CRMS4_IU_I_CTI | view | left_outer | Utilities Contract Item | |
| CRMS4_IU_I_CTP | view | left_outer | Utilities Contract Period | |
| EWA_ALY_I_OIS | view | left_outer | Status of Waste Disposal Order Item | |
| fgl_lib_txt_matnr | view | from | FI LIB: Material texts | |
| I_ACMMaterialDetailsText | view | from | BASIC | ACM Material Details - Text |
| I_CstrtHardwareBsc | view | left_outer | BASIC | Hardware Constraint Item Basic View |
| I_CstrtHardwareMatl | view | left_outer | BASIC | Hardware Material List |
| I_CstrtHdrBsc | view | left_outer | BASIC | Constraint Header Basic view |
| I_CstrtNewSwMatl | view | left_outer | BASIC | New Software Material list |
| I_CstrtSwBsc | view | left_outer | BASIC | Software Constraint Item Basic view |
| I_CstrtSwMatl | view | left_outer | BASIC | Software Material List |
| I_DFS_DisconnectedMaterialBOM | view | inner | BASIC | Disconnected Material BOM |
| I_EWAWasteVH | view_entity | inner | BASIC | Waste Material values |
| I_FldLogsMaterialTextBasic | view_entity | from | BASIC | FL Material - Text |
| I_MaterialDescription | view | left_outer | BASIC | Material Description |
| I_MaterialText | view | from | BASIC | Material Text |
| I_MaterialValueHelp | view | left_outer | BASIC | Material value help |
| I_NominationMaterialDesc | view | from | BASIC | Nomination Ticket Material Description |
| I_Oij06_Myeventss1_Object | view | left_outer | BASIC | Mass Change Events - events interface view |
| I_PhysInvtryVolMassRdng | view | left_outer | BASIC | Physical Inventory for VMR |
| I_PPDSProductVH | view_entity | inner | BASIC | PPDS Product |
| I_ProductDescription | view | from | BASIC | Product Descriptions |
| I_ProductDescription_2 | view_entity | from | BASIC | Product Descriptions |
| I_ProductText | view | from | BASIC | Product - Text |
| I_SwText | view | from | BASIC | Material Description |
| I_TripServiceMaterialVH | view | left_outer | BASIC | Value Help for Service Material |
| I_VariantMaterial | view | left_outer | BASIC | Material of Variant |
| I_VisualProductIdVH | view | left_outer | BASIC | Visual Product id |
| M_V_inforecord | view | left_outer | MM-PUR: CDS View for Purchasing Info Record | |
| m_v_m2s_pr_itm | view | left_outer | CDS View for Purchase Requisition | |
| Mbv_Srmerp_Css_Mat | view | inner | Compatibility view for /SRMERP/CCS_MAT view (ML integration) | |
| Mbv_V_Satz1 | view | inner | Compatibility view for V_SATZ1 view (ML integration) | |
| Oij05_GNominations | view | left_outer | To fetch nominations | |
| OIJ05_GSCHED | view | left_outer | CDS for Global Sim in OIJ_SCHED | |
| OIJ05_GSCHED_LO | view | left_outer | CDS for Location Balancing Global Sim in OIJ_SCHED | |
| OIJ05_ICSCHED | view | left_outer | To fetch global simulation of type IC | |
| Oij05_Nominations | view | left_outer | To fetch nominations | |
| Oij05_Oijgsched | view | left_outer | CDSV for GSched | |
| Oij05_Oijgsched_Sim | view | left_outer | CDS View for Oij05_Oijgsched_Sim | |
| Oij05_Oijsched | view | left_outer | CDSV for OIJSCHED | |
| Oij05_Oijsched_Sim | view | left_outer | CDSV for OIJ05_SCHED_SIM | |
| Oij05_Sched | view | left_outer | CDS for OIJ_SCHED | |
| P_AdvncdSchedgScmPrdMattxt | view | from | BASIC | |
| P_ProdPlantPlndIndepRqmtBasic | view | left_outer | BASIC | |
| Pphmrp_Error_Mats | view | left_outer | Attributes for Displaying Materials with Issues in last MRP | |
| R_PPDSMntrRcptProductText | view_entity | from | BASIC | Product - Text |
| R_PPDSMntrRcptProductVH | view_entity | left_outer | BASIC | Product |
| R_PPDSMntrRqmtProductText | view_entity | from | BASIC | Product - Text |
| R_PPDSMntrRqmtProductVH | view_entity | left_outer | BASIC | Product |
| rfm_psst_assign | view | left_outer | PSST Assignment monitor view | |
| rfm_psst_sto_assign | view | left_outer | Assignment Monitor STO view | |
| rfm_scc_product_data | view | inner | Get Product data | |
| SBN_DRF_PI_DETAILS | view | left_outer | Get PI details | |
| ScmPrd_Mattxt | view | from | Redirect for /SAPAPO/MATTXT | |
| UPOV_PPN_MP_BA_UOM | view | left_outer | Event Detail Ref - Before/After data | |
| UPOV_PPN_NODERULE_BA_UOM | view | left_outer | Event Detail Ref - Before/After data | |
| VC_INTEGRATION_MAKT | view | from | Extraction for MAKT |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Material Descriptions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MAKT (
MANDT, -- Client [MANDT]
MATNR, -- Material [MATNR]
SPRAS, -- Language [SPRAS]
MAKTX, -- Description [MAKTX]
MAKTG, -- Description [MAKTG]
PRIMARY KEY (MANDT, MATNR, SPRAS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA