I_BudgetEntryDocumentBasic

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_BudgetEntryDocumentBasic.
-- 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: IFMBDGTDOCBASIC

CREATE VIEW I_BudgetEntryDocumentBasic AS
SELECT
  fm_area AS FinancialManagementArea,
  docyear AS BudgetDocumentYear,
  docnr AS BudgetEntryDocument,
  docfam AS BudgetEntryDocumentFamily,
  techorg AS OriginalBudgetingApplication,
  process_ui AS BudgetingProcess,
  version AS BudgetVersion,
  crtuser AS CreatedByUser,
  crtdate AS CreationDate,
  crttime AS CreationTime,
  chguser AS LastChangedByUser,
  chgdate AS LastChangeDate,
  chgtime AS LastChangeTime,
  docdate AS BudgetEntryDocumentDate,
  postdate AS PostingDate,
  reason_rev AS ReversalReason,
  resppers AS BudgetingResponsiblePersonName,
  text50 AS BudgetEntryDocumentDescription,
  docstate AS BudgetEntryDocumentStatus,
  revstate AS BdgtEntryDocReversalStatus,
  rev_refnr AS ReversalRefBudgetEntryDocument,
  doctype AS BudgetEntryDocumentType,
  logsys AS LogicalSystem,
  cohort AS FiscalTreasuryLoanCohort,
  publaw AS PublicLaw,
  legis AS FiscalTreasuryLegislationType,
  transfer_agency AS FiscalTreasuryAgency,
  transfer_account AS FiscalTreasuryBudgetAccount,
  rcomp AS PartnerCompany,
  awtyp AS ReferenceDocumentType,
  awsys AS ReferenceDocumentLogicalSystem,
  aworg AS ReferenceDocumentContext,
  awref AS ReferenceDocument,
  awkey AS OriginalReferenceDocument,
  xblnr AS AutomaticBdgtPostingReference,
  pfm_foa AS BudgetAmendmentForm,
  pfm_spec AS BdgtAmendmentFormSpecification,
  fmfgus_key AS USFedGovernmentUUID,
  _USFedGovernmentUUID.USFedTrdgPartSubLevelPrefix AS USFedTrdgPartSubLevelPrefix,
  _USFedGovernmentUUID.USFedTradingPartnerAgency AS USFedTradingPartnerAgency,
  _USFedGovernmentUUID.USFedAllocTransfAgencyTrdgPart AS USFedAllocTransfAgencyTrdgPart,
  _USFedGovernmentUUID.USFedTrdgPartBeginPerdOfAvaily AS USFedTrdgPartBeginPerdOfAvaily,
  _USFedGovernmentUUID.USFedTrdgPartEndPerdOfAvaily AS USFedTrdgPartEndPerdOfAvaily,
  _USFedGovernmentUUID.USFedTrdgPartAvailabilityType AS USFedTrdgPartAvailabilityType,
  _USFedGovernmentUUID.USFedTrdgPartMainAccount AS USFedTrdgPartMainAccount,
  _USFedGovernmentUUID.USFedTrdgPartSubAccount AS USFedTrdgPartSubAccount,
  _USFedGovernmentUUID.USFedTrdgPartBusEventTypeCode AS USFedTrdgPartBusEventTypeCode
FROM fmbh
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_OriginalBudgetingApplication AS _OriginalBudgetingApplication ON OriginalBudgetingApplication = _OriginalBudgetingApplication.OriginalBudgetingApplication  -- association [0..1]
LEFT OUTER JOIN I_BudgetingProcess AS _BudgetingProcess ON BudgetingProcess = _BudgetingProcess.BudgetingProcess  -- association [0..1]
LEFT OUTER JOIN I_BudgetEntryDocumentType AS _BudgetEntryDocumentType ON BudgetEntryDocumentType = _BudgetEntryDocumentType.BudgetEntryDocumentType  -- association [0..1]
LEFT OUTER JOIN I_BudgetEntryDocumentStatus AS _BudgetEntryDocumentStatus ON BudgetEntryDocumentStatus = _BudgetEntryDocumentStatus.BudgetEntryDocumentStatus  -- association [1..1]
LEFT OUTER JOIN I_BdgtEntryDocReversalStatus AS _BdgtEntryDocReversalStatus ON BdgtEntryDocReversalStatus = _BdgtEntryDocReversalStatus.BdgtEntryDocReversalStatus  -- association [1..1]
LEFT OUTER JOIN I_ControllingVersion AS _BudgetVersion ON BudgetVersion = _BudgetVersion.ControllingVersion  -- association [1..1]
LEFT OUTER JOIN I_BudgetAmendmentForm AS _BudgetAmendmentForm ON BudgetAmendmentForm = _BudgetAmendmentForm.BudgetAmendmentForm  -- association [1..1]
LEFT OUTER JOIN I_BdgtAmendmentSpec AS _BudgetAmendmentSpec ON BdgtAmendmentFormSpecification = _BudgetAmendmentSpec.BdgtAmendmentFormSpecification  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN E_BudgetEntryDocument AS _Extension ON BudgetEntryDocument = _Extension.BudgetEntryDocument AND FinancialManagementArea = _Extension.FinancialManagementArea AND BudgetDocumentYear = _Extension.BudgetDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND BudgetDocumentYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_USFedGovernmentUUID AS _USFedGovernmentUUID ON USFedGovernmentUUID = _USFedGovernmentUUID.USFedGovernmentUUID  -- association [0..1]
LEFT OUTER JOIN I_USFedTrdgPartSubPrefixText AS _USFedTrdgPartSubPrefixText ON USFedTrdgPartSubLevelPrefix = _USFedTrdgPartSubPrefixText.USFedTrdgPartSubLevelPrefix  -- association [0..*]
LEFT OUTER JOIN I_USFedTradingPartnerAgcyText AS _USFedTradingPartnerAgcyText ON USFedTradingPartnerAgency = _USFedTradingPartnerAgcyText.USFedTradingPartnerAgency  -- association [0..*]
LEFT OUTER JOIN I_USFedAllocTransfTrdgPartText AS _USFedAllocTransfTrdgPartText ON USFedAllocTransfAgencyTrdgPart = _USFedAllocTransfTrdgPartText.USFedAllocTransfAgencyTrdgPart  -- association [0..*]
LEFT OUTER JOIN I_USFedTrdgPartAvailyText AS _USFedTrdgPartAvailyText ON USFedTrdgPartAvailabilityType = _USFedTrdgPartAvailyText.USFedTrdgPartAvailabilityType  -- association [0..*]
LEFT OUTER JOIN I_USFedTrdgPartMainAccountText AS _USFedTrdgPartMainAccountText ON USFedTrdgPartMainAccount = _USFedTrdgPartMainAccountText.USFedTrdgPartMainAccount  -- association [0..*]
LEFT OUTER JOIN I_USFedTrdgPartSubAccountText AS _USFedTrdgPartSubAccountText ON USFedTrdgPartSubAccount = _USFedTrdgPartSubAccountText.USFedTrdgPartSubAccount  -- association [0..*]
LEFT OUTER JOIN I_USFedTrdgPartBusEvtTypeText AS _USFedTrdgPartBusEvtTypeText ON USFedTrdgPartBusEventTypeCode = _USFedTrdgPartBusEvtTypeText.USFedTrdgPartBusEventTypeCode  -- association [0..*]
;