C_LegalContentRequestCntxtIDVH

DDL: C_LEGALCONTENTREQUESTCNTXTIDVH SQL: CLTREQCTXIDVH Type: view CONSUMPTION

Value help for Active LCM Context

C_LegalContentRequestCntxtIDVH is a Consumption CDS View that provides data about "Value help for Active LCM Context" in SAP S/4HANA. It reads from 1 data source (C_LCMActiveCntxtIdValueHelp) and exposes 25 fields with key field LglCntntMContext. It has 2 associations to related views.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
C_LCMActiveCntxtIdValueHelp C_LCMActiveCntxtIdValueHelp from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_LglCntntMContext _LegalContextExtension $projection.LglCntntMContextUUID = _LegalContextExtension.LglCntntMContextUUID
[1..*] C_LglCntxtHdrCstmFldMapping _LglCntxtHdrCstmFldMapping $projection.LglCntntMContextUUID = _LglCntxtHdrCstmFldMapping.LglCntntMContextUUID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CLTREQCTXIDVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.semanticKey LglCntntMContext view
ObjectModel.representativeKey LglCntntMContext view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Value help for Active LCM Context view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMContext LglCntntMContext Context ID
LglCntntMContextUUID LglCntntMContextUUID
LglCntntMContextTitle LglCntntMContextTitle Context Name
LglCntntMContextOwner LglCntntMContextOwner Context Owner
FirstName FirstName Owner First Name
LastName LastName Owner Last Name
LglCntntMProfile LglCntntMProfile Profile
LglCntntMLongTextUUID LglCntntMLongTextUUID
LglCntntMLongText LglCntntMLongText
LglCntntMGovLaw LglCntntMGovLaw
LglCntntMGovLawText LglCntntMGovLawText
LglCntntMCntxtLanguage LglCntntMCntxtLanguage
LglCntntMContextValidToDate LglCntntMContextValidToDate
LglCntntMCntxtAccessLvl LglCntntMCntxtAccessLvl
LglCntntMMainOrgType LglCntntMMainOrgType
LglCntntMMainOrgTypeName LglCntntMMainOrgTypeName
LglCntntMMainOrgCoCode LglCntntMMainOrgCoCode
CompanyCodeName CompanyCodeName
LglCntntMMainOrgPurOrg LglCntntMMainOrgPurOrg
PurchasingOrganizationName PurchasingOrganizationName
LglCntntMMainOrgSalesOrg LglCntntMMainOrgSalesOrg
SalesOrganizationName SalesOrganizationName
LglCntntMIntegrationType LglCntntMIntegrationType
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
_LglCntxtHdrCstmFldMapping _LglCntxtHdrCstmFldMapping 
@AbapCatalog.sqlViewName: 'CLTREQCTXIDVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.semanticKey:  'LglCntntMContext'
@ObjectModel.representativeKey: 'LglCntntMContext'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
//@ObjectModel.dataCategory: #VALUE_HELP

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Value help for Active LCM Context'
define view C_LegalContentRequestCntxtIDVH
  as select from C_LCMActiveCntxtIdValueHelp
  //Extension

  association [1..1] to E_LglCntntMContext          as _LegalContextExtension     on $projection.LglCntntMContextUUID = _LegalContextExtension.LglCntntMContextUUID
  association [1..*] to C_LglCntxtHdrCstmFldMapping as _LglCntxtHdrCstmFldMapping on $projection.LglCntntMContextUUID = _LglCntxtHdrCstmFldMapping.LglCntntMContextUUID
{
        @ObjectModel.text.element:  [ 'LglCntntMContextTitle' ]
        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        @UI.selectionField.position: 10
        @UI.lineItem.position: 10
        @EndUserText.label: 'Context ID'
  key   LglCntntMContext,

        @UI.hidden: true
        LglCntntMContextUUID,

        @Semantics.text: true
        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        @UI.selectionField.position: 15
        @UI.lineItem.position: 15
        @EndUserText.label: 'Context Name'
        LglCntntMContextTitle,

        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        @UI.selectionField.position: 20
        @UI.lineItem.position: 20
        @EndUserText.label: 'Context Owner'
        LglCntntMContextOwner,

        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        @UI.selectionField.position: 25
        @UI.lineItem.position: 25
        @EndUserText.label: 'Owner First Name'
        @Semantics.text: true
        FirstName,

        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        @UI.selectionField.position: 30
        @UI.lineItem.position: 30
        @EndUserText.label: 'Owner Last Name'
        @Semantics.text: true
        LastName,

        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        @UI.selectionField.position: 35
        @UI.lineItem.position: 35
        @EndUserText.label: 'Profile'
        @Semantics.text: true
        LglCntntMProfile,

        @UI.hidden:true
        LglCntntMLongTextUUID,

        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        @UI.selectionField: [{exclude: true}]
        @Search.fulltextIndex.required: true
        @UI.hidden:true
        LglCntntMLongText,

        @UI.hidden:true
        LglCntntMGovLaw,

        @UI.hidden:true
        //_LCMGovLawVH.LglCntntMGovLawText,

        LglCntntMGovLawText,

        @UI.hidden:true
        LglCntntMCntxtLanguage,

        @UI.hidden: true
        LglCntntMContextValidToDate,

        @UI.hidden: true
        LglCntntMCntxtAccessLvl,

        @UI.hidden: true
        LglCntntMMainOrgType,

        @UI.hidden: true
        LglCntntMMainOrgTypeName,

        @UI.hidden: true
        LglCntntMMainOrgCoCode,

        @UI.hidden: true
        CompanyCodeName,

        @UI.hidden: true
        LglCntntMMainOrgPurOrg,

        @UI.hidden: true
        PurchasingOrganizationName,

        @UI.hidden: true
        LglCntntMMainOrgSalesOrg,

        @UI.hidden: true
        SalesOrganizationName,

        @UI.hidden: true
        LglCntntMIntegrationType,

        @UI.hidden: true
        IsEndOfPurposeBlocked,
        
        @UI.hidden: true
        @ObjectModel.filter.enabled: false
        _LglCntxtHdrCstmFldMapping
}
where
  LglCntntMIntegrationType = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_LCMACTIVECNTXTIDVALUEHELP"
],
"ASSOCIATED":
[
"C_LGLCNTXTHDRCSTMFLDMAPPING",
"E_LGLCNTNTMCONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More