I_DeliveryDocumentAddress

DDL: I_DELIVERYDOCUMENTADDRESS Type: view_entity COMPOSITE Package: VDM_LE_SHP_COMMON

Delivery Document Address

I_DeliveryDocumentAddress is a Composite CDS View that provides data about "Delivery Document Address" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentCompletePartners) and exposes 53 fields with key fields DeliveryDocument, PartnerFunction. It has 3 associations to related views. Part of development package VDM_LE_SHP_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentCompletePartners DeliveryDocumentAddress from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_DeliveryDocument _DeliveryDocument _DeliveryDocument.DeliveryDocument = DeliveryDocumentAddress.SDDocument
[0..1] I_Supplier _AuthSupplier $projection.Supplier = _AuthSupplier.Supplier
[0..1] I_Customer _AuthCustomer $projection.Customer = _AuthCustomer.Customer

Annotations (8)

NameValueLevelField
EndUserText.label Delivery Document Address view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument SDDocument
KEY PartnerFunction
AddressID AddressID
FormOfAddress _DfltAddrRprstn FormOfAddress
OrganizationName1 _DfltAddrRprstn OrganizationName1
OrganizationName2 _DfltAddrRprstn OrganizationName2
OrganizationName3 _DfltAddrRprstn OrganizationName3
OrganizationName4 _DfltAddrRprstn OrganizationName4
Building _DfltAddrRprstn Building
Floor _DfltAddrRprstn Floor
RoomNumber _DfltAddrRprstn RoomNumber
CareOfName _DfltAddrRprstn CareOfName
StreetPrefixName1 _DfltAddrRprstn StreetPrefixName1
StreetPrefixName2 _DfltAddrRprstn StreetPrefixName2
StreetName _DfltAddrRprstn StreetName
HouseNumber _DfltAddrRprstn HouseNumber
HouseNumberSupplementText _DfltAddrRprstn HouseNumberSupplementText
StreetSuffixName1 _DfltAddrRprstn StreetSuffixName1
StreetSuffixName2 _DfltAddrRprstn StreetSuffixName2
DistrictName _DfltAddrRprstn DistrictName
VillageName _DfltAddrRprstn VillageName
PostalCode _DfltAddrRprstn PostalCode
CityName _DfltAddrRprstn CityName
SecondaryRegionName _DfltAddrRprstn SecondaryRegionName
Country _DfltAddrRprstn Country
Region _DfltAddrRprstn Region
AddressTimeZone _DfltAddrRprstn AddressTimeZone
TaxJurisdiction _DfltAddrRprstn TaxJurisdiction
TransportZone _DfltAddrRprstn TransportZone
POBox _DfltAddrRprstn POBox
POBoxIsWithoutNumber _DfltAddrRprstn POBoxIsWithoutNumber
DeliveryServiceTypeCode _DfltAddrRprstn DeliveryServiceTypeCode
DeliveryServiceNumber _DfltAddrRprstn DeliveryServiceNumber
POBoxLobbyName _DfltAddrRprstn POBoxLobbyName
POBoxPostalCode _DfltAddrRprstn POBoxPostalCode
POBoxDeviatingCityName _DfltAddrRprstn POBoxDeviatingCityName
POBoxDeviatingCountry _DfltAddrRprstn POBoxDeviatingCountry
POBoxDeviatingRegion _DfltAddrRprstn POBoxDeviatingRegion
CompanyPostalCode _DfltAddrRprstn CompanyPostalCode
POBoxAddrNonDeliverableReason _DfltAddrRprstn POBoxAddrNonDeliverableReason
CorrespondenceLanguage _DfltAddrRprstn CorrespondenceLanguage
PhoneAreaCodeSubscriberNumber
PhoneExtensionNumber
FaxAreaCodeSubscriberNumber
FaxExtensionNumber
EmailAddress
PrfrdCommMediumType _DfltAddrRprstn PrfrdCommMediumType
_DeliveryDocument _DeliveryDocument
Customer Customer
Supplier Supplier
ShippingPoint _DeliveryDocument ShippingPoint
_AuthSupplier _AuthSupplier
_AuthCustomer _AuthCustomer
@EndUserText.label: 'Delivery Document Address'

@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}

@VDM.viewType: #COMPOSITE

@ObjectModel: {
  usageType.dataClass: #MIXED,
  usageType.serviceQuality: #C,
  usageType.sizeCategory: #L
}

