I_CAUploadTableFieldDefinition

DDL: I_CAUPLOADTABLEFIELDDEFINITION SQL: ICAUPLDTABFDEF Type: view BASIC

Upload Tabellenfelder

I_CAUploadTableFieldDefinition is a Basic CDS View that provides data about "Upload Tabellenfelder" in SAP S/4HANA. It reads from 1 data source (dd03l) and exposes 10 fields with key fields DatabaseTable, DatabaseTableFieldName, DatabaseTableFieldPositionVal.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
dd03l dd03l from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICAUPLDTABFDEF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Upload Tabellenfelder view
ObjectModel.representativeKey DatabaseTableFieldName view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DatabaseTable dd03l tabname
KEY DatabaseTableFieldName dd03l fieldname
KEY DatabaseTableFieldPositionVal dd03l position
ABAPDataElement dd03l rollname
ABAPDictionaryDataType dd04l datatype
ABAPDictionaryDataTypeLength dd04l leng
ABAPDictionaryDataTypeDecimals dd04l decimals
ABAPLongFieldLabel dd04t scrtext_l
CAFieldIsMandatory
CDSViewField 
@AbapCatalog.sqlViewName: 'ICAUPLDTABFDEF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Upload Tabellenfelder'
@ObjectModel.representativeKey: 'DatabaseTableFieldName'
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #BASIC
define view I_CAUploadTableFieldDefinition
  as select from           dd03l
    left outer to one join dd04l on  dd04l.rollname = dd03l.rollname
                                 and dd04l.as4local = 'A'
                                 and dd04l.as4vers  = '0000'
    left outer to one join dd04t on  dd04t.rollname   = dd04l.rollname
                                 and dd04t.ddlanguage = $session.system_language
                                 and dd04t.as4local   = 'A'
                                 and dd04t.as4vers    = '0000'
{

  key  dd03l.tabname                  as DatabaseTable,

  key  dd03l.fieldname                as DatabaseTableFieldName,

  key  dd03l.position                 as DatabaseTableFieldPositionVal,

       dd03l.rollname                 as ABAPDataElement,

       dd04l.datatype                 as ABAPDictionaryDataType,

       dd04l.leng                     as ABAPDictionaryDataTypeLength,

       dd04l.decimals                 as ABAPDictionaryDataTypeDecimals,

       dd04t.scrtext_l                as ABAPLongFieldLabel,

       cast('' as abap.char(1))       as CAFieldIsMandatory,

       cast('' as globalfieldname_kk) as CDSViewField

}
where
      dd03l.as4local = 'A'
  and dd03l.as4vers  = '0000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD03L",
"DD04L",
"DD04T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More