How many fields does C_SrvcDocTypeProcStepOverview have?

C_SrvcDocTypeProcStepOverview has 9 fields. Key fields: ServiceDocumentType, SrvcProcessStepOverviewProfile, SrvcProcessStep.

C_SrvcDocTypeProcStepOverview

Q: Which tables does C_SrvcDocTypeProcStepOverview use?

C_SrvcDocTypeProcStepOverview reads from 3 data source(s): I_ServiceDocumentType, I_SrvcProcessStep, I_SrvcProcStpOvwProfileStep.

DDL: C_SRVCDOCTYPEPROCSTEPOVERVIEW Type: view CONSUMPTION Package: CRMS4_PSO

Mapping of Transaction Type and Profile

C_SrvcDocTypeProcStepOverview is a Consumption CDS View that provides data about "Mapping of Transaction Type and Profile" in SAP S/4HANA. It reads from 3 data sources (I_ServiceDocumentType, I_SrvcProcessStep, I_SrvcProcStpOvwProfileStep) and exposes 9 fields with key fields ServiceDocumentType, SrvcProcessStepOverviewProfile, SrvcProcessStep. It has 2 associations to related views. It is exposed through 1 OData service (UI_MANAGEINHREPAIRS). It is used in 1 Fiori application: Manage In-House Services. Part of development package CRMS4_PSO.

Data Sources (3)

Source	Alias	Join Type
I_ServiceDocumentType	ServiceDocumentType	from
I_SrvcProcessStep	SrvcProcessStep	inner
I_SrvcProcStpOvwProfileStep	SrvcProcStpOvwProfileStep	inner

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_SrvcProcStpOvwProfileStep	_SrvcProcStpOvwProfileStep	`$projection.SrvcProcessStepOverviewProfile = _SrvcProcStpOvwProfileStep.SrvcProcessStepOverviewProfile and $projection.SrvcProcessStep = _SrvcProcStpOvwProfileStep.SrvcProcessStep`
[0..*]	C_SrvcProcStpOvwProfileStatus	_CustMgmtLifecycleUserStatus	`$projection.SrvcProcessStepOverviewProfile = _CustMgmtLifecycleUserStatus.SrvcProcessStepOverviewProfile and $projection.SrvcProcessStep = _CustMgmtLifecycleUserStatus.SrvcProcessStep`

Annotations (12)

Name	Value	Level
EndUserText.label	Mapping of Transaction Type and Profile	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ObjectModel.representativeKey	ServiceDocumentType	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
Metadata.ignorePropagatedAnnotations	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.sqlViewName	CSRVPROSTEP	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_MANAGEINHREPAIRS	UI_MANAGEINHREPAIRS	V2	C1	NOT_RELEASED

Fiori Apps (1)

App ID	App Name	Type	Description
F4025	Manage In-House Services	Transactional	You can use this app to create and process in-house services, and add in-house objects (service object) for which you want to perform maintenance or repair. You can filter, sort, and group a list of all in-house services in the system. You can also call up in-house services, and change their data.

Manage In-House Services

Business Role: Service Manager

You can use this app to create and process in-house repairs, and add the objects to be repaired. You can filter, sort, and group a list of all in-house repairs in the system. You can also call up in-house repairs, and change their data.

Fields (9)

Key	Field	Source Table	Source Field
KEY	ServiceDocumentType	I_ServiceDocumentType	ServiceDocumentType
KEY	SrvcProcessStepOverviewProfile	I_SrvcProcStpOvwProfileStep	SrvcProcessStepOverviewProfile
KEY	SrvcProcessStep	I_SrvcProcStpOvwProfileStep	SrvcProcessStep
	SrvcProcessStepIcon
	SrvcProcessStepSequenceValue	I_SrvcProcStpOvwProfileStep	SrvcProcessStepSequenceValue
	SrvcProcessStepName	SrvcProcessStepText	SrvcProcessStepName
	_CustMgmtLifecycleUserStatus		_CustMgmtLifecycleUserStatus
	_SrvcProcStpOvwProfileStep		_SrvcProcStpOvwProfileStep
	_SrvcProcessStep		_SrvcProcessStep

@EndUserText.label: 'Mapping of Transaction Type and Profile'
@VDM: {
    viewType: #CONSUMPTION
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED
}
@ObjectModel: {
    representativeKey:'ServiceDocumentType',
    usageType: {serviceQuality: #B, sizeCategory: #S, dataClass: #CUSTOMIZING}
}
@Metadata: {
    ignorePropagatedAnnotations: true
}
@ClientHandling: {
    algorithm: #SESSION_VARIABLE
}
@AbapCatalog: {
    sqlViewName: 'CSRVPROSTEP',
    compiler.compareFilter: true,
    preserveKey: true
}

define view C_SrvcDocTypeProcStepOverview
  as select from I_ServiceDocumentType as ServiceDocumentType 
 
  inner join I_SrvcProcStpOvwProfileStep as SrvcProcStpOvwProfileStep on SrvcProcStpOvwProfileStep.SrvcProcessStepOverviewProfile = ServiceDocumentType.SrvcProcessStepOverviewProfile
 
  inner join I_SrvcProcessStep           as SrvcProcessStep           on SrvcProcessStep.SrvcProcessStep    = SrvcProcStpOvwProfileStep.SrvcProcessStep
 
  left outer to one join I_SrvcProcessStepText as SrvcProcessStepText on SrvcProcessStepText.SrvcProcessStep = SrvcProcessStep.SrvcProcessStep
                                                                     and SrvcProcessStepText.Language        = $session.system_language                               
 
  association [0..1] to I_SrvcProcStpOvwProfileStep as _SrvcProcStpOvwProfileStep on  $projection.SrvcProcessStepOverviewProfile = _SrvcProcStpOvwProfileStep.SrvcProcessStepOverviewProfile
                                                                                  and $projection.SrvcProcessStep                = _SrvcProcStpOvwProfileStep.SrvcProcessStep
  
  association [0..*] to C_SrvcProcStpOvwProfileStatus as _CustMgmtLifecycleUserStatus on $projection.SrvcProcessStepOverviewProfile = _CustMgmtLifecycleUserStatus.SrvcProcessStepOverviewProfile
                                                                                     and $projection.SrvcProcessStep                = _CustMgmtLifecycleUserStatus.SrvcProcessStep
 
 {
  key ServiceDocumentType.ServiceDocumentType                  as ServiceDocumentType,  
  @ObjectModel.foreignKey.association:'_SrvcProcStpOvwProfileStep'
  key SrvcProcStpOvwProfileStep.SrvcProcessStepOverviewProfile as SrvcProcessStepOverviewProfile,
  @ObjectModel.foreignKey.association:'_SrvcProcessStep'
  key SrvcProcStpOvwProfileStep.SrvcProcessStep                as SrvcProcessStep,
  
  
      SrvcProcessStep .SrvcProcessStepIcon                     as SrvcProcessStepIcon,      
      SrvcProcStpOvwProfileStep.SrvcProcessStepSequenceValue   as SrvcProcessStepSequenceValue,      
      SrvcProcessStepText.SrvcProcessStepName                  as SrvcProcessStepName,    
     
      _CustMgmtLifecycleUserStatus,
      _SrvcProcStpOvwProfileStep,
      _SrvcProcessStep
}

Depth:

C_SrvcDocTypeProcStepOverview view