I_CAUploadTableFieldDefinition

DDL: I_CAUPLOADTABLEFIELDDEFINITION Type: view_entity BASIC Package: FKKINV_VDM_UTILS
10 Fields 1 Data Sources 2 OData Services

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. It is exposed through 2 OData services (ASQL_F4664, ASQL_F5081). Part of development package FKKINV_VDM_UTILS.

Data Sources (1)

SourceAliasJoin Type
dd03l dd03l from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Upload Tabellenfelder view
ObjectModel.representativeKey DatabaseTableFieldName view
Analytics.technicalName ICAUPLDTABFDEF view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4664 ASQL_F4664 C2 NOT_RELEASED
ASQL_F5081 ASQL_F5081 C2 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DatabaseTable dd03l tabname Table/Constant Value
KEY DatabaseTableFieldName dd03l fieldname UI Group FieldName
KEY DatabaseTableFieldPositionVal dd03l position Test Position
ABAPDataElement dd03l rollname Repr. Data Elem
ABAPDictionaryDataType dd04l datatype Field Type
ABAPDictionaryDataTypeLength dd04l leng No. of Characters
ABAPDictionaryDataTypeDecimals dd04l decimals Rounding Places
ABAPLongFieldLabel dd04t scrtext_l Long Fld Label
CAFieldIsMandatory
CDSViewField

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CAUploadTableFieldDefinition.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_CAUploadTableFieldDefinition AS
SELECT
  dd03l.tabname AS DatabaseTable,
  dd03l.fieldname AS DatabaseTableFieldName,
  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
FROM dd03l
;

Learn More