VC_INTEGRATION_IBINVALUES

DDL: VC_INTEGRATION_IBINVALUES SQL: VCIIBINVALUES Type: view

Extraction for IBINVALUES

VC_INTEGRATION_IBINVALUES is a CDS View that provides data about "Extraction for IBINVALUES" in SAP S/4HANA. It reads from 1 data source (ibinvalues) and exposes 20 fields with key fields IN_RECNO, IN_SEGMCNT.

Data Sources (1)

SourceAliasJoin Type
ibinvalues ibinvalues from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName VCIIBINVALUES view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
EndUserText.label Extraction for IBINVALUES view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY IN_RECNO in_recno
KEY IN_SEGMCNT in_segmcnt
SYMBOL_ID symbol_id
ASSTYP asstyp
ATAUT ataut
MSEHI_LOW msehi_low
MSEHI_HIGH msehi_high
ATSRT atsrt
ATZIS atzis
ATIMB atimb
DEC_VALUE_FROM dec_value_from
DEC_VALUE_TO dec_value_to
DATE_FROM date_from
DATE_TO date_to
TIME_FROM time_from
TIME_TO time_to
CURRENCY currency
CURR_VALUE_FROM curr_value_from
CURR_VALUE_TO curr_value_to
_DATAAGING _dataaging
@AbapCatalog.sqlViewName: 'VCIIBINVALUES'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Analytics.dataExtraction: {
        enabled: true,  // Unfortunately only views with a prefix 'I_' and 'C_' are allowed to be released for C1 contract

        delta.changeDataCapture.automatic: true
}
@EndUserText.label: 'Extraction for IBINVALUES'
define view VC_INTEGRATION_IBINVALUES
  as select from ibinvalues
{
      //IBINVALUES

  key in_recno as IN_RECNO,
  key in_segmcnt as  IN_SEGMCNT,
      symbol_id as SYMBOL_ID,
      asstyp as ASSTYP,
      ataut as ATAUT,
      msehi_low as MSEHI_LOW,
      msehi_high as MSEHI_HIGH,
      atsrt as ATSRT,
      atzis as ATZIS,
      atimb as ATIMB,
      dec_value_from as DEC_VALUE_FROM,
      dec_value_to as DEC_VALUE_TO,
      date_from as DATE_FROM,
      date_to as DATE_TO,
      time_from as TIME_FROM,
      time_to as TIME_TO,
      currency as CURRENCY,
      curr_value_from as CURR_VALUE_FROM,
      curr_value_to as CURR_VALUE_TO,
      _dataaging as _DATAAGING
}