I_DocBsdRevenuesIncrBdgtBasic

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_DocBsdRevenuesIncrBdgtBasic.
-- 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: IDOCBSDRBA

CREATE VIEW I_DocBsdRevenuesIncrBdgtBasic AS
SELECT
  cast( reqtsn as fmis_request_tsn preserving type) AS FundsManagementReqTransSqnc,
  cast( datapakid as fmis_co_data_packet preserving type) AS FundsManagementDataPacket,
  cast( record as fmis_co_entry_item preserving type) AS FundsManagementEntryItem,
  FinancialManagementArea,
  BudgetCategory,
  fiscalyear AS FinMgmtAreaFiscalYear,
  fundsmanagementvaluetype AS FundsMgmtValueType,
  refbn AS ReferenceDocument,
  refbt AS FundsMgmtRefDocumentCategory,
  rforg AS ReferenceDocumentContext,
  cast( concat('0', rfpos) as fins_awitem ) AS ReferenceDocumentItem,
  rfknt AS RefDocAccountAssignment,
  cast( concat('0', rfete) as cc_rftrm ) AS ReferenceDocumentScheduleLine,
  rcond AS RefDocPricingElementContent,
  rftyp AS ReferenceDocumentType,
  cast( rfsys as fis_awsys preserving type ) AS ReferenceDocumentLogicalSystem,
  CompanyCode,
  kngjahr AS FundsMgmtFinDocFiscalYear,
  knbelnr AS FundsMgmtFinDocNumber,
  knbuzei AS FundsMgmtFinDocItem,
  AutomaticBdgtPostingReference,
  cast(revenuesfund as fmis_snd_revposted_fund preserving type ) AS SenderRevnPostedFund,
  cast(revenuesbudgetperiod as fmis_snd_revposted_budgetperio preserving type ) AS SenderRevnPostedBudgetPeriod,
  cast(revenuesfundscenter as fmis_snd_revposted_fundscenter preserving type ) AS SenderRevnPostedFundsCenter,
  cast(revenuescommitmentitem as fmis_snd_revposted_cmtmt_item preserving type ) AS SenderRevnPostdCommitmentItem,
  cast(revenuesfunctionalarea as fmis_snd_revposted_funcarea preserving type ) AS SenderRevnPostedFuncArea,
  cast(revenuesgrantid as fmis_snd_revposted_grant preserving type ) AS SenderRevnPostedGrantID,
  cast(revenuesfundedprogram as fmis_snd_revposted_fundedprog preserving type ) AS SenderRevnPostedFundedProgram,
  cast(revenuesfundsmgmtcustomerfield as fmis_snd_revposted_userdim preserving type ) AS SndrRevnPostdFundsMgmtCustFld,
  cast(budgetedfund as fmis_rcv_expbdgted_fund preserving type ) AS RcvrExpnBudgetedFund,
  cast(budgetedbudgetperiod as fmis_rcv_expbdgted_budgetperio preserving type ) AS RcvrExpnBudgetedBudgetPeriod,
  cast(budgetedfundscenter as fmis_rcv_expbdgted_fundscenter preserving type ) AS RcvrExpnBudgetedFundsCenter,
  cast(budgetedcommitmentitem as fmis_rcv_expbdgted_cmtmt_item preserving type ) AS RcvrExpnBudgetedCommitmentItem,
  cast(budgetedgrantid as fmis_rcv_expbdgted_grant_nbr preserving type ) AS RcvrExpnBudgetedGrantID,
  cast(budgetedfundedprogram as fmis_rcv_expbdgted_fundedprogr preserving type ) AS RcvrExpnBudgetedFundedProgram,
  cast(budgetedfunctionalarea as fmis_rcv_expbdgted_funcarea preserving type ) AS RcvrExpnBudgetedFunctionalArea,
  cast(budgetedfundsmgmtcustomerfield as fmis_rcv_expbdgted_userdim preserving type ) AS RcvrExpnBdgtFndsMgmtCustFld,
  BudgetEntryDocument,
  BudgetDocumentYear,
  twaer AS TransactionCurrency,
  trbtr AS PostedAmountInTransCrcy,
  _FinMgmtArea.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  fkbtr AS PostedAmountInFMACrcy,
  isrevenuesincreasingbudgetdone AS RevenuesIncreasingBudgetIsDone,
  IsStatisticalItem,
  documentisnotrelevantforrib AS DocIsNotRlvtForRevnIncrBdgt,
  _FiscalYearForFinMgmtArea.CommitmentItemFiscalYear AS CommitmentItemFiscalYear,
  cast( substring(reqtsn, 1, 8) as fmis_rib_creationdate ) AS RevnIncreasingBdgtCreationDate,
  cast( substring(reqtsn, 9, 6) as fmis_rib_creationtime ) AS RevnIncreasingBdgtCreationTime
FROM fmribdocp
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON RcvrExpnBudgetedBudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND RcvrExpnBudgetedFund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON FinancialManagementArea = _CommitmentItem.FinancialManagementArea AND RcvrExpnBudgetedCommitmentItem = _CommitmentItem.CommitmentItem AND CommitmentItemFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON RcvrExpnBudgetedGrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND RcvrExpnBudgetedFundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _FunctionalArea ON RcvrExpnBudgetedFunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND RcvrExpnBudgetedFundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_FundsCenter AS _CurrentFundsCenter ON FinancialManagementArea = _CurrentFundsCenter.FinancialManagementArea AND RcvrExpnBudgetedFundsCenter = _CurrentFundsCenter.FundsCenter AND _CurrentFundsCenter.ValidityEndDate >= $session.system_date AND _CurrentFundsCenter.ValidityStartDate <= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON financialmanagementareacrcy = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON ReferenceDocumentLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
;