C_BudgetEntryDocumentTP

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_BudgetEntryDocumentTP.
-- 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: CBDGTENTRYDOCTP

CREATE VIEW C_BudgetEntryDocumentTP AS
SELECT
  BudgetEntryDocumentWithDraft.FinancialManagementArea AS FinancialManagementArea,
  BudgetEntryDocumentWithDraft.BudgetDocumentYear AS BudgetDocumentYear,
  BudgetEntryDocumentWithDraft.BudgetEntryDocument AS BudgetEntryDocument,
  BudgetEntryDocumentWithDraft.BudgetEntryDocumentStatus AS BudgetEntryDocumentStatus,
  BudgetEntryDocumentWithDraft.FinancialManagementAreaForEdit AS FinancialManagementAreaForEdit,
  BudgetEntryDocumentWithDraft.BudgetDocYearForEdit AS BudgetDocYearForEdit,
  BudgetEntryDocumentWithDraft.BudgetEntryDocForEdit AS BudgetEntryDocForEdit,
  BudgetEntryDocumentWithDraft.BudgetEntryDocumentType AS BudgetEntryDocumentType,
  BudgetEntryDocumentWithDraft.BudgetVersion AS BudgetVersion,
  BudgetEntryDocumentWithDraft.PostingDate AS PostingDate,
  BudgetEntryDocumentWithDraft.DocumentDate AS DocumentDate,
  BudgetEntryDocumentWithDraft.LastChangedByUser AS LastChangedByUser,
  BudgetEntryDocumentWithDraft.CreationDate AS CreationDate,
  BudgetEntryDocumentWithDraft.CreationTime AS CreationTime,
  BudgetEntryDocumentWithDraft.CreationDateTime AS CreationDateTime,
  BudgetEntryDocumentWithDraft.LastChangeDate AS LastChangedDate,
  BudgetEntryDocumentWithDraft.CreatedByUser AS CreatedByUser,
  BudgetEntryDocumentWithDraft.BudgetingProcess AS BudgetingProcess,
  BudgetEntryDocumentWithDraft.BudgetAmendmentForm AS BudgetAmendmentForm,
  BudgetEntryDocumentWithDraft.BdgtAmendmentFormSpecification AS BdgtAmendmentFormSpecification,
  BudgetEntryDocumentWithDraft.USFedTrdgPartSubLevelPrefix AS USFedTrdgPartSubLevelPrefix,
  BudgetEntryDocumentWithDraft.USFedTradingPartnerAgency AS USFedTradingPartnerAgency,
  BudgetEntryDocumentWithDraft.USFedAllocTransfAgencyTrdgPart AS USFedAllocTransfAgencyTrdgPart,
  BudgetEntryDocumentWithDraft.USFedTrdgPartBeginPerdOfAvaily AS USFedTrdgPartBeginPerdOfAvaily,
  BudgetEntryDocumentWithDraft.USFedTrdgPartEndPerdOfAvaily AS USFedTrdgPartEndPerdOfAvaily,
  BudgetEntryDocumentWithDraft.USFedTrdgPartAvailabilityType AS USFedTrdgPartAvailabilityType,
  BudgetEntryDocumentWithDraft.USFedTrdgPartMainAccount AS USFedTrdgPartMainAccount,
  BudgetEntryDocumentWithDraft.USFedTrdgPartSubAccount AS USFedTrdgPartSubAccount,
  BudgetEntryDocumentWithDraft.USFedTrdgPartBusEventTypeCode AS USFedTrdgPartBusEventTypeCode,
  BudgetEntryDocumentWithDraft.FiscalTreasuryLoanCohort AS FiscalTreasuryLoanCohort,
  BudgetEntryDocumentWithDraft.PublicLaw AS PublicLaw,
  BudgetEntryDocumentWithDraft.FiscalTreasuryAgency AS FiscalTreasuryAgency,
  BudgetEntryDocumentWithDraft.FiscalTreasuryBudgetAccount AS FiscalTreasuryBudgetAccount,
  BudgetEntryDocumentWithDraft.PartnerCompany AS PartnerCompany,
  BudgetEntryDocumentWithDraft.FiscalTreasuryLegislationType AS FiscalTreasuryLegislationType,
  BudgetEntryDocumentWithDraft.BudgetEntryDocumentDescription AS BudgetEntryDocumentDescription,
  BudgetEntryDocumentWithDraft.BudgetingResponsiblePersonName AS BudgetingResponsiblePersonName,
  BudgetEntryDocumentWithDraft.ReversalRefBudgetEntryDocument AS ReversalRefBudgetEntryDocument,
  BudgetEntryDocumentWithDraft.BdgtEntryDocReversalStatus AS BdgtEntryDocReversalStatus,
  BudgetEntryDocumentWithDraft.ReversalReason AS ReversalReason,
  BudgetEntryDocumentWithDraft.BdgtEntryDocTitle AS BdgtEntryDocTitle
FROM I_BudgetEntryDocTP AS BudgetEntryDocumentWithDraft
LEFT OUTER JOIN C_BudgetEntryDocItemPayTP AS _Items ON BudgetEntryDocument = _Items.BudgetEntryDocument AND FinancialManagementArea = _Items.FinancialManagementArea AND BudgetDocumentYear = _Items.BudgetDocumentYear  -- association [0..*]
LEFT OUTER JOIN C_BudgetEntryDocItemCmtmtTP AS _Items9G ON BudgetEntryDocument = _Items9G.BudgetEntryDocument AND FinancialManagementArea = _Items9G.FinancialManagementArea AND BudgetDocumentYear = _Items9G.BudgetDocumentYear  -- association [0..*]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtAreaForEdit ON FinancialManagementAreaForEdit = _FinMgmtAreaForEdit.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_BudgetEntryDocumentType AS _BudgetEntryDocumentType ON BudgetEntryDocumentType = _BudgetEntryDocumentType.BudgetEntryDocumentType  -- association [0..1]
LEFT OUTER JOIN I_BudgetingProcess AS _BudgetingProcess ON BudgetingProcess = _BudgetingProcess.BudgetingProcess  -- association [0..1]
LEFT OUTER JOIN I_BudgetEntryDocumentStatusD AS _OverallStatus ON BudgetEntryDocumentStatus = _OverallStatus.BudgetEntryDocumentStatus  -- association [0..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_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..*]
;