R_STOShippingTP

DDL: R_STOSHIPPINGTP Type: view_entity TRANSACTIONAL Package: RAP_MM_STO
19 Fields 1 Data Sources

Shipping Data for STO - TP

R_STOShippingTP is a Transactional CDS View that provides data about "Shipping Data for STO - TP" in SAP S/4HANA. It reads from 1 data source (R_StockTransportOrderShipping) and exposes 19 fields with key fields StockTransportOrder, StockTransportOrderItem. Part of development package RAP_MM_STO.

Data Sources (1)

SourceAliasJoin Type
R_StockTransportOrderShipping R_StockTransportOrderShipping from

Annotations (8)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Shipping Data for STO - TP view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY StockTransportOrder StockTransportOrder STO Number
KEY StockTransportOrderItem StockTransportOrderItem STO Item
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
StockTransportOrderType StockTransportOrderType Document Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Plant Plant Valuation Area
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentItem _PurchasingDocumentItem
_ShippingCondition _ShippingCondition
_ShippingPoint _ShippingPoint
_StockTransportOrderItem _StockTransportOrderItem
_StockTransportOrder _StockTransportOrder

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_STOShippingTP.
-- 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_STOShippingTP AS
SELECT
  StockTransportOrder,
  StockTransportOrderItem,
  ShippingCondition,
  ShippingPoint,
  Route,
  LoadingGroup,
  TransportationGroup,
  DeliveryPriority,
  UnloadingPointName,
  StockTransportOrderType,
  PurchasingOrganization,
  PurchasingGroup,
  Plant
FROM R_StockTransportOrderShipping
;

Learn More