I_INHOUSEREPAIR
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
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