I_PubSecRevenueTypeText

DDL: I_PUBSECREVENUETYPETEXT Type: view BASIC
5 Fields 1 Data Sources 2 Associations

Revenue Type - Text

I_PubSecRevenueTypeText (Basic)

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

Cross Applications

I_PubSecRevenueTypeText is a Basic CDS View that provides data about "Revenue Type - Text" in SAP S/4HANA. It reads from 1 data source (tfmca_revtypet) and exposes 5 fields with key fields Language, PublicSectorRevenueType. It has 2 associations to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentIS-PS-CA
CapabilitiesLanguage-Dependent Text
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is designed to provide a structured representation of revenue types within the public sector, incorporating various associations and attributes related to contract accounts, transactions, period codes, document types, and workflow tasks. It serves as a foundational data model for customizing and managing revenue-related information in public sector applications. </p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the different revenue types defined for the public sector?</p></li> <li><p>How are revenue types associated with contract account categories and transactions?</p></li> <li><p>What are the start and end period codes associated with each revenue type?</p></li> <li><p>Are public sector contracts included in the revenue type configuration?</p></li> <li><p>What document types are linked to specific revenue types?</p></li> <li><p>What workflow task definitions and types are associated with revenue types?</p></li> <li><p>Is form-based tax applicable to specific revenue types?</p></li> <li><p>Is a joint tax return possible for certain revenue types?</p></li> <li><p>What is the form bundle number range for public sector revenue types?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
tfmca_revtypet PubSecRevenueTypeText from

Associations (2)

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

Annotations (16)

NameValueLevelField
EndUserText.label Revenue Type - Text view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.sqlViewName IPSREVENUETYPET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey PublicSectorRevenueType view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language tfmca_revtypet spras Off. Language
KEY PublicSectorRevenueType tfmca_revtypet abtyp Revenue Type
PublicSectorRevenueTypeName tfmca_revtypet abtypt Name of Revenue Type
_Language _Language
_PublicSectorRevenueType _PublicSectorRevenueType

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_PubSecRevenueTypeText.
-- 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_PubSecRevenueTypeText AS
SELECT
  PubSecRevenueTypeText.spras AS Language,
  PubSecRevenueTypeText.abtyp AS PublicSectorRevenueType,
  PubSecRevenueTypeText.abtypt AS PublicSectorRevenueTypeName
FROM tfmca_revtypet AS PubSecRevenueTypeText
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_PublicSectorRevenueType AS _PublicSectorRevenueType ON PublicSectorRevenueType = _PublicSectorRevenueType.PublicSectorRevenueType  -- association [0..1]
;

Learn More