I_MaintJobWrkItmCompHistlProd

DDL: I_MAINTJOBWRKITMCOMPHISTLPROD Type: view_entity COMPOSITE Package: VDM_EAM_MAINTJOB_MNG_CMP_UNPLN
14 Fields 1 Data Sources 3 Associations

Maintenance job historical material

I_MaintJobWrkItmCompHistlProd is a Composite CDS View that provides data about "Maintenance job historical material" in SAP S/4HANA. It reads from 1 data source (P_MaintJobWrkItmHistlProdRcrrc) and exposes 14 fields with key fields Material, Plant, StorageLocation, TechnicalObject, MaintenanceOrderType. It has 3 associations to related views. Part of development package VDM_EAM_MAINTJOB_MNG_CMP_UNPLN.

Data Sources (1)

SourceAliasJoin Type
P_MaintJobWrkItmHistlProdRcrrc P_MaintJobWrkItmHistlProdRcrrc from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Material _Material $projection.Material = _Material.Material
[0..1] I_MaterialUnrestrictedUseStock _MaterialUnrestrictedUseStock $projection.Material = _MaterialUnrestrictedUseStock.Material and $projection.Plant = _MaterialUnrestrictedUseStock.Plant and $projection.StorageLocation = _MaterialUnrestrictedUseStock.StorageLocation
[0..1] I_UnrestrictedUseStkOnPlntLvl _UnrestrictedUseStkOnPlntLvl $projection.Material = _UnrestrictedUseStkOnPlntLvl.Material and $projection.Plant = _UnrestrictedUseStkOnPlntLvl.Plant

Annotations (6)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Maintenance job historical material view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Material P_MaintJobWrkItmHistlProdRcrrc Material Vehicle Model
KEY Plant P_MaintJobWrkItmHistlProdRcrrc Plant Valuation Area
KEY StorageLocation P_MaintJobWrkItmHistlProdRcrrc StorageLocation StorageLocation
KEY TechnicalObject P_MaintJobWrkItmHistlProdRcrrc TechnicalObject Technical Object
KEY MaintenanceOrderType _OrderTypeperplant auart Sales Doc. Type
RcrrcOfMatlUsageInTechObj P_MaintJobWrkItmHistlProdRcrrc RcrrcOfMatlUsageInTechObj
TechObjIsEquipOrFuncnlLoc P_MaintJobWrkItmHistlProdRcrrc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
IsBatchManagementRequired _Material IsBatchManagementRequired Batch Mgmt Rqt(Plnt)
MaterialBaseUnit _Material MaterialBaseUnit Valuation Unit
MaterialGroup _Material MaterialGroup Product Group
MaterialType _Material MaterialType Material Type
_MaterialUnrestrictedUseStock _MaterialUnrestrictedUseStock
_Material _Material
_UnrestrictedUseStkOnPlntLvl _UnrestrictedUseStkOnPlntLvl

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_MaintJobWrkItmCompHistlProd.
-- 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_MaintJobWrkItmCompHistlProd AS
SELECT
  P_MaintJobWrkItmHistlProdRcrrc.Material AS Material,
  P_MaintJobWrkItmHistlProdRcrrc.Plant AS Plant,
  P_MaintJobWrkItmHistlProdRcrrc.StorageLocation AS StorageLocation,
  P_MaintJobWrkItmHistlProdRcrrc.TechnicalObject AS TechnicalObject,
  _OrderTypeperplant.auart AS MaintenanceOrderType,
  P_MaintJobWrkItmHistlProdRcrrc.RcrrcOfMatlUsageInTechObj AS RcrrcOfMatlUsageInTechObj,
  P_MaintJobWrkItmHistlProdRcrrc.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _Material.IsBatchManagementRequired AS IsBatchManagementRequired,
  _Material.MaterialBaseUnit AS MaterialBaseUnit,
  _Material.MaterialGroup AS MaterialGroup,
  _Material.MaterialType AS MaterialType
FROM P_MaintJobWrkItmHistlProdRcrrc
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialUnrestrictedUseStock AS _MaterialUnrestrictedUseStock ON Material = _MaterialUnrestrictedUseStock.Material AND Plant = _MaterialUnrestrictedUseStock.Plant AND StorageLocation = _MaterialUnrestrictedUseStock.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_UnrestrictedUseStkOnPlntLvl AS _UnrestrictedUseStkOnPlntLvl ON Material = _UnrestrictedUseStkOnPlntLvl.Material AND Plant = _UnrestrictedUseStkOnPlntLvl.Plant  -- association [0..1]
;

Learn More