@Metadata.ignorePropagatedAnnotations: true
define view entity I_DeliveryDocumentAddress
  as select from I_SDDocumentCompletePartners as DeliveryDocumentAddress
  association [0..1] to I_DeliveryDocument as _DeliveryDocument on _DeliveryDocument.DeliveryDocument = DeliveryDocumentAddress.SDDocument
  association [0..1] to I_Supplier         as _AuthSupplier     on $projection.Supplier = _AuthSupplier.Supplier
  association [0..1] to I_Customer         as _AuthCustomer     on $projection.Customer = _AuthCustomer.Customer
{

  key SDDocument                                                                  as DeliveryDocument,
  key cast(PartnerFunction as parvw_unv preserving type )                         as PartnerFunction,

      AddressID,

      ///////////////////

      // Section: Name //

      ///////////////////



      // Title

      _DfltAddrRprstn.FormOfAddress,
      //Name for organisation

      _DfltAddrRprstn.OrganizationName1,
      _DfltAddrRprstn.OrganizationName2,
      _DfltAddrRprstn.OrganizationName3,
      _DfltAddrRprstn.OrganizationName4,

      /////////////////////////////

      // Section: Street Address //

      /////////////////////////////


      // Buildling Code ... Room ... Floor

      _DfltAddrRprstn.Building,
      _DfltAddrRprstn.Floor,
      _DfltAddrRprstn.RoomNumber,

      // c/o

      _DfltAddrRprstn.CareOfName,

      // Street 2

      _DfltAddrRprstn.StreetPrefixName1,
      // Street 3

      _DfltAddrRprstn.StreetPrefixName2,
      // Street ... House Number ... Suppl.

      _DfltAddrRprstn.StreetName,
      _DfltAddrRprstn.HouseNumber,
      _DfltAddrRprstn.HouseNumberSupplementText,
      // Street 4

      _DfltAddrRprstn.StreetSuffixName1,
      // Street 5

      _DfltAddrRprstn.StreetSuffixName2,
      // District

      _DfltAddrRprstn.DistrictName,
      // Home City

      _DfltAddrRprstn.VillageName,
      // Postal Code ... City

      _DfltAddrRprstn.PostalCode,
      _DfltAddrRprstn.CityName,
      // County

      _DfltAddrRprstn.SecondaryRegionName,
      // Township


      // Country

      _DfltAddrRprstn.Country,
      // Region

      _DfltAddrRprstn.Region,
      // Time Zone ... Tax Juris.

      _DfltAddrRprstn.AddressTimeZone,
      _DfltAddrRprstn.TaxJurisdiction,
      // Transportation Zone

      _DfltAddrRprstn.TransportZone,

      /////////////////////////////

      // Section: PO Box Address //

      /////////////////////////////


      // PO Box ... PO box w/o no.

      _DfltAddrRprstn.POBox,
      _DfltAddrRprstn.POBoxIsWithoutNumber,
      // Dlvry Serv/Dlvry No

      _DfltAddrRprstn.DeliveryServiceTypeCode,
      _DfltAddrRprstn.DeliveryServiceNumber,
      // PO Box Lobby

      _DfltAddrRprstn.POBoxLobbyName,
      // Postal code ... Other City

      _DfltAddrRprstn.POBoxPostalCode,
      _DfltAddrRprstn.POBoxDeviatingCityName,
      // Other Country ... Other Region

      _DfltAddrRprstn.POBoxDeviatingCountry,
      _DfltAddrRprstn.POBoxDeviatingRegion,
      // Company Postal Code

      _DfltAddrRprstn.CompanyPostalCode,
      // Undeliverable

      _DfltAddrRprstn.POBoxAddrNonDeliverableReason,

      ////////////////////////////

      // Section: Communication //

      ////////////////////////////

      _DfltAddrRprstn.CorrespondenceLanguage,
      // Telephone ... Extension

      _DfltAddrRprstn._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber,
      _DfltAddrRprstn._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber,
      // Fax ... Extension

      _DfltAddrRprstn._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber,
      _DfltAddrRprstn._CurrentDfltFaxNumber.FaxExtensionNumber,
      // E-Mail

      _DfltAddrRprstn._CurrentDfltEmailAddress.EmailAddress,
      // Standard Method

      _DfltAddrRprstn.PrfrdCommMediumType,

      _DeliveryDocument,

      //only for DCL

      @Consumption.hidden: true
      Customer,
      @Consumption.hidden: true
      Supplier,
      @Consumption.hidden: true
      _DeliveryDocument.ShippingPoint,
      _AuthSupplier,
      _AuthCustomer

}
where
       DeliveryDocumentAddress.SDDocumentItem is initial
  and(
       _DeliveryDocument.SDDocumentCategory   = 'J'
    or _DeliveryDocument.SDDocumentCategory   = '7'
    or _DeliveryDocument.SDDocumentCategory   = 'T'
  );