fiscds_bal_gl_02

DDL: FISVD_BAL_GL_02 SQL: FISV_BAL_GL_02 Type: view

Balance

fiscds_bal_gl_02 is a CDS View that provides data about "Balance" in SAP S/4HANA. It reads from 1 data source (fiscds_bal_gl_01_ac) and exposes 39 fields.

Data Sources (1)

SourceAliasJoin Type
fiscds_bal_gl_01_ac fiscds_bal_gl_01_ac from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FISV_BAL_GL_02 view
EndUserText.label Balance view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (39)

KeyFieldSource TableSource FieldDescription
butxt butxt Posting Text
ktopl ktopl G/L Chart of Accounts
ryear ryear Ref. Year1
rldnr fiscds_bal_gl_01_ac rldnr Ledger (Compat.)
rbukrs rbukrs Company Code
racct racct GL Account From
prctr prctr Profit Centers
kokrs kokrs Org. Value
segment segment Segment number
rfarea rfarea R FuncArea
rbusa rbusa Business Area
poper poper Posting periods
koart koart Account type
blart blart Rep. rec. doc. type
hwaer hwaer Local Currency
balance_hsl hsl Local Crcy Amt
rkcur rkcur Ledger curr.
balance_ksl ksl GrpCurr
rocur rocur Free Defined Crcy 1
balance_osl osl Other Crcy Amnt
rvcur rvcur Free Defined Crcy 4
balance_vsl vsl Amount in Currency 2
rbcur rbcur Free Defined Crcy 3
balance_bsl bsl Exchange Key
rccur rccur Third Currency
balance_csl csl Amount in Currency 4
rdcur rdcur Free Defined Crcy 5
balance_dsl dsl Amount in Currency 5
recur recur Free Defined Crcy 6
balance_esl esl Amount in Currency 6
rfcur rfcur Free Defined Crcy 7
balance_fsl fsl Amount in Currency 7
rgcur rgcur Free Defined Crcy 8
balance_gsl gsl Amount in Currency 8
rfccur rfccur Functional Currency
balance_fcsl fcsl Amount in FunctCrcy
_ProfitCenter _ProfitCenter
_GLAccountInCompanyCode _GLAccountInCompanyCode
_AccountingDocumentType _AccountingDocumentType

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_bal_gl_02.
-- 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_BAL_GL_02

CREATE VIEW fiscds_bal_gl_02 AS
SELECT
  butxt,
  ktopl,
  ryear,
  fiscds_bal_gl_01_ac.rldnr AS rldnr,
  rbukrs,
  racct,
  prctr,
  kokrs,
  segment,
  rfarea,
  rbusa,
  poper,
  koart,
  blart,
  hwaer,
  hsl AS balance_hsl,
  rkcur,
  ksl AS balance_ksl,
  rocur,
  osl AS balance_osl,
  rvcur,
  vsl AS balance_vsl,
  rbcur,
  bsl AS balance_bsl,
  rccur,
  csl AS balance_csl,
  rdcur,
  dsl AS balance_dsl,
  recur,
  esl AS balance_esl,
  rfcur,
  fsl AS balance_fsl,
  rgcur,
  gsl AS balance_gsl,
  rfccur,
  fcsl AS balance_fcsl
FROM fiscds_bal_gl_01_ac
;