C_InhRepairOpenRepairOrderItem

DDL: C_INHREPAIROPENREPAIRORDERITEM Type: view_entity CONSUMPTION

Open Repair Order Items

C_InhRepairOpenRepairOrderItem is a Consumption CDS View that provides data about "Open Repair Order Items" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItem) and exposes 17 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItem ServiceItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Open Repair Order Items view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType I_ServiceDocumentItem ServiceObjectType
KEY ServiceDocument I_ServiceDocumentItem ServiceDocument
KEY ServiceDocumentItem I_ServiceDocumentItem ServiceDocumentItem
ReferenceInHouseRepair I_ServiceDocumentItem ReferenceInHouseRepair
ReferenceInHouseRepairItem I_ServiceDocumentItem ReferenceInHouseRepairItem
ServiceEmployee I_ServiceDocumentItem ServiceEmployee
ResponsibleEmployee
Division I_ServiceDocumentItem Division
ServiceDocumentType I_ServiceDocumentItem ServiceDocumentType
SalesOrganization I_ServiceDocumentItem SalesOrganization
DistributionChannel I_ServiceDocumentItem DistributionChannel
SalesOffice I_ServiceDocumentItem SalesOffice
SalesGroup I_ServiceDocumentItem SalesGroup
SalesOrganizationOrgUnitID I_ServiceDocumentItem SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID I_ServiceDocumentItem SalesOfficeOrgUnitID
SalesGroupOrgUnitID I_ServiceDocumentItem SalesGroupOrgUnitID
ServiceOrganization I_ServiceDocumentItem ServiceOrganization 
@AccessControl: {
    authorizationCheck: #MANDATORY, 
    personalData.blocking: #('TRANSACTIONAL_DATA')
}
@EndUserText.label: 'Open Repair Order Items'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #CONSUMPTION
@Metadata.ignorePropagatedAnnotations: true

define view entity C_InhRepairOpenRepairOrderItem as select from I_ServiceDocumentItem as ServiceItem {
  key ServiceItem.ServiceObjectType,
  key ServiceItem.ServiceDocument,
  key ServiceItem.ServiceDocumentItem,
  ServiceItem.ReferenceInHouseRepair,
  ServiceItem.ReferenceInHouseRepairItem,
  ServiceItem.ServiceEmployee,
  
  @Consumption.hidden: true
  cast(ServiceItem.ResponsibleEmployee as resp_empl ) as ResponsibleEmployee,
  
  @Consumption.hidden: true
  ServiceItem.Division,
  
  @Consumption.hidden: true
  ServiceItem.ServiceDocumentType,
  
  @Consumption.hidden: true
  ServiceItem.SalesOrganization,
  
  @Consumption.hidden: true
  ServiceItem.DistributionChannel,
  
  @Consumption.hidden: true
  ServiceItem.SalesOffice,
  
  @Consumption.hidden: true
  ServiceItem.SalesGroup,
  
  @Consumption.hidden: true
  ServiceItem.SalesOrganizationOrgUnitID,
  
  @Consumption.hidden: true
  ServiceItem.SalesOfficeOrgUnitID,
  
  @Consumption.hidden: true
  ServiceItem.SalesGroupOrgUnitID,
  
  @Consumption.hidden: true
  ServiceItem.ServiceOrganization
}
where ServiceItem.ServiceDocumentItemObjectType = 'BUS2000140' // Service Product Item

and ServiceItem.ServiceDocumentItemIsOpen = 'X' //open, in process or released

and ServiceItem.ServiceDocumentItemIsQuotation = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More