A_ServiceContrItmReleasedOrder

DDL: A_SERVICECONTRITMRELEASEDORDER Type: view CONSUMPTION

Item Released Order

A_ServiceContrItmReleasedOrder is a Consumption CDS View that provides data about "Item Released Order" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocumentItemSuccssr_2, I_ServiceDocumentItemEnhcd) and exposes 7 fields with key fields ServiceDocumentItmRelationUUID, ServiceDocItmRltnSqncNumber. It has 1 association to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_ServiceDocumentItemSuccssr_2 ItemSuccssr from
I_ServiceDocumentItemEnhcd ServiceDocumentItem inner

Associations (1)

CardinalityTargetAliasCondition
[1] A_ServiceContractItem _ServiceContractItem $projection.ServiceContract = _ServiceContractItem.ServiceContract and $projection.ServiceContractItem = _ServiceContractItem.ServiceContractItem

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Item Released Order view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ASRVCTRITMRLEORD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentItmRelationUUID I_ServiceDocumentItemSuccssr_2 ServiceDocumentItmRelationUUID
KEY ServiceDocItmRltnSqncNumber I_ServiceDocumentItemSuccssr_2 ServiceDocItmRltnSqncNumber
ServiceContract I_ServiceDocumentItemEnhcd ServiceDocument
ServiceContractItem I_ServiceDocumentItemEnhcd ServiceDocumentItem
ServiceOrder
ServiceOrderItem
_ServiceContractItem _ServiceContractItem 
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Item Released Order'
@VDM: {
  viewType: #CONSUMPTION,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ASRVCTRITMRLEORD',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   createEnabled: false,
   updateEnabled: false,
   deleteEnabled: false,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
@Metadata.ignorePropagatedAnnotations: true

define view A_ServiceContrItmReleasedOrder
  as select from I_ServiceDocumentItemSuccssr_2 as ItemSuccssr
    inner join   I_ServiceDocumentItemEnhcd     as ServiceDocumentItem on ItemSuccssr.ServiceDocumentItemCharUUID = ServiceDocumentItem.ServiceDocumentItemCharUUID

  association [1] to A_ServiceContractItem as _ServiceContractItem on  $projection.ServiceContract     = _ServiceContractItem.ServiceContract
                                                                   and $projection.ServiceContractItem = _ServiceContractItem.ServiceContractItem
{
  key ItemSuccssr.ServiceDocumentItmRelationUUID,
  key ItemSuccssr.ServiceDocItmRltnSqncNumber,
      ServiceDocumentItem.ServiceDocument            as ServiceContract,
      ServiceDocumentItem.ServiceDocumentItem        as ServiceContractItem,

      ItemSuccssr._ServiceDocItm.ServiceDocument     as ServiceOrder,
      ItemSuccssr._ServiceDocItm.ServiceDocumentItem as ServiceOrderItem,

      //association

      _ServiceContractItem
}
where
      ServiceDocumentItem.ServiceObjectType      = 'BUS2000112'
  and ItemSuccssr.ServiceDocumentItemObjectType  = 'BUS2000137'
  and ItemSuccssr.ServiceDocItmSuccssrBusObjType = 'BUS2000140'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTITEMENHCD",
"I_SERVICEDOCUMENTITEMSUCCSSR_2"
],
"ASSOCIATED":
[
"A_SERVICECONTRACTITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More