I_ProposedShipgPointPerPlnt

DDL: I_PROPOSEDSHIPGPOINTPERPLNT SQL: ILEPROSHIPPOINT Type: view COMPOSITE Package: VDM_LE_SHP_COMMON
6 Fields 1 Data Sources 1 Associations

Proposed Shipping Point Per Plant

I_ProposedShipgPointPerPlnt is a Composite CDS View that provides data about "Proposed Shipping Point Per Plant" in SAP S/4HANA. It reads from 1 data source (I_ShippingPointsPerPlant) and exposes 6 fields with key fields LoadingGroup, ShippingCondition, Plant, StorageLocation. It has 1 association to related views. Part of development package VDM_LE_SHP_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_ShippingPointsPerPlant I_ShippingPointsPerPlant from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ShippingPoint _ProposedShippingPoint $projection.ProposedShippingPoint = _ProposedShippingPoint.ShippingPoint

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Proposed Shipping Point Per Plant view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ILEPROSHIPPOINT view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY LoadingGroup LoadingGroup Loading Group
KEY ShippingCondition ShippingCondition Shipping Conditions
KEY Plant Plant Valuation Area
KEY StorageLocation
ProposedShippingPoint ProposedShippingPoint ShpPtDeparture
_ProposedShippingPoint _ProposedShippingPoint

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_ProposedShipgPointPerPlnt.
-- 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: ILEPROSHIPPOINT

CREATE VIEW I_ProposedShipgPointPerPlnt AS
SELECT
  LoadingGroup,
  ShippingCondition,
  Plant,
  cast( ' ' as lgort_d preserving type ) AS StorageLocation,
  ProposedShippingPoint
FROM I_ShippingPointsPerPlant
LEFT OUTER JOIN I_ShippingPoint AS _ProposedShippingPoint ON ProposedShippingPoint = _ProposedShippingPoint.ShippingPoint  -- association [1..1]
;

Learn More