I_ServiceEntrySheetItemNote

DDL: I_SERVICEENTRYSHEETITEMNOTE Type: view_entity COMPOSITE Package: APPL_MM_PUR_SES_TR
12 Fields 2 Data Sources

Service Entry Sheet Item Note

I_ServiceEntrySheetItemNote is a Composite CDS View that provides data about "Service Entry Sheet Item Note" in SAP S/4HANA. It reads from 2 data sources (I_NOTEBASIC, I_ServiceEntrySheetItem) and exposes 12 fields with key fields ServiceEntrySheet, ServiceEntrySheetItem, NoteBasicUUID. Part of development package APPL_MM_PUR_SES_TR.

Data Sources (2)

SourceAliasJoin Type
I_NOTEBASIC I_NOTEBASIC inner
I_ServiceEntrySheetItem ServiceEntrySheetItem from

Annotations (8)

NameValueLevelField
EndUserText.label Service Entry Sheet Item Note view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet I_ServiceEntrySheetItem ServiceEntrySheet Service Entry Sheet
KEY ServiceEntrySheetItem I_ServiceEntrySheetItem ServiceEntrySheetItem Item Number of SES
KEY NoteBasicUUID I_NOTEBASIC NoteBasicUUID Note ID
ServiceEntrySheetItemUniqueID I_ServiceEntrySheetItem ServiceEntrySheetItemUniqueID
PurchasingOrganization I_ServiceEntrySheetItem PurchasingOrganization Purchasing Organization
PurchasingGroup I_ServiceEntrySheetItem PurchasingGroup Purchasing Group
Plant I_ServiceEntrySheetItem Plant Valuation Area
IsEndOfPurposeBlocked I_ServiceEntrySheetItem IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
NoteBasicObjectNodeType I_NOTEBASIC NoteBasicObjectNodeType SAP Object Type
NoteBasicType I_NOTEBASIC NoteBasicType Name
NoteBasicLanguage I_NOTEBASIC NoteBasicLanguage Lang.
NoteBasicContent I_NOTEBASIC NoteBasicContent Content of note

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 I_ServiceEntrySheetItemNote.
-- 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 I_ServiceEntrySheetItemNote AS
SELECT
  ServiceEntrySheetItem.ServiceEntrySheet AS ServiceEntrySheet,
  ServiceEntrySheetItem.ServiceEntrySheetItem AS ServiceEntrySheetItem,
  I_NOTEBASIC.NoteBasicUUID AS NoteBasicUUID,
  ServiceEntrySheetItem.ServiceEntrySheetItemUniqueID AS ServiceEntrySheetItemUniqueID,
  ServiceEntrySheetItem.PurchasingOrganization AS PurchasingOrganization,
  ServiceEntrySheetItem.PurchasingGroup AS PurchasingGroup,
  ServiceEntrySheetItem.Plant AS Plant,
  ServiceEntrySheetItem.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  I_NOTEBASIC.NoteBasicObjectNodeType AS NoteBasicObjectNodeType,
  I_NOTEBASIC.NoteBasicType AS NoteBasicType,
  I_NOTEBASIC.NoteBasicLanguage AS NoteBasicLanguage,
  I_NOTEBASIC.NoteBasicContent AS NoteBasicContent
FROM I_ServiceEntrySheetItem AS ServiceEntrySheetItem
INNER JOIN I_NOTEBASIC ON /* join condition not captured in parsed metadata */
;

Learn More