SBN_DRF_COND_REC

DDL: SBN_DRF_COND_REC SQL: SBN_CREC Type: view
5 Fields 3 Data Sources

Existent Condition tables

SBN_DRF_COND_REC is a CDS View that provides data about "Existent Condition tables" in SAP S/4HANA. It reads from 3 data sources (t682i, t685, t682z) and exposes 5 fields.

Data Sources (3)

SourceAliasJoin Type
t682i i inner
t685 t from
t682z z inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SBN_CREC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Existent Condition tables view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (5)

KeyFieldSource TableSource FieldDescription
kschl t685 kschl Tax Item Type
kolnr t682i kolnr Access
kotabnr t682i kotabnr Table Number
zaehk t682z zaehk Counter
zifna t682z zifna Condition Field

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 SBN_DRF_COND_REC.
-- 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: SBN_CREC

CREATE VIEW SBN_DRF_COND_REC AS
SELECT
  t.kschl AS kschl,
  i.kolnr AS kolnr,
  i.kotabnr AS kotabnr,
  z.zaehk AS zaehk,
  z.zifna AS zifna
FROM t685 AS t
INNER JOIN t682i AS i ON /* join condition not captured in parsed metadata */
INNER JOIN t682z AS z ON /* join condition not captured in parsed metadata */
;

Learn More