C_MaterialCoveragePop

DDL: C_MATERIALCOVERAGEPOP SQL: CMATCOVPOP Type: view CONSUMPTION
51 Fields

Popovers Manage Material Coverage App

C_MaterialCoveragePop is a Consumption CDS View that provides data about "Popovers Manage Material Coverage App" in SAP S/4HANA.

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMATCOVPOP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Popovers Manage Material Coverage App view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY MRPPlant I_MaterialCoverage MRPPlant Plant
KEY MRPArea I_MaterialCoverage MRPArea MRP Area
KEY Material I_MaterialCoverage Material Vehicle Model
KEY MRPPlanningSegmentType I_MaterialCoverage MRPPlanningSegmentType MRP segment
KEY MaterialShortageProfile I_MaterialCoverage MaterialShortageProfile Shortage Prf.
KEY MRPPlanningSegment I_MaterialCoverage MRPPlanningSegment Plng Segmnt No.
KEY MaterialShortageProfileCount I_MaterialCoverage MaterialShortageProfileCount Counter
KEY FactoryCalendar I_MaterialCoverage FactoryCalendar Factory Calendar
MaterialName I_MaterialCoverage MaterialName Material Description
MRPController I_MaterialCoverage MRPController MRP Controller
MaterialBaseUnit I_MaterialCoverage MaterialBaseUnit Valuation Unit
MaterialReplnmtLeadDurnEndDate I_MaterialCoverage MaterialReplnmtLeadDurnEndDate Date
TotalReplnmtLeadDurnEndDate I_MaterialCoverage TotalReplnmtLeadDurnEndDate Date
ManualPlanningHorizonEndDate I_MaterialCoverage ManualPlanningHorizonEndDate Date
MRPSafetyDurationEndDate I_MaterialCoverage MRPSafetyDurationEndDate Date
MaterialShortageQuantity
EvaluationHorizonInDays I_MaterialCoverage EvaluationHorizonInDays
MaterialShortageDefinitionName I_MaterialCoverage MaterialShortageDefinitionName
AvailabilityChart I_MaterialCoverage AvailabilityChart
WeeklyAvailabilityChart I_MaterialCoverage WeeklyAvailabilityChart
MaterialProcurementCategory I_MaterialCoverage MaterialProcurementCategory Procurement
MaterialProcurementProfile I_MaterialCoverage MaterialProcurementProfile Special Procur.
MRPType I_MaterialCoverage MRPType MRP Type
MaterialPlannedDeliveryDurn I_MaterialCoverage MaterialPlannedDeliveryDurn Pl. Deliv. Time
MaterialPlannedProductionDurn I_MaterialCoverage MaterialPlannedProductionDurn InhseProdTime
MRPSafetyDuration I_MaterialCoverage MRPSafetyDuration Safety Time
PlanningTimeFenceInDays I_MaterialCoverage PlanningTimeFenceInDays Plng time fence
PurchasingGroup I_MaterialCoverage PurchasingGroup Purchasing Group
MaterialGoodsReceiptDuration I_MaterialCoverage MaterialGoodsReceiptDuration GR proc. time
MaterialGroup I_MaterialCoverage MaterialGroup Product Group
MaterialABCClassification I_MaterialCoverage MaterialABCClassification ABC Indicator
MRPGroup I_MaterialCoverage MRPGroup MRP Group
MRPSafetyStockMethod I_MaterialCoverage MRPSafetyStockMethod Safety Stock Method
TotalReplenishmentLeadDuration I_MaterialCoverage TotalReplenishmentLeadDuration Total RL time
MaterialTypeName I_MaterialCoverage MaterialTypeName Mat.Type Desc.
MaterialGroupName I_MaterialCoverage MaterialGroupName prod Grp Desc.
MaterialSafetyStockQty I_MaterialCoverage MaterialSafetyStockQty Safety Stock
MaterialReorderPointQty I_MaterialCoverage MaterialReorderPointQty Reorder Point
MRPAvailableStockQty I_MaterialCoverage MRPAvailableStockQty
HasMaterialShortageReplnmtLead I_MaterialCoverage HasMaterialShortageReplnmtLead
HasShortageTotalReplnmtLead I_MaterialCoverage HasShortageTotalReplnmtLead
HasShortageManualPlanHorizon I_MaterialCoverage HasShortageManualPlanHorizon
HasShortageMRPSafetyDuration I_MaterialCoverage HasShortageMRPSafetyDuration
UnitOfMeasureDspNmbrOfDcmls _UnitOfMeasure UnitOfMeasureDspNmbrOfDcmls
MaterialShortageStartDate I_MaterialCoverage MaterialShortageStartDate Time Stamp
MaterialShortageEndDate I_MaterialCoverage MaterialShortageEndDate Time Stamp
MaterialShortageDefinition
Supplier
SupplierName
NumberOfSupplier I_MaterialCoverage NumberOfSupplier
MRPPlanningSegmentExternalCode I_MaterialCoverage MRPPlanningSegmentExternalCode

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MaterialCoveragePop.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CMATCOVPOP

