A_CharcAttribSeldSetCodeT

DDL: A_CHARCATTRIBSELDSETCODET SQL: ACHATTRSELSETCT Type: view BASIC

Characteristic Attribute Selected Set Code Texts

A_CharcAttribSeldSetCodeT is a Basic CDS View that provides data about "Characteristic Attribute Selected Set Code Texts" in SAP S/4HANA. It reads from 2 data sources (I_CharcAttribSelectedSetCode, I_CharcAttributeCodeText) and exposes 7 fields with key fields SelectedCodeSetPlant, SelectedCodeSet, CharacteristicAttributeCodeGrp, CharacteristicAttributeCode, Language.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_CharcAttribSelectedSetCode I_CharcAttribSelectedSetCode from
I_CharcAttributeCodeText I_CharcAttributeCodeText inner

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ACHATTRSELSETCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Characteristic Attribute Selected Set Code Texts view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY SelectedCodeSetPlant I_CharcAttribSelectedSetCode SelectedCodeSetPlant
KEY SelectedCodeSet I_CharcAttribSelectedSetCode SelectedCodeSet
KEY CharacteristicAttributeCodeGrp I_CharcAttribSelectedSetCode CharacteristicAttributeCodeGrp
KEY CharacteristicAttributeCode I_CharcAttribSelectedSetCode CharacteristicAttributeCode
KEY Language I_CharcAttributeCodeText Language
CharacteristicAttributeCodeTxt I_CharcAttributeCodeText CharacteristicAttributeCodeTxt
_CharcAttribSelectedCodeSet _CharcAttribSelectedCodeSet 
@AbapCatalog.sqlViewName: 'ACHATTRSELSETCT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Characteristic Attribute Selected Set Code Texts'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@ObjectModel.compositionRoot: true
@ObjectModel.usageType: {
    dataClass: #MASTER,
    sizeCategory: #M,
    serviceQuality: #B
}
@ObjectModel.createEnabled: false
@ObjectModel.updateEnabled: false
@ObjectModel.deleteEnabled: false
@Metadata.ignorePropagatedAnnotations: true

define view A_CharcAttribSeldSetCodeT as select from I_CharcAttribSelectedSetCode 
   inner join I_CharcAttributeCodeText 
    on I_CharcAttribSelectedSetCode.CharacteristicAttributeCodeGrp = I_CharcAttributeCodeText.CharacteristicAttributeCodeGrp
    and I_CharcAttribSelectedSetCode.CharacteristicAttributeCode = I_CharcAttributeCodeText.CharacteristicAttributeCode
// Required for authority checks

   association to parent A_CharcAttribSeldCodeSet as _CharcAttribSelectedCodeSet
      on  $projection.SelectedCodeSetPlant = _CharcAttribSelectedCodeSet.SelectedCodeSetPlant
      and $projection.SelectedCodeSet      = _CharcAttribSelectedCodeSet.SelectedCodeSet
{
    key I_CharcAttribSelectedSetCode.SelectedCodeSetPlant,
    key I_CharcAttribSelectedSetCode.SelectedCodeSet,
    key I_CharcAttribSelectedSetCode.CharacteristicAttributeCodeGrp,
    key I_CharcAttribSelectedSetCode.CharacteristicAttributeCode,
    key I_CharcAttributeCodeText.Language,
    I_CharcAttributeCodeText.CharacteristicAttributeCodeTxt,
    //Associations

    _CharcAttribSelectedCodeSet
}
where _CharcAttribSelectedCodeSet.InspectionSelectedSetStatus = '2'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_CHARCATTRIBSELDCODESET",
"I_CHARCATTRIBSELECTEDSETCODE",
"I_CHARCATTRIBUTECODETEXT"
],
"ASSOCIATED":
[
"A_CHARCATTRIBSELDCODESET"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More