C_EquipTypeAndRsceCapOffer

DDL: C_EQUIPTYPEANDRSCECAPOFFER Type: view_entity CONSUMPTION
21 Fields 5 Data Sources 1 Associations

Equipment and Resource Capacity Offer

C_EquipTypeAndRsceCapOffer is a Consumption CDS View that provides data about "Equipment and Resource Capacity Offer" in SAP S/4HANA. It reads from 5 data sources (I_EquipmentType, I_EquipmentType, I_EquipmentType, I_EquipmentType, I_ResourceTransp) and exposes 21 fields with key fields ResourceAdditionalUUID, ResourceDimension, NmbrOfDimensionlessCapacities, ResourceDimension, NmbrOfDimensionlessCapacities. It has 1 association to related views.

Data Sources (5)

SourceAliasJoin Type
I_EquipmentType EquipmentType union
I_EquipmentType EquipmentType union
I_EquipmentType EquipmentType union
I_EquipmentType EquipmentType union
I_ResourceTransp ResourceTransp from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_RsceCapacityDimensions _RsceCapacityDimensions ResourceTransp.ResourceUUID = _RsceCapacityDimensions.ResourceUUID and _RsceCapacityDimensions.ResourceSimulationSessionUUID = '' and _RsceCapacityDimensions.ResourceSimulationVersionUUID = ''

Annotations (9)

NameValueLevelField
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Equipment and Resource Capacity Offer view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ResourceAdditionalUUID I_ResourceTransp ResourceAdditionalUUID UUID
KEY ResourceDimension _RsceCapacityDimensions ResourceDimension
KEY NmbrOfDimensionlessCapacities _RsceCapacityDimensions NmbrOfDimensionlessCapacities
ResourceCapacityUnit _RsceCapacityDimensions ResourceCapacityUnit
ResourceAdditionalUUID UUID
KEY ResourceDimension
KEY NmbrOfDimensionlessCapacities
ResourceCapacityUnit I_EquipmentType ResourceMaximumLoadWeightUnit
ResourceAdditionalUUID UUID
KEY ResourceDimension
KEY NmbrOfDimensionlessCapacities
ResourceCapacityUnit I_EquipmentType ResourceCubicCapacityUnit
ResourceAdditionalUUID UUID
KEY ResourceDimension
KEY NmbrOfDimensionlessCapacities
ResourceCapacityUnit I_EquipmentType RsceAddlCapNmbrOfUnitsUnit
ResourceAdditionalUUID UUID
KEY ResourceDimension
KEY NmbrOfDimensionlessCapacities
ResourceCapacityUnit I_EquipmentType RsceAddlCapAltvNmbrOfUnitsUnit
ResourceCapacity I_EquipmentType RsceAddlCapAltvNmbrOfUnits Alt. Number of Units

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_EquipTypeAndRsceCapOffer.
-- 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_EquipTypeAndRsceCapOffer AS
SELECT
  ResourceTransp.ResourceAdditionalUUID AS ResourceAdditionalUUID,
  _RsceCapacityDimensions.ResourceDimension AS ResourceDimension,
  _RsceCapacityDimensions.NmbrOfDimensionlessCapacities AS NmbrOfDimensionlessCapacities,
  _RsceCapacityDimensions.ResourceCapacityUnit AS ResourceCapacityUnit,
  EquipmentType.RsceAddlCapAltvNmbrOfUnits AS ResourceCapacity
FROM I_ResourceTransp AS ResourceTransp
LEFT OUTER JOIN I_RsceCapacityDimensions AS _RsceCapacityDimensions ON ResourceTransp.ResourceUUID = _RsceCapacityDimensions.ResourceUUID AND _RsceCapacityDimensions.ResourceSimulationSessionUUID = '' AND _RsceCapacityDimensions.ResourceSimulationVersionUUID = ''  -- association [0..*]
-- UNION with additional select branch(es): I_EquipmentType
;

Learn More