C_GteeMBdgtEntryDocItemForObjP

DDL: C_GTEEMBDGTENTRYDOCITEMFOROBJP SQL: CGMBDOCITM4OBJP Type: view CONSUMPTION
57 Fields 1 Data Sources

Auxiliary Cosumption view for Object Page

C_GteeMBdgtEntryDocItemForObjP is a Consumption CDS View that provides data about "Auxiliary Cosumption view for Object Page" in SAP S/4HANA. It reads from 1 data source (I_GteeMBudgetEntryDocumentItem) and exposes 57 fields with key fields GranteeMgmtBudgetEntryDocument, GteeMBudgetEntryDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_GteeMBudgetEntryDocumentItem I_GteeMBudgetEntryDocumentItem from

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CGMBDOCITM4OBJP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
EndUserText.label Auxiliary Cosumption view for Object Page view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY GranteeMgmtBudgetEntryDocument GranteeMgmtBudgetEntryDocument GM Budget Document
KEY GteeMBudgetEntryDocumentItem GteeMBudgetEntryDocumentItem
GteeMBudgetEntryDocumentType _Header GteeMBudgetEntryDocumentType
GteeMBudgetEntryDocTypeDesc Document Type Name
GranteeMgmtBudgetingProcess _Header GranteeMgmtBudgetingProcess
GteeMBudgetingProcessName GM Process Name
GrantCurrency _Header GrantCurrency Grant Currency
GranteeMgmtBudgetVersion _Header GranteeMgmtBudgetVersion
BudgetVersionName Version Name
GranteeMgmtBudgetReason _Header GranteeMgmtBudgetReason
CreationDate _Header CreationDate Time Stamp
CreationTime _Header CreationTime Time of Change
CreatedByUser _Header CreatedByUser User Name
GranteeMgmtApprovalDate _Header GranteeMgmtApprovalDate
GranteeMgmtApprovalTime _Header GranteeMgmtApprovalTime
GteeMBudgetEntryDocOrigin _Header GteeMBudgetEntryDocOrigin
GranteeMgmtBudgetVersionOrigin _Header GranteeMgmtBudgetVersionOrigin
PostingDate _Header PostingDate Posting Date for GR
GteeMBdgtEntrDocRvslStatusName Reversal Status Name
GranteeMgmtWorkflowStatus _Header GranteeMgmtWorkflowStatus
GteeMBudgetEntryDocumentDesc _Header GteeMBudgetEntryDocumentDesc
GrantID _Header GrantID Sender Grant
GranteeMgmtBudgetStatus _Header GranteeMgmtBudgetStatus
GranteeMgmtBudgetStatusName Budget Status Name
DocumentDate _Header DocumentDate Journal Entry Date
GteeMBudgetEntryDocStatus _Header GteeMBudgetEntryDocStatus
GteeMBdgtEntryDocRvslStatus _Header GteeMBdgtEntryDocRvslStatus
GteeMRvslRefBudgetEntryDoc _Header GteeMRvslRefBudgetEntryDoc
LogicalSystem _Header LogicalSystem Logical System
ReferenceDocumentType _Header ReferenceDocumentType Reference Document Type
ReferenceDocumentLogicalSystem _Header ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
ReferenceDocumentContext _Header ReferenceDocumentContext Reference Document Context
ReferenceDocument _Header ReferenceDocument Reference Document
GteeMBudgetValidityNumber GteeMBudgetValidityNumber Bdgt Validty No.
SponsoredProgram SponsoredProgram Sponsored Program
SponsoredClass SponsoredClass Sponsored Class
GteeMFinancingObjectType GteeMFinancingObjectType
GteeMFinancingObject GteeMFinancingObject
Fund Fund Sender Fund
FundName Fund Name
GteeMIndirectCostRateInPercent GteeMIndirectCostRateInPercent
GteeMCostSharingRateInPercent GteeMCostSharingRateInPercent
GteeMBudgetEntryDocItemDesc GteeMBudgetEntryDocItemDesc
GteeMInternalBudgetingProcess GteeMInternalBudgetingProcess Internal Budget Process
GranteeMgmtValueType GranteeMgmtValueType
GranteeFiscalYear GranteeFiscalYear
SponsoredClassTypeName Sponsored Class Type Name
SponsoredClassType SponsoredClassType
NetBdgtAmtInGrantCrcy NetBdgtAmtInGrantCrcy
IndirectCostBdgtAmtInGrantCrcy IndirectCostBdgtAmtInGrantCrcy
AwardBdgtAmtInGrantCrcy AwardBdgtAmtInGrantCrcy
CostShrngBdgtAmtInGrantCrcy CostShrngBdgtAmtInGrantCrcy
TotalBdgtAmtInGrantCrcy TotalBdgtAmtInGrantCrcy
GrantAuthznGrp _Grant GrantAuthznGrp
GrantLfcycStatusForAuthzn _Grant GrantLfcycStatusForAuthzn
SponsoredProgramAuthznGrp _SponsoredProgram SponsoredProgramAuthznGrp
SponsoredClassAuthznGrp _SponsoredClass SponsoredClassAuthznGrp

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_GteeMBdgtEntryDocItemForObjP.
-- 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: CGMBDOCITM4OBJP

