I_ReversalReasonText

DDL: I_REVERSALREASONTEXT Type: view_entity BASIC Package: FINS_REVERSAL_REASON_VDM
4 Fields 1 Data Sources 1 Associations 21 OData Services

Reversal Reason - Text

I_ReversalReasonText (Basic)

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

Accounting and Financial Close

I_ReversalReasonText is a Basic CDS View that provides data about "Reversal Reason - Text" in SAP S/4HANA. It reads from 1 data source (t041ct) and exposes 4 fields with key fields Language, ReversalReason. It has 1 association to related views. It is exposed through 21 OData services (ASQL_F0773, ASQL_F1345, ASQL_F1367, ...). Part of development package FINS_REVERSAL_REASON_VDM.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-GL-A-2CL
CapabilitiesData Source for Data Extraction,Language-Dependent Text,Data Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
t041ct t041ct from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataExtraction.enabled true view
EndUserText.label Reversal Reason - Text view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ReversalReason view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
Search.searchable true view

OData Services (21)

ServiceBindingVersionContractRelease
ASQL_F0773 ASQL_F0773 C2 NOT_RELEASED
ASQL_F1345 ASQL_F1345 C2 NOT_RELEASED
ASQL_F1367 ASQL_F1367 C2 NOT_RELEASED
ASQL_F1579 ASQL_F1579 C2 NOT_RELEASED
ASQL_F1597 ASQL_F1597 C2 NOT_RELEASED
ASQL_F1612 ASQL_F1612 C2 NOT_RELEASED
ASQL_F1688 ASQL_F1688 C2 NOT_RELEASED
ASQL_F1689 ASQL_F1689 C2 NOT_RELEASED
ASQL_F2547A ASQL_F2547A C2 NOT_RELEASED
ASQL_F4173 ASQL_F4173 C2 NOT_RELEASED
ASQL_F4307 ASQL_F4307 C2 NOT_RELEASED
ASQL_F4485 ASQL_F4485 C2 NOT_RELEASED
ASQL_F4670A ASQL_F4670A C2 NOT_RELEASED
ASQL_F5342 ASQL_F5342 C2 NOT_RELEASED
ASQL_F6728 ASQL_F6728 C2 NOT_RELEASED
ASQL_F6785 ASQL_F6785 C2 NOT_RELEASED
ASQL_F7103 ASQL_F7103 C2 NOT_RELEASED
ASQL_F7343 ASQL_F7343 C2 NOT_RELEASED
ASQL_F7344 ASQL_F7344 C2 NOT_RELEASED
ASQL_F7933 ASQL_F7933 C2 NOT_RELEASED
ASQL_F7934 ASQL_F7934 C2 NOT_RELEASED

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Language t041ct spras Off. Language
KEY ReversalReason t041ct stgrd Reason for Reversal or Inverse Posting
ReversalReasonName Reversal Reason Name
_Language _Language

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_ReversalReasonText.
-- 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_ReversalReasonText AS
SELECT
  t041ct.spras AS Language,
  t041ct.stgrd AS ReversalReason,
  cast ( t041ct.txt40 as fac_rvsl_rsn_name preserving type ) AS ReversalReasonName
FROM t041ct
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More