I_PT_DeliveryShipFromAddress

DDL: I_PT_DELIVERYSHIPFROMADDRESS SQL: IPTDELSHIPADDR Type: view COMPOSITE

View for Delivery Ship from address

I_PT_DeliveryShipFromAddress is a Composite CDS View that provides data about "View for Delivery Ship from address" in SAP S/4HANA. It reads from 1 data source (I_PT_SAFTShipFromAddress) and exposes 9 fields with key field DeliveryDocument. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_PT_SAFTShipFromAddress I_PT_SAFTShipFromAddress from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Address_2 _Address _Address.AddressID = $projection.AddressID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPTDELSHIPADDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label View for Delivery Ship from address view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument
AddressID AddressID
HouseNumber _Address HouseNumber
StreetName _Address StreetName
SupplierAddress
CityName _Address CityName
PostalCode _Address PostalCode
Region _Address Region
Country _Address Country 
@AbapCatalog.sqlViewName: 'IPTDELSHIPADDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'View for Delivery Ship from address'
define view I_PT_DeliveryShipFromAddress as select from I_PT_SAFTShipFromAddress
  association [0..1] to I_Address_2 as _Address on _Address.AddressID = $projection.AddressID
{
  key DeliveryDocument,
      AddressID,
      _Address.HouseNumber                                                as HouseNumber,
      _Address.StreetName                                                 as StreetName,
      coalesce(concat(_Address.HouseNumber,_Address.StreetName),'omisso') as SupplierAddress,
      _Address.CityName                                                   as CityName,
      _Address.PostalCode                                                 as PostalCode,
      _Address.Region                                                     as Region,
      _Address.Country                                                    as Country
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS_2",
"I_PT_SAFTSHIPFROMADDRESS"
],
"ASSOCIATED":
[
"I_ADDRESS_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More