P_HistMaterialMalfuncManage

DDL: P_HISTMATERIALMALFUNCMANAGE SQL: PHISTMAT Type: view CONSUMPTION
7 Fields 2 Data Sources

Historic Materials

P_HistMaterialMalfuncManage is a Consumption CDS View that provides data about "Historic Materials" in SAP S/4HANA. It reads from 2 data sources (I_MaintOrderTechObj, I_MaintOrderGoodsMovement) and exposes 7 fields.

Data Sources (2)

SourceAliasJoin Type
I_MaintOrderTechObj _MaintOrderTechObj inner
I_MaintOrderGoodsMovement I_MaintOrderGoodsMovement from

Annotations (6)

NameValueLevelField
EndUserText.label Historic Materials view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PHISTMAT view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (7)

KeyFieldSource TableSource FieldDescription
TechnicalObject I_MaintOrderTechObj TechnicalObject Technical Object
TechObjIsEquipOrFuncnlLoc I_MaintOrderTechObj TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
Material I_MaintOrderGoodsMovement Material Vehicle Model
Plant I_MaintOrderGoodsMovement Plant Valuation Area
StorageLocation I_MaintOrderGoodsMovement StorageLocation StorageLocation
MaintenanceOrder I_MaintOrderGoodsMovement MaintenanceOrder Order
DocumentDate I_MaintOrderGoodsMovement DocumentDate Journal Entry Date

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 P_HistMaterialMalfuncManage.
-- 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: PHISTMAT

CREATE VIEW P_HistMaterialMalfuncManage AS
SELECT
  _MaintOrderTechObj.TechnicalObject AS TechnicalObject,
  _MaintOrderTechObj.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  I_MaintOrderGoodsMovement.Material AS Material,
  I_MaintOrderGoodsMovement.Plant AS Plant,
  I_MaintOrderGoodsMovement.StorageLocation AS StorageLocation,
  I_MaintOrderGoodsMovement.MaintenanceOrder AS MaintenanceOrder,
  I_MaintOrderGoodsMovement.DocumentDate AS DocumentDate
FROM I_MaintOrderGoodsMovement
INNER JOIN I_MaintOrderTechObj AS _MaintOrderTechObj ON /* join condition not captured in parsed metadata */
;

Learn More