R_LockManagerItemTP

DDL: R_LOCKMANAGERITEMTP Type: view_entity TRANSACTIONAL

Lock Manager Item - TP

R_LockManagerItemTP is a Transactional CDS View that provides data about "Lock Manager Item - TP" in SAP S/4HANA. It reads from 1 data source (I_LockManagerItem) and exposes 17 fields with key field LockManagerItemUUID.

Data Sources (1)

SourceAliasJoin Type
I_LockManagerItem LockManagerItem from

Annotations (9)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.representativeKey LockManagerItemUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Lock Manager Item - TP view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY LockManagerItemUUID LockManagerItemUUID Entity GUID
LockManagerUUID LockManagerUUID Entity GUID
ReferencedObjectUUID ReferencedObjectUUID Referenced Object
ProjectDemandUUID ProjectDemandUUID Entity GUID
ProjectDemandType ProjectDemandType Demand Type
ProjDmndReferencedPlanDataUUID ProjDmndReferencedPlanDataUUID Referenced Object
ProjDmndRsceDistrIsNotSupplied ProjDmndRsceDistrIsNotSupplied Assgmt Is Confirmed
ProjDmndDistributionLineType ProjDmndDistributionLineType Line Type
ProjectDemandNodeName ProjectDemandNodeName Node Name
ProjectDemandPropertyName ProjectDemandPropertyName Demand Property
ProjDmndPropertyChangedValue ProjDmndPropertyChangedValue Property Value
LockManagerUpdateCode LockManagerUpdateCode Update Code
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_LockManager _LockManager

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 R_LockManagerItemTP.
-- 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 R_LockManagerItemTP AS
SELECT
  LockManagerItemUUID,
  LockManagerUUID,
  ReferencedObjectUUID,
  ProjectDemandUUID,
  ProjectDemandType,
  ProjDmndReferencedPlanDataUUID,
  ProjDmndRsceDistrIsNotSupplied,
  ProjDmndDistributionLineType,
  ProjectDemandNodeName,
  ProjectDemandPropertyName,
  ProjDmndPropertyChangedValue,
  LockManagerUpdateCode,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_LockManagerItem AS LockManagerItem
;