CREATE VIEW C_MaterialCoveragePop AS
SELECT
  I_MaterialCoverage.MRPPlant AS MRPPlant,
  I_MaterialCoverage.MRPArea AS MRPArea,
  I_MaterialCoverage.Material AS Material,
  I_MaterialCoverage.MRPPlanningSegmentType AS MRPPlanningSegmentType,
  I_MaterialCoverage.MaterialShortageProfile AS MaterialShortageProfile,
  I_MaterialCoverage.MRPPlanningSegment AS MRPPlanningSegment,
  I_MaterialCoverage.MaterialShortageProfileCount AS MaterialShortageProfileCount,
  I_MaterialCoverage.FactoryCalendar AS FactoryCalendar,
  I_MaterialCoverage.MaterialName AS MaterialName,
  I_MaterialCoverage.MRPController AS MRPController,
  I_MaterialCoverage.MaterialBaseUnit AS MaterialBaseUnit,
  I_MaterialCoverage.MaterialReplnmtLeadDurnEndDate AS MaterialReplnmtLeadDurnEndDate,
  I_MaterialCoverage.TotalReplnmtLeadDurnEndDate AS TotalReplnmtLeadDurnEndDate,
  I_MaterialCoverage.ManualPlanningHorizonEndDate AS ManualPlanningHorizonEndDate,
  I_MaterialCoverage.MRPSafetyDurationEndDate AS MRPSafetyDurationEndDate,
  cast (I_MaterialCoverage.MaterialShortageQuantity as materialshortageqty) AS MaterialShortageQuantity,
  I_MaterialCoverage.EvaluationHorizonInDays AS EvaluationHorizonInDays,
  I_MaterialCoverage.MaterialShortageDefinitionName AS MaterialShortageDefinitionName,
  I_MaterialCoverage.AvailabilityChart AS AvailabilityChart,
  I_MaterialCoverage.WeeklyAvailabilityChart AS WeeklyAvailabilityChart,
  I_MaterialCoverage.MaterialProcurementCategory AS MaterialProcurementCategory,
  I_MaterialCoverage.MaterialProcurementProfile AS MaterialProcurementProfile,
  I_MaterialCoverage.MRPType AS MRPType,
  I_MaterialCoverage.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  I_MaterialCoverage.MaterialPlannedProductionDurn AS MaterialPlannedProductionDurn,
  I_MaterialCoverage.MRPSafetyDuration AS MRPSafetyDuration,
  I_MaterialCoverage.PlanningTimeFenceInDays AS PlanningTimeFenceInDays,
  I_MaterialCoverage.PurchasingGroup AS PurchasingGroup,
  I_MaterialCoverage.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  I_MaterialCoverage.MaterialGroup AS MaterialGroup,
  I_MaterialCoverage.MaterialABCClassification AS MaterialABCClassification,
  I_MaterialCoverage.MRPGroup AS MRPGroup,
  I_MaterialCoverage.MRPSafetyStockMethod AS MRPSafetyStockMethod,
  I_MaterialCoverage.TotalReplenishmentLeadDuration AS TotalReplenishmentLeadDuration,
  I_MaterialCoverage.MaterialTypeName AS MaterialTypeName,
  I_MaterialCoverage.MaterialGroupName AS MaterialGroupName,
  I_MaterialCoverage.MaterialSafetyStockQty AS MaterialSafetyStockQty,
  I_MaterialCoverage.MaterialReorderPointQty AS MaterialReorderPointQty,
  I_MaterialCoverage.MRPAvailableStockQty AS MRPAvailableStockQty,
  I_MaterialCoverage.HasMaterialShortageReplnmtLead AS HasMaterialShortageReplnmtLead,
  I_MaterialCoverage.HasShortageTotalReplnmtLead AS HasShortageTotalReplnmtLead,
  I_MaterialCoverage.HasShortageManualPlanHorizon AS HasShortageManualPlanHorizon,
  I_MaterialCoverage.HasShortageMRPSafetyDuration AS HasShortageMRPSafetyDuration,
  _UnitOfMeasure.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  I_MaterialCoverage.MaterialShortageStartDate AS MaterialShortageStartDate,
  I_MaterialCoverage.MaterialShortageEndDate AS MaterialShortageEndDate,
  concat(MaterialShortageProfile, MaterialShortageProfileCount) AS MaterialShortageDefinition,
  cast( '' as md_supplier ) AS Supplier,
  cast ('' as suppliername_2) AS SupplierName,
  I_MaterialCoverage.NumberOfSupplier AS NumberOfSupplier,
  I_MaterialCoverage.MRPPlanningSegmentExternalCode AS MRPPlanningSegmentExternalCode
;

Learn More