C_EarmarkedFunds_ObjP

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_EarmarkedFunds_ObjP.
-- 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 C_EarmarkedFunds_ObjP AS
SELECT
  cast( EarmarkedFundsDocument as kblnr_dy preserving type ) AS EarmarkedFundsDocument,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  FinancialManagementArea,
  ControllingArea,
  TransactionCurrency,
  CompanyCodeCurrency,
  EarmarkedFundsDocumentType,
  _EarmarkedFundsDocTypeText.EarmarkedFundsDocTypeText AS EarmarkedFundsDocTypeText,
  EarmarkedFundsDocReference,
  EarmarkedFundsDocReference2,
  EarmarkedFundsDocReference3,
  EarmarkedFundsHeaderText,
  EarmarkedFundsHasLongText,
  PostingDate,
  DocumentDate,
  EarmarkedFundsDocumentCategory,
  _EarmarkedFundsDocCatText.EarmarkedFundsDocCategoryText AS EarmarkedFundsDocCategoryText,
  ReferenceDocument,
  ReferenceDocumentType,
  _ReferenceDocumentTypeText.ReferenceDocumentTypeName AS ReferenceDocumentTypeName,
  ReferenceDocumentContext,
  ReferenceDocumentLogicalSystem,
  EarmarkedFundsDocEntryStatus,
  EarmarkedFundsStartWorkflow,
  EarmarkedFundsIsCompleted,
  EmrkdFndsIsMarkedForArchiving,
  EmrkdFndsIsBlockedAgainstUsage,
  EmrkdFndsDocCreatedByUser,
  EmrkdFndsDocCreationDate,
  EmrkdFndsDocLastChangedByUser,
  EmrkdFndsDocLastChangeDate,
  _EarmarkedFundsDocTotals.EmrkdFndsTotalInCCCrcy AS EmrkdFndsTotalInCCCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsTotalInTransCrcy AS EmrkdFndsTotalInTransCrcy,
  cast(_EarmarkedFundsDocTotals.EmrkdFndsRelTotalInCCCrcy as fmis_efd_amtflwapprincccrcy preserving type ) AS EmrkdFndsRelTotalInCCCrcy,
  cast(_EarmarkedFundsDocTotals.EmrkdFndsRelTotalInTransCrcy as fmis_efd_amtflwapprintrancrcy preserving type ) AS EmrkdFndsRelTotalInTransCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsOpenTotalInCCCrcy AS EmrkdFndsOpenTotalInCCCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsOpenTotalInTransCrcy AS EmrkdFndsOpenTotalInTransCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsChgdTotalInCCCrcy AS EmrkdFndsChgdTotalInCCCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsChgdTotalInTransCrcy AS EmrkdFndsChgdTotalInTransCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsCnsmdTotalInCCCrcy AS EmrkdFndsCnsmdTotalInCCCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsCnsmdTotalInTransCrcy AS EmrkdFndsCnsmdTotalInTransCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsOriglTotalInCCCrcy AS EmrkdFndsOriglTotalInCCCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsOriglTotalInTransCrcy AS EmrkdFndsOriglTotalInTransCrcy
FROM I_EarmarkedFundsDocument
LEFT OUTER JOIN I_EarmarkedFundsDocTotals AS _EarmarkedFundsDocTotals ON EarmarkedFundsDocument = _EarmarkedFundsDocTotals.EarmarkedFundsDocument  -- association [0..1]
LEFT OUTER JOIN C_EarmarkedFundsPredecessorDoc AS _EarmarkedFundsPredecessor ON EarmarkedFundsDocument = _EarmarkedFundsPredecessor.EarmarkedFundsDocument  -- association [0..*]
LEFT OUTER JOIN C_EarmarkedFundssucessorDoc AS _EarmarkedFundsSuccessor ON EarmarkedFundsDocument = _EarmarkedFundsSuccessor.EmrkdFndsItmPredecessor  -- association [0..*]
LEFT OUTER JOIN C_EarmarkedFundsJournal AS _AccountingJournal ON EarmarkedFundsDocument = _AccountingJournal.EarmarkedFundsDocument  -- association [0..*]
LEFT OUTER JOIN C_BudgetaryDocumentForObjP AS _BudgetaryDocument ON EarmarkedFundsDocument = _BudgetaryDocument.OriginalReferenceDocument AND _BudgetaryDocument.ReferenceDocumentType = 'FMRES'  -- association [0..*]
LEFT OUTER JOIN C_EmrkdFndsItmForObjPWST AS _EarmarkedFundsItem ON EarmarkedFundsDocument = _EarmarkedFundsItem.EarmarkedFundsDocument  -- association [0..*]
LEFT OUTER JOIN C_FiscalYearChangeDocumentWST AS _FiscalYearChange ON EarmarkedFundsDocument = _FiscalYearChange.ReferenceDocument AND FinancialManagementArea = _FiscalYearChange.FinancialManagementArea  -- association [0..*]
LEFT OUTER JOIN I_ReferenceDocumentTypeText AS _ReferenceDocumentTypeText ON ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType AND _ReferenceDocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFunds_DocCatText AS _EarmarkedFundsDocCatText ON EarmarkedFundsDocumentCategory = _EarmarkedFundsDocCatText.EarmarkedFundsDocumentCategory AND _EarmarkedFundsDocCatText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFunds_DocTypeText AS _EarmarkedFundsDocTypeText ON EarmarkedFundsDocumentCategory = _EarmarkedFundsDocTypeText.EarmarkedFundsDocumentCategory AND EarmarkedFundsDocumentType = _EarmarkedFundsDocTypeText.EarmarkedFundsDocumentType AND _EarmarkedFundsDocTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_PurchaseOrderByFMAA AS _PurchaseOrder ON EarmarkedFundsDocument = _PurchaseOrder.EarmarkedFundsDocument AND FinancialManagementArea = _PurchaseOrder.FinancialManagementArea  -- association [0..*]
LEFT OUTER JOIN C_PurchaseRequisitionByFMAA AS _PurchaseRequisition ON EarmarkedFundsDocument = _PurchaseRequisition.EarmarkedFundsDocument AND FinancialManagementArea = _PurchaseRequisition.FinancialManagementArea  -- association [0..*]
LEFT OUTER JOIN C_EmrkdFndsBsdRevnIncrBdgtDoc AS _EmrkdFndsBsdRevnIncrBdgtDoc ON EarmarkedFundsDocument = _EmrkdFndsBsdRevnIncrBdgtDoc.EarmarkedFundsDocument  -- association [0..*]
LEFT OUTER JOIN C_EmrkdFndsBsdRevnIncrBdgt AS _EmrkdFndsBsdRevnIncrBdgt ON EarmarkedFundsDocument = _EmrkdFndsBsdRevnIncrBdgt.EarmarkedFundsDocument  -- association [0..1]
;