FAC_AD_CDS_GLACCOUNT

DDL: FAC_AD_CDS_GLACCOUNT SQL: FACADV_GLACCT Type: view
19 Fields 1 Data Sources

CDS View for G/L Account(Based on SKA1)

FAC_AD_CDS_GLACCOUNT is a CDS View that provides data about "CDS View for G/L Account(Based on SKA1)" in SAP S/4HANA. It reads from 1 data source (ska1) and exposes 19 fields with key fields ktopl, saknr.

Data Sources (1)

SourceAliasJoin Type
ska1 ska1 from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_GLACCT view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label CDS View for G/L Account(Based on SKA1) view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ktopl ska1 ktopl G/L Chart of Accounts
KEY saknr ska1 saknr G/L Account
xbilk ska1 xbilk Checkbox
sakan ska1 sakan G/L Account
bilkt ska1 bilkt Group Account Number
erdat ska1 erdat Entered On
ernam ska1 ernam User Name
gvtyp ska1 gvtyp P&L state. acct
ktoks ska1 ktoks GL Grp
mustr ska1 mustr Sample table
vbund ska1 vbund Trading Partner
xloev ska1 xloev Deletion Flag
xspea ska1 xspea Creation Block
xspeb ska1 xspeb Posting Block
xspep ska1 xspep Planning Block
mcod1 ska1 mcod1 Search Term
func_area ska1 func_area Receiving Func. Area
txt20 skat txt20 Text 20
txt50 skat txt50 Status Name

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 FAC_AD_CDS_GLACCOUNT.
-- 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: FACADV_GLACCT

CREATE VIEW FAC_AD_CDS_GLACCOUNT AS
SELECT
  ska1.ktopl AS ktopl,
  ska1.saknr AS saknr,
  ska1.xbilk AS xbilk,
  ska1.sakan AS sakan,
  ska1.bilkt AS bilkt,
  ska1.erdat AS erdat,
  ska1.ernam AS ernam,
  ska1.gvtyp AS gvtyp,
  ska1.ktoks AS ktoks,
  ska1.mustr AS mustr,
  ska1.vbund AS vbund,
  ska1.xloev AS xloev,
  ska1.xspea AS xspea,
  ska1.xspeb AS xspeb,
  ska1.xspep AS xspep,
  ska1.mcod1 AS mcod1,
  ska1.func_area AS func_area,
  skat.txt20 AS txt20,
  skat.txt50 AS txt50
FROM ska1
;

Learn More