I_UsageDcsnSelectedCodeSetTxt

DDL: I_USAGEDCSNSELECTEDCODESETTXT SQL: IUDSELCODESETTXT Type: view BASIC

Selected Set Text of Codes for Usage Decision

I_UsageDcsnSelectedCodeSetTxt is a Basic CDS View that provides data about "Selected Set Text of Codes for Usage Decision" in SAP S/4HANA. It reads from 1 data source (qpamtxt) and exposes 6 fields with key fields SelectedCodeSetPlant, SelectedCodeSet, Language. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
qpamtxt qpamtxt from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_UsageDcsnSelectedCodeSet _UsageDcsnSelectedCodeSet $projection.SelectedCodeSetPlant = _UsageDcsnSelectedCodeSet.SelectedCodeSetPlant and $projection.SelectedCodeSet = _UsageDcsnSelectedCodeSet.SelectedCodeSet
[1..1] I_Plant _SelectedCodeSetPlant $projection.SelectedCodeSetPlant = _SelectedCodeSetPlant.Plant

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IUDSELCODESETTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Selected Set Text of Codes for Usage Decision view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey SelectedCodeSet view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SelectedCodeSetPlant qpamtxt werks
KEY SelectedCodeSet qpamtxt auswahlmge
KEY Language qpamtxt language
SelectedCodeSetText qpamtxt ktx01
_UsageDcsnSelectedCodeSet _UsageDcsnSelectedCodeSet
_SelectedCodeSetPlant _SelectedCodeSetPlant 
@AbapCatalog.sqlViewName: 'IUDSELCODESETTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Selected Set Text of Codes for Usage Decision'  // Field DDDDLSRCT-DDTEXT has 60 chars length.

@AccessControl.authorizationCheck: #MANDATORY
@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: { serviceQuality: #A, sizeCategory: #M, dataClass: #MASTER }
@Metadata.ignorePropagatedAnnotations: true

define view I_UsageDcsnSelectedCodeSetTxt as select from qpamtxt 

   association [1..1] to I_UsageDcsnSelectedCodeSet as _UsageDcsnSelectedCodeSet
      on  $projection.SelectedCodeSetPlant = _UsageDcsnSelectedCodeSet.SelectedCodeSetPlant
      and $projection.SelectedCodeSet      = _UsageDcsnSelectedCodeSet.SelectedCodeSet
      
   association [1..1] to I_Plant                 as _SelectedCodeSetPlant      
      on $projection.SelectedCodeSetPlant = _SelectedCodeSetPlant.Plant
      
{
      @ObjectModel.foreignKey.association: '_SelectedCodeSetPlant'
  key qpamtxt.werks               as SelectedCodeSetPlant,
      @ObjectModel.foreignKey.association: '_UsageDcsnSelectedCodeSet'
  key qpamtxt.auswahlmge          as SelectedCodeSet,
      @Semantics.language: true
  key qpamtxt.language            as Language, 
  
      @Semantics.text: true
      qpamtxt.ktx01               as SelectedCodeSetText,  
   
   /* Associations */
   _UsageDcsnSelectedCodeSet,
   _SelectedCodeSetPlant
   
  
} where qpamtxt.katalogart = '3'

Learn More