C_FundsCenter_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_FundsCenter_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.
-- SQL view name: CFCOBJP

CREATE VIEW C_FundsCenter_ObjP AS
SELECT
  I_FundsCenter.FinancialManagementArea AS FinancialManagementArea,
  I_FundsCenter.FundsCenter AS FundsCenter,
  I_FundsCenter.ValidityEndDate AS ValidityEndDate,
  I_FundsCenter.CreatedByUser AS CreatedByUser,
  I_FundsCenter.CreationDate AS CreationDate,
  I_FundsCenter.LastChangeUser AS LastChangeUser,
  I_FundsCenter.LastChangeDate AS LastChangeDate,
  I_FundsCenter.FundsCenterExpirationDate AS FundsCenterExpirationDate,
  I_FundsCenter.ValidityStartDate AS ValidityStartDate,
  I_FundsCenter.FundsCenterResponsible AS FundsCenterResponsible,
  I_FundsCenter.FundsCenterResponsibleName AS FundsCenterResponsibleName,
  I_FundsCenter.FundsCenterAuthznGrp AS FundsCenterAuthznGrp,
  I_FundsCenter.FundsCenterDefaultFund AS FundsCenterDefaultFund,
  I_FundsCenter._Fund._Text[1:Language=$session.system_language].FundName AS FundName,
  cast( concat_with_space(FundsCenterDefaultFund, _Fund._Text[1:Language = $session.system_language].FundName, 1) as fmis_fundextendedname) AS FundExtendedName,
  I_FundsCenter.CompanyCode AS CompanyCode,
  I_FundsCenter._CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast( concat_with_space(_CompanyCode.CompanyCode, _CompanyCode.CompanyCodeName, 1) as fmis_companycodeextendedname ) AS CompanyCodeExtendedName,
  I_FundsCenter.BusinessArea AS BusinessArea,
  I_FundsCenter._BusinessArea._Text[1:Language=$session.system_language].BusinessAreaName AS BusinessAreaName,
  cast( concat_with_space(BusinessArea, _BusinessArea._Text[1:Language=$session.system_language].BusinessAreaName, 1) as fmis_busareaextendedname ) AS BusinessAreaExtendedName,
  I_FundsCenter.ProfitCenter AS ProfitCenter,
  I_FundsCenter._ProfitCenter._Text[1:Language=$session.system_language].ProfitCenterName AS ProfitCenterName,
  I_FundsCenter._FinMgmtArea._Text[1:Language=$session.system_language].FinancialManagementAreaName AS FinancialManagementAreaName,
  cast( concat_with_space(FinancialManagementArea, _FinMgmtArea._Text[1:Language = $session.system_language].FinancialManagementAreaName, 1) as fmis_fmaextendedname ) AS FinMgmtAreaExtendedName,
  _Text[1:Language=$session.system_language].FundsCenterName AS FundsCenterName,
  _Text[1:Language=$session.system_language].FundsCenterDescription AS FundsCenterDescription,
  I_FundsCenter.FndsCenterFinMgmtAreaForAuthzn AS FndsCenterFinMgmtAreaForAuthzn
FROM I_FundsCenter
LEFT OUTER JOIN C_CommitmentItemWST AS _CommitmentItem ON FundsCenter = _CommitmentItem.CmtmtItmDefaultFundsCenter AND FinancialManagementArea = _CommitmentItem.FinancialManagementArea  -- association [0..*]
LEFT OUTER JOIN C_BudDocItemForObjP AS _BudgetEntryDocument ON FinancialManagementArea = _BudgetEntryDocument.FinancialManagementArea AND FundsCenter = _BudgetEntryDocument.BudgetedFundsCenter  -- association [0..*]
LEFT OUTER JOIN C_EarmarkedFundsItemForObjP AS _EarmarkedFundsItem ON FinancialManagementArea = _EarmarkedFundsItem.FinancialManagementArea AND FundsCenter = _EarmarkedFundsItem.FundsCenter  -- association [0..*]
LEFT OUTER JOIN C_PurchaseOrderByFMAA AS _PurchaseOrder ON FinancialManagementArea = _PurchaseOrder.FinancialManagementArea AND FundsCenter = _PurchaseOrder.PostedFundsCenter  -- association [0..*]
LEFT OUTER JOIN C_PurchaseRequisitionByFMAA AS _PurchaseRequisition ON FinancialManagementArea = _PurchaseRequisition.FinancialManagementArea AND FundsCenter = _PurchaseRequisition.PostedFundsCenter  -- association [0..*]
LEFT OUTER JOIN C_JrnlEntrItmByLeadingLdgr_FM AS _AccountingLine ON FinancialManagementArea = _AccountingLine.FinancialManagementArea AND _AccountingLine.IsLeadingLedger = 'X' AND FundsCenter = _AccountingLine.FundsCenter  -- association [0..*]
LEFT OUTER JOIN C_FixedAssetsForFundsMgmt AS _FixedAsset ON FinancialManagementArea = _FixedAsset.FinancialManagementArea AND FundsCenter = _FixedAsset.FundsCenter  -- association [0..*]
LEFT OUTER JOIN C_Setleafforfundscenterobjp AS _Sets ON _Sets.SetClass = '0312' AND FinancialManagementArea = _Sets.SetSubClass AND FundsCenter = _Sets.FundsCenter  -- association [0..*]
;