FAC_AD_CDS_GLACCOUNT_CC

DDL: FAC_AD_CDS_GLACCOUNT_CC SQL: FACADV_GLACCT_CC Type: view
9 Fields 2 Data Sources

View for GL Account based on Comp Code

FAC_AD_CDS_GLACCOUNT_CC is a CDS View that provides data about "View for GL Account based on Comp 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 (11)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_GLACCT_CC 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
AbapCatalog.preserveKey true view
EndUserText.label View for GL Account based on Comp 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.
-- 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_CC

CREATE VIEW FAC_AD_CDS_GLACCOUNT_CC 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