I_GranteeMgmtBdgtDocCube

DDL: I_GRANTEEMGMTBDGTDOCCUBE SQL: IGMBDGTDOCIANC Type: view COMPOSITE
59 Fields 1 Data Sources 4 Associations

Grantee Management Budget Items - Cube

I_GranteeMgmtBdgtDocCube (Composite)

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

Cross Applications

I_GranteeMgmtBdgtDocCube is a Composite CDS View (Cube) that provides data about "Grantee Management Budget Items - Cube" in SAP S/4HANA. It reads from 1 data source (I_GteeMBdgtChgDocItem) and exposes 59 fields with key field GranteeMgmtLongSequenceNumber. It has 4 associations to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentPSM-GM-GTE-IS
CapabilitiesData Provider for Analytical Queries
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>The CDS view provides detailed information about the budget change documents captured in the Grantee Management budget line item ledger.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_GteeMBdgtChgDocItem Bdgt from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_GteeMBudgetEntryDocumentItem _GteeMBudgetEntryDocumentItem $projection.ReferenceDocument = _GteeMBudgetEntryDocumentItem.GranteeMgmtBudgetEntryDocument and $projection.ReferenceDocumentItem = _GteeMBudgetEntryDocumentItem.GteeMBudgetEntryDocumentItem
[0..1] I_GteeMBdgtValidityNumber _BudgetValidityNumber $projection.GrantID = _BudgetValidityNumber.GrantID and $projection.GteeMBudgetValidityNumber = _BudgetValidityNumber.GteeMBudgetValidityNumber and $projection.GranteeMgmtBdgtPhase = _BudgetValidityNumber.GranteeMgmtBdgtPhase and $projection.GranteeMgmtBudgetStatus = _BudgetValidityNumber.GranteeMgmtBudgetStatus
[0..1] I_GranteeMgmtBudgetStatus _GranteeMgmtBudgetStatus $projection.GranteeMgmtBudgetStatus = _GranteeMgmtBudgetStatus.GranteeMgmtBudgetStatus
[0..1] I_GteeMBdgtWorkFlowSts _GteeMBdgtWorkFlowSts $projection.GranteeMgmtBdgtWorkFlowSts = _GteeMBdgtWorkFlowSts.GranteeMgmtBdgtWorkFlowSts

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IGMBDGTDOCIANC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Grantee Management Budget Items - Cube view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY GranteeMgmtLongSequenceNumber I_GteeMBdgtChgDocItem GranteeMgmtLongSequenceNumber Record number of the line item record
Ledger I_GteeMBdgtChgDocItem Ledger Ledger
GranteeMgmtBudgetVersion I_GteeMBdgtChgDocItem GranteeMgmtBudgetVersion Version
CompanyCode I_GteeMBdgtChgDocItem CompanyCode Receiver Company Code
FinancialManagementArea I_GteeMBdgtChgDocItem FinancialManagementArea Financial Management Area
GranteeMgmtSponsor I_GteeMBdgtChgDocItem GranteeMgmtSponsor Grant Sponsor
GrantID I_GteeMBdgtChgDocItem GrantID Sender Grant
SponsoredProgram I_GteeMBdgtChgDocItem SponsoredProgram Sponsored Program
SponsoredClass I_GteeMBdgtChgDocItem SponsoredClass Sponsored Class
Fund I_GteeMBdgtChgDocItem Fund Sender Fund
GteeMBudgetValidityNumber I_GteeMBdgtChgDocItem GteeMBudgetValidityNumber Budget Validity Number
GrantFiscalYear I_GteeMBdgtChgDocItem GrantFiscalYear Fiscal Year of Sponsor (is Grant Fiscal Year)
GrantFiscalYearVariant I_GteeMBdgtChgDocItem GrantFiscalYearVariant Fiscal year variant of grant
GranteeFiscalYear I_GteeMBdgtChgDocItem GranteeFiscalYear Fiscal Year for Grantee Organization
GranteeFiscalYearVariant I_GteeMBdgtChgDocItem GranteeFiscalYearVariant Fiscal Year Variant of Grantee Organization (Company Code)
GrantCurrency I_GteeMBdgtChgDocItem GrantCurrency Grant Currency
BudgetAmountInGrantCrcy I_GteeMBdgtChgDocItem BudgetAmountInGrantCrcy Budget Amount in Grant Currency in Grantee Management
CompanyCodeCurrency I_GteeMBdgtChgDocItem CompanyCodeCurrency GM Company Code Currency
BudgetAmountInCompanyCodeCrcy I_GteeMBdgtChgDocItem BudgetAmountInCompanyCodeCrcy Budget Amount in Company Code Currency in Grantee Management
GranteeMgmtValueType I_GteeMBdgtChgDocItem GranteeMgmtValueType GM Value Type
GranteeMgmtValueTypeCategory GM Value Type Category
BusinessTransactionType I_GteeMBdgtChgDocItem BusinessTransactionType Business Transaction Category
IsStatisticalItem I_GteeMBdgtChgDocItem IsStatisticalItem Statistical Indicator
LogicalSystem I_GteeMBdgtChgDocItem LogicalSystem Logical System
GranteeMgmtBdgtPhase Budget Phase
GranteeMgmtBdgtWorkFlowSts I_GteeMBdgtChgDocItem GranteeMgmtBdgtWorkFlowSts Workflow State of a Record in the Budget Totals Table
GteeMBudgetEntryDocItemDesc I_GteeMBdgtChgDocItem GteeMBudgetEntryDocItemDesc Item Text
GteeMBudgetEntryDocumentType Budget Document Type
PostingDate I_GteeMBdgtChgDocItem PostingDate Posting Date in the Document
CreationDate I_GteeMBdgtChgDocItem CreationDate Day On Which Accounting Document Was Entered
CreationTime I_GteeMBdgtChgDocItem CreationTime Time of Change
CreatedByUser I_GteeMBdgtChgDocItem CreatedByUser User Name
SponsoredClassType _GteeMBudgetEntryDocumentItem SponsoredClassType Sponsored Class Type
GrantLifecycleStatus Lifecycle Status
ReferenceDocument I_GteeMBdgtChgDocItem ReferenceDocument Reference Doc. Number
ReferenceDocumentFiscalYear I_GteeMBdgtChgDocItem ReferenceDocumentFiscalYear Reference fiscal year
ReferenceDocumentItem I_GteeMBdgtChgDocItem ReferenceDocumentItem Reference Document Line Item
ReferenceDocumentType I_GteeMBdgtChgDocItem ReferenceDocumentType Reference Document Type
ReferenceDocumentContext I_GteeMBdgtChgDocItem ReferenceDocumentContext Reference Organizational Units
_Ledger I_GteeMBdgtChgDocItem _Ledger
_FiscalYearForCompanyCode I_GteeMBdgtChgDocItem _FiscalYearForCompanyCode
_SponsoredProgram I_GteeMBdgtChgDocItem _SponsoredProgram
_SponsoredClass I_GteeMBdgtChgDocItem _SponsoredClass
_BudgetValidityNumber _BudgetValidityNumber
_GrantLifecycleStatus
_SponsoredClassType _GteeMBudgetEntryDocumentItem _SponsoredClassType
_BudgetEntryDocType
_Fund I_GteeMBdgtChgDocItem _Fund
_ValueType I_GteeMBdgtChgDocItem _ValueType
_GteeMValueTypeCategory _ValueType _GteeMValueTypeCategory
_BudgetVersion I_GteeMBdgtChgDocItem _BudgetVersion
_GranteeMgmtBdgtPhase
_GranteeMgmtBudgetStatus _GranteeMgmtBudgetStatus
_GteeMBdgtWorkFlowSts _GteeMBdgtWorkFlowSts
_BusinessTransactionType I_GteeMBdgtChgDocItem _BusinessTransactionType
_CompanyCode I_GteeMBdgtChgDocItem _CompanyCode
_FinMgmtArea I_GteeMBdgtChgDocItem _FinMgmtArea
_Sponsor I_GteeMBdgtChgDocItem _Sponsor
_Grant I_GteeMBdgtChgDocItem _Grant

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_GranteeMgmtBdgtDocCube.
-- 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: IGMBDGTDOCIANC

