R_STOShippingDraft

DDL: R_STOSHIPPINGDRAFT Type: view_entity BASIC Package: RAP_MM_STO
21 Fields 1 Data Sources

Shipping Data for STO - Draft

R_STOShippingDraft is a Basic CDS View that provides data about "Shipping Data for STO - Draft" in SAP S/4HANA. It reads from 1 data source (mmstoshipping_d) and exposes 21 fields with key fields StockTransportOrder, StockTransportOrderItem, DraftUUID. Part of development package RAP_MM_STO.

Data Sources (1)

SourceAliasJoin Type
mmstoshipping_d mmstoshipping_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 Shipping Data for STO - Draft view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY StockTransportOrder stocktransportorder STO Number
KEY StockTransportOrderItem stocktransportorderitem STO Item
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
ShippingCondition shippingcondition Shipping Conditions
ShippingPoint shippingpoint Shipping Point
Route route Vehicle route
LoadingGroup loadinggroup Loading Group
TransportationGroup transportationgroup Trans. Group
DeliveryPriority deliverypriority Delivery Prior.
UnloadingPointName unloadingpointname Unloading Point Name
StkTransptOrdDraftUUID stktransptorddraftuuid Draft Document ID
StockTransportOrderType stocktransportordertype Document Type
PurchasingOrganization purchasingorganization Purchasing Organization
PurchasingGroup purchasinggroup Purchasing Group
Plant plant Valuation Area
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_STOShippingDraft.
-- 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_STOShippingDraft AS
SELECT
  StockTransportOrder,
  StockTransportOrderItem,
  DraftUUID,
  ParentDraftUUID,
  ShippingCondition,
  ShippingPoint,
  Route,
  LoadingGroup,
  TransportationGroup,
  DeliveryPriority,
  UnloadingPointName,
  StkTransptOrdDraftUUID,
  StockTransportOrderType,
  PurchasingOrganization,
  PurchasingGroup,
  Plant,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity
FROM mmstoshipping_d
;

Learn More