I_RESettlmtApportionmentFactor

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_RESettlmtApportionmentFactor.
-- 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 I_RESettlmtApportionmentFactor AS
SELECT
  apportfactorguid AS RESettlementApprtmtFactorUUID,
  lineitemtype AS RESettlementLineItemType,
  settlementprocessuuid AS RESettlementProcessUUID,
  settlementuuid AS RESettlementUUID,
  settlperiodguid AS RESettlementRulePeriodUUID,
  servicegroupuuid_source AS REServiceGroupUUID,
  architectureobjectuuid AS REArchitectureObjectUUID,
  servicegroupuuid_target AS REServiceGroupTargetUUID,
  rentableobjectuuid AS RealEstateRentableObjectUUID,
  intreno_cn AS REContractIntRealEstateNumber,
  isoccupied AS RERentableObjectIsOccupied,
  costcategory AS RECostCategory,
  participtype AS REParticipationType,
  validfrom AS ValidityStartDate,
  validto AS ValidityEndDate,
  totalsettlementdays AS RETotalNumberOfSettlementDays,
  settlementdays AS RENumberOfSettlementDays,
  meas AS REMeasurementType,
  measvalue AS REMeasurementQuantity,
  measunit AS REMeasurementUnit,
  denominatormethod AS REDenominatorMethod,
  denominator AS RESettlementDenominator,
  denominatorshare AS RESettlementShareDenominator,
  apportfactor AS REApportionmentFactorValue,
  vacancy_percent AS REVacancyPercent,
  threshold AS RESettlmtDnmntrThresholdInPct,
  termtype AS RETermType,
  termno AS RETermNumber,
  retrievalstatus AS RESettlmtDataRetrievalStatus,
  settlementstatus AS RESettlementStatus,
  CreationDateTime,
  LastChangeDateTime
FROM vicsapportfactor
LEFT OUTER JOIN I_RESettlementProcess AS _RESettlementProcess ON RESettlementProcessUUID = _RESettlementProcess.RESettlementProcessUUID  -- association [0..1]
LEFT OUTER JOIN I_RESettlementLineItemType AS _RESettlementLineItemType ON RESettlementLineItemType = _RESettlementLineItemType.RESettlementLineItemType  -- association [0..1]
LEFT OUTER JOIN I_REServiceGroup AS _REServiceGroup ON REServiceGroupUUID = _REServiceGroup.REServiceGroupUUID  -- association [0..1]
LEFT OUTER JOIN I_REServiceGroup AS _REServiceGroupTarget ON REServiceGroupTargetUUID = _REServiceGroupTarget.REServiceGroupUUID  -- association [0..1]
LEFT OUTER JOIN I_REArchitectureObject AS _REArchitectureObject ON REArchitectureObjectUUID = _REArchitectureObject.REArchitectureObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_RERentableObject AS _RERentableObject ON RealEstateRentableObjectUUID = _RERentableObject.RealEstateRentableObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_REContract AS _REContract ON REContractIntRealEstateNumber = _REContract.InternalRealEstateNumber  -- association [0..1]
LEFT OUTER JOIN I_RECostCategory AS _RECostCategory ON RECostCategory = _RECostCategory.RECostCategory  -- association [0..1]
LEFT OUTER JOIN I_REParticipationType AS _REParticipationType ON REParticipationType = _REParticipationType.REParticipationType  -- association [0..1]
LEFT OUTER JOIN I_REMeasurementType AS _REMeasurementType ON REMeasurementType = _REMeasurementType.REMeasurementType  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON REMeasurementUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_REDenominatorMethod AS _REDenominatorMethod ON REDenominatorMethod = _REDenominatorMethod.REDenominatorMethod  -- association [0..1]
LEFT OUTER JOIN I_RESrvcGrpSettlmtRulePeriod AS _RESrvcGrpSettlmtRulePeriod ON RESettlementRulePeriodUUID = _RESrvcGrpSettlmtRulePeriod.RESettlementRulePeriodUUID  -- association [0..1]
LEFT OUTER JOIN I_RESettlmtDataRetrievalStatus AS _RESettlmtDataRetrievalStatus ON RESettlmtDataRetrievalStatus = _RESettlmtDataRetrievalStatus.RESettlmtDataRetrievalStatus  -- association [0..1]
LEFT OUTER JOIN I_RESettlementStatus AS _RESettlementStatus ON RESettlementStatus = _RESettlementStatus.RESettlementStatus  -- association [0..1]
LEFT OUTER JOIN I_RESettlement AS _RESettlement ON RESettlementUUID = _RESettlement.RESettlementUUID  -- association [1..1]
;