FISCDS_BLART_VH

DDL: FISVD_BLART_VH SQL: FISV_BLART_VH Type: view

Journal Entry Type/Text

FISCDS_BLART_VH is a CDS View that provides data about "Journal Entry Type/Text" in SAP S/4HANA. It reads from 2 data sources (t003, t003t) and exposes 3 fields with key fields blart, spras.

Data Sources (2)

SourceAliasJoin Type
t003 t003 from
t003t t003t left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName FISV_BLART_VH view
EndUserText.label Journal Entry Type/Text view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 2 view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY blart t003t blart Rep. rec. doc. type
KEY spras t003t spras Off. Language
ltext t003t ltext Text exists

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 FISCDS_BLART_VH.
-- 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: FISV_BLART_VH

CREATE VIEW FISCDS_BLART_VH AS
SELECT
  t003t.blart AS blart,
  t003t.spras AS spras,
  t003t.ltext AS ltext
FROM t003
LEFT OUTER JOIN t003t ON /* join condition not captured in parsed metadata */
;