I_AllRepairObjectSituation

DDL: I_ALLREPAIROBJECTSITUATION Type: view_entity COMPOSITE
32 Fields 2 Data Sources 3 Associations

Anchor for Repair Object Situations

I_AllRepairObjectSituation is a Composite CDS View that provides data about "Anchor for Repair Object Situations" in SAP S/4HANA. It reads from 2 data sources (I_InHouseRepair, I_InHouseRepairItem) and exposes 32 fields with key fields CustMgmtObjectType, InHouseRepair, RepairObject. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InHouseRepair InHRepair inner
I_InHouseRepairItem InhRepItem from

Associations (3)

CardinalityTargetAliasCondition
[0..1] E_InHouseRepairItem _RepairObjectExtension $projection.CustMgmtObjectType = _RepairObjectExtension.CustMgmtObjectType and $projection.InHouseRepair = _RepairObjectExtension.InHouseRepair and $projection.RepairObject = _RepairObjectExtension.InHouseRepairItem
[0..1] R_InhRepairItmNrOfOpnMaintOrds _InhReprItmNrOfOpnMaintOrd $projection.InHouseRepairItemUUID = _InhReprItmNrOfOpnMaintOrd.InHouseRepairItemUUID
[0..1] P_InhRepairItmNrOfBillgRdyItms _InhRepairItmNrOfBillgRdyItms $projection.InHouseRepairItemUUID = _InhRepairItmNrOfBillgRdyItms.InHouseRepairItemUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Anchor for Repair Object Situations view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.uniqueIdField InHouseRepairItemUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CustMgmtObjectType I_InHouseRepairItem CustMgmtObjectType Trans. Cat.
KEY InHouseRepair I_InHouseRepairItem InHouseRepair
KEY RepairObject I_InHouseRepairItem InHouseRepairItem
InHouseRepairItemUUID I_InHouseRepairItem InHouseRepairItemUUID Push ItemGU
InhRepairStatus
RepairObjectStatus
ResponsibleEmployeeUserID RespEmployeeUser UserID User Name
InHouseRepairUUID I_InHouseRepairItem InHouseRepairUUID Unique Identifier
CreatedByUser I_InHouseRepairItem CreatedByUser User Name
InhRepairItemCategory I_InHouseRepairItem InhRepairItemCategory Item Category
SalesOrganization I_InHouseRepair SalesOrganization Sales Organization
DistributionChannel I_InHouseRepair DistributionChannel RefDistCh-Cust/Mat.
Division I_InHouseRepair Division Internal Division ID
SalesOffice I_InHouseRepair SalesOffice Sales Office
SalesGroup I_InHouseRepair SalesGroup Sales Group
InhRepairType I_InHouseRepairItem InhRepairType Type of Data
RespEmployeeBusinessPartnerId I_InHouseRepair ResponsibleEmployee Employee Resp.
SalesOrganizationOrgUnitID I_InHouseRepair SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID I_InHouseRepair SalesOfficeOrgUnitID Sales Office
SalesGroupOrgUnitID I_InHouseRepair SalesGroupOrgUnitID Sales Group
InhRepairItemAvailyStatus I_InHouseRepairItem InhRepairItemAvailyStatus Availability
ServiceDocumentIsOpen
NumberOfOpenMaintenanceOrders _InhReprItmNrOfOpnMaintOrd NumberOfOpenMaintenanceOrders
NrOfSrvcDocItmsReadyForBilling _InhRepairItmNrOfBillgRdyItms NrOfSrvcDocItmsReadyForBilling
_InHouseRepair I_InHouseRepairItem _InHouseRepair
_SalesOrganization I_InHouseRepair _SalesOrganization
_DistributionChannel I_InHouseRepair _DistributionChannel
_Division I_InHouseRepair _Division
_SalesOffice I_InHouseRepair _SalesOffice
_SalesGroup I_InHouseRepair _SalesGroup
_CustMgmtObjectType I_InHouseRepairItem _CustMgmtObjectType
_InhRepairItemCategory I_InHouseRepairItem _InhRepairItemCategory

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_AllRepairObjectSituation.
-- 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_AllRepairObjectSituation AS
SELECT
  InhRepItem.CustMgmtObjectType AS CustMgmtObjectType,
  InhRepItem.InHouseRepair AS InHouseRepair,
  InhRepItem.InHouseRepairItem AS RepairObject,
  InhRepItem.InHouseRepairItemUUID AS InHouseRepairItemUUID,
  cast(InHRepair.InhRepairStatus as crms4_inhrepair_status preserving type) AS InhRepairStatus,
  cast(InhRepItem.InhRepairItemStatus as crms4_repair_obj_status preserving type) AS RepairObjectStatus,
  RespEmployeeUser.UserID AS ResponsibleEmployeeUserID,
  InhRepItem.InHouseRepairUUID AS InHouseRepairUUID,
  InhRepItem.CreatedByUser AS CreatedByUser,
  InhRepItem.InhRepairItemCategory AS InhRepairItemCategory,
  InHRepair.SalesOrganization AS SalesOrganization,
  InHRepair.DistributionChannel AS DistributionChannel,
  InHRepair.Division AS Division,
  InHRepair.SalesOffice AS SalesOffice,
  InHRepair.SalesGroup AS SalesGroup,
  InhRepItem.InhRepairType AS InhRepairType,
  InHRepair.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  InHRepair.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  InHRepair.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  InHRepair.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  InhRepItem.InhRepairItemAvailyStatus AS InhRepairItemAvailyStatus,
  cast(InhRepItem._ServiceOrder._SuccessorServiceTransaction.ServiceDocumentIsOpen as crms4_serv_doc_is_open preserving type) AS ServiceDocumentIsOpen,
  _InhReprItmNrOfOpnMaintOrd.NumberOfOpenMaintenanceOrders AS NumberOfOpenMaintenanceOrders,
  _InhRepairItmNrOfBillgRdyItms.NrOfSrvcDocItmsReadyForBilling AS NrOfSrvcDocItmsReadyForBilling,
  InhRepItem._InHouseRepair AS _InHouseRepair,
  InHRepair._SalesOrganization AS _SalesOrganization,
  InHRepair._DistributionChannel AS _DistributionChannel,
  InHRepair._Division AS _Division,
  InHRepair._SalesOffice AS _SalesOffice,
  InHRepair._SalesGroup AS _SalesGroup,
  InhRepItem._CustMgmtObjectType AS _CustMgmtObjectType,
  InhRepItem._InhRepairItemCategory AS _InhRepairItemCategory
FROM I_InHouseRepairItem AS InhRepItem
INNER JOIN I_InHouseRepair AS InHRepair ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_InHouseRepairItem AS _RepairObjectExtension ON CustMgmtObjectType = _RepairObjectExtension.CustMgmtObjectType AND InHouseRepair = _RepairObjectExtension.InHouseRepair AND RepairObject = _RepairObjectExtension.InHouseRepairItem  -- association [0..1]
LEFT OUTER JOIN R_InhRepairItmNrOfOpnMaintOrds AS _InhReprItmNrOfOpnMaintOrd ON InHouseRepairItemUUID = _InhReprItmNrOfOpnMaintOrd.InHouseRepairItemUUID  -- association [0..1]
LEFT OUTER JOIN P_InhRepairItmNrOfBillgRdyItms AS _InhRepairItmNrOfBillgRdyItms ON InHouseRepairItemUUID = _InhRepairItmNrOfBillgRdyItms.InHouseRepairItemUUID  -- association [0..1]
;

Learn More