fac_ad_cds_glaccount_cc_bs

DDL: FAC_AD_CDS_CC_GLACCOUNT SQL: FACADV_CC_GLACCT Type: view
9 Fields 2 Data Sources

CDS View for G/L Account in Company Code

fac_ad_cds_glaccount_cc_bs is a CDS View that provides data about "CDS View for G/L Account in Company Code" in SAP S/4HANA. It reads from 2 data sources (skb1, t001) and exposes 9 fields with key fields bukrs, saknr.

Data Sources (2)

SourceAliasJoin Type
skb1 skb1 from
t001 t001 left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_CC_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 in Company Code view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY bukrs skb1 bukrs Value
KEY saknr skb1 saknr G/L Account
butxt t001 butxt Posting Text
ktopl t001 ktopl G/L Chart of Accounts
xbilk ska1 xbilk Checkbox
txt20 skat txt20 Text 20
txt50 skat txt50 Status Name
mitkz skb1 mitkz Reconcil. ID
xintb skb1 xintb Created Int.

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_cc_bs.
-- 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_CC_GLACCT

CREATE VIEW fac_ad_cds_glaccount_cc_bs AS
SELECT
  skb1.bukrs AS bukrs,
  skb1.saknr AS saknr,
  t001.butxt AS butxt,
  t001.ktopl AS ktopl,
  ska1.xbilk AS xbilk,
  skat.txt20 AS txt20,
  skat.txt50 AS txt50,
  skb1.mitkz AS mitkz,
  skb1.xintb AS xintb
FROM skb1
LEFT OUTER JOIN t001 ON /* join condition not captured in parsed metadata */
;

Learn More