I_MaintJobPckgBuildTotals

DDL: I_MAINTJOBPCKGBUILDTOTALS Type: view_entity COMPOSITE Package: VDM_EAM_MAINTJOBPACKAGE
6 Fields 1 Data Sources

Totals of Maintenance Work Pack

I_MaintJobPckgBuildTotals is a Composite CDS View that provides data about "Totals of Maintenance Work Pack" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceJobPackageBuild) and exposes 6 fields with key field MaintenanceJobPackageBuildUUID. Part of development package VDM_EAM_MAINTJOBPACKAGE.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceJobPackageBuild I_MaintenanceJobPackageBuild from

Annotations (8)

NameValueLevelField
EndUserText.label Totals of Maintenance Work Pack view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey MaintenanceJobPackageBuildUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Analytics.technicalName IMJPBTOTALS view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceJobPackageBuildUUID MaintenanceJobPackageBuildUUID Package Build UUID
NumberOfMaintenanceJobPackages
NmbrOfMaintJobPackageBuildOps
NrOfMaintJobPckgBuildOutpItems
MaintJobPckgBuildPlndWrk
MaintJobPckgBuildPlndWrkUnit

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_MaintJobPckgBuildTotals.
-- 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 I_MaintJobPckgBuildTotals AS
SELECT
  MaintenanceJobPackageBuildUUID,
  count ( distinct I_MaintenanceJobPackageBuild._MaintenanceJobPackage.MaintenanceJobPackageUUID ) AS NumberOfMaintenanceJobPackages,
  sum ( I_MaintenanceJobPackageBuild._MaintenanceJobPackage._MaintenanceJobPackageTotals.NumberOfMaintJobPackageOps ) AS NmbrOfMaintJobPackageBuildOps,
  sum ( I_MaintenanceJobPackageBuild._MaintenanceJobPackage._MaintenanceJobPackageTotals.NmbrOfMaintJobPckgOutputItems ) AS NrOfMaintJobPckgBuildOutpItems,
  sum ( I_MaintenanceJobPackageBuild._MaintenanceJobPackage._MaintenanceJobPackageTotals.MaintJobPckgPlannedWork ) AS MaintJobPckgBuildPlndWrk,
  cast ( 'H' as eam_mjp_plnd_work_unit ) AS MaintJobPckgBuildPlndWrkUnit
FROM I_MaintenanceJobPackageBuild
;

Learn More