P_OrderOpPRTStatusBasic

DDL: P_ORDEROPPRTSTATUSBASIC Type: view_entity COMPOSITE Package: VDM_PP_SFC

Order Operation PRT Status

P_OrderOpPRTStatusBasic is a Composite CDS View that provides data about "Order Operation PRT Status" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectStatusBasic) and exposes 7 fields with key field ObjectInternalID. It has 5 associations to related views. Part of development package VDM_PP_SFC.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatusBasic jest from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_StatusCode _PRTIsCreatedCode _PRTIsCreatedCode.StatusCode = 'I0001' and _PRTIsCreatedCode.StatusProfile = ''
[0..1] I_StatusCode _PRTIsReleasedCode _PRTIsReleasedCode.StatusCode = 'I0002' and _PRTIsReleasedCode.StatusProfile = ''
[0..1] I_StatusCode _PRTIsPrintedCode _PRTIsPrintedCode.StatusCode = 'I0007' and _PRTIsPrintedCode.StatusProfile = ''
[0..1] I_StatusCode _PRTIsDeletedCode _PRTIsDeletedCode.StatusCode = 'I0013' and _PRTIsDeletedCode.StatusProfile = ''
[0..1] I_StatusCode _PRTIsNotAvailableCode _PRTIsNotAvailableCode.StatusCode = 'I0095' and _PRTIsNotAvailableCode.StatusProfile = ''

Annotations (6)

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

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ObjectInternalID I_StatusObjectStatusBasic StatusObject
_StatusObject _StatusObject
_PRTIsCreatedCode _PRTIsCreatedCode
_PRTIsReleasedCode _PRTIsReleasedCode
_PRTIsPrintedCode _PRTIsPrintedCode
_PRTIsDeletedCode _PRTIsDeletedCode
_PRTIsNotAvailableCode _PRTIsNotAvailableCode 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// provides the non-aggregated system status for Operation PRTs

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


/*+[hideWarning] { "IDS" : [ "KEY_CHECK", "CALCULATED_FIELD_CHECK" ]  } */
define view entity P_OrderOpPRTStatusBasic
  as select from I_StatusObjectStatusBasic as jest

  association [0..1] to I_StatusCode as _PRTIsCreatedCode      on  _PRTIsCreatedCode.StatusCode    = 'I0001'
                                                               and _PRTIsCreatedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _PRTIsReleasedCode     on  _PRTIsReleasedCode.StatusCode    = 'I0002'
                                                               and _PRTIsReleasedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _PRTIsPrintedCode      on  _PRTIsPrintedCode.StatusCode    = 'I0007'
                                                               and _PRTIsPrintedCode.StatusProfile = ''           
  association [0..1] to I_StatusCode as _PRTIsDeletedCode      on  _PRTIsDeletedCode.StatusCode    = 'I0013'
                                                               and _PRTIsDeletedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _PRTIsNotAvailableCode on  _PRTIsNotAvailableCode.StatusCode    = 'I0095'
                                                               and _PRTIsNotAvailableCode.StatusProfile = ''
{
    // Key

key jest.StatusObject as ObjectInternalID,

    @Semantics.booleanIndicator: true
    case jest.StatusCode
      when 'I0001' then 'X'
      else ''
    end as OrderOperationPRTIsCreated,
    @Semantics.booleanIndicator: true
    case jest.StatusCode
      when 'I0002' then 'X'
      else ''
    end as OrderOperationPRTIsReleased,
    @Semantics.booleanIndicator: true
    case jest.StatusCode
      when 'I0007' then 'X'
      else ''
    end as OrderOperationPRTIsPrinted,
    @Semantics.booleanIndicator: true
    case jest.StatusCode
      when 'I0013' then 'X'
      else ''
    end as OrderOperationPRTIsDeleted,
    @Semantics.booleanIndicator: true
    case jest.StatusCode
      when 'I0095' then 'X'
      else ''
    end as OrdOperationPRTIsNotAvailable,

    // Associations

    _StatusObject,
    _PRTIsCreatedCode,
    _PRTIsReleasedCode,
    _PRTIsPrintedCode,
    _PRTIsDeletedCode,
    _PRTIsNotAvailableCode
}
where
  (     jest.StatusCode       = 'I0001'
    or  jest.StatusCode       = 'I0002'
    or  jest.StatusCode       = 'I0007'
    or  jest.StatusCode       = 'I0013'
    or  jest.StatusCode       = 'I0095'
  ) and jest.StatusIsInactive = ' ' 
    and jest.StatusObject like 'OF%';

Learn More