VC_INTEGRATION_IBIN

DDL: VC_INTEGRATION_IBIN SQL: VCIIBIN Type: view

Extraction for IBIN

VC_INTEGRATION_IBIN is a CDS View that provides data about "Extraction for IBIN" in SAP S/4HANA. It reads from 1 data source (ibin) and exposes 27 fields with key field IN_RECNO.

Data Sources (1)

SourceAliasJoin Type
ibin ibin from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName VCIIBIN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L 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 IBIN view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY IN_RECNO in_recno
VALFR valfr
VALTO valto
AENNR aennr
DELFLAG delflag
INSTANCE instance
MLANG mlang
SORTF sortf
OBJNR objnr
IBASE ibase
AMOUNT amount
UNIT unit
DATUV datuv
TECHS techs
IN_OBJNR in_objnr
IN_GUID in_guid
OBJECTTYP objecttyp
VOID void
CSTATUS cstatus
CUCOCNT cucocnt
EXPERT expert
MAT_VARIANT mat_variant
ATAUT ataut
KLART klart
CRTIM crtim
UPTIM uptim
_DATAAGING _dataaging
@AbapCatalog.sqlViewName: 'VCIIBIN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #L
@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 IBIN'
define view VC_INTEGRATION_IBIN
  as select from ibin
{
      //IBIN

  key in_recno as IN_RECNO,
      valfr as VALFR,
      valto as VALTO,
      aennr as AENNR,
      delflag as DELFLAG,
      instance as INSTANCE,
      mlang as MLANG,
      sortf as SORTF,
      objnr as OBJNR,
      ibase as IBASE,
      amount as AMOUNT,
      unit as UNIT,
      datuv as DATUV,
      techs as TECHS,
      in_objnr as IN_OBJNR,
      in_guid as IN_GUID,
      objecttyp as OBJECTTYP,
      void as VOID,
      cstatus as CSTATUS,
      cucocnt as CUCOCNT,
      expert as EXPERT,
      mat_variant as MAT_VARIANT,
      ataut as ATAUT,
      klart as KLART,
      // crnam,

      crtim as CRTIM,
      // upnam,

      uptim as UPTIM,
      _dataaging as _DATAAGING
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"IBIN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/