C_MDChangeProcessSource

DDL: C_MDCHANGEPROCESSSOURCE SQL: CMDCHGPROCSOURCE Type: view CONSUMPTION Package: MDC_PROCESS_OBJECT

Source Data Information

C_MDChangeProcessSource is a Consumption CDS View that provides data about "Source Data Information" in SAP S/4HANA. It reads from 1 data source (I_MDChangeProcessSourceTP) and exposes 12 fields with key field MDChgProcessSourceUUID. It has 3 associations to related views. It is exposed through 4 OData services (C_MDMYBPCHANGEPROCESS_SRV, MASTERDATACHANGEPROCESSSD, MASTERDATACHANGEPROCESSSD, ...). Part of development package MDC_PROCESS_OBJECT.

Data Sources (1)

SourceAliasJoin Type
I_MDChangeProcessSourceTP I_MDChangeProcessSourceTP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_MasterDataChangeProcess _Root _Root.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
[0..*] I_MDChgProcessSourceWorklistTP _SourceWorklist _SourceWorklist.MDChgProcessSourceUUID = $projection.MDChgProcessSourceUUID
[0..1] C_MDChgProcessSourceStatusVH _MDChgProcessSourceStatusVH _MDChgProcessSourceStatusVH.MDChgProcessSrceStatus = $projection.MDChgProcessSrceStatus

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CMDCHGPROCSOURCE view
EndUserText.label Source Data Information view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.draftEnabled false view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
Metadata.allowExtensions true view

OData Services (4)

ServiceBindingVersionContractRelease
C_MDMYBPCHANGEPROCESS_SRV C_MDMYBPCHANGEPROCESS_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 (12)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessSourceUUID MDChgProcessSourceUUID
MasterDataChangeProcessUUID MasterDataChangeProcessUUID
MasterDataChangeProcess MasterDataChangeProcess
MDChgProcessSrceSystem MDChgProcessSrceSystem
MDChgProcessSrceStatus MDChgProcessSrceStatus
MDChgProcessSourceStatusText _MDChgProcessSourceStatusVH MDChgProcessSourceStatusText
MDChgProcessSrceFilter MDChgProcessSrceFilter
MDChgProcessNmbrOfSrceRecords MDChgProcessNmbrOfSrceRecords
MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode
MDChgProcessSrceFilterChain MDChgProcessSrceFilterChain
_Root _Root
_SourceWorklist _SourceWorklist
@AbapCatalog.sqlViewName: 'CMDCHGPROCSOURCE'
@EndUserText.label: 'Source Data Information'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
//    compositionRoot: true,

    transactionalProcessingDelegated:true,
    createEnabled:true,
    updateEnabled:true,
    deleteEnabled:true,
    draftEnabled:false,
    usageType.serviceQuality: #C,
    usageType.sizeCategory : #L,
    usageType.dataClass: #MIXED
    }
@AccessControl.authorizationCheck: #CHECK
@Search.searchable: true
@Metadata.allowExtensions: true
define view C_MDChangeProcessSource
  as select from I_MDChangeProcessSourceTP
  association [1..1] to C_MasterDataChangeProcess      as _Root                       on _Root.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
  association [0..*] to I_MDChgProcessSourceWorklistTP as _SourceWorklist             on _SourceWorklist.MDChgProcessSourceUUID = $projection.MDChgProcessSourceUUID
  association [0..1] to C_MDChgProcessSourceStatusVH   as _MDChgProcessSourceStatusVH on _MDChgProcessSourceStatusVH.MDChgProcessSrceStatus = $projection.MDChgProcessSrceStatus
{
      //I_MDChangeProcessSourceTP

      @UI.hidden: true
      @Consumption.filter.hidden: true
  key MDChgProcessSourceUUID,
      @Consumption.filter.hidden: true
      MasterDataChangeProcessUUID,
      @Consumption.filter.hidden: true
      MasterDataChangeProcess,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7, ranking: #HIGH }
      @UI: { selectionField: [{position: 100}]}
      @Consumption.valueHelpDefinition: [
        { entity: {name: 'C_MDChgProcSrceFltrInProcVH', element: 'MDChgProcessSrceSystem'},
//        additionalBinding: [ { element: 'MDChgProcessSrceObjectTypeCode', localElement: 'MDChgProcessSrceObjectTypeCode', usage: #FILTER }],

        distinctValues: true }
        ]
      MDChgProcessSrceSystem,
      @Consumption.filter.hidden: true
      MDChgProcessSrceStatus,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @Consumption.filter.hidden: true
      _MDChgProcessSourceStatusVH.MDChgProcessSourceStatusText as MDChgProcessSourceStatusText,
      @Consumption.valueHelpDefinition: [
        { entity: {name: 'C_MDChgProcSrceFltrInProcVH', element: 'MDChgProcessSrceFilter'},
//        additionalBinding: [ { element: 'MDChgProcessSrceObjectTypeCode', localElement: 'MDChgProcessSrceObjectTypeCode', usage: #FILTER }],

        distinctValues: true }
        ]
      MDChgProcessSrceFilter,
      @Consumption.filter.hidden: true
      MDChgProcessNmbrOfSrceRecords,
      @Consumption.filter.hidden: true
      MDChgProcessSrceObjectTypeCode,
      @Consumption.filter.hidden: true
      MDChgProcessSrceFilterChain,
      /* Associations */
      //I_MDChangeProcessSourceTP

      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      @Consumption.filter.hidden: true
      _Root,
      @Consumption.filter.hidden: true
      _SourceWorklist
} 
  where MDChgProcessNmbrOfSrceRecords > 0