I_GteeMBudgetEntryDocument

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_GteeMBudgetEntryDocument.
-- 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: IGMBDGTDOC

CREATE VIEW I_GteeMBudgetEntryDocument AS
SELECT
  bdgt_doc_nbr AS GranteeMgmtBudgetEntryDocument,
  doc_type AS GteeMBudgetEntryDocumentType,
  process AS GranteeMgmtBudgetingProcess,
  waers AS GrantCurrency,
  bdgt_version AS GranteeMgmtBudgetVersion,
  bdgt_reason_code AS GranteeMgmtBudgetReason,
  entry_date AS CreationDate,
  entry_time AS CreationTime,
  entry_user AS CreatedByUser,
  approval_date AS GranteeMgmtApprovalDate,
  approval_time AS GranteeMgmtApprovalTime,
  bdgt_origin AS GteeMBudgetEntryDocOrigin,
  bdgt_ver_origin AS GranteeMgmtBudgetVersionOrigin,
  posting_date AS PostingDate,
  status AS GranteeMgmtWorkflowStatus,
  text AS GteeMBudgetEntryDocumentDesc,
  grant_nbr AS GrantID,
  bdgt_status AS GranteeMgmtBudgetStatus,
  doc_date AS DocumentDate,
  cast ( docstate as gmis_bdgt_docstate preserving type ) AS GteeMBudgetEntryDocStatus,
  rev_status AS GteeMBdgtEntryDocRvslStatus,
  rev_refnr AS GteeMRvslRefBudgetEntryDoc,
  logsys AS LogicalSystem,
  awtyp AS ReferenceDocumentType,
  awsys AS ReferenceDocumentLogicalSystem,
  aworg AS ReferenceDocumentContext,
  awref AS ReferenceDocument
FROM gmbdgtheader
LEFT OUTER JOIN I_GteeMBudgetEntryDocType AS _BudgetDocType ON GteeMBudgetEntryDocumentType = _BudgetDocType.GteeMBudgetEntryDocumentType  -- association [0..1]
LEFT OUTER JOIN I_GranteeMgmtBudgetingProcess AS _BudgetingProcess ON GranteeMgmtBudgetingProcess = _BudgetingProcess.GranteeMgmtBudgetingProcess  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GrantCurrency ON GrantCurrency = _GrantCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ControllingVersion AS _BudgetVersion ON GranteeMgmtBudgetVersion = _BudgetVersion.ControllingVersion  -- association [0..1]
LEFT OUTER JOIN I_GranteeMgmtBudgetReason AS _BudgetReason ON GranteeMgmtBudgetReason = _BudgetReason.GranteeMgmtBudgetReason  -- association [0..1]
LEFT OUTER JOIN I_ControllingVersion AS _BudgetVersionOrigin ON GranteeMgmtBudgetVersionOrigin = _BudgetVersionOrigin.ControllingVersion  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_GranteeMgmtBudgetStatus AS _BudgetStatus ON GranteeMgmtBudgetStatus = _BudgetStatus.GranteeMgmtBudgetStatus  -- association [0..1]
LEFT OUTER JOIN I_GteeMBdgtEntryDocStatus AS _BudgetEntryDocumentStatus ON GteeMBudgetEntryDocStatus = _BudgetEntryDocumentStatus.GteeMBudgetEntryDocStatus  -- association [0..1]
LEFT OUTER JOIN I_GteeMBdgtEntrDocRvslSts AS _BdgtEntryDocRvslStatus ON GteeMBdgtEntryDocRvslStatus = _BdgtEntryDocRvslStatus.GteeMBdgtEntryDocRvslStatus  -- association [0..1]
LEFT OUTER JOIN I_GteeMBudgetEntryDocumentItem AS _Item ON GranteeMgmtBudgetEntryDocument = _Item.GranteeMgmtBudgetEntryDocument  -- association [0..*]
;