A_MaintPlngBucketUserStatus

DDL: A_MAINTPLNGBUCKETUSERSTATUS Type: view_entity CONSUMPTION
10 Fields 1 Data Sources

Maintenance Planning Bucket User Status

A_MaintPlngBucketUserStatus is a Consumption CDS View that provides data about "Maintenance Planning Bucket User Status" in SAP S/4HANA. It reads from 1 data source (R_MaintPlngBucketUserStatusTP) and exposes 10 fields with key fields MaintPlanningBucketUUID, StatusProfile, UserStatus.

Data Sources (1)

SourceAliasJoin Type
R_MaintPlngBucketUserStatusTP R_MaintPlngBucketUserStatusTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Maintenance Planning Bucket User Status view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entityType.name MaintPlngBucketUserStatus_Type view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MaintPlanningBucketUUID MaintPlanningBucketUUID UUID
KEY StatusProfile StatusProfile Status Profile
KEY UserStatus UserStatus
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenanceEventType MaintenanceEventType Revision Type
StatusSequenceNumber StatusSequenceNumber
StatusDisplayPosition StatusDisplayPosition
MaintPlngBucketStatusObject MaintPlngBucketStatusObject Object number
StatusIsActive StatusIsActive
StatusAuthorizationKey StatusAuthorizationKey

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 A_MaintPlngBucketUserStatus.
-- 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 A_MaintPlngBucketUserStatus AS
SELECT
  MaintPlanningBucketUUID,
  StatusProfile,
  UserStatus,
  MaintenancePlanningPlant,
  MaintenanceEventType,
  StatusSequenceNumber,
  StatusDisplayPosition,
  MaintPlngBucketStatusObject,
  StatusIsActive,
  StatusAuthorizationKey
FROM R_MaintPlngBucketUserStatusTP
;

Learn More