P_InHouseRepairItemStatusHist

DDL: P_INHOUSEREPAIRITEMSTATUSHIST SQL: PIHRITMSTH Type: view COMPOSITE
9 Fields 3 Data Sources

P_InHouseRepairItemStatusHist is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_InHouseRepairItem, P_InHouseRepairItemStatus, I_SrvcMgmtObjStsChgInformation) and exposes 9 fields with key field InHouseRepairItemUUID.

Data Sources (3)

SourceAliasJoin Type
I_InHouseRepairItem InhRepItem from
P_InHouseRepairItemStatus InhRepItemStatus inner
I_SrvcMgmtObjStsChgInformation StatusHistory inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PIHRITMSTH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey InHouseRepairItemUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY InHouseRepairItemUUID InHouseRepairItemUUID Push ItemGU
InHouseRepair I_InHouseRepairItem InHouseRepair
InHouseRepairItem I_InHouseRepairItem InHouseRepairItem
InhRepairItemStatus P_InHouseRepairItemStatus InhRepairItemStatus
InhRepairItemCategory P_InHouseRepairItemStatus InhRepairItemCategory Item Category
UserStatus P_InHouseRepairItemStatus UserStatus
_InhRepairItemCategory P_InHouseRepairItemStatus _InhRepairItemCategory
_InhRepairItemStatusText P_InHouseRepairItemStatus _InhRepairItemStatusText
clientNULLasStatusChangedDateTime

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_InHouseRepairItemStatusHist.
-- 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: PIHRITMSTH

CREATE VIEW P_InHouseRepairItemStatusHist AS
SELECT
  InHouseRepairItemUUID,
  InhRepItem.InHouseRepair AS InHouseRepair,
  InhRepItem.InHouseRepairItem AS InHouseRepairItem,
  InhRepItemStatus.InhRepairItemStatus AS InhRepairItemStatus,
  InhRepItemStatus.InhRepairItemCategory AS InhRepairItemCategory,
  InhRepItemStatus.UserStatus AS UserStatus,
  InhRepItemStatus._InhRepairItemCategory AS _InhRepairItemCategory,
  InhRepItemStatus._InhRepairItemStatusText AS _InhRepairItemStatusText,
  dats_tims_to_tstmp(StatusHistory.ChangeDocumentStatusDate , StatusHistory.ChangeDocumentStatusTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as StatusChangedDateTime AS clientNULLasStatusChangedDateTime
FROM I_InHouseRepairItem AS InhRepItem
INNER JOIN P_InHouseRepairItemStatus AS InhRepItemStatus ON /* join condition not captured in parsed metadata */
INNER JOIN I_SrvcMgmtObjStsChgInformation AS StatusHistory ON /* join condition not captured in parsed metadata */
;

Learn More