I_INHOUSEREPAIRITEM

CDS View

In-House Service Object

I_INHOUSEREPAIRITEM is a CDS View in S/4HANA. In-House Service Object. It contains 74 fields. 23 CDS views read from this table.

CDS Views using this table (23)

ViewTypeJoinVDMDescription
C_InhRepairProcessFlow view from CONSUMPTION Transaction History of In-House Service Object
C_InhRepairProcessFlow view union_all CONSUMPTION Transaction History of In-House Service Object
C_InhReprItmProcFlwInformation view_entity from CONSUMPTION Attributes of In-House Service Object
C_InhReprLogisticsProcessFlow view_entity from CONSUMPTION Process Flow for Log Process of ServObj
C_InhReprLogisticsProcessFlow view_entity union_all CONSUMPTION Process Flow for Log Process of ServObj
I_AllRepairObjectSituation view_entity from COMPOSITE Anchor for IHS Object Situations
I_InHouseRepairItemTP view_entity from TRANSACTIONAL In-House Service Object
I_InhRepairItemNote view inner BASIC Notes for In-House Service Object
I_RepairObjectSituation view from COMPOSITE In-House Service Object Situations
I_ReprObjCompltnNotPosblSitn view_entity from COMPOSITE IHS Object Completion Situation
I_ReprObjPrecheckDelayedSitn view_entity from COMPOSITE Anchor for Follow-Up Step of Precheck Pending
I_SrvcDocStatusChangeDocument view inner COMPOSITE Change Documents for Status
P_InHouseRepairItemStatusHist view from COMPOSITE
P_InhRepairItemChildCounter view_entity from COMPOSITE
P_InhRepairItemNote view_entity inner TRANSACTIONAL
P_InhReprItmLogsErrFndn view_entity from COMPOSITE
R_InhRepairItemCreditStatus view_entity from COMPOSITE Credit Status of Service Transaction
R_InhRepairItemRefObjectTP view_entity from TRANSACTIONAL Ref Objects of In-House Srvc Objct - TP
R_InhRepairItmFUPCustReturnTP view_entity from TRANSACTIONAL FollowUp Returns Ord Itm for IHR Itm - TP
R_InhRepairItmPartnerTP view_entity inner TRANSACTIONAL Partner of In-House Service Object - TP
R_InhRepairItmSrvcOrdTP view_entity from TRANSACTIONAL Related SrvcOrd for Inh Repr Item - TP
R_InhRepairItmSrvcQtanTP view_entity from TRANSACTIONAL Related SrvcQtan for Inh Repr Item - TP
R_SrvcOrdItmTransHistory view_entity inner COMPOSITE Transaction History in SRVO Item

Fields (74)

