@AbapCatalog.sqlViewName: 'IMDCHGPROCMDLFLD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Process model field'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@Search.searchable: true
define view I_MDChangeProcessModelField
as select from I_MDChangeProcessModelTable as Table
inner join I_MDChgProcModFieldProperty as Field on Field.MDChgProcessSrceObjectTypeCode = Table.MDChgProcessSrceObjectTypeCode
and Field.MDChgProcessModelTableName = Table.MDChgProcessModelTableName
left outer join I_MDChangeProcModelSpecialFld as SpecialField on SpecialField.MDChgProcessSrceObjectTypeCode = Field.MDChgProcessSrceObjectTypeCode
and SpecialField.MDChgProcessModelTableName = Field.MDChgProcessModelTableName
and SpecialField.MDChangeProcessModelFieldName = Field.MDChangeProcessModelFieldName
left outer join dd03l as dd03l on (
dd03l.tabname = Table.MDChgProcessModelTableName
// or dd03l.tabname = SpecialField.MDChgProcModelActiveTableName
)
and dd03l.fieldname = Field.MDChangeProcessModelFieldName
and dd03l.as4local = 'A'
and dd03l.as4vers = '0000'
left outer join I_MDChgProcModCstmFldPrpty as CustomField on CustomField.MDChgProcessSrceObjectTypeCode = Table.MDChgProcessSrceObjectTypeCode
and CustomField.MDChgProcessModelTableName = Table.MDChgProcessModelTableName
and CustomField.MDChangeProcessModelFieldName = Field.MDChangeProcessModelFieldName
and CustomField.client = $session.client
left outer join dd04t as dd04t on dd04t.rollname = dd03l.rollname
and dd04t.as4local = dd03l.as4local
and dd04t.as4vers = dd03l.as4vers
and dd04t.ddlanguage = $session.system_language
{
// key $session.client as mandt,
@EndUserText.label: 'Attribute'
@ObjectModel.text.element: ['MDChangeProcessModelFieldDesc']
key cast ( concat(concat(Table.MDChgProcessModelTableName, '-'), Field.MDChangeProcessModelFieldName) as mdc_search_query_attribute ) as MDChgProcessSrchQueryAttribute,
@Consumption.filter.hidden: true
key Table.MDChgProcessSrceObjectTypeCode as MDChgProcessSrceObjectTypeCode,
@EndUserText.label: 'Table'
@Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #MEDIUM}
Table.MDChgProcessModelTableName as MDChgProcessModelTableName,
@EndUserText.label: 'Table Description'
Table.MDChangeProcModelTableDesc as MDChangeProcModelTableDesc,
@EndUserText.label: 'Field'
@Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #MEDIUM}
Field.MDChangeProcessModelFieldName as MDChangeProcessModelFieldName,
@EndUserText.label: 'Field Description'
@Semantics.text: true
@Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH}
dd04t.ddtext as MDChangeProcessModelFieldDesc,
@UI.hidden : true
dd03l.keyflag as IsKeyField
}
where
(
CustomField.MDChgProcModelFieldIsObscured is initial
or CustomField.MDChgProcModelFieldIsObscured is null
and Field.MDChgProcModelFieldIsObscured is initial
)
and(
CustomField.MDChgProcModelFieldIsTechnical is initial
or CustomField.MDChgProcModelFieldIsTechnical is null
and Field.MDChgProcModelFieldIsTechnical is initial
)
// and Table.MDChgProcessSrceObjectTypeCode = '147'
union select from I_MDChgProcModelFieldExtension as ModelFieldExtension
left outer join I_MDChgProcModCstmFldPrpty as _Custom on _Custom.MDChgProcessSrceObjectTypeCode = ModelFieldExtension.MDChgProcessSrceObjectTypeCode
and _Custom.MDChgProcessModelTableName = ModelFieldExtension.MDChgProcessModelTableName
and _Custom.MDChangeProcessModelFieldName = ModelFieldExtension.MDChangeProcessModelFieldName
and _Custom.client = $session.client
left outer join I_MDChangeProcessModelTable as ModelTable on ModelFieldExtension.MDChgProcessModelTableName = ModelTable.MDChgProcessModelTableName
and ModelFieldExtension.MDChgProcessSrceObjectTypeCode = ModelTable.MDChgProcessSrceObjectTypeCode
{
@EndUserText.label: 'Attribute'
@ObjectModel.text.element: ['MDChangeProcessModelFieldDesc']
key cast ( concat(concat(
ModelFieldExtension.MDChgProcessModelTableName
, '-'), ModelFieldExtension.MDChangeProcessModelFieldName) as mdc_search_query_attribute ) as MDChgProcessSrchQueryAttribute,
@Consumption.filter.hidden: true
key ModelFieldExtension.MDChgProcessSrceObjectTypeCode,
@EndUserText.label: 'Table'
@Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #MEDIUM}
ModelFieldExtension.MDChgProcessModelTableName,
@EndUserText.label: 'Table Description'
ModelTable.MDChangeProcModelTableDesc as MDChangeProcModelTableDesc,
@EndUserText.label: 'Field'
@Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #MEDIUM}
ModelFieldExtension.MDChangeProcessModelFieldName,
@EndUserText.label: 'Field Description'
@Semantics.text: true
@Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH}
ModelFieldExtension.MDChangeProcessModelFieldDesc,
@UI.hidden : true
cast( '' as char1 preserving type ) as IsKeyField
}
where
// ModelFieldExtension.MDChgProcessSrceObjectTypeCode = '147' and
_Custom.MDChangeProcessModelFieldName is null
union select from I_MDChangeProcessModelTable as Table
inner join I_MDChangeProcModelSpecialFld as SpecialField on Table.MDChgProcessSrceObjectTypeCode = SpecialField.MDChgProcessSrceObjectTypeCode
and Table.MDChgProcessModelTableName = SpecialField.MDChgProcessModelTableName
left outer join dd03l as dd03l on dd03l.tabname = SpecialField.MDChgProcModelActiveTableName
and dd03l.fieldname = SpecialField.MDChangeProcessModelFieldName
and dd03l.as4local = 'A'
and dd03l.as4vers = '0000'
left outer join dd04t as dd04t on dd04t.rollname = dd03l.rollname
and dd04t.as4local = dd03l.as4local
and dd04t.as4vers = dd03l.as4vers
and dd04t.ddlanguage = $session.system_language
{
// key $session.client as mandt,
@EndUserText.label: 'Attribute'
@ObjectModel.text.element: ['MDChangeProcessModelFieldDesc']
key cast ( concat(concat(SpecialField.MDChgProcModelActiveTableName, '-'), SpecialField.MDChangeProcessModelFieldName) as mdc_search_query_attribute ) as MDChgProcessSrchQueryAttribute,
@Consumption.filter.hidden: true
key SpecialField.MDChgProcessSrceObjectTypeCode as MDChgProcessSrceObjectTypeCode,
@EndUserText.label: 'Table'
@Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #MEDIUM}
SpecialField.MDChgProcModelActiveTableName as MDChgProcessModelTableName,
@EndUserText.label: 'Table Description'
Table.MDChangeProcModelTableDesc as MDChangeProcModelTableDesc,
@EndUserText.label: 'Field'
@Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #MEDIUM}
SpecialField.MDChangeProcessModelFieldName as MDChangeProcessModelFieldName,
@EndUserText.label: 'Field Description'
@Semantics.text: true
@Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH}
dd04t.ddtext as MDChangeProcessModelFieldDesc,
@UI.hidden : true
dd03l.keyflag as IsKeyField
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MDCHANGEPROCESSMODELTABLE",
"I_MDCHANGEPROCMODELSPECIALFLD",
"I_MDCHGPROCMODCSTMFLDPRPTY",
"I_MDCHGPROCMODELFIELDEXTENSION",
"I_MDCHGPROCMODFIELDPROPERTY",
"DD03L",
"DD04T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/