fac_ad_cds_t074u

DDL: FAC_AD_CDS_T074U SQL: FACADV_T074U Type: view
10 Fields 3 Data Sources

Help View for Special G/L Indicator

fac_ad_cds_t074u is a CDS View that provides data about "Help View for Special G/L Indicator" in SAP S/4HANA. It reads from 3 data sources (dd07t, t074t, t074u) and exposes 10 fields with key fields koart, umskz, domname, as4local, valpos.

Data Sources (3)

SourceAliasJoin Type
dd07t dd07t left_outer
t074t t074t left_outer
t074u t074u from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_T074U view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Help View for Special G/L Indicator view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY koart t074u koart Account type
KEY umskz t074u umskz Special G/L Ind
KEY domname dd07t domname Domain
KEY as4local dd07t as4local Activation State
KEY valpos dd07t valpos Value key
KEY as4vers dd07t as4vers Version
umsks t074u umsks Transact.Type
ktext t074t ktext Text
ltext t074t ltext Text exists
ddtext dd07t ddtext Short 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_t074u.
-- 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_T074U

CREATE VIEW fac_ad_cds_t074u AS
SELECT
  t074u.koart AS koart,
  t074u.umskz AS umskz,
  dd07t.domname AS domname,
  dd07t.as4local AS as4local,
  dd07t.valpos AS valpos,
  dd07t.as4vers AS as4vers,
  t074u.umsks AS umsks,
  t074t.ktext AS ktext,
  t074t.ltext AS ltext,
  dd07t.ddtext AS ddtext
FROM t074u
LEFT OUTER JOIN dd07t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t074t ON /* join condition not captured in parsed metadata */
;

Learn More