FSH_V_PLANNING_FILE_ENTRIES

DDL: FSH_V_PLANNING_FILE_ENTRIES SQL: FSH_V_PFE Type: view

Planning File entries for Fashion

FSH_V_PLANNING_FILE_ENTRIES is a CDS View that provides data about "Planning File entries for Fashion" in SAP S/4HANA. It reads from 4 data sources (pph_dbvm, mara, marc, t438a) and exposes 9 fields.

4 data source(s) 9 fields

Data Sources (4)

SourceAliasJoin Type
pph_dbvm dbvm inner
mara mara inner
marc marc_kmat left_outer
t438a t438a inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FSH_V_PFE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Planning File entries for Fashion view

Fields (9)

KeyFieldSource TableSource FieldDescription
mandt marc mandt
matnr pph_dbvm matnr
berid pph_dbvm berid
werks pph_dbvm werks
gsaen pph_dbvm gsaen
sobsl marc sobsl
dispo marc dispo
beskz marc beskz
disvf t438a disvf 
@AbapCatalog.sqlViewName: 'FSH_V_PFE'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #AUTOMATED
@ObjectModel.usageType: {serviceQuality: #X, sizeCategory: #XXL, dataClass:#TRANSACTIONAL}
@EndUserText.label: 'Planning File entries for Fashion'
define view FSH_V_PLANNING_FILE_ENTRIES
  as select distinct from marc
  inner join mara       as mara     on  marc.matnr = mara.matnr
  inner join t438a      as t438a    on  t438a.dismm = marc.dismm
  inner join pph_dbvm   as dbvm     on  dbvm.matnr = marc.matnr
                                    and dbvm.plscn = '000'                --"Long Term Planning not considered at this time"
                                    and dbvm.nodisp = ''                  --" no automatic MRP is filled
                                    and dbvm.sc_empty = ''
                                    and dbvm.werks = marc.werks
  left outer join marc as marc_kmat on  marc_kmat.matnr = mara.satnr      --" find KMAT for material variant, only MARC-level
                                    and marc_kmat.werks = marc.werks
  

  {               
    marc.mandt,
    dbvm.matnr,
    dbvm.berid,
    dbvm.werks,
    dbvm.gsaen,
    case 
      when mara.disst = ' ' 
        then '999'
      else mara.disst
    end as disst,
    marc.sobsl,
    marc.dispo,
    marc.beskz,
    t438a.disvf,
    case mara.kzkfg   -- fill groupid so that all variants belong to same group as KMAT
                      -- logic for PP/DS RPM, here only plant specific SATID is taken into account
     when 'X' 
      then marc.scm_matlocid_guid16
     when ' ' 
      then marc_kmat.scm_matlocid_guid16
    end as group_id,
    case marc.ppskz
     when 'X' 
      then
        case t438a.cbppt
          when '6' 
            then ' ' -- Plan in ABAP but read components from PPDS -> do not send to PPDS
         else 'E'    -- send to PP/DS
       end
     else ' ' -- in future here we can already determine whether ABAP or Hana is to be started
    end as mrp_kind
  } 
  where 
        t438a.disvf != 'N'  --No MRP
    and t438a.disvf != 'W'  --Replenishment (IS Retail)
  ;  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARA",
"MARC",
"PPH_DBVM",
"T438A"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More