FAC_AD_CDS_T030U

DDL: FAC_AD_CDS_T030U SQL: FACADV_T030U Type: view Package: ODATA_ACC_DETERMINATION
11 Fields 1 Data Sources

CDS View For T030U

FAC_AD_CDS_T030U is a CDS View that provides data about "CDS View For T030U" in SAP S/4HANA. It reads from 1 data source (t030u) and exposes 11 fields with key fields ktopl, bwber, ktosl, hkont. Part of development package ODATA_ACC_DETERMINATION.

Data Sources (1)

SourceAliasJoin Type
t030u t030u from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_T030U 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 T030U view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ktopl t030u ktopl G/L Chart of Accounts
KEY bwber t030u bwber Valuation Area
KEY ktosl t030u ktosl Transaction
KEY hkont t030u hkont Transfer acct
korrk t030u korrk Adjustment Acct
zielk t030u zielk Target Account
bwber_text
ktopl_text
HKONT_text
KORRK_text
ZIELK_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_T030U.
-- 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_T030U

CREATE VIEW FAC_AD_CDS_T030U AS
SELECT
  t030u.ktopl AS ktopl,
  t030u.bwber AS bwber,
  t030u.ktosl AS ktosl,
  t030u.hkont AS hkont,
  t030u.korrk AS korrk,
  t030u.zielk AS zielk,
  bwber_text[1:spras = $session.system_language].ltext AS bwber_text,
  ktopl_text[1:spras = $session.system_language].ktplt AS ktopl_text,
  HKONT_text[1:spras = $session.system_language].txt20 AS HKONT_text,
  KORRK_text[1:spras = $session.system_language].txt20 AS KORRK_text,
  ZIELK_text[1:spras = $session.system_language].txt20 AS ZIELK_text
FROM t030u
;

Learn More