P_MaintOrdConfOrderStatus

DDL: P_MAINTORDCONFORDERSTATUS SQL: PMTORDCONFSYSST Type: view CONSUMPTION

P_MaintOrdConfOrderStatus is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrder) and exposes 2 fields with key field MaintenanceOrder.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrder I_MaintenanceOrder from

Annotations (4)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PMTORDCONFSYSST view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder I_MaintenanceOrder MaintenanceOrder
MaintenanceOrderInternalID I_MaintenanceOrder MaintenanceOrderInternalID 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PMTORDCONFSYSST'

define view P_MaintOrdConfOrderStatus
  as select from           I_MaintenanceOrder
    left outer to one join I_StsObjConcatActiveStsILL as _StsObjConcatActiveStsILL on _StsObjConcatActiveStsILL.StatusObject = I_MaintenanceOrder.MaintenanceOrderInternalID
{
  key I_MaintenanceOrder.MaintenanceOrder,

      I_MaintenanceOrder.MaintenanceOrderInternalID,

      _StsObjConcatActiveStsILL.ConcatenatedActiveSystStsName
}

Learn More