Fclm_Bam_Doc_Chara

DDL: FCLM_BAM_DOC_CHARA SQL: VFCLMDCHARA Type: view
8 Fields 3 Data Sources

Characteristics of Bank Account Document

Fclm_Bam_Doc_Chara is a CDS View that provides data about "Characteristics of Bank Account Document" in SAP S/4HANA. It reads from 3 data sources (klah, ksml, cabn) and exposes 8 fields with key fields mandt, clint, posnr, adzhl.

Data Sources (3)

SourceAliasJoin Type
klah a from
ksml b inner
cabn c inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMDCHARA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Characteristics of Bank Account Document view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY mandt klah mandt Editing Client
KEY clint ksml clint Int class no.
KEY posnr ksml posnr WBS Element
KEY adzhl ksml adzhl Int. counter
class klah class User Group
klart klah klart Class Type
imerk ksml imerk Internal char.
atnam cabn atnam Characteristic

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 Fclm_Bam_Doc_Chara.
-- 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: VFCLMDCHARA

CREATE VIEW Fclm_Bam_Doc_Chara AS
SELECT
  a.mandt AS mandt,
  b.clint AS clint,
  b.posnr AS posnr,
  b.adzhl AS adzhl,
  a.class AS class,
  a.klart AS klart,
  b.imerk AS imerk,
  c.atnam AS atnam
FROM klah AS a
INNER JOIN ksml AS b ON /* join condition not captured in parsed metadata */
INNER JOIN cabn AS c ON /* join condition not captured in parsed metadata */
;

Learn More