/SCMTMS/CV_ResourceBasicEnh

DDL: /SCMTMS/CV_RESOURCEBASICENH Type: view_entity Package: /SCMTMS/CDS_FO_RESOURCE
21 Fields 3 Data Sources 2 Associations

BOPF: Resource Root Additional Data

/SCMTMS/CV_ResourceBasicEnh is a CDS View that provides data about "BOPF: Resource Root Additional Data" in SAP S/4HANA. It reads from 3 data sources (/sapapo/trtype, /sapapo/cpmtr, I_ResourceBasic) and exposes 21 fields with key field ResourceUUID. It has 2 associations to related views. Part of development package /SCMTMS/CDS_FO_RESOURCE.

Data Sources (3)

SourceAliasJoin Type
/sapapo/trtype _MeansOfTransport left_outer
/sapapo/cpmtr _MtrCompartment left_outer
I_ResourceBasic _ResourceBasic from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ResourceTextBasic _ResourceTextBasic $projection.ResourceUUID = _ResourceTextBasic.ResourceUUID and _ResourceTextBasic.ResourceSimulationSessionUUID = '' and _ResourceTextBasic.ResourceSimulationVersionUUID = '' and _ResourceTextBasic.Language = $session.system_language
[0..1] I_LocationBasic _LocationBasic $projection.ResourceHomeLocationUUID = _LocationBasic.LocationUUID

Annotations (6)

NameValueLevelField
EndUserText.label BOPF: Resource Root Additional Data view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ResourceUUID I_ResourceBasic ResourceUUID Internal Resrce
ResourceID I_ResourceBasic ResourceID Vehicle ID
LocationUUID _LocationBasic LocationUUID UUID
LocationAdditionalUUID _LocationBasic LocationAdditionalUUID
ResourceType I_ResourceBasic ResourceType Worklist Type
ResourceFactoryCalendar I_ResourceBasic ResourceFactoryCalendar Workdays only
ResourceHomeLocationUUID I_ResourceBasic ResourceHomeLocationUUID Single-Character Flag
ResourceSimulationSessionUUID I_ResourceBasic ResourceSimulationSessionUUID Sim. Session
ResourceSimulationVersionUUID I_ResourceBasic ResourceSimulationVersionUUID GUID
ResourceTimeZone I_ResourceBasic ResourceTimeZone Time Zone Difference
TransportMeansType I_ResourceBasic TransportMeansType Packag.Mat.Type
LastChangedByUser I_ResourceBasic LastChangedByUser User Name
ChangedDateTime I_ResourceBasic ChangedDateTime Time Stamp
IsMultiResource /sapapo/trtype ext_ttype_flg Multiresource
NumberOfResources /sapapo/trtype ext_ttype_num No. of Indiv. Res.
IsPassiveResource /sapapo/trtype passive Passive
MultiResourceIsLocked /sapapo/trtype lock_multires Lock Multiresource
TransportationMode /sapapo/trtype trmodcode Mode of Transp.
ResourceCompartmentProfile /sapapo/cpmtr cmprofile Comp. Profile
ResourceName _ResourceTextBasic ResourceName
Language _ResourceTextBasic Language Report Text Language

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 /SCMTMS/CV_ResourceBasicEnh.
-- 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 /SCMTMS/CV_ResourceBasicEnh AS
SELECT
  _ResourceBasic.ResourceUUID AS ResourceUUID,
  _ResourceBasic.ResourceID AS ResourceID,
  _LocationBasic.LocationUUID AS LocationUUID,
  _LocationBasic.LocationAdditionalUUID AS LocationAdditionalUUID,
  _ResourceBasic.ResourceType AS ResourceType,
  _ResourceBasic.ResourceFactoryCalendar AS ResourceFactoryCalendar,
  _ResourceBasic.ResourceHomeLocationUUID AS ResourceHomeLocationUUID,
  _ResourceBasic.ResourceSimulationSessionUUID AS ResourceSimulationSessionUUID,
  _ResourceBasic.ResourceSimulationVersionUUID AS ResourceSimulationVersionUUID,
  _ResourceBasic.ResourceTimeZone AS ResourceTimeZone,
  _ResourceBasic.TransportMeansType AS TransportMeansType,
  _ResourceBasic.LastChangedByUser AS LastChangedByUser,
  _ResourceBasic.ChangedDateTime AS ChangedDateTime,
  _MeansOfTransport.ext_ttype_flg AS IsMultiResource,
  _MeansOfTransport.ext_ttype_num AS NumberOfResources,
  _MeansOfTransport.passive AS IsPassiveResource,
  _MeansOfTransport.lock_multires AS MultiResourceIsLocked,
  _MeansOfTransport.trmodcode AS TransportationMode,
  _MtrCompartment.cmprofile AS ResourceCompartmentProfile,
  _ResourceTextBasic.ResourceName AS ResourceName,
  _ResourceTextBasic.Language AS Language
FROM I_ResourceBasic AS _ResourceBasic
LEFT OUTER JOIN /sapapo/trtype AS _MeansOfTransport ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /sapapo/cpmtr AS _MtrCompartment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ResourceTextBasic AS _ResourceTextBasic ON ResourceUUID = _ResourceTextBasic.ResourceUUID AND _ResourceTextBasic.ResourceSimulationSessionUUID = '' AND _ResourceTextBasic.ResourceSimulationVersionUUID = '' AND _ResourceTextBasic.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LocationBasic AS _LocationBasic ON ResourceHomeLocationUUID = _LocationBasic.LocationUUID  -- association [0..1]
;

Learn More