I_TreasuryValuationArea

DDL: I_TREASURYVALUATIONAREA Type: view_entity BASIC Package: FTR_GENERAL_CORE
4 Fields 1 Data Sources 5 OData Services

Treasury Valuation Area

I_TreasuryValuationArea (Basic)

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

Treasury Valuation Area · Financial Operations

I_TreasuryValuationArea is a Basic CDS View (Dimension) that provides data about "Treasury Valuation Area" in SAP S/4HANA. It reads from 1 data source (trgc_val_area) and exposes 4 fields with key field TreasuryValuationArea. It is exposed through 5 OData services (ASQL_F1754, ASQL_F1755, ASQL_F1867, ...). Part of development package FTR_GENERAL_CORE.

SAP Help Documentation

CategoryCDS Views for Configuration Data
Data CategoryDimension
StatusReleased
Data Extraction TypeFull (physical deletions are possible in source tables)
Corresponding DataSourceITRSRVLTNR
Purpose
This CDS view provides access to information on the valuation areas for answering the following business questions: Which valuation areas exist? What is the name of the valuation area? Which valuation area is the paying valuation area? Which accounting principle is assigned to the valuation area?

Structure
Measures and attributes Some important attributes are: Valuation area Name of the valuation area Paying valuation area (yes/no) Accounting principle

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM-2CL
CapabilitiesData Source for Data Extraction,Analytical Dimension,Data Source for Defining CDS Entities,Data Source in SQL Select,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageFinancial Operations for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides access to information on the valuation areas for answering the following business questions:</p> <ul> <li> <p>Which valuation areas exist?</p> </li> <li> <p>What is the name of the valuation area?</p> </li> <li> <p>Which valuation area is the paying valuation area?</p> </li> <li> <p>Which accounting principle is assigned to the valuation area?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
trgc_val_area TreasuryValuationArea from

Annotations (17)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed false view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
EndUserText.label Treasury Valuation Area view
ObjectModel.sapObjectNodeType.name TreasuryValuationArea view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey TreasuryValuationArea view
Analytics.technicalName ITRSRVLTNR view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
Search.searchable true view

OData Services (5)

ServiceBindingVersionContractRelease
ASQL_F1754 ASQL_F1754 C2 NOT_RELEASED
ASQL_F1755 ASQL_F1755 C2 NOT_RELEASED
ASQL_F1867 ASQL_F1867 C2 NOT_RELEASED
ASQL_F2331 ASQL_F2331 C2 NOT_RELEASED
ASQL_F3966 ASQL_F3966 C2 NOT_RELEASED

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY TreasuryValuationArea trgc_val_area valuation_area Treasury Valuation Area
TreasuryValuationAreaName Name of the Valuation Area
ValuationAreaIsPaying trgc_val_area paying_val_area Paying valuation area
AccountingPrinciple trgc_val_area acc_principle Evaluation area EBRR

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_TreasuryValuationArea.
-- 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_TreasuryValuationArea AS
SELECT
  TreasuryValuationArea.valuation_area AS TreasuryValuationArea,
  cast(TreasuryValuationArea.val_area_name as ftr_gen_valuation_area_name preserving type) AS TreasuryValuationAreaName,
  TreasuryValuationArea.paying_val_area AS ValuationAreaIsPaying,
  TreasuryValuationArea.acc_principle AS AccountingPrinciple
FROM trgc_val_area AS TreasuryValuationArea
;

Learn More