V_TWRF1_CUST_TAB_CDS

DDL: V_TWRF1_CUST_TAB_CDS SQL: V_TWRF1_CUSTTAB Type: view

View For Customizing Tables For Sites

V_TWRF1_CUST_TAB_CDS is a CDS View that provides data about "View For Customizing Tables For Sites" in SAP S/4HANA. It reads from 2 data sources (twrf1_cust_tab, twrf1) and exposes 7 fields with key fields wrkrg, tabna, spras.

Data Sources (2)

SourceAliasJoin Type
twrf1_cust_tab customizing_tables inner
twrf1 rule_table from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName V_TWRF1_CUSTTAB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label View For Customizing Tables For Sites view
AbapCatalog.buffering.numberOfKeyFields 0 view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY wrkrg twrf1 wrkrg Copy rule
KEY tabna twrf1 tabna Table name
KEY spras original spras Off. Language
maint_view twrf1_cust_tab maint_view maintenance view
maint_group twrf1_cust_tab maint_group maintenance group
maint_sortf twrf1_cust_tab maint_sortf Two-digit no.
descr

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 V_TWRF1_CUST_TAB_CDS.
-- 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: V_TWRF1_CUSTTAB

CREATE VIEW V_TWRF1_CUST_TAB_CDS AS
SELECT
  rule_table.wrkrg AS wrkrg,
  rule_table.tabna AS tabna,
  original.spras AS spras,
  customizing_tables.maint_view AS maint_view,
  customizing_tables.maint_group AS maint_group,
  customizing_tables.maint_sortf AS maint_sortf,
  coalesce(delta.descr, original.descr) AS descr
FROM twrf1 AS rule_table
INNER JOIN twrf1_cust_tab AS customizing_tables ON /* join condition not captured in parsed metadata */
;