I_PurchaseReqnDeliveryAddress
Pur Reqn Delivery Address Basic View
I_PurchaseReqnDeliveryAddress is a Composite CDS View that provides data about "Pur Reqn Delivery Address Basic View" in SAP S/4HANA. It reads from 1 data source (I_PurchaseReqnAddress) and exposes 60 fields with key fields PurchaseRequisition, PurchaseRequisitionItem. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PurchaseReqnAddress | _PurchaseReqnAddress | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | R_PurchaseReqnItem | _PurchaseReqnItem | _PurchaseReqnItem.PurchaseRequisition = $projection.PurchaseRequisition and _PurchaseReqnItem.PurchaseRequisitionItem = $projection.PurchaseRequisitionItem |
| [1..1] | I_PurchaseReqn | _PurchaseReqn | _PurchaseReqn.PurchaseRequisition = $projection.PurchaseRequisition |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IPURREQNDELIVADD | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Pur Reqn Delivery Address Basic View | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #COMPOSITE | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view |
Fields (60)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseRequisition | I_PurchaseReqnAddress | PurchaseRequisition | |
| KEY | PurchaseRequisitionItem | I_PurchaseReqnAddress | PurchaseRequisitionItem | |
| AddressID | I_PurchaseReqnAddress | AddressID | ||
| AddressType | I_PurchaseReqnAddress | AddressType | ||
| Plant | I_PurchaseReqnAddress | Plant | ||
| StorageLocation | I_PurchaseReqnAddress | StorageLocation | ||
| ManualDeliveryAddressID | I_PurchaseReqnAddress | ManualDeliveryAddressID | ||
| ItemDeliveryAddressID | I_PurchaseReqnAddress | ItemDeliveryAddressID | ||
| CareOfName | I_PurchaseReqnAddress | CareOfName | ||
| AdditionalStreetSuffixName | I_PurchaseReqnAddress | AdditionalStreetSuffixName | ||
| CorrespondenceLanguage | I_PurchaseReqnAddress | CorrespondenceLanguage | ||
| PrfrdCommMediumType | I_PurchaseReqnAddress | PrfrdCommMediumType | ||
| POBox | I_PurchaseReqnAddress | POBox | ||
| POBoxIsWithoutNumber | I_PurchaseReqnAddress | POBoxIsWithoutNumber | ||
| POBoxPostalCode | I_PurchaseReqnAddress | POBoxPostalCode | ||
| POBoxLobbyName | I_PurchaseReqnAddress | POBoxLobbyName | ||
| POBoxDeviatingCityName | I_PurchaseReqnAddress | POBoxDeviatingCityName | ||
| POBoxDeviatingRegion | I_PurchaseReqnAddress | POBoxDeviatingRegion | ||
| POBoxDeviatingCountry | I_PurchaseReqnAddress | POBoxDeviatingCountry | ||
| DeliveryServiceTypeCode | I_PurchaseReqnAddress | DeliveryServiceTypeCode | ||
| DeliveryServiceNumber | I_PurchaseReqnAddress | DeliveryServiceNumber | ||
| AddressTimeZone | I_PurchaseReqnAddress | AddressTimeZone | ||
| FullName | I_PurchaseReqnAddress | FullName | Name | |
| CityName | I_PurchaseReqnAddress | CityName | ||
| District | I_PurchaseReqnAddress | District | ||
| CityCode | I_PurchaseReqnAddress | CityCode | ||
| HomeCityName | I_PurchaseReqnAddress | HomeCityName | ||
| PostalCode | I_PurchaseReqnAddress | PostalCode | ||
| CompanyPostalCode | I_PurchaseReqnAddress | CompanyPostalCode | ||
| StreetName | I_PurchaseReqnAddress | StreetName | ||
| StreetPrefixName | I_PurchaseReqnAddress | StreetPrefixName | ||
| AdditionalStreetPrefixName | I_PurchaseReqnAddress | AdditionalStreetPrefixName | ||
| StreetSuffixName | I_PurchaseReqnAddress | StreetSuffixName | ||
| HouseNumber | I_PurchaseReqnAddress | HouseNumber | ||
| HouseNumberSupplementText | I_PurchaseReqnAddress | HouseNumberSupplementText | ||
| Building | I_PurchaseReqnAddress | Building | ||
| Floor | I_PurchaseReqnAddress | Floor | ||
| RoomNumber | I_PurchaseReqnAddress | RoomNumber | ||
| Country | I_PurchaseReqnAddress | Country | ||
| Region | I_PurchaseReqnAddress | Region | ||
| County | I_PurchaseReqnAddress | County | ||
| FormOfAddress | I_PurchaseReqnAddress | FormOfAddress | ||
| BusinessPartnerName1 | I_PurchaseReqnAddress | BusinessPartnerName1 | ||
| BusinessPartnerName2 | I_PurchaseReqnAddress | BusinessPartnerName2 | ||
| Nation | I_PurchaseReqnAddress | Nation | ||
| PhoneNumber | I_PurchaseReqnAddress | PhoneNumber | ||
| FaxNumber | I_PurchaseReqnAddress | FaxNumber | ||
| SearchTerm1 | I_PurchaseReqnAddress | SearchTerm1 | ||
| StreetSearch | I_PurchaseReqnAddress | StreetSearch | ||
| CitySearch | I_PurchaseReqnAddress | CitySearch | ||
| BusinessPartnerName3 | I_PurchaseReqnAddress | BusinessPartnerName3 | ||
| BusinessPartnerName4 | I_PurchaseReqnAddress | BusinessPartnerName4 | ||
| TaxJurisdiction | I_PurchaseReqnAddress | TaxJurisdiction | ||
| TransportZone | I_PurchaseReqnAddress | TransportZone | ||
| Person | I_PurchaseReqnAddress | Person | ||
| PlantText | I_PurchaseReqnAddress | PlantText | ||
| _PurchaseReqnItem | _PurchaseReqnItem | |||
| _PurchaseReqn | _PurchaseReqn | |||
| _FormOfAddress | I_PurchaseReqnAddress | _FormOfAddress | ||
| _Region | I_PurchaseReqnAddress | _Region |
@AbapCatalog.sqlViewName: 'IPURREQNDELIVADD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Pur Reqn Delivery Address Basic View'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.semanticKey:['PurchaseRequisition', 'PurchaseRequisitionItem', 'AddressID']
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view I_PurchaseReqnDeliveryAddress
as select from I_PurchaseReqnAddress as _PurchaseReqnAddress
association [1..1] to R_PurchaseReqnItem as _PurchaseReqnItem
on _PurchaseReqnItem.PurchaseRequisition = $projection.PurchaseRequisition
and _PurchaseReqnItem.PurchaseRequisitionItem = $projection.PurchaseRequisitionItem
association [1..1] to I_PurchaseReqn as _PurchaseReqn on _PurchaseReqn.PurchaseRequisition = $projection.PurchaseRequisition
{
key _PurchaseReqnAddress.PurchaseRequisition,
key _PurchaseReqnAddress.PurchaseRequisitionItem,
_PurchaseReqnAddress.AddressID,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.AddressType,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.Plant,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.StorageLocation,
// _PurchaseReqnAddress.SupplierReceivingDelivery,
// _PurchaseReqnAddress.CustomerReceivingDelivery,
_PurchaseReqnAddress.ManualDeliveryAddressID,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.ItemDeliveryAddressID,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.CareOfName,
_PurchaseReqnAddress.AdditionalStreetSuffixName,
_PurchaseReqnAddress.CorrespondenceLanguage,
_PurchaseReqnAddress.PrfrdCommMediumType,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.POBox,
_PurchaseReqnAddress.POBoxIsWithoutNumber,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.POBoxPostalCode,
_PurchaseReqnAddress.POBoxLobbyName,
_PurchaseReqnAddress.POBoxDeviatingCityName,
_PurchaseReqnAddress.POBoxDeviatingRegion,
_PurchaseReqnAddress.POBoxDeviatingCountry,
_PurchaseReqnAddress.DeliveryServiceTypeCode,
_PurchaseReqnAddress.DeliveryServiceNumber,
_PurchaseReqnAddress.AddressTimeZone,
@EndUserText.label: 'Name'
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.FullName,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.CityName,
_PurchaseReqnAddress.District,
_PurchaseReqnAddress.CityCode,
_PurchaseReqnAddress.HomeCityName,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.PostalCode,
_PurchaseReqnAddress.CompanyPostalCode,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.StreetName,
_PurchaseReqnAddress.StreetPrefixName,
_PurchaseReqnAddress.AdditionalStreetPrefixName,
_PurchaseReqnAddress.StreetSuffixName,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.HouseNumber,
_PurchaseReqnAddress.HouseNumberSupplementText,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.Building,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.Floor,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.RoomNumber,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.Country,
@ObjectModel.foreignKey.association: '_Region'
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.Region,
_PurchaseReqnAddress.County,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.FormOfAddress,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.BusinessPartnerName1,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.BusinessPartnerName2,
_PurchaseReqnAddress.Nation,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.PhoneNumber,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.FaxNumber,
_PurchaseReqnAddress.SearchTerm1,
_PurchaseReqnAddress.StreetSearch,
_PurchaseReqnAddress.CitySearch,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.BusinessPartnerName3,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_PurchaseReqnAddress.BusinessPartnerName4,
_PurchaseReqnAddress.TaxJurisdiction,
_PurchaseReqnAddress.TransportZone,
_PurchaseReqnAddress.Person,
_PurchaseReqnAddress.PlantText,
/* Associations */
@ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
_PurchaseReqnItem,
@ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
_PurchaseReqn,
_PurchaseReqnAddress._FormOfAddress,
_PurchaseReqnAddress._Region
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEREQNADDRESS"
],
"ASSOCIATED":
[
"I_FORMOFADDRESS",
"I_PURCHASEREQN",
"I_REGION",
"R_PURCHASEREQNITEM"
],
"BASE":
[
"I_PURCHASEREQNADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/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