P_FSLeafWithGLAcctCoA1

DDL: P_FSLEAFWITHGLACCTCOA1 SQL: PFSLGLACCTCOA1 Type: view BASIC Package: FINS_FIS_FICO

FS leaf item with assigned G/L Account (in Chart of Account)

P_FSLeafWithGLAcctCoA1 is a Basic CDS View that provides data about "FS leaf item with assigned G/L Account (in Chart of Account)" in SAP S/4HANA. It reads from 6 data sources and exposes 25 fields with key fields versn, ergsl, ktopl, saknr, vonkt. Part of development package FINS_FIS_FICO.

Data Sources (6)

SourceAliasJoin Type
fagl_011zc fagl_011zc from
fagl_011zc fagl_011zc2 union_all
ska1 ska1 inner
ska1 ska1 inner
t011 t011 inner
t011 t0112 inner

Parameters (2)

NameTypeDefault
P_VERSN abap.char( 4 )
P_KTOPL abap.char( 4 )

Annotations (6)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PFSLGLACCTCOA1 view
AbapCatalog.compiler.compareFilter true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY versn fagl_011zc versn Version
KEY ergsl fagl_011zc ergsl FS Item
KEY ktopl fagl_011zc ktopl G/L Chart of Accounts
KEY saknr ska1 saknr G/L Account
KEY vonkt fagl_011zc vonkt Account From
biskt fagl_011zc biskt Account To
xsoll fagl_011zc xsoll Debit Balance
xhabn fagl_011zc xhabn Credit Balance
xergs t011 xergs Group Account Number
bilkt ska1 bilkt Group Account Number
xbilk ska1 xbilk Checkbox
gvtyp ska1 gvtyp P&L state. acct
versn Version
KEY ergsl fagl_011zc ergsl FS Item
KEY ktopl fagl_011zc ktopl G/L Chart of Accounts
KEY saknr ska1 saknr G/L Account
KEY vonkt fagl_011zc vonkt Account From
biskt fagl_011zc biskt Account To
xsoll fagl_011zc xsoll Debit Balance
xhabn fagl_011zc xhabn Credit Balance
xergs t011 xergs Group Account Number
bilkt ska1 bilkt Group Account Number
xbilk ska1 xbilk Checkbox
gvtyp ska1 gvtyp P&L state. acct
xspep ska1 xspep Planning Block

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 P_FSLeafWithGLAcctCoA1.
-- 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: PFSLGLACCTCOA1
-- Parameters: P_VERSN : abap.char( 4 ), P_KTOPL : abap.char( 4 )

CREATE VIEW P_FSLeafWithGLAcctCoA1 AS
SELECT
  fagl_011zc.versn AS versn,
  fagl_011zc.ergsl AS ergsl,
  fagl_011zc.ktopl AS ktopl,
  ska1.saknr AS saknr,
  fagl_011zc.vonkt AS vonkt,
  fagl_011zc.biskt AS biskt,
  fagl_011zc.xsoll AS xsoll,
  fagl_011zc.xhabn AS xhabn,
  t011.xergs AS xergs,
  ska1.bilkt AS bilkt,
  ska1.xbilk AS xbilk,
  ska1.gvtyp AS gvtyp,
  ska1.xspep AS xspep
FROM fagl_011zc
INNER JOIN ska1 ON /* join condition not captured in parsed metadata */
INNER JOIN t011 ON /* join condition not captured in parsed metadata */
INNER JOIN t011 AS t0112 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): fagl_011zc
;