C_UniversalAllocationGrantVH

DDL: C_UNIVERSALALLOCATIONGRANTVH Type: view_entity CONSUMPTION Package: ODATA_MANAGE_ALLOCATION_V2_VH
13 Fields 1 Data Sources 2 OData Services

Grant

C_UniversalAllocationGrantVH is a Consumption CDS View that provides data about "Grant" in SAP S/4HANA. It reads from 1 data source (I_Grant) and exposes 13 fields with key field GrantID. It is exposed through 2 OData services (ASQL_F3338A, UI_FCO_MANAGE_ALLOCATION). Part of development package ODATA_MANAGE_ALLOCATION_V2_VH.

Data Sources (1)

SourceAliasJoin Type
I_Grant I_Grant from

Annotations (12)

NameValueLevelField
EndUserText.label Grant view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey GrantID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations false view
Search.searchable true view
AccessControl.personalData.blocking #REQUIRED view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F3338A ASQL_F3338A C2 NOT_RELEASED
UI_FCO_MANAGE_ALLOCATION UI_FCOUA_MANAGE_ALLOCATION V2 C1 NOT_RELEASED

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY GrantID GrantID Sender Grant
GrantName
CompanyCode CompanyCode Receiver Company Code
GranteeMgmtSponsor GranteeMgmtSponsor With Partner
BusinessPartnerName _Sponsor BusinessPartnerName Sponsor Name
GrantIsNotRelevantGrant GrantIsNotRelevantGrant
GrantAuthznGrp GrantAuthznGrp Authorization Group
GrantLfcycStatusForAuthzn GrantLfcycStatusForAuthzn
GrantLifecycleStatus GrantLifecycleStatus Status
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate Validity End Date
_Text _Text
_Sponsor _Sponsor

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 C_UniversalAllocationGrantVH.
-- 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 C_UniversalAllocationGrantVH AS
SELECT
  GrantID,
  _Text[1:Language = $session.system_language].GrantName AS GrantName,
  CompanyCode,
  GranteeMgmtSponsor,
  _Sponsor.BusinessPartnerName AS BusinessPartnerName,
  GrantIsNotRelevantGrant,
  GrantAuthznGrp,
  GrantLfcycStatusForAuthzn,
  GrantLifecycleStatus,
  ValidityStartDate,
  ValidityEndDate
FROM I_Grant
;

Learn More