KeyField CDS FieldsUsed in Views
KEY CustMgmtObjectType CustMgmtObjectType,ServiceObjectType 8
KEY CustMgmtPrdcssrTransacObjType BusinessObjectType 1
KEY InHouseRepair InHouseRepair,PrecedingDocument,SubsequentDocument 16
KEY InHouseRepairItem InHouseRepairItem,PrecedingDocumentItem,RepairObject,SubsequentDocumentItem 17
KEY InHouseRepairItemUUID InHouseRepairItemUUID 11
KEY InhRepairItemObjectType BusinessObjectType,InhRepairItemObjectType 3
KEY ServiceDocument ServiceOrder 1
KEY ServiceDocumentItem ServiceOrderItem 1
KEY ServiceDocumentItemObjectType BusinessObjectType 1
_CustMgmtObjectType _CustMgmtObjectType 3
_InHouseRepair _InHouseRepair 3
_InhRepairItemAvailyStatus _InhRepairItemAvailyStatus 1
_InhRepairItemCategory _InhRepairItemCategory 4
_InhRepairItemHasError _InhRepairItemHasError 1
_InhRepairItemIsOpen _InhRepairItemIsOpen 1
_InhRepairItemStatus _InhRepairItemStatus 1
_InhRepairItemStatusText _InhRepairItemStatusText 1
_InhRepairItemSuplmntyStatus _InhRepairItemSuplmntyStatus 1
_InhRepairReferenceEquipment _InhRepairReferenceEquipment 1
_InhRepairReferenceEquipText _InhRepairReferenceEquipText 1
_InhReprItemSpecialStockType _InhReprItemSpecialStockType 1
_InhReprItemSpecialStockTypeT _InhReprItemSpecialStockTypeT 1
_InhReprItmInvtryUsblyCode _InhReprItmInvtryUsblyCode 1
_InhReprItmInvtryUsblyCodeTxt _InhReprItmInvtryUsblyCodeTxt 1
_OutboundDelivery _OutboundDelivery 1
_Plant _Plant 1
_Product _Product 1
_ProductText _ProductText 1
_QuantityUnitOfMeasure _QuantityUnitOfMeasure 1
_ServiceOrder _ServiceOrder 1
_ServiceQuotation _ServiceQuotation 1
_SrvcMgmtObjectStatus _SrvcMgmtObjectStatus 1
_StorageLocation _StorageLocation 1
CreatedByUser CreatedByUser 6
CreationDateTime CreationDateTime 2
DistributionChannel DistributionChannel 5
Division Division 5
InHouseRepairIsIntercompany InHouseRepairIsIntercompany 1
InHouseRepairItemCharUUID InHouseRepairItemCharUUID 3
InHouseRepairUUID InHouseRepairUUID 4
InhRepairItemAvailyStatus InhRepairItemAvailyStatus 4
InhRepairItemCategory InhRepairItemCategory 4
InhRepairItemDeliveryStatus InhRepairItemDeliveryStatus 1
InhRepairItemHasError InhRepairItemHasError 1
InhRepairItemIsObsolete InhRepairItemIsObsolete 1
InhRepairItemIsOpen InhRepairItemIsOpen 1
InhRepairItemSpecialStockType InhRepairItemSpecialStockType 1
InhRepairItemStatus InhRepairItemStatus 2
InhRepairItemSuplmntyStatus InhRepairItemSuplmntyStatus 1
InhRepairReferenceEquipment InhRepairReferenceEquipment 1
InhRepairType InhRepairType 11
InhReprItmInvtryUsabilityCode InhReprItmInvtryUsabilityCode 1
InhReprItmPartnerReferenceItem InhReprItmPartnerReferenceItem 1
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
OriginallyRequestedProduct OriginallyRequestedProduct 1
Plant Plant 2
PostingDate PostingDate 1
Product Product 2
ProductUUID ProductUUID 1
Quantity Quantity 2
QuantityUnit QuantityUnit 2
ReferenceCustomerReturnItem ReferenceCustomerReturnItem 1
RefRetsMgmtProcessItem RefRetsMgmtProcessItem 1
RefRetsMgmtProcItmQtySplit RefRetsMgmtProcItmQtySplit 1
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId 5
SalesGroup SalesGroup 5
SalesGroupOrgUnitID SalesGroupOrgUnitID 5
SalesOffice SalesOffice 5
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 5
SalesOrganization SalesOrganization 5
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 5
SerialNumber SerialNumber 2
StorageLocation StorageLocation 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- In-House Service Object
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INHOUSEREPAIRITEM (
    CUSTMGMTOBJECTTYPE,
    CUSTMGMTPRDCSSRTRANSACOBJTYPE,
    INHOUSEREPAIR,
    INHOUSEREPAIRITEM,
    INHOUSEREPAIRITEMUUID,
    INHREPAIRITEMOBJECTTYPE,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTITEMOBJECTTYPE,
    _CUSTMGMTOBJECTTYPE,
    _INHOUSEREPAIR,
    _INHREPAIRITEMAVAILYSTATUS,
    _INHREPAIRITEMCATEGORY,
    _INHREPAIRITEMHASERROR,
    _INHREPAIRITEMISOPEN,
    _INHREPAIRITEMSTATUS,
    _INHREPAIRITEMSTATUSTEXT,
    _INHREPAIRITEMSUPLMNTYSTATUS,
    _INHREPAIRREFERENCEEQUIPMENT,
    _INHREPAIRREFERENCEEQUIPTEXT,
    _INHREPRITEMSPECIALSTOCKTYPE,
    _INHREPRITEMSPECIALSTOCKTYPET,
    _INHREPRITMINVTRYUSBLYCODE,
    _INHREPRITMINVTRYUSBLYCODETXT,
    _OUTBOUNDDELIVERY,
    _PLANT,
    _PRODUCT,
    _PRODUCTTEXT,
    _QUANTITYUNITOFMEASURE,
    _SERVICEORDER,
    _SERVICEQUOTATION,
    _SRVCMGMTOBJECTSTATUS,
    _STORAGELOCATION,
    CREATEDBYUSER,
    CREATIONDATETIME,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    INHOUSEREPAIRISINTERCOMPANY,
    INHOUSEREPAIRITEMCHARUUID,
    INHOUSEREPAIRUUID,
    INHREPAIRITEMAVAILYSTATUS,
    INHREPAIRITEMCATEGORY,
    INHREPAIRITEMDELIVERYSTATUS,
    INHREPAIRITEMHASERROR,
    INHREPAIRITEMISOBSOLETE,
    INHREPAIRITEMISOPEN,
    INHREPAIRITEMSPECIALSTOCKTYPE,
    INHREPAIRITEMSTATUS,
    INHREPAIRITEMSUPLMNTYSTATUS,
    INHREPAIRREFERENCEEQUIPMENT,
    INHREPAIRTYPE,
    INHREPRITMINVTRYUSABILITYCODE,
    INHREPRITMPARTNERREFERENCEITEM,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    ORIGINALLYREQUESTEDPRODUCT,
    PLANT,
    POSTINGDATE,
    PRODUCT,
    PRODUCTUUID,
    QUANTITY,
    QUANTITYUNIT,
    REFERENCECUSTOMERRETURNITEM,
    REFRETSMGMTPROCESSITEM,
    REFRETSMGMTPROCITMQTYSPLIT,
    RESPEMPLOYEEBUSINESSPARTNERID,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    SERIALNUMBER,
    STORAGELOCATION,
    PRIMARY KEY (CUSTMGMTOBJECTTYPE, CUSTMGMTPRDCSSRTRANSACOBJTYPE, INHOUSEREPAIR, INHOUSEREPAIRITEM, INHOUSEREPAIRITEMUUID, INHREPAIRITEMOBJECTTYPE, SERVICEDOCUMENT, SERVICEDOCUMENTITEM, SERVICEDOCUMENTITEMOBJECTTYPE)
);