P_Rtc_Racct

DDL: P_RTC_RACCT SQL: PRTC_RACCT Type: view BASIC
8 Fields 1 Data Sources

P_Rtc_Racct is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (rtc_model) and exposes 8 fields.

Data Sources (1)

SourceAliasJoin Type
rtc_model rtc_model from

Annotations (6)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName PRTC_RACCT view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality B view

Fields (8)

KeyFieldSource TableSource FieldDescription
model rtc_model model Vehicle Model
state rtc_model state Vehicle Region
ktopl rtc_model ktopl G/L Chart of Accounts
saknr ska1 saknr G/L Account
bilkt ska1 bilkt Group Account Number
spras skat spras Off. Language
txt20 skat txt20 Text 20
txt50 skat txt50 Status Name

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 P_Rtc_Racct.
-- 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: PRTC_RACCT

CREATE VIEW P_Rtc_Racct AS
SELECT
  rtc_model.model AS model,
  rtc_model.state AS state,
  rtc_model.ktopl AS ktopl,
  ska1.saknr AS saknr,
  ska1.bilkt AS bilkt,
  skat.spras AS spras,
  skat.txt20 AS txt20,
  skat.txt50 AS txt50
FROM rtc_model
;

Learn More