I_DeliveryDocumentAddress
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)
| Source | Alias | Join Type |
|---|---|---|
| I_SDDocumentCompletePartners | DeliveryDocumentAddress | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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'
);
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA