I_MaintenanceJobPackageTotals

DDL: I_MAINTENANCEJOBPACKAGETOTALS SQL: IMJPTTLS Type: view COMPOSITE
9 Fields 3 Data Sources 1 Associations

Totals of Maintenance Job Pack

I_MaintenanceJobPackageTotals is a Composite CDS View that provides data about "Totals of Maintenance Job Pack" in SAP S/4HANA. It reads from 3 data sources (I_MaintenanceJobPackage, P_MaintJobPckgOutpItmStsCount, P_MaintJobPckgTotalsFromOps) and exposes 9 fields with key field MaintenanceJobPackageUUID. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_MaintenanceJobPackage I_MaintenanceJobPackage from
P_MaintJobPckgOutpItmStsCount OutpItmStsCount inner
P_MaintJobPckgTotalsFromOps TotalsFromOps inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.MaintJobPckgPlannedWorkUnit = _UnitOfMeasure.UnitOfMeasure

Annotations (10)

NameValueLevelField
EndUserText.label Totals of Maintenance Job Pack view
AbapCatalog.sqlViewName IMJPTTLS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey MaintenanceJobPackageUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceJobPackageUUID I_MaintenanceJobPackage MaintenanceJobPackageUUID Job Package UUID
MaintenanceJobPackage I_MaintenanceJobPackage MaintenanceJobPackage Maintenance Job Pckg
NumberOfMaintJobPackageOps P_MaintJobPckgTotalsFromOps NumberOfMaintJobPackageOps
NmbrOfMaintJobPckgOutputItems P_MaintJobPckgOutpItmStsCount NmbrOfMaintJobPckgOutputItems
MaintJobPckgPlannedWork P_MaintJobPckgTotalsFromOps MaintJobPckgPlannedWork
MaintJobPckgPlannedWorkUnit P_MaintJobPckgTotalsFromOps MaintJobPckgPlannedWorkUnit
_MaintJobPackageOperation I_MaintenanceJobPackage _MaintJobPackageOperation
_UnitOfMeasure _UnitOfMeasure
_MaintJobPackageOutputItem I_MaintenanceJobPackage _MaintJobPackageOutputItem

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_MaintenanceJobPackageTotals.
-- 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: IMJPTTLS

CREATE VIEW I_MaintenanceJobPackageTotals AS
SELECT
  I_MaintenanceJobPackage.MaintenanceJobPackageUUID AS MaintenanceJobPackageUUID,
  I_MaintenanceJobPackage.MaintenanceJobPackage AS MaintenanceJobPackage,
  TotalsFromOps.NumberOfMaintJobPackageOps AS NumberOfMaintJobPackageOps,
  OutpItmStsCount.NmbrOfMaintJobPckgOutputItems AS NmbrOfMaintJobPckgOutputItems,
  TotalsFromOps.MaintJobPckgPlannedWork AS MaintJobPckgPlannedWork,
  TotalsFromOps.MaintJobPckgPlannedWorkUnit AS MaintJobPckgPlannedWorkUnit,
  I_MaintenanceJobPackage._MaintJobPackageOperation AS _MaintJobPackageOperation,
  I_MaintenanceJobPackage._MaintJobPackageOutputItem AS _MaintJobPackageOutputItem
FROM I_MaintenanceJobPackage
INNER JOIN P_MaintJobPckgTotalsFromOps AS TotalsFromOps ON /* join condition not captured in parsed metadata */
INNER JOIN P_MaintJobPckgOutpItmStsCount AS OutpItmStsCount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MaintJobPckgPlannedWorkUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;

Learn More