I_ShippingPoint

DDL: I_SHIPPINGPOINT SQL: ISDSHIPPINGPNT Type: view BASIC Package: VDM_LE_SHP_COMMON

Shipping Point

I_ShippingPoint is a Basic CDS View (Dimension) that provides data about "Shipping Point" in SAP S/4HANA. It reads from 1 data source (tvst) and exposes 9 fields with key field ShippingPoint. It has 2 associations to related views. It is exposed through 7 OData services (C_SALESORDERMANAGE_SD, UI_CUSTOMERRETURNMANAGE, UI_RFM_SLSORD_PRGS_MONITOR, ...). Part of development package VDM_LE_SHP_COMMON.

1 data source(s) Exposed by 7 service(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
tvst tvst from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ShippingPointText _Text $projection.ShippingPoint = _Text.ShippingPoint
[0..1] I_Country _ActiveDepartureCountry $projection.ActiveDepartureCountry = _ActiveDepartureCountry.Country

Annotations (16)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ShippingPoint view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Shipping Point view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDSHIPPINGPNT view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name ShippingPoint view

OData Services (7)

ServiceBindingVersionContractRelease
C_SALESORDERMANAGE_SD C_SALESORDERMANAGE_SRV V4 C1 NOT_RELEASED
UI_CUSTOMERRETURNMANAGE UI_CUSTOMERRETURNMANAGE V4 C1 NOT_RELEASED
UI_RFM_SLSORD_PRGS_MONITOR UI_RFM_SLSORD_PRGS_MONITOR V2 C1 NOT_RELEASED
UI_SALESCONTRACTMANAGE UI_SALESCONTRACTMANAGE V4 C1 NOT_RELEASED
UI_SALESDOCUMENTMANAGE UI_SALESDOCUMENTMANAGE V4 C1 NOT_RELEASED
UI_SALESQUOTATIONMANAGE UI_SALESQUOTATIONMANAGE V4 C1 NOT_RELEASED
UI_SLSORDERWITHOUTCHARGEMANAGE UI_SLSORDERWITHOUTCHARGEMANAGE V4 C1 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ShippingPoint vstel
ActiveDepartureCountry aland
AddressID adrnr
PickingConfirmation koqui
ConfigDeprecationCode configdeprecationcode
LoadingTimeWorkHoursInMinutes
PickPackTimeWorkHoursInMinutes
_Text _Text
_ActiveDepartureCountry _ActiveDepartureCountry 
@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