I_CACHESUPPLYDEMANDITEM

CDS View

Supply Demand and Uncovered Demand Item

I_CACHESUPPLYDEMANDITEM is a CDS View in S/4HANA. Supply Demand and Uncovered Demand Item. It contains 19 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 19 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MRPSalesDemand view left_outer COMPOSITE MRP Sales Demand
P_MRPProdDemandAggregation view left_outer COMPOSITE

Fields (19)

KeyField CDS FieldsUsed in Views
KEY MRPElement MRPElement 1
KEY MRPElementCategory MRPElementCategory 1
KEY MRPElementItem MRPElementItem 1
KEY MRPElementScheduleLine MRPElementScheduleLine 1
KEY NumberOfShortages MaterialShortageProfileCount 1
KEY SourceMRPElement SourceMRPElement 2
KEY SourceMRPElementCategory SourceMRPElementCategory 2
IssuingOrReceivingPlant IssuingOrReceivingPlant 1
MaximumDelayDate MaximumDelayDate 1
MaximumDelayInDays MaximumDelayInDays 1
MaximumDelayInWorkdays MaximumDelayInWorkdays 1
MRPElementAvailyOrRqmtDate MRPElementAvailyOrRqmtDate 1
MRPElementDelayedQuantity MRPElementDelayedQuantity 1
MRPElementOpenQuantity MRPElementOpenQuantity 1
MRPElementTypeImportance MRPElementTypeImportance 1
MRPElementUncoveredQuantity MRPElementUncoveredQuantity 1
ProcurementProgress ProcurementProgress 1
SourceMRPElementItem SourceMRPElementItem 1
StorageLocation StorageLocation 1 
@AbapCatalog.sqlViewName: 'ICACHESUPDEMITEM'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Supply Demand and Uncovered Demand Item'

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

@AccessControl: {authorizationCheck: #NOT_REQUIRED,
                personalData.blocking: #NOT_REQUIRED
}

@VDM.viewType: #BASIC

define view I_CacheSupplyDemandItem
  as select from pph_cache_item as CacheItem

{
  key mrpplant                                                        as MRPPlant,
  key material                                                        as Material,
  key mrparea                                                         as MRPArea,
  key mrpplanningsegmenttype                                          as MRPPlanningSegmentType,
  key mrpplanningsegmentnumber                                        as MRPPlanningSegment,
  key mrpelementcategory                                              as MRPElementCategory,
  key mrpelement                                                      as MRPElement,
  key mrpelementitem                                                  as MRPElementItem,
  key mrpelementscheduleline                                          as MRPElementScheduleLine,
  key materialshortageprofile                                         as MaterialShortageProfile,
  key materialshortageprof_cnt                                        as NumberOfShortages,
  key mrpelementavailyorrqmtdate                                      as 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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PPH_CACHE_ITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More