I_PubSecGrantStsNtwkConfign

DDL: I_PUBSECGRANTSTSNTWKCONFIGN SQL: IPSMGRNTSTSCNFG Type: view BASIC
12 Fields 1 Data Sources

Grant Status Network Configuration

I_PubSecGrantStsNtwkConfign is a Basic CDS View that provides data about "Grant Status Network Configuration" in SAP S/4HANA. It reads from 1 data source (psm_gmstatus_cnf) and exposes 12 fields with key fields GrantType, GrantLifecycleStatus.

Data Sources (1)

SourceAliasJoin Type
psm_gmstatus_cnf psm_gmstatus_cnf from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPSMGRNTSTSCNFG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Grant Status Network Configuration view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY GrantType grant_type Grant Type
KEY GrantLifecycleStatus lifecycle_status Status
GrantPreviousStatus1 previous_state1 Previous Status
GrantPreviousStatus2 previous_state2 Previous Status
GrantPreviousStatus3 previous_state3 Previous Status
GrantPreviousStatus4 previous_state4 Previous Status
GrantPreviousStatus5 previous_state5 Previous Status
GrantPreviousStatus6 previous_state6 Previous Status
GrantPreviousStatus7 previous_state7 Previous Status
GrantPreviousStatus8 previous_state8 Previous Status
GrantInitialState initial_state Initial State
GrantWorkflowActive workflow_active Workflow Active

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_PubSecGrantStsNtwkConfign.
-- 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: IPSMGRNTSTSCNFG

CREATE VIEW I_PubSecGrantStsNtwkConfign AS
SELECT
  grant_type AS GrantType,
  lifecycle_status AS GrantLifecycleStatus,
  previous_state1 AS GrantPreviousStatus1,
  previous_state2 AS GrantPreviousStatus2,
  previous_state3 AS GrantPreviousStatus3,
  previous_state4 AS GrantPreviousStatus4,
  previous_state5 AS GrantPreviousStatus5,
  previous_state6 AS GrantPreviousStatus6,
  previous_state7 AS GrantPreviousStatus7,
  previous_state8 AS GrantPreviousStatus8,
  initial_state AS GrantInitialState,
  workflow_active AS GrantWorkflowActive
FROM psm_gmstatus_cnf
;

Learn More