Fclm_Bam_Sh_Bukrs

DDL: FCLM_BAM_SH_BUKRS SQL: VFCLMBAMSHBUKRS Type: view

Search help for company code

Fclm_Bam_Sh_Bukrs is a CDS View that provides data about "Search help for company code" in SAP S/4HANA. It reads from 1 data source (t001) and exposes 4 fields.

Data Sources (1)

SourceAliasJoin Type
t001 t001 left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMBAMSHBUKRS view
ClientDependent true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Search help for company code view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
bukrs header bukrs Value
butxt t001 butxt Posting Text
ort01 t001 ort01 Province
waers t001 waers Transaction Currency

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_Sh_Bukrs.
-- 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: VFCLMBAMSHBUKRS

CREATE VIEW Fclm_Bam_Sh_Bukrs AS
SELECT
  header.bukrs AS bukrs,
  t001.butxt AS butxt,
  t001.ort01 AS ort01,
  t001.waers AS waers
LEFT OUTER JOIN t001 ON /* join condition not captured in parsed metadata */
;