I_ConditionType

DDL: I_CONDITIONTYPE SQL: ICONDITIONTYPE Type: view BASIC

Condition Type

I_ConditionType is a Basic CDS View that provides data about "Condition Type" in SAP S/4HANA. It reads from 1 data source (t685) and exposes 6 fields with key fields ConditionUsage, ConditionApplication, ConditionType. It has 3 associations to related views.

SAP Help Documentation

CategoryPrice Management
StatusReleased
Purpose
This CDS view retrieves relevant data about condition types. It provides the prerequisites for answering the following business questions: What are the available condition types? What is the usage of a given condition type? Which application area is a given condition type used for?

Structure
Object types This view relates to the following SAP object types: SalesPricingConditionRecord PurgPricingConditionRecord Main CDS parameters and filters No parameters or filters are provided. Measures and attributes This CDS view provides the following attributes: Condition type ( ConditionType ) Usage ( ConditionUsage ) Application ( ConditionApplication )

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
t685 t685 from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ConditionApplication _ConditionApplication $projection.ConditionApplication = _ConditionApplication.ConditionApplication
[0..1] I_ConditionUsage _ConditionUsage $projection.ConditionUsage = _ConditionUsage.ConditionUsage
[0..*] I_ConditionTypeText _Text $projection.ConditionType = _Text.ConditionType and $projection.ConditionApplication = _Text.ConditionApplication and $projection.ConditionUsage = _Text.ConditionUsage

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ICONDITIONTYPE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE 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
EndUserText.label Condition Type view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey ConditionType view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ConditionUsage kvewe Usage
KEY ConditionApplication kappl Application
KEY ConditionType kschl Tax Item Type
_Text _Text
_ConditionApplication _ConditionApplication
_ConditionUsage _ConditionUsage

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_ConditionType.
-- 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: ICONDITIONTYPE

CREATE VIEW I_ConditionType AS
SELECT
  kvewe AS ConditionUsage,
  kappl AS ConditionApplication,
  kschl AS ConditionType
FROM t685
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]
LEFT OUTER JOIN I_ConditionTypeText AS _Text ON ConditionType = _Text.ConditionType AND ConditionApplication = _Text.ConditionApplication AND ConditionUsage = _Text.ConditionUsage  -- association [0..*]
;