_MATERIAL
_MATERIAL is an SAP database table in S/4HANA. It contains 68 fields.
Fields (68)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CostEstimate | CostEstimate | 1 |
| KEY | material | mat,Material,Product | 6 |
| KEY | matnr | Material | 2 |
| KEY | ProcessCategory | ProcessCategory | 1 |
| KEY | Product | AdvancedPlanningProductName,PackagingMaterial,Product,ProductName | 11 |
| KEY | werks | Plant | 1 |
| _BaseUnit | _BaseUnit | 4 | |
| _MaterialGroup | _MaterialGroup | 3 | |
| _MaterialType | _MaterialType | 5 | |
| _WeightUnit | _WeightUnit | 1 | |
| AccountingDocument | AccountingDocument | 1 | |
| AuthorizationGroup | AuthorizationGroup,MTRAuthorizationGroup,ProductAuthorizationGroup | 19 | |
| BaseUnit | MaterialBaseUnit | 2 | |
| Commodity | Commodity,ContractCommodityItem | 3 | |
| CompanyCode | CompanyCode | 1 | |
| CrossPlantConfigurableProduct | CrossPlantConfigurableProduct,GenericProduct | 27 | |
| Currency | Currency | 1 | |
| FiscalYear | FiscalYear | 1 | |
| InventoryAmtInCCCrcy | InventoryAmtInCCCrcy | 1 | |
| InventoryValuationType | InventoryValuationType | 1 | |
| IsBatchManagementRequired | IsBatchManagementRequired | 6 | |
| LedgerGLLineItem | LedgerGLLineItem | 1 | |
| LedgerValuationCurrencyRole | LedgerValuationCurrencyRole | 1 | |
| MaterialAuthorizationGroup | ProductAuthorizationGroup | 1 | |
| MaterialBaseUnit | BaseUnit,MaterialBaseUnit,UnitOfMeasure | 37 | |
| MaterialConsumptionQty | MaterialConsumptionQty | 1 | |
| MaterialConsumptionValue | MaterialConsumptionValue | 1 | |
| MaterialGrossWeight | MaterialGrossWeight | 4 | |
| MaterialGroup | MaterialGroup,ProductGroup | 26 | |
| MaterialIsBatchManaged | MaterialIsBatchManaged | 2 | |
| MaterialManufacturerNumber | MaterialManufacturerNumber | 4 | |
| MaterialManufacturerPartNumber | MaterialManufacturerPartNumber | 4 | |
| MaterialName | MaterialName,PackagingMaterialName | 11 | |
| MaterialNetWeight | MaterialNetWeight | 5 | |
| MaterialProcurementType | MaterialProcurementType | 1 | |
| MaterialType | MaterialType,ProductType | 22 | |
| MaterialTypeName | MaterialTypeName | 1 | |
| MaterialValuationClass | MaterialValuationClass | 1 | |
| MaterialWeightUnit | MaterialWeightUnit | 5 | |
| PackagingMaterialType | PackagingMaterialType | 1 | |
| Plant | Plant | 1 | |
| PlantName | PlantName | 1 | |
| ProdCharc1InternalNumber | ProdCharc1InternalNumber | 9 | |
| ProdCharc2InternalNumber | ProdCharc2InternalNumber | 9 | |
| ProdCharc3InternalNumber | ProdCharc3InternalNumber | 9 | |
| ProductCategory | ProductCategory | 9 | |
| ProductCharacteristic1 | ProductCharacteristic1 | 12 | |
| ProductCharacteristic2 | ProductCharacteristic2,ProductCharacteristic3 | 12 | |
| ProductCharacteristic3 | ProductCharacteristic3 | 11 | |
| ProductExternalID | ProductExternalID | 1 | |
| ProductGroup | MaterialGroup | 8 | |
| ProductGroupAuthorizationGroup | ProductGroupAuthorizationGroup | 1 | |
| ProductHierarchy | ProductHierarchy | 4 | |
| ProductType | MaterialType | 3 | |
| ProductTypeAuthorizationGroup | ProductTypeAuthorizationGroup | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| SalesDocument | SalesDocument | 1 | |
| SalesDocumentItem | SalesDocumentItem | 1 | |
| sgt_covs | SegmentationStrategy | 1 | |
| SourceCompanyCode | SourceCompanyCode | 1 | |
| SourceLedger | SourceLedger | 1 | |
| Supplier | Supplier | 1 | |
| Timestamp | Timestamp | 1 | |
| ValuationArea | ValuationArea | 1 | |
| ValuationQuantity | ValuationQuantity | 1 | |
| ValuationQuantityUnit | ValuationQuantityUnit | 1 | |
| VolumeUnit | VolumeUnit | 1 | |
| WBSElement | WBSElement | 1 |