I_CHARCATTRIBSELDSETCODESETTXT

CDS View

Text of Selected Set of Codes for Charac. Attributes

I_CHARCATTRIBSELDSETCODESETTXT is a CDS View in S/4HANA. Text of Selected Set of Codes for Charac. Attributes. It contains 4 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_CharcAttribSeldSetT view from BASIC Characteristic Attribute Selected Set Texts

Fields (4)

KeyField CDS FieldsUsed in Views
KEY Language Language 1
KEY SelectedCodeSet SelectedCodeSet 1
KEY SelectedCodeSetPlant SelectedCodeSetPlant 1
SelectedCodeSetText SelectedCodeSetText 1 
@AbapCatalog.sqlViewName: 'ICHATTSELDCDSETT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Text of Selected Set of Codes for Charac. Attributes'
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel.supportedCapabilities:
    [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #LANGUAGE_DEPENDENT_TEXT ]
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'SelectedCodeSet'
@ObjectModel.usageType: {
    dataClass: #CUSTOMIZING,
    sizeCategory: #S,
    serviceQuality: #A
}
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true
define view I_CharcAttribSeldSetCodeSetTxt as select from qpamtxt 

   association [0..1] to I_Plant                      as _SelectedCodeSetPlant           on  $projection.SelectedCodeSetPlant = _SelectedCodeSetPlant.Plant
   association [1..1] to I_CharcAttribSelectedCodeSet as _SelectedCodeSet                on  $projection.SelectedCodeSetPlant = _SelectedCodeSet.SelectedCodeSetPlant
                                                                                         and $projection.SelectedCodeSet      = _SelectedCodeSet.SelectedCodeSet
                                                                                         
{
       @ObjectModel.foreignKey.association: '_SelectedCodeSetPlant'
   key qpamtxt.werks                as SelectedCodeSetPlant,
       @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
   key qpamtxt.auswahlmge           as SelectedCodeSet,
       @Semantics.language: true
   key qpamtxt.language             as Language,
   
       @Semantics.text: true
       @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8 }
   cast( qpamtxt.ktx01 as vdm_qktextam preserving type ) as SelectedCodeSetText,
   
   
   /* Associations */
   _SelectedCodeSetPlant,
   _SelectedCodeSet
    
}
where katalogart = '1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"QPAMTXT"
],
"ASSOCIATED":
[
"I_CHARCATTRIBSELECTEDCODESET",
"I_PLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More