P_SFIAtOpActyForBackflush

DDL: P_SFIATOPACTYFORBACKFLUSH Type: view_entity COMPOSITE Package: MPE_EXEC_SFI

SFI at Operation Activity relevant for Backflush

P_SFIAtOpActyForBackflush is a Composite CDS View that provides data about "SFI at Operation Activity relevant for Backflush" in SAP S/4HANA. It reads from 4 data sources (I_SASStatus, I_ShopFloorItemConfirmation, I_ShopFloorItemStatus, I_SASStatus) and exposes 3 fields. Part of development package MPE_EXEC_SFI.

4 data source(s) 3 fields

Data Sources (4)

SourceAliasJoin Type
I_SASStatus SFIStatus inner
I_ShopFloorItemConfirmation ShopFloorItemConfirmation inner
I_ShopFloorItemStatus ShopFloorItemStatus from
I_SASStatus StartStatus inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (3)

KeyFieldSource TableSource FieldDescription
ShopFloorItem I_ShopFloorItemStatus ShopFloorItem
OpActyNtwkInstance I_ShopFloorItemStatus OpActyNtwkInstance
OpActyNtwkElement I_ShopFloorItemStatus OpActyNtwkElement 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_SFIAtOpActyForBackflush
  as select from I_ShopFloorItemStatus       as ShopFloorItemStatus
    inner join   I_ShopFloorItemConfirmation as ShopFloorItemConfirmation on ShopFloorItemConfirmation.ShopFloorItemStatusChangeDoc = ShopFloorItemStatus.SFIOpActyStsLastChgdByDoc
    inner join   I_SASStatus                 as SFIStatus                 on SFIStatus.StatusAndActionSchemaStatus = ShopFloorItemStatus.StatusAndActionSchemaStatus
    inner join   I_SASStatus                 as StartStatus               on StartStatus.StatusAndActionSchemaStatus = ShopFloorItemConfirmation.SASActionStartStatus

{
  ShopFloorItemStatus.ShopFloorItem,
  ShopFloorItemStatus.OpActyNtwkInstance,
  ShopFloorItemStatus.OpActyNtwkElement
}
where
        SFIStatus.SASStatusCategory   = 3 -- Completed
  or(
        SFIStatus.SASStatusCategory   = 7 -- Scrapped
    and StartStatus.SASStatusCategory = 2 -- from In Process
  )

Learn More