Fclm_Bseg_Basic

DDL: FCLM_BSEG_BASIC SQL: VFCLMBSEGBS Type: view
25 Fields 1 Data Sources

BASIC BSEG

Fclm_Bseg_Basic is a CDS View that provides data about "BASIC BSEG" in SAP S/4HANA. It reads from 1 data source (bseg) and exposes 25 fields.

Data Sources (1)

SourceAliasJoin Type
bseg bseg from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMBSEGBS view
EndUserText.label BASIC BSEG view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (25)

KeyFieldSource TableSource FieldDescription
logsys
bukrs bukrs Value
gjahr gjahr Settlement Year
belnr belnr SD Document
buzei buzei Posting View Item
shkzg shkzg Returns
wrbtr wrbtr Gross Amount
h_waers h_waers Currency
h_hwaer h_hwaer Local Currency
dmbtr dmbtr Loc. amount
fqftype fqftype Flow Type
ktosl ktosl Transaction
augbl augbl Clrng doc.
augdt augdt Clearing
agzei agzei Clearing Item
rebzg rebzg Invoice Ref.
rebzt rebzt Follow-On Doc. Type
rebzz rebzz Item
rebzj rebzj Fiscal Year
valut valut Value date
fdtag fdtag Planning Date
netdt netdt Due On
sk1dt sk1dt Cash Discount 1
sk2dt sk2dt Cash Discount 2
h_budat h_budat Posting Date

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_Bseg_Basic.
-- 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: VFCLMBSEGBS

CREATE VIEW Fclm_Bseg_Basic AS
SELECT
  cast('' as logsys) AS logsys,
  bukrs,
  gjahr,
  belnr,
  buzei,
  shkzg,
  wrbtr,
  h_waers,
  h_hwaer,
  dmbtr,
  fqftype,
  ktosl,
  augbl,
  augdt,
  agzei,
  rebzg,
  rebzt,
  rebzz,
  rebzj,
  valut,
  fdtag,
  netdt,
  sk1dt,
  sk2dt,
  h_budat
FROM bseg
;

Learn More