P_SlsDocItmVarConfign

DDL: P_SLSDOCITMVARCONFIGN Type: view_entity BASIC Package: IQUOTE_API

Private view for variant config data

P_SlsDocItmVarConfign is a Basic CDS View that provides data about "Private view for variant config data" in SAP S/4HANA. It reads from 4 data sources (cabn, ibin, ibsymbol, ibinvalues) and exposes 5 fields with key fields ProductConfiguration, CharcInternalID, InstalledBaseSegmentVal. Part of development package IQUOTE_API.

4 data source(s) 5 fields

Data Sources (4)

SourceAliasJoin Type
cabn Characteristic inner
ibin IBN from
ibsymbol IBSY inner
ibinvalues IBVL inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProductConfiguration ibin instance
KEY CharcInternalID
KEY InstalledBaseSegmentVal ibinvalues in_segmcnt
CharcDescription cabn atnam
time_fromelseendasCharcValue 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM.private:true
@VDM.viewType: #BASIC
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
define view entity P_SlsDocItmVarConfign
  as select from ibin       as IBN
    inner join   ibinvalues as IBVL           on IBN.in_recno = IBVL.in_recno
    inner join   ibsymbol   as IBSY           on IBSY.symbol_id = IBVL.symbol_id
    inner join   cabn       as Characteristic on Characteristic.atinn = IBSY.atinn
{
  key IBN.instance                                        as ProductConfiguration,
  key cast( IBSY.atinn as atinn_no_conv preserving type ) as CharcInternalID,
  key IBVL.in_segmcnt                                     as InstalledBaseSegmentVal,
      Characteristic.atnam                                as CharcDescription,
      case Characteristic.atfor
       when 'CHAR' then IBSY.atwrt
            when 'CURR' then cast ( IBVL.curr_value_from as abap.char(50))
            when 'DATE' then IBVL.date_from
            when 'NUM'  then cast ( IBVL.dec_value_from as abap.char(50))
            when 'TIME' then IBVL.time_from
            else ''
            end                                           as CharcValue
}
where
      Characteristic.adzhl =  '0000'
  and IBN.valto            >= tstmp_current_utctimestamp()

Learn More