I_DFS_MaintRevisionBasic

DDL: I_DFS_MAINTREVISIONBASIC SQL: IREVISIONBASIC Type: view BASIC
15 Fields 1 Data Sources

Basic view of Revision

I_DFS_MaintRevisionBasic is a Basic CDS View that provides data about "Basic view of Revision" in SAP S/4HANA. It reads from 1 data source (t352r) and exposes 15 fields with key fields MaintenanceRevision, MaintenancePlanningPlant.

Data Sources (1)

SourceAliasJoin Type
t352r t352r from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IREVISIONBASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Basic view of Revision view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceRevision revnr Revision
KEY MaintenancePlanningPlant t352r iwerk Planning Plant
MaintenanceRevisionDesc t352r revtx RevDescription
RevisionStartDate t352r revbd Start date
RevisionStartTime t352r revbz RevStrtTime
RevisionEndDate t352r reved End date
RevisionEndTime t352r revez RevEndTime
DfsMaintRevisionType t352r revty Revision Type
DfsMaintRevisionObjectNumber t352r objnr Val. Obj. No.
Equipment t352r equnr Equipment
FunctionalLocation t352r tplnr Functional loc.
DfsMaintRevisionWorkCenter t352r vaplz Main WorkCtr
DfsMaintRevisionPlant t352r vawrk Plnt WorkCenter
DfsMaintCnctntdRevisionText
DfsMaintRevisionWBSElement

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 I_DFS_MaintRevisionBasic.
-- 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.
-- SQL view name: IREVISIONBASIC

CREATE VIEW I_DFS_MaintRevisionBasic AS
SELECT
  revnr AS MaintenanceRevision,
  t352r.iwerk AS MaintenancePlanningPlant,
  t352r.revtx AS MaintenanceRevisionDesc,
  t352r.revbd AS RevisionStartDate,
  t352r.revbz AS RevisionStartTime,
  t352r.reved AS RevisionEndDate,
  t352r.revez AS RevisionEndTime,
  t352r.revty AS DfsMaintRevisionType,
  t352r.objnr AS DfsMaintRevisionObjectNumber,
  t352r.equnr AS Equipment,
  t352r.tplnr AS FunctionalLocation,
  t352r.vaplz AS DfsMaintRevisionWorkCenter,
  t352r.vawrk AS DfsMaintRevisionPlant,
  concat( iwerk,revnr ) AS DfsMaintCnctntdRevisionText,
  cast( t352r.pspel as abap.numc(8)) AS DfsMaintRevisionWBSElement
FROM t352r
;

Learn More