I_INHOUSEREPAIRITEM

CDS View
56 Fields 14 CDS Views

In-House Repair Item

I_INHOUSEREPAIRITEM is a CDS View in S/4HANA. In-House Repair Item. It contains 56 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
C_InhRepairProcessFlow view from CONSUMPTION Transaction History of In-House Repair Item
C_InhRepairProcessFlow view union_all CONSUMPTION Transaction History of In-House Repair Item
I_AllRepairObjectSituation view_entity from COMPOSITE Anchor for Repair Object Situations
I_InHouseRepairItemTP view_entity from TRANSACTIONAL In-House Repair Item
I_InhRepairItemNote view inner BASIC Notes for In-House Repair Item
I_RepairObjectSituation view from COMPOSITE Repair Object Situations
I_ReprObjCompltnNotPosblSitn view_entity from COMPOSITE Repair 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_InhRepairItemNote view_entity inner TRANSACTIONAL
R_InhRepairItmFUPCustReturnTP view_entity from TRANSACTIONAL FollowUp Returns Ord Itm for IHR Itm - 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

Fields (56)

KeyField CDS FieldsUsed in Views
KEY CustMgmtObjectType CustMgmtObjectType,ServiceObjectType 6
KEY InHouseRepair InHouseRepair,PrecedingDocument,SubsequentDocument 11
KEY InHouseRepairItem InHouseRepairItem,RepairObject 11
KEY InHouseRepairItemUUID InHouseRepairItemUUID 9
_CustMgmtObjectType _CustMgmtObjectType 3
_InHouseRepair _InHouseRepair 3
_InhRepairItemAvailyStatus _InhRepairItemAvailyStatus 1
_InhRepairItemCategory _InhRepairItemCategory 4
_InhRepairItemHasError _InhRepairItemHasError 1
_InhRepairItemIsOpen _InhRepairItemIsOpen 1
_InhRepairItemStatus _InhRepairItemStatus 1
_InhRepairItemSuplmntyStatus _InhRepairItemSuplmntyStatus 1
_InhRepairReferenceEquipment _InhRepairReferenceEquipment 1
_InhRepairReferenceEquipText _InhRepairReferenceEquipText 1
_OutboundDelivery _OutboundDelivery 1
_Product _Product 1
_ProductText _ProductText 1
_QuantityUnitOfMeasure _QuantityUnitOfMeasure 1
_ServiceOrder _ServiceOrder 1
_ServiceQuotation _ServiceQuotation 1
_SrvcMgmtObjectStatus _SrvcMgmtObjectStatus 1
CreatedByUser CreatedByUser 5
CreationDateTime CreationDateTime 1
DistributionChannel DistributionChannel 2
Division Division 2
InHouseRepairItemCharUUID InHouseRepairItemCharUUID 2
InHouseRepairUUID InHouseRepairUUID 4
InhRepairItemAvailyStatus InhRepairItemAvailyStatus 3
InhRepairItemCategory InhRepairItemCategory 4
InhRepairItemDeliveryStatus InhRepairItemDeliveryStatus 1
InhRepairItemHasError InhRepairItemHasError 1
InhRepairItemIsOpen InhRepairItemIsOpen 1
InhRepairItemObjectType InhRepairItemObjectType 1
InhRepairItemStatus InhRepairItemStatus 1
InhRepairItemSuplmntyStatus InhRepairItemSuplmntyStatus 1
InhRepairReferenceEquipment InhRepairReferenceEquipment 1
InhRepairType InhRepairType 9
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
OriginallyRequestedProduct OriginallyRequestedProduct 1
PostingDate PostingDate 1
Product Product 1
ProductUUID ProductUUID 1
Quantity Quantity 1
QuantityUnit QuantityUnit 1
ReferenceCustomerReturnItem ReferenceCustomerReturnItem 1
RefRetsMgmtProcessItem RefRetsMgmtProcessItem 1
RefRetsMgmtProcItmQtySplit RefRetsMgmtProcItmQtySplit 1
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId 2
SalesGroup SalesGroup 2
SalesGroupOrgUnitID SalesGroupOrgUnitID 2
SalesOffice SalesOffice 2
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 2
SalesOrganization SalesOrganization 2
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 2
SerialNumber SerialNumber 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 Repair Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INHOUSEREPAIRITEM (
    CUSTMGMTOBJECTTYPE,
    INHOUSEREPAIR,
    INHOUSEREPAIRITEM,
    INHOUSEREPAIRITEMUUID,
    _CUSTMGMTOBJECTTYPE,
    _INHOUSEREPAIR,
    _INHREPAIRITEMAVAILYSTATUS,
    _INHREPAIRITEMCATEGORY,
    _INHREPAIRITEMHASERROR,
    _INHREPAIRITEMISOPEN,
    _INHREPAIRITEMSTATUS,
    _INHREPAIRITEMSUPLMNTYSTATUS,
    _INHREPAIRREFERENCEEQUIPMENT,
    _INHREPAIRREFERENCEEQUIPTEXT,
    _OUTBOUNDDELIVERY,
    _PRODUCT,
    _PRODUCTTEXT,
    _QUANTITYUNITOFMEASURE,
    _SERVICEORDER,
    _SERVICEQUOTATION,
    _SRVCMGMTOBJECTSTATUS,
    CREATEDBYUSER,
    CREATIONDATETIME,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    INHOUSEREPAIRITEMCHARUUID,
    INHOUSEREPAIRUUID,
    INHREPAIRITEMAVAILYSTATUS,
    INHREPAIRITEMCATEGORY,
    INHREPAIRITEMDELIVERYSTATUS,
    INHREPAIRITEMHASERROR,
    INHREPAIRITEMISOPEN,
    INHREPAIRITEMOBJECTTYPE,
    INHREPAIRITEMSTATUS,
    INHREPAIRITEMSUPLMNTYSTATUS,
    INHREPAIRREFERENCEEQUIPMENT,
    INHREPAIRTYPE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    ORIGINALLYREQUESTEDPRODUCT,
    POSTINGDATE,
    PRODUCT,
    PRODUCTUUID,
    QUANTITY,
    QUANTITYUNIT,
    REFERENCECUSTOMERRETURNITEM,
    REFRETSMGMTPROCESSITEM,
    REFRETSMGMTPROCITMQTYSPLIT,
    RESPEMPLOYEEBUSINESSPARTNERID,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    SERIALNUMBER,
    PRIMARY KEY (CUSTMGMTOBJECTTYPE, INHOUSEREPAIR, INHOUSEREPAIRITEM, INHOUSEREPAIRITEMUUID)
);

Learn More