I_PublicSectorContract

DDL: I_PUBLICSECTORCONTRACT Type: view BASIC
14 Fields 1 Data Sources 2 Associations

Public Sector Contract

I_PublicSectorContract (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_PublicSectorContract is a Basic CDS View that provides data about "Public Sector Contract" in SAP S/4HANA. It reads from 1 data source (dpsob) and exposes 14 fields with key field PublicSectorContract. It has 2 associations 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 contracts within a system. It captures essential details about each contract, including its unique identifiers, type, name, creation and modification details, authorization group, archiving status, and associated address information. The view facilitates the integration and retrieval of contract data for various business processes and reporting needs. This CDS view provides the data to answer the following business questions: What are the unique identifiers and names of public sector contracts in the system? What type of contract is associated with each public sector contract? Who created or last modified a specific public sector contract, and when did these actions occur? Is a particular public sector contract marked for archiving? What is the associated address for each public sector contract? How can the authorization group for a specific public sector contract be identified? 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 must have the following authorization objects assigned: Authorization Object ID Authorization Object Text F_PSOB_BEG PSCD Contract Object: Authorization Group F_PSOB_VGT PSCD Contract Object: Object Type Authorization

Structure
Important Fields Important fields in this view include the following: Field Name Label PublicSectorContract Contract Object PublicSectorContractUUID Cnt Objt GUID PublicSectorContractType Taxpayer Contract Type PublicSectorContractName Taxpayer Contract Name PublicSectorContractLegacyName Contract Object Legacy Name CreatedByUser Created By CreationDate Created On LastChangedByUser Changed By LastChangedDate Changed On AuthorizationGroup Authorization Group IsMarkedForArchiving Archiving Flag AddressID Address Number

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 contracts within a system. It captures essential details about each contract, including its unique identifiers, type, name, creation and modification details, authorization group, archiving status, and associated address information. The view facilitates the integration and retrieval of contract data for various business processes and reporting needs. </p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the unique identifiers and names of public sector contracts in the system?</p></li> <li><p>What type of contract is associated with each public sector contract?</p></li> <li><p>Who created or last modified a specific public sector contract, and when did these actions occur?</p></li> <li><p>Is a particular public sector contract marked for archiving?</p></li> <li><p>What is the associated address for each public sector contract?</p></li> <li><p>How can the authorization group for a specific public sector contract be identified?</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
dpsob PublicSectorContract from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PublicSectorContractType _PublicSectorContractType $projection.PublicSectorContractType = _PublicSectorContractType.PublicSectorContractType
[0..1] I_AddressDefaultRepresentation _Address $projection.AddressID = _Address.AddressID

Annotations (14)

NameValueLevelField
EndUserText.label Public Sector Contract view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.sqlViewName IPSCONTRACT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey PublicSectorContract view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.modelingPattern #NONE view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PublicSectorContract dpsob psobkey Identification Key for Contract Object
PublicSectorContractUUID psob_guid GUID of a Contract Object
PublicSectorContractType Taxpayer Contract Type
PublicSectorContractName Taxpayer Contract Name
PublicSectorContractLegacyName Contract Object Legacy Name
CreatedByUser ernam Name of Person Responsible for Creating the Object
CreationDate erdat Record Created On
LastChangedByUser aenam Name of Person Who Changed Object
LastChangedDate aedat Last Changed On
AuthorizationGroup begru Authorization Group
IsMarkedForArchiving xdele Indicator: Production Run Data Deleted
AddressID loadr Address Number of Location
_PublicSectorContractType _PublicSectorContractType
_Address _Address

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_PublicSectorContract.
-- 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_PublicSectorContract AS
SELECT
  PublicSectorContract.psobkey AS PublicSectorContract,
  psob_guid AS PublicSectorContractUUID,
  cast( PublicSectorContract.psobtyp as ps_taxpayer_contract_type preserving type ) AS PublicSectorContractType,
  cast( psobtxt as ps_taxpayer_contractname preserving type ) AS PublicSectorContractName,
  cast( legacyobjk1 as ps_contractobject_legacyname preserving type ) AS PublicSectorContractLegacyName,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  aenam AS LastChangedByUser,
  aedat AS LastChangedDate,
  begru AS AuthorizationGroup,
  xdele AS IsMarkedForArchiving,
  loadr AS AddressID
FROM dpsob AS PublicSectorContract
LEFT OUTER JOIN I_PublicSectorContractType AS _PublicSectorContractType ON PublicSectorContractType = _PublicSectorContractType.PublicSectorContractType  -- association [0..1]
LEFT OUTER JOIN I_AddressDefaultRepresentation AS _Address ON AddressID = _Address.AddressID  -- association [0..1]
;

Learn More