A_CharcAttribSeldSetCode

DDL: A_CHARCATTRIBSELDSETCODE SQL: ACHATTRSELSETC Type: view BASIC

Characteristic Attribute Selected Set Codes and Code Groups

A_CharcAttribSeldSetCode is a Basic CDS View that provides data about "Characteristic Attribute Selected Set Codes and Code Groups" in SAP S/4HANA. It reads from 1 data source (I_CharcAttribSelectedSetCode) and exposes 11 fields with key fields SelectedCodeSetPlant, SelectedCodeSet, CharacteristicAttributeCodeGrp, CharacteristicAttributeCode.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_CharcAttribSelectedSetCode I_CharcAttribSelectedSetCode from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ACHATTRSELSETC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Characteristic Attribute Selected Set Codes and Code Groups 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 #A view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SelectedCodeSetPlant I_CharcAttribSelectedSetCode SelectedCodeSetPlant
KEY SelectedCodeSet I_CharcAttribSelectedSetCode SelectedCodeSet
KEY CharacteristicAttributeCodeGrp I_CharcAttribSelectedSetCode CharacteristicAttributeCodeGrp
KEY CharacteristicAttributeCode I_CharcAttribSelectedSetCode CharacteristicAttributeCode
CharcAttributeValuation I_CharcAttribSelectedSetCode CharcAttributeValuation
DefectClass I_CharcAttribSelectedSetCode DefectClass
CharcAttribSeldSetCodeCrtedBy I_CharcAttribSelectedSetCode CharcAttribSeldSetCodeCrtedBy
CharcAttribSeldSetCodeCrtedOn I_CharcAttribSelectedSetCode CharcAttribSeldSetCodeCrtedOn
CharcAttribSeldSetCodeChgdBy I_CharcAttribSelectedSetCode CharcAttribSeldSetCodeChgdBy
CharcAttribSeldSetCodeChgdOn I_CharcAttribSelectedSetCode CharcAttribSeldSetCodeChgdOn
_CharcAttribSelectedCodeSet _CharcAttribSelectedCodeSet 
@AbapCatalog.sqlViewName: 'ACHATTRSELSETC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Characteristic Attribute Selected Set Codes and Code Groups'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@ObjectModel.compositionRoot: true
@ObjectModel.usageType: {
    dataClass: #MASTER,
    sizeCategory: #M,
    serviceQuality: #A
}
@ObjectModel.createEnabled: false
@ObjectModel.updateEnabled: false
@ObjectModel.deleteEnabled: false
@Metadata.ignorePropagatedAnnotations: true

define view A_CharcAttribSeldSetCode as select from I_CharcAttribSelectedSetCode 
// 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,
    I_CharcAttribSelectedSetCode.CharcAttributeValuation,
    I_CharcAttribSelectedSetCode.DefectClass,
    I_CharcAttribSelectedSetCode.CharcAttribSeldSetCodeCrtedBy,
    I_CharcAttribSelectedSetCode.CharcAttribSeldSetCodeCrtedOn,
    I_CharcAttribSelectedSetCode.CharcAttribSeldSetCodeChgdBy,
    I_CharcAttribSelectedSetCode.CharcAttribSeldSetCodeChgdOn,
    //Associations

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

Learn More