VC_INTEGRATION_AUSP

DDL: VC_INTEGRATION_AUSP SQL: VCIAUSP Type: view

Extraction for AUSP

VC_INTEGRATION_AUSP is a CDS View that provides data about "Extraction for AUSP" in SAP S/4HANA. It reads from 1 data source (ausp) and exposes 37 fields with key fields OBJEK, ATINN, ATZHL, MAFID, KLART.

Data Sources (1)

SourceAliasJoin Type
ausp ausp from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName VCIAUSP 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 AUSP view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY OBJEK objek
KEY ATINN atinn
KEY ATZHL atzhl
KEY MAFID mafid
KEY KLART klart
KEY ADZHL adzhl
ATWRT atwrt
ATFLV atflv
ATAWE atawe
ATFLB atflb
ATAW1 ataw1
ATCOD atcod
ATTLV attlv
ATTLB attlb
ATPRZ atprz
ATINC atinc
ATAUT ataut
AENNR aennr
DATUV datuv
LKENZ lkenz
ATIMB atimb
ATZIS atzis
ATSRT atsrt
ATVGLART atvglart
DATUB datub
DEC_VALUE_FROM dec_value_from
DEC_VALUE_TO dec_value_to
CURR_VALUE_FROM curr_value_from
CURR_VALUE_TO curr_value_to
CURRENCY currency
DATE_FROM date_from
DATE_TO date_to
TIME_FROM time_from
TIME_TO time_to
PARTNER_GUID partner_guid
CHANGED_AT changed_at
TYPE_BP_GUID type_bp_guid
@AbapCatalog.sqlViewName: 'VCIAUSP'
@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 AUSP'
define view VC_INTEGRATION_AUSP
  as select from ausp
{
      //AUSP

  key objek as OBJEK,
  key atinn as ATINN,
  key atzhl as ATZHL,
  key mafid as MAFID,
  key klart as KLART,
  key adzhl as ADZHL,
      atwrt as ATWRT,
      atflv as ATFLV,
      atawe as ATAWE,
      atflb as ATFLB,
      ataw1 as ATAW1,
      atcod as ATCOD,
      attlv as ATTLV,
      attlb as ATTLB,
      atprz as ATPRZ,
      atinc as ATINC,
      ataut as ATAUT,
      aennr as AENNR,
      datuv as DATUV,
      lkenz as LKENZ,
      atimb as ATIMB,
      atzis as ATZIS,
      atsrt as ATSRT,
      atvglart as ATVGLART,
      datub as DATUB,
      dec_value_from as DEC_VALUE_FROM,
      dec_value_to as DEC_VALUE_TO,
      curr_value_from as CURR_VALUE_FROM,
      curr_value_to as CURR_VALUE_TO,
      currency as CURRENCY,
      date_from as DATE_FROM,
      date_to as DATE_TO,
      time_from as TIME_FROM,
      time_to as TIME_TO,
      partner_guid as PARTNER_GUID,
      changed_at as CHANGED_AT,
      // changed_by,

      type_bp_guid as TYPE_BP_GUID
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AUSP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/