How many fields does I_MDChgProcessWorklistQueryTP have?

I_MDChgProcessWorklistQueryTP has 16 fields. Key fields: MDChgProcessSrceWlQueryUUID.

I_MDChgProcessWorklistQueryTP

Q: Which tables does I_MDChgProcessWorklistQueryTP use?

I_MDChgProcessWorklistQueryTP reads from 4 data source(s): mdc_d_prcwlquery, mdc_search_query, mdc_worklist, I_MDChgProcessSourceWorklistTP.

DDL: I_MDCHGPROCESSWORKLISTQUERYTP Type: view TRANSACTIONAL Package: MDC_PROCESS_OBJECT

Process Master Data Change Process Query

I_MDChgProcessWorklistQueryTP is a Transactional CDS View that provides data about "Process Master Data Change Process Query" in SAP S/4HANA. It reads from 4 data sources (mdc_d_prcwlquery, mdc_search_query, mdc_worklist, I_MDChgProcessSourceWorklistTP) and exposes 16 fields with key field MDChgProcessSrceWlQueryUUID. It has 3 associations to related views. It is exposed through 4 OData services (C_MASTERDATALOADFILETP_SRV, MASTERDATACHANGEPROCESSSD, MASTERDATACHANGEPROCESSSD, ...). Part of development package MDC_PROCESS_OBJECT.

Data Sources (4)

Source	Alias	Join Type
mdc_d_prcwlquery	queryNode	from
mdc_search_query	searchQuery	left_outer
mdc_worklist	worklist	left_outer
I_MDChgProcessSourceWorklistTP	worklistNode	inner

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_MDChgProcessSourceWorklistTP	_Parent	`_Parent.MDChgProcessSrceWlUUID = $projection.MDChgProcessSrceWlUUID`
[1..1]	I_MasterDataChangeProcessTP	_Root	`_Root.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID`
[1..1]	I_MDChangeProcessModelFieldVH	_Field	`_Field.MDChgProcessSrchQueryAttribute = $projection.MDChgProcessSrchQueryAttribute and _Field.MDChgProcessSrceObjectTypeCode = $projection.MDChgProcessSrceObjectTypeCode`

Annotations (11)

Name	Value	Level
EndUserText.label	Process Master Data Change Process Query	view
AbapCatalog.sqlViewName	IMDCHGPROCQRYTP	view
AbapCatalog.compiler.compareFilter	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.writeActivePersistence	IMDCHGPROCQRY_W	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view

OData Services (4)

Service	Binding	Version	Contract	Release
C_MASTERDATALOADFILETP_SRV	C_MASTERDATALOADFILETP_V4	V4	C1	NOT_RELEASED
MASTERDATACHANGEPROCESSSD	C_MASTERDATACHANGEPROCESS_V4	V4	C1	C1
MASTERDATACHANGEPROCESSSD	MASTERDATACHANGEPROCESSSB	V2	C1	NOT_RELEASED
MASTERDATACHANGEPROCESSSD	MDCHANGEPROCESSSB_2	V2	C1	NOT_RELEASED

Fields (16)

Key	Field	Source Table	Source Field
KEY	MDChgProcessSrceWlQueryUUID	mdc_d_prcwlquery	db_key
	MasterDataChangeProcessUUID	mdc_d_prcwlquery	root_key
	MDChgProcessSrceWlUUID	mdc_d_prcwlquery	parent_key
	MasterDataChangeProcess	mdc_d_prcwlquery	process_id
	MasterDataChgProcessWorklist	I_MDChgProcessSourceWorklistTP	MDChgProcessSourceWorklist
	MDChgProcessSrchQuery	mdc_d_prcwlquery	query_guid
	MDChgProcessSrchQueryAttribute	mdc_search_query	attributeqry
	MDChgProcessSrchQuerySign	mdc_search_query	signqry
	MDChgProcessSrchQueryOption	mdc_search_query	optionqry
	MDChgProcessSrchQueryLowValue	mdc_search_query	lowqry
	MDChgProcessSrchQueryHighValue	mdc_search_query	highqry
	MDChgProcessSrceObjectTypeCode	I_MDChgProcessSourceWorklistTP	MDChgProcessWlObjectTypeCode
	MDChangeProcessModelFieldDesc	_Field	MDChangeProcessModelFieldDesc
	_Parent		_Parent
	_Root		_Root
	_Field		_Field

