I_ConditionTypeText

DDL: I_CONDITIONTYPETEXT SQL: ICONDITIONTYPET Type: view BASIC

Condition Type - Text

I_ConditionTypeText is a Basic CDS View that provides data about "Condition Type - Text" in SAP S/4HANA. It reads from 1 data source (t685t) and exposes 7 fields with key fields Language, ConditionUsage, ConditionApplication, ConditionType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t685t t685t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ConditionApplication _ConditionApplication $projection.ConditionApplication = _ConditionApplication.ConditionApplication
[0..1] I_ConditionUsage _ConditionUsage $projection.ConditionUsage = _ConditionUsage.ConditionUsage

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName ICONDITIONTYPET view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Condition Type - Text view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 001 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ConditionType view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Language spras Off. Language
KEY ConditionUsage kvewe Usage
KEY ConditionApplication kappl Application
KEY ConditionType kschl Tax Item Type
ConditionTypeName Wgh.Dat.Ty.Txt.
_ConditionUsage _ConditionUsage
_ConditionApplication _ConditionApplication

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_ConditionTypeText.
-- 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.
-- SQL view name: ICONDITIONTYPET

CREATE VIEW I_ConditionTypeText AS
SELECT
  spras AS Language,
  kvewe AS ConditionUsage,
  kappl AS ConditionApplication,
  kschl AS ConditionType,
  cast(vtext as vtxtm ) AS ConditionTypeName
FROM t685t
LEFT OUTER JOIN I_ConditionApplication AS _ConditionApplication ON ConditionApplication = _ConditionApplication.ConditionApplication  -- association [0..1]
LEFT OUTER JOIN I_ConditionUsage AS _ConditionUsage ON ConditionUsage = _ConditionUsage.ConditionUsage  -- association [0..1]
;