I_SHIPPINGPOINT

CDS View

Shipping Point

I_SHIPPINGPOINT is a CDS View in S/4HANA. Shipping Point. It contains 3 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 3 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_JITShippingPointVH view_entity from CONSUMPTION Consumption view vh for Shipping Point
C_ShippingPointVH view from CONSUMPTION Shipping Point Value Help
I_DeliveryPickViewShpPoint view from COMPOSITE Delivery Pick View
I_DigitalVehShippingPoint view_entity from BASIC Digital Vehicle Shipping Point
I_ShippingPointStdVH view from COMPOSITE Shipping Point

Fields (3)

KeyField CDS FieldsUsed in Views
KEY ShippingPoint ShippingPoint 1
_Text _Text 1
PickingConfirmation PickingConfirmation 1 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'ShippingPoint'
@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Shipping Point'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#CHECK
@AbapCatalog.sqlViewName: 'ISDSHIPPINGPNT'
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #ANALYTICAL_DIMENSION ]
@ObjectModel.modelingPattern: [ #ANALYTICAL_DIMENSION ]
@ObjectModel.sapObjectNodeType.name: 'ShippingPoint'

define view I_ShippingPoint
as select from
tvst
association [0..*] to I_ShippingPointText as _Text on $projection.ShippingPoint = _Text.ShippingPoint
association [0..1] to I_Country as _ActiveDepartureCountry on $projection.ActiveDepartureCountry = _ActiveDepartureCountry.Country
{
    @ObjectModel.text.association: '_Text'
    key vstel             as ShippingPoint,
    @ObjectModel.foreignKey.association: '_ActiveDepartureCountry'
    aland                 as ActiveDepartureCountry,
    adrnr                 as AddressID,
    koqui                 as PickingConfirmation,
    configdeprecationcode as ConfigDeprecationCode,
    cast(floor(division(floor(division(loadtg,10000,4)),24,2))
      + division(floor(division(cast(mod(cast(floor(division(loadtg,10000,4)) as abap.int8),24)*3600 + floor(division(loadtg - floor(division(loadtg,10000,4))*10000,100,2))*60
      + mod(cast(loadtg as abap.int8),100) as abap.int8),864,6)),100,2) as le_loadtg_day)                                               as LoadingTimeInWorkingDays,
    cast(floor(division(loadtn,10000,4))*60 + division(loadtn - floor(division(loadtn,10000,4))*10000,100,0) as le_loadtn_min)          as LoadingTimeWorkHoursInMinutes,
    cast(floor(division(floor(division(pipatg,10000,4)),24,2))
      + division(floor(division(cast(mod(cast(floor(division(pipatg,10000,4))as abap.int8),24)*3600 + floor(division(pipatg - floor(division(pipatg,10000,4))*10000,100,2))*60
      + mod(cast(pipatg as abap.int8),100) as abap.int8),864,6)),100,2) as le_pipatg_day)                                               as PickPackTimeInWorkingDays,
    cast(floor(division(pipatn,10000,4))*60 + division(pipatn - floor(division(pipatn,10000,4))*10000,100,0) as le_pipatn_min)          as PickPackTimeWorkHoursInMinutes,

    _Text,
    _ActiveDepartureCountry
};

Learn More