Fac_Ad_Cds_Bi2

DDL: FAC_AD_CDS_BI2 SQL: FACADV_BI2 Type: view
10 Fields 1 Data Sources 4 Associations

CDS View For BI2

Fac_Ad_Cds_Bi2 is a CDS View that provides data about "CDS View For BI2" in SAP S/4HANA. It reads from 1 data source (t030u) and exposes 10 fields with key fields ktopl, bwber, ktosl, hkont. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t030u t030u from

Associations (4)

CardinalityTargetAliasCondition
[0..*] t033t BWBER_TEXT $projection.bwber = BWBER_TEXT.bwber
[0..*] skat HKONT_TEXT $projection.ktopl = HKONT_TEXT.ktopl and $projection.hkont = HKONT_TEXT.saknr
[0..*] skat KORRK_TEXT $projection.ktopl = KORRK_TEXT.ktopl and $projection.korrk = KORRK_TEXT.saknr
[0..*] skat ZIELK_TEXT $projection.ktopl = ZIELK_TEXT.ktopl and $projection.zielk = ZIELK_TEXT.saknr

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_BI2 view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View For BI2 view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ktopl t030u ktopl G/L Chart of Accounts
KEY bwber t030u bwber Valuation Area
KEY ktosl t030u ktosl Transaction
KEY hkont t030u hkont Transfer acct
korrk t030u korrk Adjustment Acct
zielk t030u zielk Target Account
BWBER_TEXT
HKONT_TEXT
KORRK_TEXT
ZIELK_TEXT

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 Fac_Ad_Cds_Bi2.
-- 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: FACADV_BI2

CREATE VIEW Fac_Ad_Cds_Bi2 AS
SELECT
  t030u.ktopl AS ktopl,
  t030u.bwber AS bwber,
  t030u.ktosl AS ktosl,
  t030u.hkont AS hkont,
  t030u.korrk AS korrk,
  t030u.zielk AS zielk,
  BWBER_TEXT[1:spras = $session.system_language].ltext AS BWBER_TEXT,
  HKONT_TEXT[1:spras = $session.system_language].txt20 AS HKONT_TEXT,
  KORRK_TEXT[1:spras = $session.system_language].txt20 AS KORRK_TEXT,
  ZIELK_TEXT[1:spras = $session.system_language].txt20 AS ZIELK_TEXT
FROM t030u
LEFT OUTER JOIN t033t AS BWBER_TEXT ON bwber = BWBER_TEXT.bwber  -- association [0..*]
LEFT OUTER JOIN skat AS HKONT_TEXT ON ktopl = HKONT_TEXT.ktopl AND hkont = HKONT_TEXT.saknr  -- association [0..*]
LEFT OUTER JOIN skat AS KORRK_TEXT ON ktopl = KORRK_TEXT.ktopl AND korrk = KORRK_TEXT.saknr  -- association [0..*]
LEFT OUTER JOIN skat AS ZIELK_TEXT ON ktopl = ZIELK_TEXT.ktopl AND zielk = ZIELK_TEXT.saknr  -- association [0..*]
;

Learn More