CREATE VIEW I_GranteeMgmtBdgtDocCube AS
SELECT
  Bdgt.GranteeMgmtLongSequenceNumber AS GranteeMgmtLongSequenceNumber,
  Bdgt.Ledger AS Ledger,
  Bdgt.GranteeMgmtBudgetVersion AS GranteeMgmtBudgetVersion,
  Bdgt.CompanyCode AS CompanyCode,
  Bdgt.FinancialManagementArea AS FinancialManagementArea,
  Bdgt.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  Bdgt.GrantID AS GrantID,
  Bdgt.SponsoredProgram AS SponsoredProgram,
  Bdgt.SponsoredClass AS SponsoredClass,
  Bdgt.Fund AS Fund,
  Bdgt.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  Bdgt.GrantFiscalYear AS GrantFiscalYear,
  Bdgt.GrantFiscalYearVariant AS GrantFiscalYearVariant,
  Bdgt.GranteeFiscalYear AS GranteeFiscalYear,
  Bdgt.GranteeFiscalYearVariant AS GranteeFiscalYearVariant,
  Bdgt.GrantCurrency AS GrantCurrency,
  Bdgt.BudgetAmountInGrantCrcy AS BudgetAmountInGrantCrcy,
  Bdgt.CompanyCodeCurrency AS CompanyCodeCurrency,
  Bdgt.BudgetAmountInCompanyCodeCrcy AS BudgetAmountInCompanyCodeCrcy,
  Bdgt.GranteeMgmtValueType AS GranteeMgmtValueType,
  Bdgt._ValueType.GranteeMgmtValueTypeCategory AS GranteeMgmtValueTypeCategory,
  Bdgt.BusinessTransactionType AS BusinessTransactionType,
  Bdgt.IsStatisticalItem AS IsStatisticalItem,
  Bdgt.LogicalSystem AS LogicalSystem,
  Bdgt._BudgetVersion.GranteeMgmtBdgtPhase AS GranteeMgmtBdgtPhase,
  Bdgt.GranteeMgmtBdgtWorkFlowSts AS GranteeMgmtBdgtWorkFlowSts,
  Bdgt.GteeMBudgetEntryDocItemDesc AS GteeMBudgetEntryDocItemDesc,
  _GteeMBudgetEntryDocumentItem._Header.GteeMBudgetEntryDocumentType AS GteeMBudgetEntryDocumentType,
  Bdgt.PostingDate AS PostingDate,
  Bdgt.CreationDate AS CreationDate,
  Bdgt.CreationTime AS CreationTime,
  Bdgt.CreatedByUser AS CreatedByUser,
  _GteeMBudgetEntryDocumentItem.SponsoredClassType AS SponsoredClassType,
  Bdgt._Grant.GrantLifecycleStatus AS GrantLifecycleStatus,
  Bdgt.ReferenceDocument AS ReferenceDocument,
  Bdgt.ReferenceDocumentFiscalYear AS ReferenceDocumentFiscalYear,
  Bdgt.ReferenceDocumentItem AS ReferenceDocumentItem,
  Bdgt.ReferenceDocumentType AS ReferenceDocumentType,
  Bdgt.ReferenceDocumentContext AS ReferenceDocumentContext,
  Bdgt._Ledger AS _Ledger,
  Bdgt._FiscalYearForCompanyCode AS _FiscalYearForCompanyCode,
  Bdgt._SponsoredProgram AS _SponsoredProgram,
  Bdgt._SponsoredClass AS _SponsoredClass,
  Bdgt._Grant._GrantLifecycleStatus AS _GrantLifecycleStatus,
  _GteeMBudgetEntryDocumentItem._SponsoredClassType AS _SponsoredClassType,
  _GteeMBudgetEntryDocumentItem._Header._BudgetDocType AS _BudgetEntryDocType,
  Bdgt._Fund AS _Fund,
  Bdgt._ValueType AS _ValueType,
  _ValueType._GteeMValueTypeCategory AS _GteeMValueTypeCategory,
  Bdgt._BudgetVersion AS _BudgetVersion,
  Bdgt._BudgetVersion._GranteeMgmtBdgtPhase AS _GranteeMgmtBdgtPhase,
  Bdgt._BusinessTransactionType AS _BusinessTransactionType,
  Bdgt._CompanyCode AS _CompanyCode,
  Bdgt._FinMgmtArea AS _FinMgmtArea,
  Bdgt._Sponsor AS _Sponsor,
  Bdgt._Grant AS _Grant
