R_BudgetDocumentTP

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 R_BudgetDocumentTP.
-- 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 R_BudgetDocumentTP AS
SELECT
  BudgetDocument,
  BudgetDocumentYear,
  ControllingArea,
  cast( concat( concat( substring( concat( ControllingArea, ' '), 1, 4), BudgetDocumentYear ), ltrim( BudgetDocument , '0' ) ) as abap.char(90)) AS MaintWorkRequestAttchKey,
  cast('BudgetDocument' as abap.char(30)) AS SAPObjectNodeType,
  ControllingArea AS ControllingAreaForEdit,
  BudgetDocumentYear AS BudgetDocumentYearForEdit,
  BudgetDocument AS BudgetDocumentForEdit,
  BudgetDocumentType,
  BudgetCategoryUsage,
  BudgetProcessGroup,
  PlanningCategory,
  GrantID,
  GrantExternalBudgetIsActive,
  PostingDate,
  DocumentDate,
  BudgetingResponsiblePersonName,
  BudgetDocumentStatus,
  BudgetDocumentDescription,
  ReversalRefBudgetDocument,
  ReversalReason,
  I_BudgetDocumentBasic.CreatedByUser AS CreatedByUser,
  I_BudgetDocumentBasic.CreationDate AS CreationDate,
  I_BudgetDocumentBasic.CreationTime AS CreationTime,
  I_BudgetDocumentBasic.LastChangedByUser AS LastChangedByUser,
  I_BudgetDocumentBasic.LastChangeDate AS LastChangeDate,
  I_BudgetDocumentBasic.LastChangeTime AS LastChangeTime,
  _BudgetAmount.GlobalCurrency AS GlobalCurrency,
  _BudgetAmount.SenderBudgetTotalAmount AS SenderBudgetTotalAmount,
  _BudgetAmount.ReceiverBudgetTotalAmount AS ReceiverBudgetTotalAmount,
  _BudgetAmount.ReceiverBudgetTotalAmount - _BudgetAmount.SenderBudgetTotalAmount AS BudgetTotalAmount
FROM I_BudgetDocumentBasic
LEFT OUTER JOIN R_BudgetDocumentTP AS _BudgetDocument ON ReversalRefBudgetDocument = _BudgetDocument.BudgetDocument AND BudgetDocumentYear = _BudgetDocument.BudgetDocumentYear AND ControllingArea = _BudgetDocument.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaForEdit ON ControllingAreaForEdit = _ControllingAreaForEdit.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [1..1]
LEFT OUTER JOIN I_BudgetDocumentTotalAmount AS _BudgetAmount ON ControllingArea = _BudgetAmount.ControllingArea AND BudgetDocumentYear = _BudgetAmount.BudgetDocumentYear AND BudgetDocument = _BudgetAmount.BudgetDocument  -- association [1..1]
LEFT OUTER JOIN I_HDMRelationTP AS _HDMRelation ON MaintWorkRequestAttchKey = _HDMRelation.LinkedSAPObjectKey AND SAPObjectNodeType = _HDMRelation.SAPObjectNodeType  -- association [0..*]
LEFT OUTER JOIN R_BudgetDocumentSenderTP AS _BudgetDocumentItemSndr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_BudgetDocumentReceiverTP AS _BudgetDocumentItemRcvr ON /* condition not available in parsed metadata */  -- association [0..*]
;