I_REContrOrglAssgmtTerm

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_REContrOrglAssgmtTerm.
-- 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: IREORGASSTERM

CREATE VIEW I_REContrOrglAssgmtTerm AS
SELECT
  intreno AS InternalRealEstateNumber,
  termtype AS RETermType,
  termno AS RETermNumber,
  cast(validfrom as rebdvdmvalidfrom preserving type ) AS ValidityStartDate,
  cast(validto as rebdvdmvalidto preserving type ) AS ValidityEndDate,
  gsber AS BusinessArea,
  prctr AS ProfitCenter,
  cast(addobjnr as retmvdmraaddobjnr preserving type ) AS REStatusObject,
  txjcd AS TaxJurisdiction,
  cast(fund as bp_geber) AS Fund,
  cast(fundscenter as fm_fictr) AS FundsCenter,
  cast( commitmentitem as fm_fipex preserving type ) AS CommitmentItem,
  cast(functionalarea as fm_farea) AS FunctionalArea,
  cast(grantnumber as reravdmgrantnumber preserving type ) AS REFundsManagementGrantID,
  cast(budgetperiod as fm_budget_period) AS BudgetPeriod,
  _REKeyAssgmt.RealEstateObjectType AS RealEstateObjectType,
  _REKeyAssgmt._CompanyCode.ControllingArea AS ControllingArea,
  _REKeyAssgmt._CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  _REKeyAssgmt._CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  _REKeyAssgmt._CompanyCode.CompanyCode AS CompanyCode,
  _REKeyAssgmt._REObjectType AS _REObjectType
FROM vitmoa AS _REOrganizationalAssgmtTerm
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REContract AS _REContract ON InternalRealEstateNumber = _REContract.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_RETermType AS _RETermType ON RETermType = _RETermType.RETermType AND RealEstateObjectType = _RETermType.RealEstateObjectType  -- association [1..1]
LEFT OUTER JOIN I_RETerm AS _RETerm ON InternalRealEstateNumber = _RETerm.InternalRealEstateNumber AND RETermType = _RETerm.RETermType AND RETermNumber = _RETerm.RETermNumber  -- association [1..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea AND _ProfitCenter.ValidityEndDate >= $session.system_date AND _ProfitCenter.ValidityStartDate <= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction AND TaxCalculationProcedure = _TaxJurisdiction.TaxJurisdictionCalcProcedure  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisCalcProcedure AS _TaxJurisdictionCalcProcedure ON TaxCalculationProcedure = _TaxJurisdictionCalcProcedure.TaxJurisdictionCalcProcedure  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON Fund = _Fund.Fund AND FinancialManagementArea = _Fund.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FundsCenter = _FundsCenter.FundsCenter AND FinancialManagementArea = _FundsCenter.FinancialManagementArea  -- association [0..*]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON CommitmentItem = _CommitmentItem.CommitmentItem AND FinancialManagementArea = _CommitmentItem.FinancialManagementArea  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON REFundsManagementGrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [0..1]
;