@EndUserText.label: 'Value Help for Coverage with Filter'
@AbapCatalog:
{
sqlViewName: 'CCCMKTCVRGVH',
compiler.compareFilter: true,
preserveKey: true
}
--Access Control: Authorization checks
@AccessControl:
{
authorizationCheck: #CHECK
}
--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE
--VDM view type
@VDM.viewType: #CONSUMPTION
@ObjectModel:
{
dataCategory: #VALUE_HELP,
semanticKey: [ 'ChmlCmplncMktCvrgUUID' ],
representativeKey: 'ChmlCmplncMktCvrgUUID',
usageType:
{
dataClass: #MIXED,
sizeCategory: #S,
serviceQuality: #C
},
updateEnabled: true,
deleteEnabled: true,
// This is necessary because we call creatyEntry in the UI5 coding in order to create an empty entry on the
// specific marketability popup
createEnabled: true
}
--Header information
@UI:
{
headerInfo:
{
typeName: 'Specific Marketability',
typeNamePlural: 'Countries/Regions'
}
}
@Search.searchable: true
@Consumption.ranked: true
define view C_ChmlCmplncMktCvrgVH
with parameters
P_ChmlCmplncInfoUUID : sysuuid_x,
P_Country : ehfnd_country_id
as select from I_ChmlCmplncMktCvrg
//association [0..1] to I_ChmlCmplncMktCvrgStsVH as _CvrgStsImprtVH on _CvrgStsImprtVH.ChmlCmplncCvrgStatus = $projection.chmlcmplncimprtallwd
//association [0..1] to I_ChmlCmplncMktCvrgStsVH as _CvrgStsExprtVH on _CvrgStsExprtVH.ChmlCmplncCvrgStatus = $projection.chmlcmplncexprtallwd
association [0..1] to I_ChmlCmplncMktCvrgStsVH as _CvrgStsSalesVH on _CvrgStsSalesVH.ChmlCmplncCvrgStatus = $projection.ChmlCmplncSalesAllwd
// needed for DCL
association [1..1] to I_ChmlCmplncInfo as _ChmlCmplncInfo on _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
{
key ChmlCmplncMktCvrgUUID,
// needed for DCL
$parameters.P_ChmlCmplncInfoUUID as ChmlCmplncInfoUUID,
/*@UI:
{
textArrangement: #TEXT_ONLY,
identification :
{
position: 10,
importance: #HIGH
}
}
@ObjectModel:
{
text.element: [ 'ChmlCmplncImprtAllwdName' ],
foreignKey.association: '_CvrgStsImprtVH'
}
ChmlCmplncImprtAllwd,
// Production Allowed Name
@ObjectModel.readOnly: true
@Semantics.text: true
_CvrgStsImprtVH.ChmlCmplncCvrgStatusName as ChmlCmplncImprtAllwdName,
@UI:
{
textArrangement: #TEXT_ONLY,
identification :
{
position: 20,
importance: #HIGH
}
}
@ObjectModel:
{
text.element: [ 'ChmlCmplncExprtAllwdName' ],
foreignKey.association: '_CvrgStsExprtVH'
}
ChmlCmplncExprtAllwd,
// Production Allowed Name
@ObjectModel.readOnly: true
@Semantics.text: true
_CvrgStsExprtVH.ChmlCmplncCvrgStatusName as ChmlCmplncExprtAllwdName,
*/
@UI:
{
textArrangement: #TEXT_ONLY,
identification :
{
position: 30,
importance: #HIGH
}
}
@ObjectModel:
{
text.element: [ 'ChmlCmplncSalesAllwdName' ],
foreignKey.association: '_CvrgStsSalesVH'
}
ChmlCmplncSalesAllwd,
// Production Allowed Name
@ObjectModel.readOnly: true
@Semantics.text: true
@Search:
{
defaultSearchElement: true,
fuzzinessThreshold: 0.8,
ranking: #HIGH
}
_CvrgStsSalesVH.ChmlCmplncCvrgStatusName as ChmlCmplncSalesAllwdName,
//_CvrgStsExprtVH,
//_CvrgStsImprtVH,
_CvrgStsSalesVH,
_ChmlCmplncInfo
}
where
ChmlCmplncInfoUUID = $parameters.P_ChmlCmplncInfoUUID
and Country = $parameters.P_Country
union
select from I_ChmlCmplncMktCvrgDraft
//association [0..1] to I_ChmlCmplncMktCvrgStsVH as _CvrgStsImprtVH on _CvrgStsImprtVH.ChmlCmplncCvrgStatus = $projection.ChmlCmplncImprtAllwd
//association [0..1] to I_ChmlCmplncMktCvrgStsVH as _CvrgStsExprtVH on _CvrgStsExprtVH.ChmlCmplncCvrgStatus = $projection.ChmlCmplncExprtAllwd
association [0..1] to I_ChmlCmplncMktCvrgStsVH as _CvrgStsSalesVH on _CvrgStsSalesVH.ChmlCmplncCvrgStatus = $projection.ChmlCmplncSalesAllwd
// needed for DCL
association [1..1] to I_ChmlCmplncInfo as _ChmlCmplncInfo on _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
{
key ChmlCmplncMktCvrgUUID,
// needed for DCL
$parameters.P_ChmlCmplncInfoUUID as ChmlCmplncInfoUUID,
/*@UI:
{
textArrangement: #TEXT_ONLY,
identification :
{
position: 10,
importance: #HIGH
}
}
@ObjectModel:
{
text.element: [ 'ChmlCmplncImprtAllwdName' ],
foreignKey.association: '_CvrgStsImprtVH'
}
ChmlCmplncImprtAllwd,
// Production Allowed Name
@ObjectModel.readOnly: true
@Semantics.text: true
_CvrgStsImprtVH.ChmlCmplncCvrgStatusName as ChmlCmplncImprtAllwdName,
@UI:
{
textArrangement: #TEXT_ONLY,
identification :
{
position: 20,
importance: #HIGH
}
}
@ObjectModel:
{
text.element: [ 'ChmlCmplncExprtAllwdName' ],
foreignKey.association: '_CvrgStsExprtVH'
}
ChmlCmplncExprtAllwd,
// Production Allowed Name
@ObjectModel.readOnly: true
@Semantics.text: true
_CvrgStsExprtVH.ChmlCmplncCvrgStatusName as ChmlCmplncExprtAllwdName,
*/
@UI:
{
textArrangement: #TEXT_ONLY,
identification :
{
position: 30,
importance: #HIGH
}
}
@ObjectModel:
{
text.element: [ 'ChmlCmplncSalesAllwdName' ],
foreignKey.association: '_CvrgStsSalesVH'
}
@Search:
{
fuzzinessThreshold: 0.8,
ranking: #HIGH
}
ChmlCmplncSalesAllwd,
// Production Allowed Name
@ObjectModel.readOnly: true
@Semantics.text: true
@Search:
{
defaultSearchElement: true,
fuzzinessThreshold: 0.8,
ranking: #HIGH
}
_CvrgStsSalesVH.ChmlCmplncCvrgStatusName as ChmlCmplncSalesAllwdName,
//_CvrgStsExprtVH,
//_CvrgStsImprtVH,
_CvrgStsSalesVH,
_ChmlCmplncInfo
}
where
ChmlCmplncInfoUUID = $parameters.P_ChmlCmplncInfoUUID
and Country = $parameters.P_Country