P_OrderOperationStatusBasic

DDL: P_ORDEROPERATIONSTATUSBASIC Type: view_entity COMPOSITE Package: VDM_PP_SFC

Main System Status of Order Operation

P_OrderOperationStatusBasic is a Composite CDS View that provides data about "Main System Status of Order Operation" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectStatusBasic) and exposes 1 field with key field ObjectInternalID. Part of development package VDM_PP_SFC.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatusBasic jest from

Annotations (6)

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

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY ObjectInternalID I_StatusObjectStatusBasic StatusObject 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// provides the non-aggregated main operation system status per ObjectInternalID (multiple lines per key)

// to be used in aggregation views such as P_OrderOperationStatusBasicAgg only


/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view entity P_OrderOperationStatusBasic
  as select from I_StatusObjectStatusBasic as jest
{
      // Technical Key

  key jest.StatusObject as ObjectInternalID,
      // Status

      case jest.StatusCode
        when 'I0001' then 'X' else '' end as OperationIsCreated,
      case jest.StatusCode
        when 'I0002' then 'X' else '' end as OperationIsReleased,
      case jest.StatusCode
        when 'I0007' then 'X' else '' end as OperationIsPrinted,
      case jest.StatusCode
        when 'I0009' then 'X' else '' end as OperationIsConfirmed,
      case jest.StatusCode
        when 'I0010' then 'X' else '' end as OperationIsPartiallyConfirmed,
      case jest.StatusCode
        when 'I0013' then 'X' else '' end as OperationIsDeleted,
      case jest.StatusCode
        when 'I0045' then 'X' else '' end as OperationIsTechlyCompleted,
      case jest.StatusCode
        when 'I0046' then 'X' else '' end as OperationIsClosed,
      case jest.StatusCode
        when 'I0051' then 'X' else '' end as OperationIsConfdByMilestone,
      case jest.StatusCode
        when 'I0052' then 'X' else '' end as OperationIsManuallyConfirmed,
      case jest.StatusCode
        when 'I0117' then 'X' else '' end as OperationIsScheduled,
      case jest.StatusCode
        when 'I0328' then 'X' else '' end as OperationIsGenerated,        
      case jest.StatusCode
        when 'I0377' then 'X' else '' end as OperationIsPartiallyDelivered,
      case jest.StatusCode
        when 'I0378' then 'X' else '' end as OperationIsDelivered,
      case jest.StatusCode
        when 'I0650' then 'X' else '' end as ControlRecipeIsCreated
}
where
  (
       jest.StatusCode       = 'I0001'
    or jest.StatusCode       = 'I0002'
    or jest.StatusCode       = 'I0007'
    or jest.StatusCode       = 'I0009'
    or jest.StatusCode       = 'I0010'
    or jest.StatusCode       = 'I0013'
    or jest.StatusCode       = 'I0045'
    or jest.StatusCode       = 'I0046'
    or jest.StatusCode       = 'I0051'
    or jest.StatusCode       = 'I0052'
    or jest.StatusCode       = 'I0117'
    or jest.StatusCode       = 'I0328'
    or jest.StatusCode       = 'I0377'
    or jest.StatusCode       = 'I0378'
    or jest.StatusCode       = 'I0650'
 ) and jest.StatusIsInactive = '' 
   and jest.StatusObject like 'OV%';

Learn More