I_INHOUSEREPAIRITEM
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA