I_ProductValuationCategoryText

DDL: I_PRODUCTVALUATIONCATEGORYTEXT SQL: IPRODVALCATT Type: view BASIC
3 Fields 1 Data Sources

Product Valuation Category - Text

I_ProductValuationCategoryText (Basic)

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

Database & Data Management

I_ProductValuationCategoryText is a Basic CDS View that provides data about "Product Valuation Category - Text" in SAP S/4HANA. It reads from 1 data source (t149t) and exposes 3 fields with key fields InventoryValuationCategory, Language.

SAP API Hub

StateC1
Line of BusinessDatabase & Data Management
Application ComponentLO-MD-MM
CapabilitiesAssociation Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source for Search, Data Source in SQL Select, Language-Dependent Text
PackageDatabase & Data Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
t149t t149t from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IPRODVALCATT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Product Valuation Category - Text view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
Search.searchable true view
ObjectModel.representativeKey InventoryValuationCategory view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY InventoryValuationCategory bwtty Valuation Category
KEY Language t149t spras Off. Language
InventoryValuationCategoryName Inventory Valuation Category 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 I_ProductValuationCategoryText.
-- 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: IPRODVALCATT

CREATE VIEW I_ProductValuationCategoryText AS
SELECT
  bwtty AS InventoryValuationCategory,
  t149t.spras AS Language,
  cast( t149t.btbez as inventoryvaluationcategoryname ) AS InventoryValuationCategoryName
FROM t149t
;

Learn More