FCLM_BAM_DM_ATTR

DDL: FCLM_BAM_DM_ATTR SQL: VFCLMBAMDMATTR Type: view
11 Fields 3 Data Sources

Active Company Code List of FI

FCLM_BAM_DM_ATTR is a CDS View that provides data about "Active Company Code List of FI" in SAP S/4HANA. It reads from 3 data sources (draw, tdwa, drat) and exposes 11 fields.

Data Sources (3)

SourceAliasJoin Type
draw a from
tdwa b inner
drat c left_outer

Parameters (1)

NameTypeDefault
plang spras

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMBAMDMATTR view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Active Company Code List of FI view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (11)

KeyFieldSource TableSource FieldDescription
mandt draw mandt Editing Client
dktxt
dktxt_uc
dokar draw dokar SW Document Type
doknr draw doknr Document
dokvr draw dokvr Doc. Version
doktl draw doktl Document Part
dwnam draw dwnam User
dokst draw dokst Document Status
labor draw labor Work Center
begru draw begru AuthorizGroup

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_DM_ATTR.
-- 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: VFCLMBAMDMATTR
-- Parameters: plang : spras

CREATE VIEW FCLM_BAM_DM_ATTR AS
SELECT
  a.mandt AS mandt,
  coalesce(c.dktxt,'') AS dktxt,
  coalesce(c.dktxt_uc,'') AS dktxt_uc,
  a.dokar AS dokar,
  a.doknr AS doknr,
  a.dokvr AS dokvr,
  a.doktl AS doktl,
  a.dwnam AS dwnam,
  a.dokst AS dokst,
  a.labor AS labor,
  a.begru AS begru
FROM draw AS a
INNER JOIN tdwa AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN drat AS c ON /* join condition not captured in parsed metadata */
;

Learn More