MATERIAL

85 Fields

MATERIAL is an SAP database table in S/4HANA. It contains 85 fields.

Fields (85)

KeyField CDS FieldsUsed in Views
KEY FactoryCalendar FactoryCalendar 3
KEY MasterProject MasterProject 1
KEY Material Material 5
KEY MaterialShortageProfile MaterialShortageProfile 3
KEY MaterialShortageProfileCount MaterialShortageProfileCount 3
KEY MRPArea MRPArea 3
KEY MRPPlanningSegment MRPPlanningSegment 3
KEY MRPPlanningSegmentType MRPPlanningSegmentType 1
KEY MRPPlant MRPPlant 3
_UnitOfMeasure _UnitOfMeasure 3
BaseUnit MaterialBaseUnit 3
Customer Customer 1
CustomerName CustomerName 1
DaysOfSupplyCriticality DaysOfSupplyCriticality 2
DaysOfSupplyDuration DaysOfSupplyDuration 3
EvaluationHorizonInDays EvaluationHorizonInDays 3
HasAcceptedShortage HasAcceptedShortage 2
HasShortageManualPlanHorizon HasShortageManualPlanHorizon 3
HasShortageMRPSafetyDuration HasShortageMRPSafetyDuration 3
HasShortageTotalReplnmtLead HasShortageTotalReplnmtLead 3
IntraDaySupplyDuration IntraDaySupplyDuration 3
IsMarkedForDeletion IsMarkedForDeletion 2
IssueCount IssueCount 2
LastBufferUpdateDateTime LastBufferUpdateDateTime 2
LowLevelCode LowLevelCode 2
ManualPlanningHorizonEndDate ManualPlanningHorizonEndDate 3
MaterialABCClassification MaterialABCClassification 3
MaterialBaseUnit BaseUnit,MaterialBaseUnit 5
MaterialCompIsProcuredDirectly MaterialCompIsProcuredDirectly 1
MaterialFirstShortageDate MaterialFirstShortageDate 1
MaterialFirstShortageDateQty MaterialFirstShortageDateQty 1
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 3
MaterialGroup MaterialGroup 3
MaterialGroupName MaterialGroupName 3
MaterialName MaterialName 4
MaterialPlannedProductionDurn MaterialPlannedProductionDurn 3
MaterialProcurementCategory MaterialProcurementCategory 3
MaterialProcurementProfile MaterialProcurementProfile 3
MaterialSafetyStockQty MaterialSafetyStockQty 1
MaterialShortageDefinitionName MaterialShortageDefinitionName 3
MaterialShortageDuration MaterialShortageDuration 2
MaterialShortageDurnInWorkdays MaterialShortageDurnInWorkdays 2
MaterialShortageEndDate MaterialShortageEndDate 3
MaterialShortageStartDate MaterialShortageStartDate 3
MaterialType MaterialType 3
MaterialTypeName MaterialTypeName 3
MatlMaxCoverageDurnInWorkdays MatlMaxCoverageDurnInWorkdays 1
matnr PackagingMaterial 2
MRPAvailableStockQty MRPAvailableStockQty 3
MRPController MRPController 3
MRPGroup MRPGroup 3
MRPMaterialNoteText MRPMaterialNoteText 2
MRPSafetyDuration MRPSafetyDuration 3
MRPSafetyDurationEndDate MRPSafetyDurationEndDate 3
MRPSafetyStockMethod MRPSafetyStockMethod 2
MRPValidMaterialStatus MRPValidMaterialStatus 3
NumberOfCancelProcesses NumberOfCancelProcesses 2
NumberOfPastDueEndDateElements NumberOfPastDueEndDateElements 2
NumberOfPastDueStartDateElmnts NumberOfPastDueStartDateElmnts 2
NumberOfRescheduleOutElements NumberOfRescheduleOutElements 2
NumberOfSupplier NumberOfSupplier 3
PlanningSegmentDocumentItem PlanningSegmentDocumentItem 1
PlanningTimeFenceInDays PlanningTimeFenceInDays 3
PlantLanguage PlantLanguage 3
ProductionProductHierarchy ProductionProductHierarchy 2
ProductionProductHierarchyNode ProductionProductHierarchyNode 2
Project Project 1
ProjectDescription ProjectDescription 1
ProjectResponsiblePerson ProjectResponsiblePerson 1
ProjectResponsiblePersonName ProjectResponsiblePersonName 1
ResponsiblePerson ResponsiblePerson 1
ScheduleAgreementHasReleaseDoc ScheduleAgreementHasReleaseDoc 1
SegmentationStrategy SegmentationStrategy 1
StockDaysSupplyCriticality StockDaysSupplyCriticality 2
StockDaysSupplyDuration StockDaysSupplyDuration 2
StockIntraDaySupplyDuration StockIntraDaySupplyDuration 2
TimeTillShortageInCalendarDays TimeTillShortageInCalendarDays 2
TotalReplenishmentLeadDuration TotalReplenishmentLeadDuration 3
TotalReplnmtLeadDurnEndDate TotalReplnmtLeadDurnEndDate 3
UnitOfMeasureDspNmbrOfDcmls UnitOfMeasureDspNmbrOfDcmls 3
UnitOfMeasureNumberOfDecimals UnitOfMeasureNumberOfDecimals 1
WBSDescription WBSDescription 1
WBSElement WBSElement 1
WBSElementInternalID WBSElementInternalID 1
WeeklyAvailabilityChart WeeklyAvailabilityChart 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MATERIAL (
    FACTORYCALENDAR,
    MASTERPROJECT,
    MATERIAL,
    MATERIALSHORTAGEPROFILE,
    MATERIALSHORTAGEPROFILECOUNT,
    MRPAREA,
    MRPPLANNINGSEGMENT,
    MRPPLANNINGSEGMENTTYPE,
    MRPPLANT,
    _UNITOFMEASURE,
    BASEUNIT,
    CUSTOMER,
    CUSTOMERNAME,
    DAYSOFSUPPLYCRITICALITY,
    DAYSOFSUPPLYDURATION,
    EVALUATIONHORIZONINDAYS,
    HASACCEPTEDSHORTAGE,
    HASSHORTAGEMANUALPLANHORIZON,
    HASSHORTAGEMRPSAFETYDURATION,
    HASSHORTAGETOTALREPLNMTLEAD,
    INTRADAYSUPPLYDURATION,
    ISMARKEDFORDELETION,
    ISSUECOUNT,
    LASTBUFFERUPDATEDATETIME,
    LOWLEVELCODE,
    MANUALPLANNINGHORIZONENDDATE,
    MATERIALABCCLASSIFICATION,
    MATERIALBASEUNIT,
    MATERIALCOMPISPROCUREDDIRECTLY,
    MATERIALFIRSTSHORTAGEDATE,
    MATERIALFIRSTSHORTAGEDATEQTY,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALGROUP,
    MATERIALGROUPNAME,
    MATERIALNAME,
    MATERIALPLANNEDPRODUCTIONDURN,
    MATERIALPROCUREMENTCATEGORY,
    MATERIALPROCUREMENTPROFILE,
    MATERIALSAFETYSTOCKQTY,
    MATERIALSHORTAGEDEFINITIONNAME,
    MATERIALSHORTAGEDURATION,
    MATERIALSHORTAGEDURNINWORKDAYS,
    MATERIALSHORTAGEENDDATE,
    MATERIALSHORTAGESTARTDATE,
    MATERIALTYPE,
    MATERIALTYPENAME,
    MATLMAXCOVERAGEDURNINWORKDAYS,
    MATNR,
    MRPAVAILABLESTOCKQTY,
    MRPCONTROLLER,
    MRPGROUP,
    MRPMATERIALNOTETEXT,
    MRPSAFETYDURATION,
    MRPSAFETYDURATIONENDDATE,
    MRPSAFETYSTOCKMETHOD,
    MRPVALIDMATERIALSTATUS,
    NUMBEROFCANCELPROCESSES,
    NUMBEROFPASTDUEENDDATEELEMENTS,
    NUMBEROFPASTDUESTARTDATEELMNTS,
    NUMBEROFRESCHEDULEOUTELEMENTS,
    NUMBEROFSUPPLIER,
    PLANNINGSEGMENTDOCUMENTITEM,
    PLANNINGTIMEFENCEINDAYS,
    PLANTLANGUAGE,
    PRODUCTIONPRODUCTHIERARCHY,
    PRODUCTIONPRODUCTHIERARCHYNODE,
    PROJECT,
    PROJECTDESCRIPTION,
    PROJECTRESPONSIBLEPERSON,
    PROJECTRESPONSIBLEPERSONNAME,
    RESPONSIBLEPERSON,
    SCHEDULEAGREEMENTHASRELEASEDOC,
    SEGMENTATIONSTRATEGY,
    STOCKDAYSSUPPLYCRITICALITY,
    STOCKDAYSSUPPLYDURATION,
    STOCKINTRADAYSUPPLYDURATION,
    TIMETILLSHORTAGEINCALENDARDAYS,
    TOTALREPLENISHMENTLEADDURATION,
    TOTALREPLNMTLEADDURNENDDATE,
    UNITOFMEASUREDSPNMBROFDCMLS,
    UNITOFMEASURENUMBEROFDECIMALS,
    WBSDESCRIPTION,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    WEEKLYAVAILABILITYCHART,
    PRIMARY KEY (FACTORYCALENDAR, MASTERPROJECT, MATERIAL, MATERIALSHORTAGEPROFILE, MATERIALSHORTAGEPROFILECOUNT, MRPAREA, MRPPLANNINGSEGMENT, MRPPLANNINGSEGMENTTYPE, MRPPLANT)
);

Learn More