FROM I_GteeMBdgtChgDocItem AS Bdgt
LEFT OUTER JOIN I_GteeMBudgetEntryDocumentItem AS _GteeMBudgetEntryDocumentItem ON ReferenceDocument = _GteeMBudgetEntryDocumentItem.GranteeMgmtBudgetEntryDocument AND ReferenceDocumentItem = _GteeMBudgetEntryDocumentItem.GteeMBudgetEntryDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_GteeMBdgtValidityNumber AS _BudgetValidityNumber ON GrantID = _BudgetValidityNumber.GrantID AND GteeMBudgetValidityNumber = _BudgetValidityNumber.GteeMBudgetValidityNumber AND GranteeMgmtBdgtPhase = _BudgetValidityNumber.GranteeMgmtBdgtPhase AND GranteeMgmtBudgetStatus = _BudgetValidityNumber.GranteeMgmtBudgetStatus  -- association [0..1]
LEFT OUTER JOIN I_GranteeMgmtBudgetStatus AS _GranteeMgmtBudgetStatus ON GranteeMgmtBudgetStatus = _GranteeMgmtBudgetStatus.GranteeMgmtBudgetStatus  -- association [0..1]
LEFT OUTER JOIN I_GteeMBdgtWorkFlowSts AS _GteeMBdgtWorkFlowSts ON GranteeMgmtBdgtWorkFlowSts = _GteeMBdgtWorkFlowSts.GranteeMgmtBdgtWorkFlowSts  -- association [0..1]
;

Learn More