C_GteeMBdgtEntrDocItm4ObjP_Unr

DDL: C_GTEEMBDGTENTRDOCITM4OBJP_UNR SQL: CGMBDOCITM4OBPU Type: view CONSUMPTION
53 Fields 1 Data Sources 3 Associations

Auxiliary Consumption view for Obj Page

C_GteeMBdgtEntrDocItm4ObjP_Unr is a Consumption CDS View that provides data about "Auxiliary Consumption view for Obj Page" in SAP S/4HANA. It reads from 1 data source (I_GteeMBudgetEntryDocumentItem) and exposes 53 fields with key fields GranteeMgmtBudgetEntryDocument, GteeMBudgetEntryDocumentItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_GteeMBudgetEntryDocumentItem I_GteeMBudgetEntryDocumentItem from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_GteeMBudgetEntryDocTypeText _DocTypeText $projection.GteeMBudgetEntryDocumentType = _DocTypeText.GteeMBudgetEntryDocumentType
[0..1] I_ControllingVersionText _BudgetVersionText $projection.granteemgmtbudgetversion = _BudgetVersionText.ControllingVersion and _BudgetVersionText.Language = $session.system_language
[0..*] I_BusTransactionTypeText _BudgetingProcessText $projection.GteeMInternalBudgetingProcess = _BudgetingProcessText.BusinessTransactionType

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CGMBDOCITM4OBPU 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 Consumption view for Obj Page view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY GranteeMgmtBudgetEntryDocument GranteeMgmtBudgetEntryDocument
KEY GteeMBudgetEntryDocumentItem GteeMBudgetEntryDocumentItem
GteeMBudgetEntryDocumentType _Header GteeMBudgetEntryDocumentType
GranteeMgmtBudgetingProcess _Header GranteeMgmtBudgetingProcess
GrantCurrency _Header GrantCurrency Grant Currency
GranteeMgmtBudgetVersion _Header GranteeMgmtBudgetVersion
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
GranteeMgmtWorkflowStatus _Header GranteeMgmtWorkflowStatus
GteeMBudgetEntryDocumentDesc _Header GteeMBudgetEntryDocumentDesc
GrantID _Header GrantID Sender Grant
GranteeMgmtBudgetStatus _Header GranteeMgmtBudgetStatus
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
GteeMIndirectCostRateInPercent GteeMIndirectCostRateInPercent
GteeMCostSharingRateInPercent GteeMCostSharingRateInPercent
GteeMBudgetEntryDocItemDesc GteeMBudgetEntryDocItemDesc
GteeMInternalBudgetingProcess GteeMInternalBudgetingProcess
GranteeMgmtValueType GranteeMgmtValueType
GranteeFiscalYear GranteeFiscalYear
SponsoredClassType SponsoredClassType
NetBdgtAmtInGrantCrcy NetBdgtAmtInGrantCrcy
IndirectCostBdgtAmtInGrantCrcy IndirectCostBdgtAmtInGrantCrcy
AwardBdgtAmtInGrantCrcy AwardBdgtAmtInGrantCrcy
CostShrngBdgtAmtInGrantCrcy CostShrngBdgtAmtInGrantCrcy
TotalBdgtAmtInGrantCrcy TotalBdgtAmtInGrantCrcy
GrantAuthznGrp _Grant GrantAuthznGrp
GrantLfcycStatusForAuthzn _Grant GrantLfcycStatusForAuthzn
SponsoredProgramAuthznGrp _SponsoredProgram SponsoredProgramAuthznGrp
SponsoredClassAuthznGrp _SponsoredClass SponsoredClassAuthznGrp
_DocTypeText _DocTypeText
_BudgetVersionText _BudgetVersionText
_BudgetingProcessText _BudgetingProcessText

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_GteeMBdgtEntrDocItm4ObjP_Unr.
-- 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: CGMBDOCITM4OBPU

CREATE VIEW C_GteeMBdgtEntrDocItm4ObjP_Unr AS
SELECT
  GranteeMgmtBudgetEntryDocument,
  GteeMBudgetEntryDocumentItem,
  _Header.GteeMBudgetEntryDocumentType AS GteeMBudgetEntryDocumentType,
  _Header.GranteeMgmtBudgetingProcess AS GranteeMgmtBudgetingProcess,
  _Header.GrantCurrency AS GrantCurrency,
  _Header.GranteeMgmtBudgetVersion AS GranteeMgmtBudgetVersion,
  _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.GranteeMgmtWorkflowStatus AS GranteeMgmtWorkflowStatus,
  _Header.GteeMBudgetEntryDocumentDesc AS GteeMBudgetEntryDocumentDesc,
  _Header.GrantID AS GrantID,
  _Header.GranteeMgmtBudgetStatus AS GranteeMgmtBudgetStatus,
  _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,
  GteeMIndirectCostRateInPercent,
  GteeMCostSharingRateInPercent,
  GteeMBudgetEntryDocItemDesc,
  GteeMInternalBudgetingProcess,
  GranteeMgmtValueType,
  GranteeFiscalYear,
  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
LEFT OUTER JOIN I_GteeMBudgetEntryDocTypeText AS _DocTypeText ON GteeMBudgetEntryDocumentType = _DocTypeText.GteeMBudgetEntryDocumentType  -- association [0..*]
LEFT OUTER JOIN I_ControllingVersionText AS _BudgetVersionText ON granteemgmtbudgetversion = _BudgetVersionText.ControllingVersion AND _BudgetVersionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusTransactionTypeText AS _BudgetingProcessText ON GteeMInternalBudgetingProcess = _BudgetingProcessText.BusinessTransactionType  -- association [0..*]
;

Learn More