fac_ad_cds_t074

DDL: FAC_AD_CDS_T074 SQL: FACADV_T074 Type: view Package: ODATA_ACC_DETERMINATION
10 Fields 1 Data Sources

CDS View For T074

fac_ad_cds_t074 is a CDS View that provides data about "CDS View For T074" in SAP S/4HANA. It reads from 1 data source (t074) and exposes 10 fields with key fields ktopl, koart, umskz, hkont. Part of development package ODATA_ACC_DETERMINATION.

Data Sources (1)

SourceAliasJoin Type
t074 t074 from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_T074 view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View For T074 view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ktopl ktopl G/L Chart of Accounts
KEY koart koart Account type
KEY umskz umskz Special G/L Ind
KEY hkont hkont Transfer acct
skont skont G/L Account
kon30 kon30 Acct Determinatn Tax Clearing
ebene ebene Planning Level
hkont_text
skont_text
ebene_text

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_t074.
-- 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_T074

CREATE VIEW fac_ad_cds_t074 AS
SELECT
  ktopl,
  koart,
  umskz,
  hkont,
  skont,
  kon30,
  ebene,
  recon_text[1:spras = $session.system_language].txt20 AS hkont_text,
  gl_text[1:spras = $session.system_language].txt20 AS skont_text,
  t036t[1:spras = $session.system_language].ltext AS ebene_text
FROM t074
;

Learn More