I_CacheSupplyDemandItem

DDL: I_CACHESUPPLYDEMANDITEM SQL: ICACHESUPDEMITEM Type: view BASIC
31 Fields 1 Data Sources

Supply Demand and Uncovered Demand Item

I_CacheSupplyDemandItem is a Basic CDS View that provides data about "Supply Demand and Uncovered Demand Item" in SAP S/4HANA. It reads from 1 data source (pph_cache_item) and exposes 31 fields with key fields MRPPlant, Material, MRPArea, MRPPlanningSegmentType, MRPPlanningSegment.

Data Sources (1)

SourceAliasJoin Type
pph_cache_item CacheItem from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICACHESUPDEMITEM view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Supply Demand and Uncovered Demand Item view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY MRPPlant mrpplant Plant
KEY Material material Vehicle Model
KEY MRPArea mrparea MRP Area
KEY MRPPlanningSegmentType mrpplanningsegmenttype MRP segment
KEY MRPPlanningSegment mrpplanningsegmentnumber Plng Segmnt No.
KEY MRPElementCategory mrpelementcategory MRP Elmnt Ind.
KEY MRPElement mrpelement MRP element number
KEY MRPElementItem mrpelementitem MRP elemnt item
KEY MRPElementScheduleLine mrpelementscheduleline Scheduling
KEY MaterialShortageProfile materialshortageprofile Shortage Prf.
KEY NumberOfShortages materialshortageprof_cnt Counter
KEY MRPElementAvailyOrRqmtDate mrpelementavailyorrqmtdate Time Stamp
MRPElementEndDate pph_cache_item mrpelementenddate Date
MRPElementStartDate pph_cache_item mrpelementstartdate Order Start
MRPElementQuantityIsFirm pph_cache_item mrpelementquantityisfirm TRUE
MRPElementOpenQuantity pph_cache_item mrpelementopenquantity Rec./reqd qty
MRPElementTypeImportance pph_cache_item mrpelementtypeimportance Sort ind. 01
ProductionVersion pph_cache_item productionversion Version ID
Supplier pph_cache_item supplier Supplier
Customer pph_cache_item customer Sold-to Party
IssuingOrReceivingPlant pph_cache_item issuingorreceivingplant Transfer Plant
StorageLocation pph_cache_item storagelocation StorageLocation
SourceMRPElementCategory pph_cache_item sourcemrpelementcategory MRP Elmnt Ind.
SourceMRPElement pph_cache_item sourcemrpelement MRP element number
SourceMRPElementItem pph_cache_item sourcemrpelementitem MRP elemnt item
MRPElementUncoveredQuantity pph_cache_item mrpelementuncoveredquantity DEC 20 3
MRPElementDelayedQuantity pph_cache_item mrpelementdelayedquantity DEC 20 3
MaximumDelayDate pph_cache_item maximumdelaydate Date
MaximumDelayInDays pph_cache_item maximumdelayindays Max.DelayInDays
MaximumDelayInWorkdays pph_cache_item maximumdelayinworkdays MaxDelayWorkday
ProcurementProgress pph_cache_item procurementprogressindicator Proc. Progress

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 I_CacheSupplyDemandItem.
-- 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: ICACHESUPDEMITEM

CREATE VIEW I_CacheSupplyDemandItem AS
SELECT
  MRPPlant,
  Material,
  MRPArea,
  MRPPlanningSegmentType,
  mrpplanningsegmentnumber AS MRPPlanningSegment,
  MRPElementCategory,
  MRPElement,
  MRPElementItem,
  MRPElementScheduleLine,
  MaterialShortageProfile,
  materialshortageprof_cnt AS NumberOfShortages,
  MRPElementAvailyOrRqmtDate,
  CacheItem.mrpelementenddate AS MRPElementEndDate,
  CacheItem.mrpelementstartdate AS MRPElementStartDate,
  CacheItem.mrpelementquantityisfirm AS MRPElementQuantityIsFirm,
  CacheItem.mrpelementopenquantity AS MRPElementOpenQuantity,
  CacheItem.mrpelementtypeimportance AS MRPElementTypeImportance,
  CacheItem.productionversion AS ProductionVersion,
  CacheItem.supplier AS Supplier,
  CacheItem.customer AS Customer,
  CacheItem.issuingorreceivingplant AS IssuingOrReceivingPlant,
  CacheItem.storagelocation AS StorageLocation,
  CacheItem.sourcemrpelementcategory AS SourceMRPElementCategory,
  CacheItem.sourcemrpelement AS SourceMRPElement,
  CacheItem.sourcemrpelementitem AS SourceMRPElementItem,
  CacheItem.mrpelementuncoveredquantity AS MRPElementUncoveredQuantity,
  CacheItem.mrpelementdelayedquantity AS MRPElementDelayedQuantity,
  CacheItem.maximumdelaydate AS MaximumDelayDate,
  CacheItem.maximumdelayindays AS MaximumDelayInDays,
  CacheItem.maximumdelayinworkdays AS MaximumDelayInWorkdays,
  CacheItem.procurementprogressindicator AS ProcurementProgress
FROM pph_cache_item AS CacheItem
;

Learn More