@EndUserText.label: 'Process Master Data Change Process Query'
@AbapCatalog: {
  sqlViewName: 'IMDCHGPROCQRYTP',
  compiler.compareFilter: true
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
  writeActivePersistence: 'IMDCHGPROCQRY_W',
  createEnabled,
  updateEnabled,
  deleteEnabled,
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #C,
    sizeCategory: #M
  }
//  alternativeKey: [{

//    id : 'MDCHGPROCESSSRCHQUERY',

//    uniqueness : #UNIQUE_IF_NOT_INITIAL,

//    element : ['MASTERDATACHANGEPROCESS', 'MDCHGPROCESSSOURCEWORKLIST', 'MDCHGPROCESSSRCHQUERY' ]

//  }]

}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
define view I_MDChgProcessWorklistQueryTP
  as select from    mdc_d_prcwlquery               as queryNode
    inner join      I_MDChgProcessSourceWorklistTP as worklistNode on worklistNode.MDChgProcessSrceWlUUID = queryNode.parent_key
    left outer join mdc_worklist                   as worklist     on worklist.worklist_guid = worklistNode.MDChgProcessSourceWorklist
    left outer join mdc_search_query               as searchQuery  on  searchQuery.search_guid = worklist.search_guid
                                                                   and searchQuery.query_guid  = queryNode.query_guid

  association [1..1] to I_MDChgProcessSourceWorklistTP as _Parent on  _Parent.MDChgProcessSrceWlUUID = $projection.MDChgProcessSrceWlUUID
  association [1..1] to I_MasterDataChangeProcessTP    as _Root   on  _Root.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
  association [1..1] to I_MDChangeProcessModelFieldVH  as _Field  on  _Field.MDChgProcessSrchQueryAttribute = $projection.MDChgProcessSrchQueryAttribute
                                                                  and _Field.MDChgProcessSrceObjectTypeCode = $projection.MDChgProcessSrceObjectTypeCode
{
  key queryNode.db_key                          as MDChgProcessSrceWlQueryUUID,
      queryNode.root_key                        as MasterDataChangeProcessUUID,
      queryNode.parent_key                      as MDChgProcessSrceWlUUID,

      @Consumption.valueHelpDefinition: [{
        entity: { name: 'C_MDChgProcessActivatedProcess', element: 'MasterDataChangeProcess'},
        additionalBinding: [{ usage: #FILTER, element: 'MDChgProcessSrceObjectTypeCode', localElement: 'MDChgProcessSrceObjectTypeCode' }],
        useForValidation: true
      }]
      queryNode.process_id                      as MasterDataChangeProcess,
      worklistNode.MDChgProcessSourceWorklist   as MasterDataChgProcessWorklist,
      queryNode.query_guid                      as MDChgProcessSrchQuery,
      //      case

      //        when searchQuery.query_guid is not null then searchQuery.query_guid

      //        else queryNode.db_key

      //      end                                       as MDChgProcessSrchQuery,


      @Consumption.valueHelpDefinition: [{
        entity: { name: 'C_MDChangeProcessModelFieldVH', element: 'MDChgProcessSrchQueryAttribute'},
        useForValidation: true,
        additionalBinding: [
          { usage: #FILTER, element: 'MDChgProcessSrceObjectTypeCode', localElement: 'MDChgProcessSrceObjectTypeCode' },
          { usage: #FILTER, element: 'MDChgProcQryAttribIsSelective', localConstant: 'X' },
          { usage: #FILTER, element: 'MDChgProcQryAttribIsObscured', localConstant: ' ' },
          { usage: #FILTER, element: 'MDChgProcQryAttribIsTechnical', localConstant: ' ' }
        ]
      }]
      @UI.textArrangement: #TEXT_FIRST
      searchQuery.attributeqry                  as MDChgProcessSrchQueryAttribute,
      searchQuery.signqry                       as MDChgProcessSrchQuerySign,
      searchQuery.optionqry                     as MDChgProcessSrchQueryOption,
      searchQuery.lowqry                        as MDChgProcessSrchQueryLowValue,
      searchQuery.highqry                       as MDChgProcessSrchQueryHighValue,
      worklistNode.MDChgProcessWlObjectTypeCode as MDChgProcessSrceObjectTypeCode,
      _Field.MDChangeProcessModelFieldDesc      as MDChangeProcessModelFieldDesc,

      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _Parent,
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _Root,
      _Field
}

Depth:

I_MDChgProcessWorklistQueryTP view