R_MaintPlngBcktScopeValueDraft

DDL: R_MAINTPLNGBCKTSCOPEVALUEDRAFT Type: view_entity BASIC
42 Fields 1 Data Sources 1 Associations

Maint plng bckt scope name draft data

R_MaintPlngBcktScopeValueDraft is a Basic CDS View that provides data about "Maint plng bckt scope name draft data" in SAP S/4HANA. It reads from 1 data source (eam_plngbktscpd) and exposes 42 fields with key field MaintPlanningBucketScopeUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
eam_plngbktscpd eam_plngbktscpd from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_MaintPlngBucketScopeDraft _MaintPBucketScpDraftExtn $projection.MaintPlanningBucketScopeUUID = _MaintPBucketScpDraftExtn.MaintPlanningBucketScopeUUID

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maint plng bckt scope name draft data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix MBS view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.quota.maximumFields 450 view
AbapCatalog.extensibility.quota.maximumBytes 45000 view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY MaintPlanningBucketScopeUUID maintplanningbucketscopeuuid UUID
MaintPlanningBucketUUID maintplanningbucketuuid UUID
MaintPlngBcktScpRangeFieldName maintplngbcktscprangefieldname Field Name
MaintPlngBucketScopeRgSg maintplngbucketscopergsg INCL/EXCL
MaintPlngBucketScopeRgOp maintplngbucketscopergop Option
MaintPlngBucketScopeRgFr maintplngbucketscopergfr Field Value
MaintPlngBucketScopeRgTo maintplngbucketscopergto Field Value
MaintenancePlanningPlant maintenanceplanningplant Planning Plant
MaintenancePlannerGroup maintenanceplannergroup Planner Group
MaintenancePlannerGroupName maintenanceplannergroupname Planner Group Name
MaintenancePlant maintenanceplant Plant
PlantSection plantsection Plant Section
PlantSectionPersonRespName plantsectionpersonrespname GrpResp.
MainWorkCenter mainworkcenter Work Center
WorkCenterInternalID workcenterinternalid Work Center
MainWorkCenterText mainworkcentertext Work Center Text
Equipment equipment Equipment check
EquipmentName equipmentname Tech. Obj. Desc
FunctionalLocation functionallocation Object ID
FunctionalLocationName functionallocationname Functional Loc.
ABCIndicator abcindicator ABC Indicator
AssetLocation assetlocation Location
MaintenanceActivityType maintenanceactivitytype MaintActivType
OperationSystemCondition operationsystemcondition SystemCondition
LocationName locationname Location Name
OperationSystemConditionText operationsystemconditiontext Text
AssetManufacturerName assetmanufacturername Manufacturer
CostCenter costcenter Cost Center
WorkCenter workcenter Work Center
WBSElement wbselement WBS Internal ID
WBSElementInternalID wbselementinternalid WBS Internal ID
TechnicalObjectType technicalobjecttype Text object
FunctionalLocationLabelName functionallocationlabelname Functional Loc.
MainWorkCenterPlant mainworkcenterplant Plnt WorkCenter
MaintOrderProcessingContext maintorderprocessingcontext Processing Context
SoldToParty soldtoparty Sold-to Party
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

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_MaintPlngBcktScopeValueDraft.
-- 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_MaintPlngBcktScopeValueDraft AS
SELECT
  MaintPlanningBucketScopeUUID,
  MaintPlanningBucketUUID,
  MaintPlngBcktScpRangeFieldName,
  MaintPlngBucketScopeRgSg,
  MaintPlngBucketScopeRgOp,
  MaintPlngBucketScopeRgFr,
  MaintPlngBucketScopeRgTo,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  MaintenancePlannerGroupName,
  MaintenancePlant,
  PlantSection,
  PlantSectionPersonRespName,
  MainWorkCenter,
  WorkCenterInternalID,
  MainWorkCenterText,
  Equipment,
  EquipmentName,
  FunctionalLocation,
  FunctionalLocationName,
  ABCIndicator,
  AssetLocation,
  MaintenanceActivityType,
  OperationSystemCondition,
  LocationName,
  OperationSystemConditionText,
  AssetManufacturerName,
  CostCenter,
  WorkCenter,
  WBSElement,
  WBSElementInternalID,
  TechnicalObjectType,
  FunctionalLocationLabelName,
  MainWorkCenterPlant,
  MaintOrderProcessingContext,
  SoldToParty,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM eam_plngbktscpd
LEFT OUTER JOIN E_MaintPlngBucketScopeDraft AS _MaintPBucketScpDraftExtn ON MaintPlanningBucketScopeUUID = _MaintPBucketScpDraftExtn.MaintPlanningBucketScopeUUID  -- association [0..1]
;

Learn More