I_CommodityHedgeRequestStatus

DDL: I_COMMODITYHEDGEREQUESTSTATUS SQL: ICMMHDGREQSTS Type: view COMPOSITE Package: FIN_CMM_CMDTY_HEDGE_REQUESTS

Commodity Hedge Requests Status

I_CommodityHedgeRequestStatus is a Composite CDS View that provides data about "Commodity Hedge Requests Status" in SAP S/4HANA. It reads from 1 data source (I_SystemStatus) and exposes 1 field with key field SystemStatus. Part of development package FIN_CMM_CMDTY_HEDGE_REQUESTS.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_SystemStatus I_SystemStatus from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMMHDGREQSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Commodity Hedge Requests Status view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY SystemStatus SystemStatus 
@AbapCatalog.sqlViewName: 'ICMMHDGREQSTS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType : { dataClass: #MASTER,
                           sizeCategory: #S,
                           serviceQuality: #A }
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Commodity Hedge Requests Status'

define view I_CommodityHedgeRequestStatus
  as select from I_SystemStatus
{
  key SystemStatus
}
where
     SystemStatus = 'ICRQ1'
  or SystemStatus = 'ICRQ2'
  or SystemStatus = 'ICRQ3'
  or SystemStatus = 'ICRQ4'
  or SystemStatus = 'ICRQ5'
  or SystemStatus = 'ICRQ6'
  or SystemStatus = 'ICRQ7'
  or SystemStatus = 'ICRQ8'
  or SystemStatus = 'ICRQ9'
  or SystemStatus = 'ICRQA'
  or SystemStatus = 'ICRQB'
  or SystemStatus = 'ICRQC'
  or SystemStatus = 'ICRQD';

Learn More