I_ShippingPointsPerPlant

DDL: I_SHIPPINGPOINTSPERPLANT Type: view_entity BASIC Package: VDM_LE_SHP_COMMON

Shipping points per plant

I_ShippingPointsPerPlant (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Supply Chain

I_ShippingPointsPerPlant is a Basic CDS View that provides data about "Shipping points per plant" in SAP S/4HANA. It reads from 1 data source (tvstz) and exposes 18 fields with key fields ShippingCondition, LoadingGroup, Plant. Part of development package VDM_LE_SHP_COMMON.

SAP Help Documentation

CategoryGeneric CDS Views for Delivery Documents
Purpose
This CDS view provides information about shipping points associated with each plant. You can use this view to analyze and manage shipping logistics by understanding each plant's proposed and alternative shipping points. This CDS view provides the data to answer the following business question: What are the proposed and alternative shipping points for each plant? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations This CDS view does not require any authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description LoadingGroup A grouping of materials that share the same loading requirements ShippingCondition General shipping strategy for the delivery of goods from the supplier to the customer Plant Plant ProposedShippingPoint Shipping Point proposed for plant, shipping condition, and loading group AlternativeShippingPoint1 to AlternativeShippingPoint11 Specifies a shipping point that you can enter during document processing as an alternative to the shipping point automatically proposed by the system There are eleven alternative shipping point fields available.

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessSupply Chain
Application ComponentLE-SHP-GF-2CL
CapabilitiesAssociation Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSupply Chain for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides information about shipping points associated with each plant. You can use this view to analyze and manage shipping logistics by understanding each plant's proposed and alternative shipping points.</p> <p>This CDS view provides the data to answer the following business question:</p> <ul> <li><p>What are the proposed and alternative shipping points for each plant?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
tvstz tvstz from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Shipping points per plant view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.modelingPattern #NONE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ShippingCondition vsbed Shipping Conditions
KEY LoadingGroup ladgr Loading Group
KEY Plant werks Receiving Plant
ProposedShippingPoint vstel Proposed Shipping Point
AlternativeShippingPoint1 vste1 Alternative Shipping Point
AlternativeShippingPoint2 vste2 Alternative Shipping Point
AlternativeShippingPoint3 vste3 Alternative Shipping Point
AlternativeShippingPoint4 vste4 Alternative Shipping Point
AlternativeShippingPoint5 vste5 Alternative Shipping Point
AlternativeShippingPoint6 vste6 Alternative Shipping Point
AlternativeShippingPoint7 vste7 Alternative Shipping Point
AlternativeShippingPoint8 vste8 Alternative Shipping Point
AlternativeShippingPoint9 vste9 Alternative Shipping Point
AlternativeShippingPoint10 vste10 Alternative Shipping Point
AlternativeShippingPoint11 vste11 Alternative Shipping Point
_LoadingGroup _LoadingGroup
_ShippingCondition _ShippingCondition
_Plant _Plant

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_ShippingPointsPerPlant.
-- 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_ShippingPointsPerPlant AS
SELECT
  vsbed AS ShippingCondition,
  ladgr AS LoadingGroup,
  werks AS Plant,
  vstel AS ProposedShippingPoint,
  vste1 AS AlternativeShippingPoint1,
  vste2 AS AlternativeShippingPoint2,
  vste3 AS AlternativeShippingPoint3,
  vste4 AS AlternativeShippingPoint4,
  vste5 AS AlternativeShippingPoint5,
  vste6 AS AlternativeShippingPoint6,
  vste7 AS AlternativeShippingPoint7,
  vste8 AS AlternativeShippingPoint8,
  vste9 AS AlternativeShippingPoint9,
  vste10 AS AlternativeShippingPoint10,
  vste11 AS AlternativeShippingPoint11
FROM tvstz
;