A_OutbDeliveryAddress_2

DDL: A_OUTBDELIVERYADDRESS_2 SQL: AOUTBDELIVERYAD2 Type: view COMPOSITE

Outbound Delivery Address

A_OutbDeliveryAddress_2 is a Composite CDS View that provides data about "Outbound Delivery Address" in SAP S/4HANA. It reads from 1 data source (I_DeliveryPartnerAddress) and exposes 52 fields with key fields DeliveryDocument, PartnerFunction. It has 1 association to related views.

1 data source(s) 52 fields

Data Sources (1)

SourceAliasJoin Type
I_DeliveryPartnerAddress I_DeliveryPartnerAddress from

Associations (1)

CardinalityTargetAliasCondition
[0..1] A_OutbDeliveryHeader_1 _OutbDeliveryDocument _OutbDeliveryDocument.DeliveryDocument = $projection.DeliveryDocument

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName AOUTBDELIVERYAD2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Outbound Delivery Address view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument
KEY PartnerFunction PartnerFunction
AddressID AddressID
DeliveryVersion _OutbDeliveryDocument DeliveryVersion
FormOfAddress FormOfAddress
BusinessPartnerName1 BusinessPartnerName1
BusinessPartnerName2 BusinessPartnerName2
BusinessPartnerName3 BusinessPartnerName3
BusinessPartnerName4 BusinessPartnerName4
PersonFamilyName PersonFamilyName
PersonGivenName PersonGivenName
Building Building
Floor Floor
RoomNumber RoomNumber
CareOfName CareOfName
StreetPrefixName StreetPrefixName
AdditionalStreetPrefixName AdditionalStreetPrefixName
StreetName StreetName
HouseNumber HouseNumber
HouseNumberSupplementText HouseNumberSupplementText
StreetSuffixName StreetSuffixName
AdditionalStreetSuffixName AdditionalStreetSuffixName
District District
HomeCityName HomeCityName
PostalCode PostalCode
CityName CityName
County County
Country Country
Region Region
AddressTimeZone AddressTimeZone
TaxJurisdiction TaxJurisdiction
TransportZone TransportZone
POBox POBox
POBoxIsWithoutNumber POBoxIsWithoutNumber
DeliveryServiceTypeCode DeliveryServiceTypeCode
DeliveryServiceNumber DeliveryServiceNumber
POBoxLobbyName POBoxLobbyName
POBoxPostalCode POBoxPostalCode
POBoxDeviatingCityName POBoxDeviatingCityName
POBoxDeviatingCountry POBoxDeviatingCountry
POBoxDeviatingRegion POBoxDeviatingRegion
CompanyPostalCode CompanyPostalCode
AddressPostBoxUnusable AddressPostBoxUnusable
PhoneNumber PhoneNumber
PhoneNumberExtension PhoneNumberExtension
MobilePhoneNumber MobilePhoneNumber
FaxNumber FaxNumber
FaxNumberExtension FaxNumberExtension
EmailAddress EmailAddress
PrfrdCommMediumType PrfrdCommMediumType
CorrespondenceLanguage CorrespondenceLanguage
_OutbDeliveryDocument _OutbDeliveryDocument 
@AbapCatalog.sqlViewName: 'AOUTBDELIVERYAD2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Outbound Delivery Address'
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@VDM.viewType: #COMPOSITE
@ObjectModel: {
  usageType.dataClass: #TRANSACTIONAL,
  usageType.serviceQuality: #C,
  usageType.sizeCategory: #XL
}

define view A_OutbDeliveryAddress_2 as select from I_DeliveryPartnerAddress 
  association [0..1] to A_OutbDeliveryHeader_1 as _OutbDeliveryDocument on _OutbDeliveryDocument.DeliveryDocument = $projection.DeliveryDocument
{
  key DeliveryDocument,
  key PartnerFunction,
  AddressID,
  _OutbDeliveryDocument.DeliveryVersion,
  FormOfAddress,
  BusinessPartnerName1,
  BusinessPartnerName2,
  BusinessPartnerName3,
  BusinessPartnerName4,
  PersonFamilyName,
  PersonGivenName,
  Building,
  Floor,
  RoomNumber,
  CareOfName,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  StreetName,
  HouseNumber,
  HouseNumberSupplementText,
  StreetSuffixName,
  AdditionalStreetSuffixName,
  District,
  HomeCityName,
  PostalCode,
  CityName,
  County,
  Country,
  Region,
  AddressTimeZone,
  TaxJurisdiction,
  TransportZone,
  POBox,
  POBoxIsWithoutNumber,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  POBoxLobbyName,
  POBoxPostalCode,
  POBoxDeviatingCityName,
  POBoxDeviatingCountry,
  POBoxDeviatingRegion,
  CompanyPostalCode,
  AddressPostBoxUnusable,
  PhoneNumber,
  PhoneNumberExtension,
  MobilePhoneNumber,
  FaxNumber,
  FaxNumberExtension,
  EmailAddress,
  PrfrdCommMediumType,
  CorrespondenceLanguage,
  
  _OutbDeliveryDocument
} where
   _OutbDeliveryDocument.SDDocumentCategory = 'J';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_OUTBDELIVERYHEADER_1",
"I_DELIVERYPARTNERADDRESS"
],
"ASSOCIATED":
[
"A_OUTBDELIVERYHEADER_1"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More