P_ProdPlantPlndIndepRqmtBasic

DDL: P_PRODPLANTPLNDINDEPRQMTBASIC SQL: PPIRMB Type: view BASIC

P_ProdPlantPlndIndepRqmtBasic is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (makt, mara, marc, t438m) and exposes 7 fields with key fields Product, Plant.

4 data source(s) 7 fields

Data Sources (4)

SourceAliasJoin Type
makt makt left_outer
mara mara inner
marc marc from
t438m t438m left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PPIRMB view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Product marc matnr
KEY Plant marc werks
PeriodType marc perkz
UnitOfMeasure mara meins
ProductName makt maktx
MRPController marc dispo
strgrendasStrategy_Group 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'PPIRMB'
@AbapCatalog.preserveKey:true

@VDM.private: true
@VDM.viewType: #BASIC

@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_ProdPlantPlndIndepRqmtBasic
  as select from    marc
    inner join      mara  on marc.matnr = mara.matnr
    left outer join makt  on  makt.spras = $session.system_language
                          and makt.matnr = marc.matnr
    left outer join t438m on  t438m.werks = marc.werks
                          and t438m.mtart = marc.disgr
{
  key   marc.matnr as Product,
  key   marc.werks as Plant,
        marc.perkz as PeriodType,
        mara.meins as UnitOfMeasure,
        makt.maktx as ProductName,
        marc.dispo as MRPController,
        case when marc.strgr = '' and t438m.strgr is not null
          then t438m.strgr
          else marc.strgr
          end      as Strategy_Group
//        marc.strgr as Strategy_Group


        
}
where
  (
       /* Select materials with Month/Week as plan indicator or those that haven't been planned */
       marc.perkz =  'M'
    or marc.perkz =  'W'
    //or marc.perkz =  ''

  )
  and  mara.lvorm =  '' -- ignore materilas deleted at client level
  and  marc.lvorm =  '' -- ignore materilas deleted at plant level
  and  ( marc.strgr <> '' or  marc.disgr <> '' ) -- ignore materials without MRP Stratergy
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MAKT",
"MARA",
"MARC",
"T438M"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More