I_SlsPrcgKeyCombination

DDL: I_SLSPRCGKEYCOMBINATION SQL: ISLSPRCGKEYCOM Type: view BASIC

Key Combination for Pricing in Sales

I_SlsPrcgKeyCombination is a Basic CDS View that provides data about "Key Combination for Pricing in Sales" in SAP S/4HANA. It reads from 1 data source (t685) and exposes 6 fields with key fields ConditionTable, ConditionType, AccessNumberOfAccessSequence. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
t685 t685 inner

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_SlsPrcgKeyCombinationText _Text $projection.ConditionType = _Text.conditiontype and $projection.AccessNumberOfAccessSequence = _Text.accessnumberofaccesssequence and $projection.ConditionTable = _Text.ConditionTable
[1..1] I_ConditionType _ConditionType $projection.ConditionType = _ConditionType.ConditionType and _ConditionType.ConditionUsage = 'A' and _ConditionType.ConditionApplication = 'V'

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ISLSPRCGKEYCOM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Key Combination for Pricing in Sales view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
UI.headerInfo.typeName Key Combination for Pricing in Sales view
UI.headerInfo.typeNamePlural Key Combination for Pricing in Sales view
Search.searchable true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ConditionTable
KEY ConditionType t685 kschl
KEY AccessNumberOfAccessSequence t682i kolnr
PrcgKeyCombinationText Key Combination
_Text _Text
_ConditionType _ConditionType 
@AbapCatalog.sqlViewName: 'ISLSPRCGKEYCOM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Key Combination for Pricing in Sales'
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM: {
  viewType: #BASIC
}
@ObjectModel:{
   usageType:{
     dataClass: #CUSTOMIZING,
     serviceQuality: #A,
     sizeCategory: #S
   }
}

@UI.headerInfo:{
  typeName:       'Key Combination for Pricing in Sales',
  typeNamePlural: 'Key Combination for Pricing in Sales'
}

@Search.searchable: true
define view I_SlsPrcgKeyCombination
  as select distinct from t682i
    inner join            t685 on  t682i.kvewe = t685.kvewe
                               and t682i.kappl = t685.kappl
                               and t682i.kozgf = t685.kozgf
                               and t682i.kvewe = 'A'
                               and t682i.kappl = 'V'
                               and t685.kozgf != ''

  association [0..*] to I_SlsPrcgKeyCombinationText as _Text          on  $projection.ConditionType                = _Text.conditiontype
                                                                      and $projection.AccessNumberOfAccessSequence = _Text.accessnumberofaccesssequence
                                                                      and $projection.ConditionTable               = _Text.ConditionTable
  association [1..1] to I_ConditionType             as _ConditionType on  $projection.ConditionType           = _ConditionType.ConditionType
                                                                      and _ConditionType.ConditionUsage       = 'A'
                                                                      and _ConditionType.ConditionApplication = 'V'
{

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.text.association: '_Text'
  key cast(t682i.kotabnr as kotabnr_char)  as ConditionTable,
      @Search:      { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
      @Consumption.valueHelpDefinition: [{ entity: { name: 'I_SalesPricingConditionTypeVH', element: 'ConditionType' } }]
      @ObjectModel.foreignKey.association: '_ConditionType'
  key t685.kschl                           as ConditionType,
      @Search:      { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
  key t682i.kolnr                          as AccessNumberOfAccessSequence,
      
      @EndUserText.label: 'Key Combination'
      @EndUserText.quickInfo: 'Key Combination'
      @Consumption.filter.hidden: true
      cast('' as txt1024)                 as PrcgKeyCombinationText,
      
      _Text,
      _ConditionType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T682I",
"T685"
],
"ASSOCIATED":
[
"I_CONDITIONTYPE",
"I_SLSPRCGKEYCOMBINATIONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More