I_ServiceEntrySheetNote

DDL: I_SERVICEENTRYSHEETNOTE Type: view_entity COMPOSITE Package: APPL_MM_PUR_SES_TR
9 Fields 2 Data Sources

Service Entry Sheet Note

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

Data Sources (2)

SourceAliasJoin Type
I_NOTEBASIC I_NOTEBASIC inner
I_ServiceEntrySheet ServiceEntrySheet from

Annotations (8)

NameValueLevelField
EndUserText.label Service Entry Sheet 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 (9)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet I_ServiceEntrySheet ServiceEntrySheet Service Entry Sheet
KEY NoteBasicUUID I_NOTEBASIC NoteBasicUUID Note ID
PurchasingOrganization I_ServiceEntrySheet PurchasingOrganization Purchasing Organization
PurchasingGroup I_ServiceEntrySheet PurchasingGroup Purchasing Group
IsEndOfPurposeBlocked I_ServiceEntrySheet 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_ServiceEntrySheetNote.
-- 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_ServiceEntrySheetNote AS
SELECT
  ServiceEntrySheet.ServiceEntrySheet AS ServiceEntrySheet,
  I_NOTEBASIC.NoteBasicUUID AS NoteBasicUUID,
  ServiceEntrySheet.PurchasingOrganization AS PurchasingOrganization,
  ServiceEntrySheet.PurchasingGroup AS PurchasingGroup,
  ServiceEntrySheet.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_ServiceEntrySheet AS ServiceEntrySheet
INNER JOIN I_NOTEBASIC ON /* join condition not captured in parsed metadata */
;

Learn More