What is I_PRAAccountDescription in SAP S/4HANA?

I_PRAAccountDescription is a basic CDS view in SAP S/4HANA. PRA GL Account Description It contains 11 fields.

Which tables does I_PRAAccountDescription read from?

I_PRAAccountDescription reads data from: skat, t001.

What VDM layer is I_PRAAccountDescription?

I_PRAAccountDescription is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_PRAAccountDescription

DDL: I_PRAACCOUNTDESCRIPTION Type: view_entity BASIC

11 Fields 2 Data Sources 4 Associations

PRA GL Account Description

I_PRAAccountDescription (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

PRA General Ledger Account · Cross Applications

I_PRAAccountDescription is a Basic CDS View that provides data about "PRA GL Account Description" in SAP S/4HANA. It reads from 2 data sources (skat, t001) and exposes 11 fields with key fields CompanyCode, Language, ChartOfAccounts, GLAccount. It has 4 associations to related views.

SAP Help Documentation

Category	CDS Views for Production and Revenue Accounting (PRA)

Purpose
This CDS view is a coded representation of detailed information about the chart of accounts. For example, it could have details of the general ledger account, account type code, and so on.

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: F_SKA1_KTP:KTOPL-,F_SKA1_KTP:ACTVT-03 (Mapping role for I_PRAAccountDescription)

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	IS-OIL-PRA
Capabilities	Data Source in SQL Select
Package	Cross Applications for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view is a coded representation of detailed information about the chart of accounts. For example, it could have details of the general ledger account, account type code, and so on.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (2)

Source	Alias	Join Type
skat	account	inner
t001	company	from

Associations (4)

Cardinality	Target	Alias	Condition
[0..*]	I_ChartOfAccountsText	_ChartOfAccountsText	`$projection.ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts`
[0..1]	I_Language	_Language	`$projection.Language = _Language.Language`
[0..1]	I_ChartOfAccounts	_ChartOfAccounts	`$projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts`
[0..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	PRA GL Account Description	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MASTER	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#BASIC	view
ObjectModel.sapObjectNodeType.name	PRAGenLdgrAcct	view

Fields (11)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	t001	bukrs	Company Code
KEY	Language	skat	spras	Off. Language
KEY	ChartOfAccounts	t001	ktopl	G/L Chart of Accounts
KEY	GLAccount	skat	saknr	G/L Account Number
	GLAccountName	skat	txt20	G/L Account Short Text
	CompanyCodeName	t001	butxt	Name of Company Code or Company
	LastChangeDateTime	skat	last_changed_ts	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	_ChartOfAccountsText		_ChartOfAccountsText
	_Language		_Language
	_ChartOfAccounts		_ChartOfAccounts
	_CompanyCode		_CompanyCode

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 I_PRAAccountDescription.
-- 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.

CREATE VIEW I_PRAAccountDescription AS
SELECT
  company.bukrs AS CompanyCode,
  account.spras AS Language,
  company.ktopl AS ChartOfAccounts,
  account.saknr AS GLAccount,
  account.txt20 AS GLAccountName,
  company.butxt AS CompanyCodeName,
  account.last_changed_ts AS LastChangeDateTime
FROM t001 AS company
INNER JOIN skat AS account ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Depth:

I_PRAAccountDescription view_entity