CREATE VIEW C_GteeMBdgtEntryDocItemForObjP AS
SELECT
  GranteeMgmtBudgetEntryDocument,
  GteeMBudgetEntryDocumentItem,
  _Header.GteeMBudgetEntryDocumentType AS GteeMBudgetEntryDocumentType,
  _Header._BudgetDocType._Text[1:Language=$session.system_language].GteeMBudgetEntryDocTypeDesc AS GteeMBudgetEntryDocTypeDesc,
  _Header.GranteeMgmtBudgetingProcess AS GranteeMgmtBudgetingProcess,
  _Header._BudgetingProcess._Text[1:Language=$session.system_language].GteeMBudgetingProcessName AS GteeMBudgetingProcessName,
  _Header.GrantCurrency AS GrantCurrency,
  _Header.GranteeMgmtBudgetVersion AS GranteeMgmtBudgetVersion,
  _Header._BudgetVersion._Text[1:Language=$session.system_language].ControllingVersionText AS BudgetVersionName,
  _Header.GranteeMgmtBudgetReason AS GranteeMgmtBudgetReason,
  _Header.CreationDate AS CreationDate,
  _Header.CreationTime AS CreationTime,
  _Header.CreatedByUser AS CreatedByUser,
  _Header.GranteeMgmtApprovalDate AS GranteeMgmtApprovalDate,
  _Header.GranteeMgmtApprovalTime AS GranteeMgmtApprovalTime,
  _Header.GteeMBudgetEntryDocOrigin AS GteeMBudgetEntryDocOrigin,
  _Header.GranteeMgmtBudgetVersionOrigin AS GranteeMgmtBudgetVersionOrigin,
  _Header.PostingDate AS PostingDate,
  _Header._BdgtEntryDocRvslStatus._Text[1:Language=$session.system_language].GteeMBdgtEntrDocRvslStatusName AS GteeMBdgtEntrDocRvslStatusName,
  _Header.GranteeMgmtWorkflowStatus AS GranteeMgmtWorkflowStatus,
  _Header.GteeMBudgetEntryDocumentDesc AS GteeMBudgetEntryDocumentDesc,
  _Header.GrantID AS GrantID,
  _Header.GranteeMgmtBudgetStatus AS GranteeMgmtBudgetStatus,
  _Header._BudgetStatus._Text[1:Language=$session.system_language].GranteeMgmtBudgetStatusName AS GranteeMgmtBudgetStatusName,
  _Header.DocumentDate AS DocumentDate,
  _Header.GteeMBudgetEntryDocStatus AS GteeMBudgetEntryDocStatus,
  _Header.GteeMBdgtEntryDocRvslStatus AS GteeMBdgtEntryDocRvslStatus,
  _Header.GteeMRvslRefBudgetEntryDoc AS GteeMRvslRefBudgetEntryDoc,
  _Header.LogicalSystem AS LogicalSystem,
  _Header.ReferenceDocumentType AS ReferenceDocumentType,
  _Header.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  _Header.ReferenceDocumentContext AS ReferenceDocumentContext,
  _Header.ReferenceDocument AS ReferenceDocument,
  GteeMBudgetValidityNumber,
  SponsoredProgram,
  SponsoredClass,
  GteeMFinancingObjectType,
  GteeMFinancingObject,
  Fund,
  _Fund._Text[1:Language = $session.system_language].FundName AS FundName,
  GteeMIndirectCostRateInPercent,
  GteeMCostSharingRateInPercent,
  GteeMBudgetEntryDocItemDesc,
  GteeMInternalBudgetingProcess,
  GranteeMgmtValueType,
  GranteeFiscalYear,
  _SponsoredClassType._Text[1:Language = $session.system_language].SponsoredClassTypeName AS SponsoredClassTypeName,
  SponsoredClassType,
  NetBdgtAmtInGrantCrcy,
  IndirectCostBdgtAmtInGrantCrcy,
  AwardBdgtAmtInGrantCrcy,
  CostShrngBdgtAmtInGrantCrcy,
  TotalBdgtAmtInGrantCrcy,
  _Grant.GrantAuthznGrp AS GrantAuthznGrp,
  _Grant.GrantLfcycStatusForAuthzn AS GrantLfcycStatusForAuthzn,
  _SponsoredProgram.SponsoredProgramAuthznGrp AS SponsoredProgramAuthznGrp,
  _SponsoredClass.SponsoredClassAuthznGrp AS SponsoredClassAuthznGrp
FROM I_GteeMBudgetEntryDocumentItem
;

Learn More