I_PurchasingDeliveryAddressTP
Purchasing Delivery Address - TP
I_PurchasingDeliveryAddressTP is a Transactional CDS View that provides data about "Purchasing Delivery Address - TP" in SAP S/4HANA. It reads from 1 data source (I_Address_2) and exposes 68 fields with key fields AddressID, AddressPersonID, AddressRepresentationCode. It has 1 association to related views. Part of development package RAP_MM_PUR_RFQ.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_Address_2 | Address | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_LanguageText | _LanguageText | _LanguageText.Language = $projection.CorrespondenceLanguage and _LanguageText.LanguageCode = $projection.CorrespondenceLanguage |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IPURDELADDR | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Purchasing Delivery Address - TP | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view |
Fields (68)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | AddressID | I_Address_2 | AddressID | |
| KEY | AddressPersonID | I_Address_2 | AddressPersonID | |
| KEY | AddressRepresentationCode | I_Address_2 | AddressRepresentationCode | |
| AddressObjectType | I_Address_2 | AddressObjectType | ||
| CorrespondenceLanguage | I_Address_2 | CorrespondenceLanguage | ||
| PrfrdCommMediumType | I_Address_2 | PrfrdCommMediumType | ||
| AddresseeFullName | I_Address_2 | AddresseeFullName | ||
| PersonGivenName | I_Address_2 | PersonGivenName | ||
| PersonFamilyName | I_Address_2 | PersonFamilyName | ||
| OrganizationName1 | I_Address_2 | OrganizationName1 | ||
| OrganizationName2 | I_Address_2 | OrganizationName2 | ||
| OrganizationName3 | I_Address_2 | OrganizationName3 | ||
| OrganizationName4 | I_Address_2 | OrganizationName4 | ||
| AddressSearchTerm1 | I_Address_2 | AddressSearchTerm1 | ||
| AddressSearchTerm2 | I_Address_2 | AddressSearchTerm2 | ||
| CityNumber | I_Address_2 | CityNumber | ||
| CityName | I_Address_2 | CityName | ||
| DistrictName | I_Address_2 | DistrictName | ||
| VillageName | I_Address_2 | VillageName | ||
| PostalCode | I_Address_2 | PostalCode | ||
| CompanyPostalCode | I_Address_2 | CompanyPostalCode | ||
| Street | I_Address_2 | Street | ||
| StreetName | I_Address_2 | StreetName | ||
| StreetAddrNonDeliverableReason | I_Address_2 | StreetAddrNonDeliverableReason | ||
| StreetPrefixName1 | I_Address_2 | StreetPrefixName1 | ||
| StreetPrefixName2 | I_Address_2 | StreetPrefixName2 | ||
| StreetSuffixName1 | I_Address_2 | StreetSuffixName1 | ||
| StreetSuffixName2 | I_Address_2 | StreetSuffixName2 | ||
| HouseNumber | I_Address_2 | HouseNumber | ||
| HouseNumberSupplementText | I_Address_2 | HouseNumberSupplementText | ||
| Building | I_Address_2 | Building | ||
| Floor | I_Address_2 | Floor | ||
| RoomNumber | I_Address_2 | RoomNumber | ||
| Country | I_Address_2 | Country | ||
| Region | I_Address_2 | Region | ||
| FormOfAddress | I_Address_2 | FormOfAddress | ||
| TaxJurisdiction | I_Address_2 | TaxJurisdiction | ||
| TransportZone | I_Address_2 | TransportZone | ||
| POBox | I_Address_2 | POBox | ||
| POBoxAddrNonDeliverableReason | I_Address_2 | POBoxAddrNonDeliverableReason | ||
| POBoxIsWithoutNumber | I_Address_2 | POBoxIsWithoutNumber | ||
| POBoxPostalCode | I_Address_2 | POBoxPostalCode | ||
| POBoxLobbyName | I_Address_2 | POBoxLobbyName | ||
| POBoxDeviatingCityName | I_Address_2 | POBoxDeviatingCityName | ||
| POBoxDeviatingRegion | I_Address_2 | POBoxDeviatingRegion | ||
| POBoxDeviatingCountry | I_Address_2 | POBoxDeviatingCountry | ||
| CareOfName | I_Address_2 | CareOfName | ||
| DeliveryServiceTypeCode | I_Address_2 | DeliveryServiceTypeCode | ||
| DeliveryServiceNumber | I_Address_2 | DeliveryServiceNumber | ||
| AddressTimeZone | I_Address_2 | AddressTimeZone | ||
| SecondaryRegion | I_Address_2 | SecondaryRegion | ||
| SecondaryRegionName | I_Address_2 | SecondaryRegionName | ||
| TertiaryRegion | I_Address_2 | TertiaryRegion | ||
| TertiaryRegionName | I_Address_2 | TertiaryRegionName | ||
| RegionalStructureCheckStatus | I_Address_2 | RegionalStructureCheckStatus | ||
| AddressGroup | I_Address_2 | AddressGroup | ||
| _OrganizationAddress | _OrganizationAddress | |||
| _PersonAddress | _PersonAddress | |||
| _EmailAddress | _EmailAddress | |||
| _PhoneNumber | _PhoneNumber | |||
| _FaxNumber | _FaxNumber | |||
| _UniformResourceIdentifier | _UniformResourceIdentifier | |||
| _CurrentDfltEmailAddress | _CurrentDfltEmailAddress | |||
| _CurrentDfltMobilePhoneNumber | _CurrentDfltMobilePhoneNumber | |||
| _CurrentDfltLandlinePhoneNmbr | _CurrentDfltLandlinePhoneNmbr | |||
| _CurrentDfltFaxNumber | _CurrentDfltFaxNumber | |||
| _MainWebsiteURL | _MainWebsiteURL | |||
| _LanguageText | _LanguageText |
@AbapCatalog.sqlViewName: 'IPURDELADDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Purchasing Delivery Address - TP'
@ObjectModel: { semanticKey: ['AddressID'],
usageType.dataClass: #TRANSACTIONAL,
usageType.serviceQuality: #C,
usageType.sizeCategory: #L }
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
viewType: #TRANSACTIONAL,
lifecycle.contract.type: #SAP_INTERNAL_API
}
define view I_PurchasingDeliveryAddressTP
as select from I_Address_2 as Address
association [0..1] to I_LanguageText as _LanguageText on _LanguageText.Language = $projection.CorrespondenceLanguage
and _LanguageText.LanguageCode = $projection.CorrespondenceLanguage
{
key Address.AddressID,
key Address.AddressPersonID,
key Address.AddressRepresentationCode,
Address.AddressObjectType,
Address.CorrespondenceLanguage,
Address.PrfrdCommMediumType,
Address.AddresseeFullName,
Address.PersonGivenName,
Address.PersonFamilyName,
Address.OrganizationName1,
Address.OrganizationName2,
Address.OrganizationName3,
Address.OrganizationName4,
Address.AddressSearchTerm1,
Address.AddressSearchTerm2,
Address.CityNumber,
Address.CityName,
Address.DistrictName,
Address.VillageName,
Address.PostalCode,
Address.CompanyPostalCode,
Address.Street,
Address.StreetName,
// @EndUserText.label: 'Street Address Non-Deliverable Reason'
Address.StreetAddrNonDeliverableReason,
Address.StreetPrefixName1,
Address.StreetPrefixName2,
Address.StreetSuffixName1,
Address.StreetSuffixName2,
Address.HouseNumber,
Address.HouseNumberSupplementText,
Address.Building,
Address.Floor,
Address.RoomNumber,
Address.Country,
Address.Region,
Address.FormOfAddress,
Address.TaxJurisdiction,
Address.TransportZone,
Address.POBox,
// @EndUserText.label: 'PO Box Address Non-Deliverable Reason'
Address.POBoxAddrNonDeliverableReason,
Address.POBoxIsWithoutNumber,
Address.POBoxPostalCode,
Address.POBoxLobbyName,
Address.POBoxDeviatingCityName,
Address.POBoxDeviatingRegion,
Address.POBoxDeviatingCountry,
Address.CareOfName,
Address.DeliveryServiceTypeCode,
Address.DeliveryServiceNumber,
Address.AddressTimeZone,
Address.SecondaryRegion,
Address.SecondaryRegionName,
Address.TertiaryRegion,
Address.TertiaryRegionName,
Address.RegionalStructureCheckStatus,
Address.AddressGroup,
_OrganizationAddress,
_PersonAddress,
_EmailAddress,
_PhoneNumber,
_FaxNumber,
_UniformResourceIdentifier,
_CurrentDfltEmailAddress,
_CurrentDfltMobilePhoneNumber,
_CurrentDfltLandlinePhoneNmbr,
_CurrentDfltFaxNumber,
_MainWebsiteURL,
_LanguageText
}
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