C_SchedgAgrmtItemNotesTP

DDL: C_SCHEDGAGRMTITEMNOTESTP SQL: CSCHAGRITMNOTETP Type: view CONSUMPTION
10 Fields 1 Data Sources 2 Associations

Scheduling Agreement Item Notes

C_SchedgAgrmtItemNotesTP is a Consumption CDS View that provides data about "Scheduling Agreement Item Notes" in SAP S/4HANA. It reads from 1 data source (I_SchedgAgrmtItemNotesTP) and exposes 10 fields with key fields Language, DocumentText, TechnicalObjectType, ArchObjectNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SchedgAgrmtItemNotesTP I_SchedgAgrmtItemNotesTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_Schedgagrmthdr _SchedgAgrmtHdrWithDraft _SchedgAgrmtHdrWithDraft.SchedulingAgreement = $projection.SchedulingAgreement
[1..1] C_Schedgagrmtitm _SchedgAgrmtItmWithDraft _SchedgAgrmtItmWithDraft.SchedulingAgreement = $projection.SchedulingAgreement and _SchedgAgrmtItmWithDraft.SchedulingAgreementItem = $projection.SchedulingAgreementItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSCHAGRITMNOTETP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Scheduling Agreement Item Notes view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Language Language Report Text Language
KEY DocumentText DocumentText Text ID
KEY TechnicalObjectType TechnicalObjectType Text object
KEY ArchObjectNumber ArchObjectNumber Text Name
SchedulingAgreement SchedulingAgreement Scheduling Agreement
SchedulingAgreementItem SchedulingAgreementItem Schedule Item Number
NoteDescription NoteDescription Long Text
FixedIndicator FixedIndicator Fixing
_SchedgAgrmtHdrWithDraft _SchedgAgrmtHdrWithDraft
_SchedgAgrmtItmWithDraft _SchedgAgrmtItmWithDraft

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_SchedgAgrmtItemNotesTP.
-- 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.
-- SQL view name: CSCHAGRITMNOTETP

CREATE VIEW C_SchedgAgrmtItemNotesTP AS
SELECT
  Language,
  DocumentText,
  TechnicalObjectType,
  ArchObjectNumber,
  SchedulingAgreement,
  SchedulingAgreementItem,
  NoteDescription,
  FixedIndicator
FROM I_SchedgAgrmtItemNotesTP
LEFT OUTER JOIN C_Schedgagrmthdr AS _SchedgAgrmtHdrWithDraft ON _SchedgAgrmtHdrWithDraft.SchedulingAgreement = SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN C_Schedgagrmtitm AS _SchedgAgrmtItmWithDraft ON _SchedgAgrmtItmWithDraft.SchedulingAgreement = SchedulingAgreement AND _SchedgAgrmtItmWithDraft.SchedulingAgreementItem = SchedulingAgreementItem  -- association [1..1]
;

Learn More