C_InhReprItmMngReprObjNote

DDL: C_INHREPRITMMNGREPROBJNOTE Type: view_entity CONSUMPTION
22 Fields 1 Data Sources

Notes for Manage Service Objects

C_InhReprItmMngReprObjNote is a Consumption CDS View that provides data about "Notes for Manage Service Objects" in SAP S/4HANA. It reads from 1 data source (R_InhRepairItemNoteTP) and exposes 22 fields with key fields InHouseRepair, InHouseRepairItem, TextObjectType, Language.

Data Sources (1)

SourceAliasJoin Type
R_InhRepairItemNoteTP R_InhRepairItemNoteTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Notes for Manage Service Objects view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.query.implementedBy ABAP:CL_CRMS4_REPA_QY_NOTE_ITEM view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY InHouseRepair InHouseRepair
KEY InHouseRepairItem InHouseRepairItem
KEY TextObjectType TextObjectType Text ID
KEY Language Language Report Text Language
InHouseRepairItemUUID InHouseRepairItemUUID
TextObjectCategory TextObjectCategory Text object
InhRepairNoteText InhRepairNoteText User Group
LastChangeDateTime LastChangeDateTime Timestamp
CustMgmtObjectType 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
_InHouseRepair _InHouseRepair

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 C_InhReprItmMngReprObjNote.
-- 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 C_InhReprItmMngReprObjNote AS
SELECT
  InHouseRepair,
  InHouseRepairItem,
  TextObjectType,
  Language,
  InHouseRepairItemUUID,
  TextObjectCategory,
  InhRepairNoteText,
  LastChangeDateTime,
  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 R_InhRepairItemNoteTP
;

Learn More