I_CACHESUPPLIER

CDS View

MRP Cache Supplier

I_CACHESUPPLIER is a CDS View in S/4HANA. MRP Cache Supplier. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_CacheSupplier view from CONSUMPTION MRP Supplier
I_MRPSupplierCount view from COMPOSITE Number of Suppliers for a material 
@AbapCatalog.sqlViewName: 'ICACHESUPPLIER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'MRP Cache Supplier'

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.viewType: #BASIC
@AccessControl.personalData.blocking: #REQUIRED

define view I_CacheSupplier
  as select from pph_cache_suppl

  association [1..1] to I_SupplierMaster as _SupplierMaster on $projection.Supplier = _SupplierMaster.Supplier
  association [1..1] to I_Supplier       as _Supplier       on $projection.Supplier = _Supplier.Supplier


{
  key pph_cache_suppl.mrpplant                 as MRPPlant,
  key pph_cache_suppl.material                 as Material,
  key pph_cache_suppl.mrparea                  as MRPArea,
  key pph_cache_suppl.mrpplanningsegmenttype   as MRPPlanningSegmentType,
  key pph_cache_suppl.mrpplanningsegmentnumber as MRPPlanningSegment,
  key pph_cache_suppl.supplier                 as Supplier,
      pph_cache_suppl.sequencenumber           as SequenceNumber,
      pph_cache_suppl.mrpelementenddate        as MRPElementEndDate,
      _SupplierMaster.SupplierName             as SupplierName,
      _SupplierMaster.AuthorizationGroup,

      _SupplierMaster,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      _Supplier

}







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

Learn More