R_InhRepairItemNoteTP

DDL: R_INHREPAIRITEMNOTETP Type: view_entity TRANSACTIONAL
25 Fields 1 Data Sources 5 Associations

Notes for In-House Repair Item

R_InhRepairItemNoteTP is a Transactional CDS View that provides data about "Notes for In-House Repair Item" in SAP S/4HANA. It reads from 1 data source (P_InhRepairItemNote) and exposes 25 fields with key fields InHouseRepair, InHouseRepairItem, TextObjectType, Language. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_InhRepairItemNote ihritemnote from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_InHouseRepairTP _InHouseRepairTP $projection.InHouseRepair = _InHouseRepairTP.InHouseRepair
[1..1] I_InHouseRepair _InHouseRepair $projection.CustMgmtObjectType = _InHouseRepair.CustMgmtObjectType and $projection.InHouseRepair = _InHouseRepair.InHouseRepair
[0..1] I_TextObjectType _TextObjectType $projection.TextObjectType = _TextObjectType.TextObjectType and $projection.TextObjectCategory = _TextObjectType.TextObjectCategory
[0..1] I_TextObjectCategory _TextObjectCategory $projection.TextObjectCategory = _TextObjectCategory.TextObjectCategory
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (8)

NameValueLevelField
EndUserText.label Notes for In-House Repair Item view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY InHouseRepair P_InhRepairItemNote InHouseRepair Transaction ID
KEY InHouseRepairItem P_InhRepairItemNote InHouseRepairItem Service Document
KEY TextObjectType P_InhRepairItemNote TextObjectType Text ID
KEY Language P_InhRepairItemNote Language Report Text Language
InHouseRepairItemUUID P_InhRepairItemNote InHouseRepairItemUUID
TextObjectCategory P_InhRepairItemNote TextObjectCategory Text object
CreatedByUser P_InhRepairItemNote CreatedByUser User Name
InhRepairNoteText _InoteTemp text User Group
LastChangeDateTime _InHouseRepairItemTP LastChangeDateTime Timestamp
CustMgmtObjectType P_InhRepairItemNote CustMgmtObjectType
RespEmployeeBusinessPartnerId _InHouseRepair ResponsibleEmployee Employee Resp.
SalesOrganization _InHouseRepair SalesOrganization Sales Organization
DistributionChannel _InHouseRepair DistributionChannel RefDistCh-Cust/Mat.
Division _InHouseRepair Division Internal Division ID
SalesOffice _InHouseRepair SalesOffice Sales Office
SalesGroup _InHouseRepair SalesGroup Sales Group
SalesOrganizationOrgUnitID _InHouseRepair SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID _InHouseRepair SalesOfficeOrgUnitID
SalesGroupOrgUnitID _InHouseRepair SalesGroupOrgUnitID
_TextObjectType _TextObjectType
_TextObjectCategory _TextObjectCategory
_Language _Language
_InHouseRepairItemTP _InHouseRepairItemTP
_InHouseRepair _InHouseRepair
_InHouseRepairTP _InHouseRepairTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_InhRepairItemNoteTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_InhRepairItemNoteTP AS
SELECT
  ihritemnote.InHouseRepair AS InHouseRepair,
  ihritemnote.InHouseRepairItem AS InHouseRepairItem,
  ihritemnote.TextObjectType AS TextObjectType,
  ihritemnote.Language AS Language,
  ihritemnote.InHouseRepairItemUUID AS InHouseRepairItemUUID,
  ihritemnote.TextObjectCategory AS TextObjectCategory,
  ihritemnote.CreatedByUser AS CreatedByUser,
  _InoteTemp.text AS InhRepairNoteText,
  _InHouseRepairItemTP.LastChangeDateTime AS LastChangeDateTime,
  ihritemnote.CustMgmtObjectType AS CustMgmtObjectType,
  _InHouseRepair.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  _InHouseRepair.SalesOrganization AS SalesOrganization,
  _InHouseRepair.DistributionChannel AS DistributionChannel,
  _InHouseRepair.Division AS Division,
  _InHouseRepair.SalesOffice AS SalesOffice,
  _InHouseRepair.SalesGroup AS SalesGroup,
  _InHouseRepair.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  _InHouseRepair.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  _InHouseRepair.SalesGroupOrgUnitID AS SalesGroupOrgUnitID
FROM P_InhRepairItemNote AS ihritemnote
LEFT OUTER JOIN I_InHouseRepairTP AS _InHouseRepairTP ON InHouseRepair = _InHouseRepairTP.InHouseRepair  -- association [1..1]
LEFT OUTER JOIN I_InHouseRepair AS _InHouseRepair ON CustMgmtObjectType = _InHouseRepair.CustMgmtObjectType AND InHouseRepair = _InHouseRepair.InHouseRepair  -- association [1..1]
LEFT OUTER JOIN I_TextObjectType AS _TextObjectType ON TextObjectType = _TextObjectType.TextObjectType AND TextObjectCategory = _TextObjectType.TextObjectCategory  -- association [0..1]
LEFT OUTER JOIN I_TextObjectCategory AS _TextObjectCategory ON TextObjectCategory = _TextObjectCategory.TextObjectCategory  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More