I_REMeasurementType

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_REMeasurementType.
-- 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: IREMSMTTYPE

CREATE VIEW I_REMeasurementType AS
SELECT
  meas AS REMeasurementType,
  issummeas AS REMeasurementIsTotal,
  baserate AS RESettlmtBasicComponent,
  setzeroifvacant AS REMeasurementIsZeroForVacancy,
  ispercent AS REValueIsPresentedAsPercentage,
  ispropapport AS REMsmtHasEqualApportionment,
  getbycondtype AS REMsmtIsDeterminedByCndnType,
  isconsumption AS REMsmtTypeIsUsedForConsumption,
  isresetable AS REMeterIsResettable,
  measunitdef AS REDefaultMeasurementUnit,
  usageforao AS REMsmtUsageForArchitecturalObj,
  usageforro AS REMsmtUsageForRentalObject,
  usageforbe AS REMsmtUsageForBusinessEntity,
  usageforpr AS REMsmtUsageForLand,
  usageforbu AS REMsmtUsageForBuilding,
  usageforcn AS REMsmtUsageForContract,
  usageforpl AS REMsmtUsageForParcels,
  usageforgo AS REMsmtUsageForGenericObject,
  isspcfactor AS REMsmtTypeIsAreaMeasurement,
  usedforapport AS REMsmtTypeIsUsedForApprtmt,
  disableexceptro AS REExcptnRntlObjIsNotPossible,
  disableexceptao AS REExcptnArchlObjIsNotPossible,
  disableexceptcn AS REExcptnContrTypeIsNotPossible,
  objrelprop AS REDifferingMeasurement,
  iscoshare AS RETypeIsRprstvForOwnrShipShare,
  sckeydaterel AS RERefFactorIsRelatedToKeyDate,
  nocompression AS RENoCompressionIsActive,
  cuexcludeassign AS REIsExclForNewAssgmt
FROM tivbdmeas
LEFT OUTER JOIN I_REMeasurementTypeText AS _Text ON REMeasurementType = _Text.REMeasurementType  -- association [0..*]
LEFT OUTER JOIN I_RESettlmtBasicComponent AS _RESettlmtBasicComponent ON RESettlmtBasicComponent = _RESettlmtBasicComponent.RESettlmtBasicComponent  -- association [0..1]
LEFT OUTER JOIN I_REMsmtAllowedUsages AS _REMsmtUsageForArchlObj ON REMsmtUsageForArchitecturalObj = _REMsmtUsageForArchlObj.REMsmtAllowedUsages  -- association [0..1]
LEFT OUTER JOIN I_REMsmtAllowedUsages AS _REMsmtUsageForRentalObj ON REMsmtUsageForRentalObject = _REMsmtUsageForRentalObj.REMsmtAllowedUsages  -- association [0..1]
LEFT OUTER JOIN I_REMsmtAllowedUsages AS _REMsmtUsageForBusinessEntity ON REMsmtUsageForBusinessEntity = _REMsmtUsageForBusinessEntity.REMsmtAllowedUsages  -- association [0..1]
LEFT OUTER JOIN I_REMsmtAllowedUsages AS _REMsmtUsageForLand ON REMsmtUsageForLand = _REMsmtUsageForLand.REMsmtAllowedUsages  -- association [0..1]
LEFT OUTER JOIN I_REMsmtAllowedUsages AS _REMsmtUsageForBuilding ON REMsmtUsageForBuilding = _REMsmtUsageForBuilding.REMsmtAllowedUsages  -- association [0..1]
LEFT OUTER JOIN I_REMsmtAllowedUsages AS _REMsmtUsageForContract ON REMsmtUsageForContract = _REMsmtUsageForContract.REMsmtAllowedUsages  -- association [0..1]
LEFT OUTER JOIN I_REMsmtAllowedUsages AS _REMsmtUsageForParcels ON REMsmtUsageForParcels = _REMsmtUsageForParcels.REMsmtAllowedUsages  -- association [0..1]
LEFT OUTER JOIN I_REDifferingMeasurement AS _REDifferingMeasurement ON REDifferingMeasurement = _REDifferingMeasurement.REDifferingMeasurement  -- association [0..1]
;