I_CABllbleItmUploadSchemaCSV

DDL: I_CABLLBLEITMUPLOADSCHEMACSV Type: view_entity BASIC

Upload Schema CSV (abr. Pos.)

I_CABllbleItmUploadSchemaCSV is a Basic CDS View that provides data about "Upload Schema CSV (abr. Pos.)" in SAP S/4HANA. It reads from 1 data source (tfk8109_csv) and exposes 15 fields with key field CAUploadSchema. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
tfk8109_csv tfk8109_csv from

Associations (7)

CardinalityTargetAliasCondition
[1..1] I_CABllbleItmUploadSchema _CABllbleItmUploadSchema $projection.CAUploadSchema = _CABllbleItmUploadSchema.CAUploadSchema
[0..1] I_CAUploadDelimiter _CAUploadDelimiter $projection.CAUploadDelimiterValue = _CAUploadDelimiter.CAUploadDelimiterValue
[0..1] I_CAUploadDecimalSeparator _CAUploadDecimalSeparator $projection.CAUploadDecimalSeparatorValue = _CAUploadDecimalSeparator.CAUploadDecimalSeparatorValue
[0..1] I_CAUploadThousandSeparator _CAUploadThousandSeparator $projection.CAUploadThousandSeparatorValue = _CAUploadThousandSeparator.CAUploadThousandSeparatorValue
[0..1] I_CAUploadDateFormat _CAUploadDateFormat $projection.CAUploadDateFormat = _CAUploadDateFormat.CAUploadDateFormat
[0..1] I_CAUploadTimeFormat _CAUploadTimeFormat $projection.CAUploadTimeFormat = _CAUploadTimeFormat.CAUploadTimeFormat
[0..1] I_CAUploadColumnSeparator _CAUploadColumnSeparator $projection.CAUploadColumnSeparatorValue = _CAUploadColumnSeparator.CAUploadColumnSeparatorValue

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Upload Schema CSV (abr. Pos.) view
ObjectModel.representativeKey CAUploadSchema view
Analytics.technicalName ICABIT8109_CSV view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CAUploadSchema tfk8109_csv upload_schema Upload Schema
CAUploadDelimiterValue Delimiter
CAUploadNumberOfStartLine tfk8109_csv start_line Number Start Line
CAUploadDecimalSeparatorValue
CAUploadThousandSeparatorValue
CAUploadCommentValue tfk8109_csv upl_comment Comment
CAUploadTimeFormat
CAUploadColumnSeparatorValue
_CABllbleItmUploadSchema _CABllbleItmUploadSchema
_CAUploadDelimiter _CAUploadDelimiter
_CAUploadDecimalSeparator _CAUploadDecimalSeparator
_CAUploadThousandSeparator _CAUploadThousandSeparator
_CAUploadDateFormat _CAUploadDateFormat
_CAUploadTimeFormat _CAUploadTimeFormat
_CAUploadColumnSeparator _CAUploadColumnSeparator

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_CABllbleItmUploadSchemaCSV.
-- 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_CABllbleItmUploadSchemaCSV AS
SELECT
  tfk8109_csv.upload_schema AS CAUploadSchema,
  cast( tfk8109_csv.delimiter as upload_delimiter_kk preserving type ) AS CAUploadDelimiterValue,
  tfk8109_csv.start_line AS CAUploadNumberOfStartLine,
  cast( tfk8109_csv.decimal_separator as upload_decimal_separator_kk preserving type ) AS CAUploadDecimalSeparatorValue,
  cast( tfk8109_csv.thousand_separator as upload_thousand_separator_kk preserving type ) AS CAUploadThousandSeparatorValue,
  tfk8109_csv.upl_comment AS CAUploadCommentValue,
  cast( '0' as upload_time_format_kk ) AS CAUploadTimeFormat,
  cast( tfk8109_csv.column_separator as upload_column_separator_kk preserving type ) AS CAUploadColumnSeparatorValue
FROM tfk8109_csv
LEFT OUTER JOIN I_CABllbleItmUploadSchema AS _CABllbleItmUploadSchema ON CAUploadSchema = _CABllbleItmUploadSchema.CAUploadSchema  -- association [1..1]
LEFT OUTER JOIN I_CAUploadDelimiter AS _CAUploadDelimiter ON CAUploadDelimiterValue = _CAUploadDelimiter.CAUploadDelimiterValue  -- association [0..1]
LEFT OUTER JOIN I_CAUploadDecimalSeparator AS _CAUploadDecimalSeparator ON CAUploadDecimalSeparatorValue = _CAUploadDecimalSeparator.CAUploadDecimalSeparatorValue  -- association [0..1]
LEFT OUTER JOIN I_CAUploadThousandSeparator AS _CAUploadThousandSeparator ON CAUploadThousandSeparatorValue = _CAUploadThousandSeparator.CAUploadThousandSeparatorValue  -- association [0..1]
LEFT OUTER JOIN I_CAUploadDateFormat AS _CAUploadDateFormat ON CAUploadDateFormat = _CAUploadDateFormat.CAUploadDateFormat  -- association [0..1]
LEFT OUTER JOIN I_CAUploadTimeFormat AS _CAUploadTimeFormat ON CAUploadTimeFormat = _CAUploadTimeFormat.CAUploadTimeFormat  -- association [0..1]
LEFT OUTER JOIN I_CAUploadColumnSeparator AS _CAUploadColumnSeparator ON CAUploadColumnSeparatorValue = _CAUploadColumnSeparator.CAUploadColumnSeparatorValue  -- association [0..1]
;