Fac_Ad_Cds_Ctab

DDL: FAC_AD_CDS_CTAB SQL: FACADV_CTAB Type: view Package: ODATA_ACC_DETERMINATION

View of Condition Tables

Fac_Ad_Cds_Ctab is a CDS View that provides data about "View of Condition Tables" in SAP S/4HANA. It reads from 5 data sources (t681, t681b, t682, t682i, tmc1t) and exposes 7 fields. Part of development package ODATA_ACC_DETERMINATION.

Data Sources (5)

SourceAliasJoin Type
t681 t681 inner
t681b t681b left_outer
t682 t682 inner
t682i t682i inner
tmc1t tmc1t left_outer

Parameters (1)

NameTypeDefault
p_langu syst_langu

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_CTAB view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label View of Condition Tables view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view

Fields (7)

KeyFieldSource TableSource FieldDescription
kappl t685 kappl Application
kschl t685 kschl Tax Item Type
kolnr t682i kolnr Access
kotabnr
kotab t681 kotab Condition table
gstxt tmc1t gstxt Short text
vtext t681b vtext Wgh.Dat.Ty.Txt.

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_Ctab.
-- 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_CTAB
-- Parameters: p_langu : syst_langu

CREATE VIEW Fac_Ad_Cds_Ctab AS
SELECT
  t685.kappl AS kappl,
  t685.kschl AS kschl,
  t682i.kolnr AS kolnr,
  cast(t681.kotabnr as abap.char(3)) AS kotabnr,
  t681.kotab AS kotab,
  tmc1t.gstxt AS gstxt,
  t681b.vtext AS vtext
INNER JOIN t682 ON /* join condition not captured in parsed metadata */
INNER JOIN t682i ON /* join condition not captured in parsed metadata */
INNER JOIN t681 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tmc1t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t681b ON /* join condition not captured in parsed metadata */
;