R_MaintPlngBcktExecObjectDraft

DDL: R_MAINTPLNGBCKTEXECOBJECTDRAFT Type: view_entity BASIC
39 Fields 1 Data Sources 2 Associations

Maint plng bckt execution objects draft

R_MaintPlngBcktExecObjectDraft is a Basic CDS View that provides data about "Maint plng bckt execution objects draft" in SAP S/4HANA. It reads from 1 data source (eam_bcktexecobjd) and exposes 39 fields with key fields MaintExecutionObject, MaintExecutionObjectType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
eam_bcktexecobjd eam_bcktexecobjd from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Equipment _Equipment $projection.Equipment = _Equipment.Equipment
[0..1] I_LocationAccountAssignment _LocationAccountAssignment _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = $projection.MaintObjectLocAcctAssgmtNmbr

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Maint plng bckt execution objects draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY MaintExecutionObject maintexecutionobject Exec. Object
KEY MaintExecutionObjectType maintexecutionobjecttype Object Type
MaintExecutionObjectTypeDesc maintexecutionobjecttypedesc MObj.Type Desc.
DocumentText documenttext Text ID
MaintPlanningBucketUUID maintplanningbucketuuid UUID
MaintPriority maintpriority Priority
MaintPriorityDesc maintprioritydesc Priority
MainWorkCenter mainworkcenter Work Center
WorkCenterInternalID workcenterinternalid Work Center
NotificationType notificationtype Notifictn Type
MaintenanceOrderType maintenanceordertype Order Type
MaintOrdProcessPhaseCode maintordprocessphasecode Process Phase
MaintOrdProcessSubPhaseCode maintordprocesssubphasecode Process Subphase
MaintenanceRevision maintenancerevision Revision
MaintenanceNotification maintenancenotification Notification
Equipment equipment Equipment check
ABCIndicator abcindicator ABC Indicator
MaintenancePlanningPlant maintenanceplanningplant Planning Plant
MaintenancePlanningPlantName maintenanceplanningplantname Plant Name
OperationSystemCondition operationsystemcondition SystemCondition
MaintenanceActivityType maintenanceactivitytype MaintActivType
MaintenanceItem maintenanceitem MaintItem
MaintenanceItemDescription maintenanceitemdescription MaintItem text
MaintExecObjRequiredStartDate maintexecobjrequiredstartdate Bas. Start Date
MaintExecObjectRequiredEndDate maintexecobjectrequiredenddate Basic fin. date
FunctionalLocationName functionallocationname Functional Loc.
FunctionalLocationLabelName functionallocationlabelname Functional Loc.
MaintenanceProcessingPhase maintenanceprocessingphase Phase
NmbrOfMaintPlngBcktExecObjects nmbrofmaintplngbcktexecobjects INT4
MaintObjectLocAcctAssgmtNmbr maintobjectlocacctassgmtnmbr Loc/AccAssmt
MaintObjectInternalID maintobjectinternalid Object number
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
_Equipment _Equipment
_LocationAccountAssignment _LocationAccountAssignment

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_MaintPlngBcktExecObjectDraft.
-- 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_MaintPlngBcktExecObjectDraft AS
SELECT
  MaintExecutionObject,
  MaintExecutionObjectType,
  MaintExecutionObjectTypeDesc,
  DocumentText,
  MaintPlanningBucketUUID,
  MaintPriority,
  MaintPriorityDesc,
  MainWorkCenter,
  WorkCenterInternalID,
  NotificationType,
  MaintenanceOrderType,
  MaintOrdProcessPhaseCode,
  MaintOrdProcessSubPhaseCode,
  MaintenanceRevision,
  MaintenanceNotification,
  Equipment,
  ABCIndicator,
  MaintenancePlanningPlant,
  MaintenancePlanningPlantName,
  OperationSystemCondition,
  MaintenanceActivityType,
  MaintenanceItem,
  MaintenanceItemDescription,
  MaintExecObjRequiredStartDate,
  MaintExecObjectRequiredEndDate,
  FunctionalLocationName,
  FunctionalLocationLabelName,
  MaintenanceProcessingPhase,
  NmbrOfMaintPlngBcktExecObjects,
  MaintObjectLocAcctAssgmtNmbr,
  MaintObjectInternalID,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM eam_bcktexecobjd
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
;

Learn More