I_PublicSectorFormClass

DDL: I_PUBLICSECTORFORMCLASS Type: view BASIC

Public Sector Form Class

I_PublicSectorFormClass (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_PublicSectorFormClass is a Basic CDS View that provides data about "Public Sector Form Class" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field PublicSectorFormClass. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Taxpayer Identification and Returns Processing
Purpose
This CDS view is designed to provide a structured representation of public sector forms, including their metadata, status, and associations with related entities such as form bundles, form classes, and form statuses. It serves as a foundational data model for transactional operations related to public sector forms, ensuring that the necessary data is available for processing and analysis. This CDS view provides the data to answer the following business questions: What are the details of a specific public sector form, including its name, number, and unique identifiers? When was the last change made to a particular public sector form? What is the current status of a public sector form, and what are its associated class and bundle? Has a public sector form been amended, and if so, what are the identifiers of the superseding and superseded forms? What is the storage location and batch information for document management services related to a public sector form? What is the template version of a public sector form? How can associations with form bundles, classes, and statuses be utilized for further analysis or processing? This view provides supported values for PublicSectorFormClass . The values and their meanings are: Value Meaning ISR Form TF Table Form 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 .

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentIS-PS-CA
CapabilitiesAssociation Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is designed to provide a structured representation of public sector forms, including their metadata, status, and associations with related entities such as form bundles, form classes, and form statuses. It serves as a foundational data model for transactional operations related to public sector forms, ensuring that the necessary data is available for processing and analysis. </p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the details of a specific public sector form, including its name, number, and unique identifiers?</p></li> <li><p>When was the last change made to a particular public sector form?</p></li> <li><p>What is the current status of a public sector form, and what are its associated class and bundle?</p></li> <li><p>Has a public sector form been amended, and if so, what are the identifiers of the superseding and superseded forms?</p></li> <li><p>What is the storage location and batch information for document management services related to a public sector form?</p></li> <li><p>What is the template version of a public sector form?</p></li> <li><p>How can associations with form bundles, classes, and statuses be utilized for further analysis or processing?</p></li> </ul> <p>This view provides supported values for PublicSectorFormClass.</p> <p>The values and their meanings are:</p> <p>Value</p> <p>Meaning</p> &nbsp; <p>ISR Form</p> <p>TF</p> <p>Table Form</p> <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
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PublicSectorFormClassText _Text $projection.PublicSectorFormClass = _Text.PublicSectorFormClass

Annotations (13)

NameValueLevelField
EndUserText.label Public Sector Form Class view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.sqlViewName IPUBSECFORMCLASS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey PublicSectorFormClass view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #NONE view
Metadata.ignorePropagatedAnnotations true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY PublicSectorFormClass Form Class
_Text _Text

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_PublicSectorFormClass.
-- 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_PublicSectorFormClass AS
SELECT
  cast( substring( dd07l.domvalue_l, 1, 2 ) as ps_form_class preserving type ) AS PublicSectorFormClass
FROM dd07l
LEFT OUTER JOIN I_PublicSectorFormClassText AS _Text ON PublicSectorFormClass = _Text.PublicSectorFormClass  -- association [0..*]
;