R_STOItemNoteDraft

DDL: R_STOITEMNOTEDRAFT Type: view_entity BASIC Package: RAP_MM_STO
14 Fields 1 Data Sources

Item Note for STO - Draft

R_STOItemNoteDraft is a Basic CDS View that provides data about "Item Note for STO - Draft" in SAP S/4HANA. It reads from 1 data source (mmstoitmnote_d) and exposes 14 fields with key fields StockTransportOrder, StockTransportOrderItem, TextObjectType, Language, DraftUUID. Part of development package RAP_MM_STO.

Data Sources (1)

SourceAliasJoin Type
mmstoitmnote_d mmstoitmnote_d from

Annotations (8)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Item Note for STO - Draft view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY StockTransportOrder stocktransportorder STO Number
KEY StockTransportOrderItem stocktransportorderitem STO Item
KEY TextObjectType textobjecttype Text ID
KEY Language language Report Text Language
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
PlainLongText plainlongtext Long Text
STOItemUniqueID stoitemuniqueid Document Item
StkTransptOrdDraftUUID stktransptorddraftuuid Draft Document ID
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE

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_STOItemNoteDraft.
-- 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_STOItemNoteDraft AS
SELECT
  StockTransportOrder,
  StockTransportOrderItem,
  TextObjectType,
  Language,
  DraftUUID,
  ParentDraftUUID,
  PlainLongText,
  STOItemUniqueID,
  StkTransptOrdDraftUUID,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity
FROM mmstoitmnote_d
;

Learn More