VC_INTEGRATION_DD04T

DDL: VC_INTEGRATION_DD04T SQL: VCIDD04T Type: view

Extraction for DD04T

VC_INTEGRATION_DD04T is a CDS View that provides data about "Extraction for DD04T" in SAP S/4HANA. It reads from 1 data source (dd03l) and exposes 9 fields with key fields ROLLNAME, DDLANGUAGE, AS4LOCAL, AS4VERS.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
dd03l dd03l left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName VCIDD04T 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 #META view
Analytics.dataExtraction.enabled true view
EndUserText.label Extraction for DD04T view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ROLLNAME dd04t rollname
KEY DDLANGUAGE dd04t ddlanguage
KEY AS4LOCAL dd04t as4local
KEY AS4VERS dd04t as4vers
DDTEXT dd04t ddtext
REPTEXT dd04t reptext
SCRTEXT_S dd04t scrtext_s
SCRTEXT_M dd04t scrtext_m
SCRTEXT_L dd04t scrtext_l 
@AbapCatalog.sqlViewName: 'VCIDD04T'
@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: #META
@Analytics.dataExtraction: {
        enabled: true,  // Unfortunately only views with a prefix 'I_' and 'C_' are allowed to be released for C1 contract

        delta.changeDataCapture: {
            mapping:[
                {
                 table: 'dd04t',
                 role: #MAIN,
                 viewElement: [
                    'ROLLNAME',
                    'DDLANGUAGE',
                    'AS4LOCAL',
                    'AS4VERS'],
                 tableElement: [
                    'rollname',
                    'ddlanguage',
                    'as4local',
                    'as4vers']
                }
                ]
        }        
}
@EndUserText.label: 'Extraction for DD04T'
define view VC_INTEGRATION_DD04T as select distinct from dd04t left outer join dd03l on dd04t.rollname = dd03l.rollname 
{
  //DD04T

  key dd04t.rollname as ROLLNAME,
  key dd04t.ddlanguage as DDLANGUAGE,
  key dd04t.as4local as AS4LOCAL,
  key dd04t.as4vers as AS4VERS,
  dd04t.ddtext as DDTEXT,
  dd04t.reptext as REPTEXT,
  dd04t.scrtext_s as SCRTEXT_S,
  dd04t.scrtext_m as SCRTEXT_M,
  dd04t.scrtext_l as SCRTEXT_L
} where dd03l.tabname = 'KOMK' or dd03l.tabname = 'KOMP' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD03L",
"DD04T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More