I_INHOUSEREPAIR

CDS View

In-House Service

I_INHOUSEREPAIR is a CDS View in S/4HANA. In-House Service. It contains 31 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_InhRepairProcFlowInformation view_entity from CONSUMPTION In-House Repair Attributes in Process Flow
ESH_N_INHOUSEREPAIR view from Anchor view -INHOUSEREPAIR
I_AllRepairObjectSituation view_entity inner COMPOSITE Anchor for Repair Object Situations
I_InHouseRepairSituation view_entity from COMPOSITE In-House Repair Situations
I_InHouseRepairTP view_entity from TRANSACTIONAL In-House Repair
I_InHouseRepairVH view_entity from COMPOSITE In-House Repair
I_InhRepairNote view_entity inner BASIC Notes for In-House Repair
I_RepairObjectSituation view_entity inner COMPOSITE Repair Object Situations
I_ReprObjCompltnNotPosblSitn view_entity inner COMPOSITE Repair Object Completion Situation
I_SrvcDocStatusChangeDocument view inner COMPOSITE Change Documents for Status
P_InhRepairNote view_entity inner TRANSACTIONAL Notes for In-House Repair
R_InhRepairFUPCustReturnTP view_entity from TRANSACTIONAL Follow-Up Returns Order for IHR - TP

Fields (31)

KeyField CDS FieldsUsed in Views
KEY CustMgmtObjectType CustMgmtObjectType 3
KEY InHouseRepair InHouseRepair 4
KEY InHouseRepairCharUUID ChangeDocObject 1
KEY InHouseRepairUUID InHouseRepairUUID 4
_CustMgmtObjectType _CustMgmtObjectType 1
_DistributionChannel _DistributionChannel 4
_Division _Division 4
_InhRepairType _InhRepairType 1
_RepairOrders _RepairOrders 1
_ResponsibleEmployee _ResponsibleEmployee 1
_SalesGroup _SalesGroup 4
_SalesGroupOrgUnit _SalesGroupOrgUnit 1
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2 1
_SalesOffice _SalesOffice 4
_SalesOfficeOrgUnit _SalesOfficeOrgUnit 1
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2 1
_SalesOrganization _SalesOrganization 4
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit 1
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2 1
CreatedByUser CreatedByUser 1
DistributionChannel DistributionChannel 6
Division Division 6
InhRepairType InhRepairType 3
PostingDate PostingDate 1
ResponsibleEmployee RespEmployeeBusinessPartnerId,ResponsibleEmployee 3
SalesGroup SalesGroup 6
SalesGroupOrgUnitID SalesGroupOrgUnitID 3
SalesOffice SalesOffice 6
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 3
SalesOrganization SalesOrganization 6
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 3

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INHOUSEREPAIR (
    CUSTMGMTOBJECTTYPE,
    INHOUSEREPAIR,
    INHOUSEREPAIRCHARUUID,
    INHOUSEREPAIRUUID,
    _CUSTMGMTOBJECTTYPE,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _INHREPAIRTYPE,
    _REPAIRORDERS,
    _RESPONSIBLEEMPLOYEE,
    _SALESGROUP,
    _SALESGROUPORGUNIT,
    _SALESGROUPORGUNIT_2,
    _SALESOFFICE,
    _SALESOFFICEORGUNIT,
    _SALESOFFICEORGUNIT_2,
    _SALESORGANIZATION,
    _SALESORGANIZATIONORGUNIT,
    _SALESORGANIZATIONORGUNIT_2,
    CREATEDBYUSER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    INHREPAIRTYPE,
    POSTINGDATE,
    RESPONSIBLEEMPLOYEE,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    PRIMARY KEY (CUSTMGMTOBJECTTYPE, INHOUSEREPAIR, INHOUSEREPAIRCHARUUID, INHOUSEREPAIRUUID)
);