I_MaintJobPckgBuildTotals

DDL: I_MAINTJOBPCKGBUILDTOTALS SQL: IMJPBTOTALS Type: view COMPOSITE
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.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceJobPackageBuild I_MaintenanceJobPackageBuild from

Annotations (11)

NameValueLevelField
EndUserText.label Totals of Maintenance Work Pack view
AbapCatalog.sqlViewName IMJPBTOTALS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey MaintenanceJobPackageBuildUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL 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.
-- SQL view name: IMJPBTOTALS

CREATE VIEW I_MaintJobPckgBuildTotals AS
SELECT
  MaintenanceJobPackageBuildUUID,
  count ( distinct _MaintenanceJobPackage.MaintenanceJobPackageUUID ) AS NumberOfMaintenanceJobPackages,
  sum ( _MaintenanceJobPackage._MaintenanceJobPackageTotals.NumberOfMaintJobPackageOps ) AS NmbrOfMaintJobPackageBuildOps,
  sum ( _MaintenanceJobPackage._MaintenanceJobPackageTotals.NmbrOfMaintJobPckgOutputItems ) AS NrOfMaintJobPckgBuildOutpItems,
  sum ( _MaintenanceJobPackage._MaintenanceJobPackageTotals.MaintJobPckgPlannedWork ) AS MaintJobPckgBuildPlndWrk,
  cast ( 'H' as eam_mjp_plnd_work_unit ) AS MaintJobPckgBuildPlndWrkUnit
FROM I_MaintenanceJobPackageBuild
;

Learn More