I_PurchaseReqnDeliveryAddress

DDL: I_PURCHASEREQNDELIVERYADDRESS SQL: IPURREQNDELIVADD Type: view COMPOSITE Package: VDM_MM_PUR_PR
60 Fields 1 Data Sources 2 Associations

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. Part of development package VDM_MM_PUR_PR.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseReqnAddress _PurchaseReqnAddress from

Associations (2)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition I_PurchaseReqnAddress PurchaseRequisition Requisition
KEY PurchaseRequisitionItem I_PurchaseReqnAddress PurchaseRequisitionItem Requisn. item
AddressID I_PurchaseReqnAddress AddressID Ship-to address
AddressType I_PurchaseReqnAddress AddressType Address Type
Plant I_PurchaseReqnAddress Plant Valuation Area
StorageLocation I_PurchaseReqnAddress StorageLocation StorageLocation
ManualDeliveryAddressID I_PurchaseReqnAddress ManualDeliveryAddressID Address Number
ItemDeliveryAddressID I_PurchaseReqnAddress ItemDeliveryAddressID Address
CareOfName I_PurchaseReqnAddress CareOfName c/o
AdditionalStreetSuffixName I_PurchaseReqnAddress AdditionalStreetSuffixName Street 5
CorrespondenceLanguage I_PurchaseReqnAddress CorrespondenceLanguage Language
PrfrdCommMediumType I_PurchaseReqnAddress PrfrdCommMediumType Comm. Method
POBox I_PurchaseReqnAddress POBox PO Box
POBoxIsWithoutNumber I_PurchaseReqnAddress POBoxIsWithoutNumber PO Box w/o No.
POBoxPostalCode I_PurchaseReqnAddress POBoxPostalCode PO Box Postal Code
POBoxLobbyName I_PurchaseReqnAddress POBoxLobbyName PO Box Lobby
POBoxDeviatingCityName I_PurchaseReqnAddress POBoxDeviatingCityName PO Box City
POBoxDeviatingRegion I_PurchaseReqnAddress POBoxDeviatingRegion PO Region
POBoxDeviatingCountry I_PurchaseReqnAddress POBoxDeviatingCountry PO Box C/R
DeliveryServiceTypeCode I_PurchaseReqnAddress DeliveryServiceTypeCode Delvry Serv Type
DeliveryServiceNumber I_PurchaseReqnAddress DeliveryServiceNumber Delivery Service No.
AddressTimeZone I_PurchaseReqnAddress AddressTimeZone Time Zone
FullName I_PurchaseReqnAddress FullName Name
CityName I_PurchaseReqnAddress CityName Name
District I_PurchaseReqnAddress District District Court
CityCode I_PurchaseReqnAddress CityCode IATA: City
HomeCityName I_PurchaseReqnAddress HomeCityName Different City
PostalCode I_PurchaseReqnAddress PostalCode Postal Code
CompanyPostalCode I_PurchaseReqnAddress CompanyPostalCode Company Post Cd
StreetName I_PurchaseReqnAddress StreetName Text
StreetPrefixName I_PurchaseReqnAddress StreetPrefixName Street 2
AdditionalStreetPrefixName I_PurchaseReqnAddress AdditionalStreetPrefixName Street 3
StreetSuffixName I_PurchaseReqnAddress StreetSuffixName Street 4
HouseNumber I_PurchaseReqnAddress HouseNumber House Number
HouseNumberSupplementText I_PurchaseReqnAddress HouseNumberSupplementText Supplement
Building I_PurchaseReqnAddress Building Building code
Floor I_PurchaseReqnAddress Floor Floor
RoomNumber I_PurchaseReqnAddress RoomNumber Room Number
Country I_PurchaseReqnAddress Country Venue: Ctry/Reg
Region I_PurchaseReqnAddress Region Venue Region
County I_PurchaseReqnAddress County Wyoming County
FormOfAddress I_PurchaseReqnAddress FormOfAddress Title Key
BusinessPartnerName1 I_PurchaseReqnAddress BusinessPartnerName1 Name
BusinessPartnerName2 I_PurchaseReqnAddress BusinessPartnerName2 Name 2
Nation I_PurchaseReqnAddress Nation Country/Region
PhoneNumber I_PurchaseReqnAddress PhoneNumber Telephone no.
FaxNumber I_PurchaseReqnAddress FaxNumber Fax Number
SearchTerm1 I_PurchaseReqnAddress SearchTerm1 Search Term 1
StreetSearch I_PurchaseReqnAddress StreetSearch
CitySearch I_PurchaseReqnAddress CitySearch
BusinessPartnerName3 I_PurchaseReqnAddress BusinessPartnerName3 Name 3
BusinessPartnerName4 I_PurchaseReqnAddress BusinessPartnerName4 Name 4
TaxJurisdiction I_PurchaseReqnAddress TaxJurisdiction Tax Jurisdiction
TransportZone I_PurchaseReqnAddress TransportZone Transport Zone
Person I_PurchaseReqnAddress Person Person/ Farm/ Field
PlantText I_PurchaseReqnAddress PlantText Plant Name
_PurchaseReqnItem _PurchaseReqnItem
_PurchaseReqn _PurchaseReqn
_FormOfAddress I_PurchaseReqnAddress _FormOfAddress
_Region I_PurchaseReqnAddress _Region

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PurchaseReqnDeliveryAddress.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPURREQNDELIVADD

CREATE VIEW I_PurchaseReqnDeliveryAddress AS
SELECT
  _PurchaseReqnAddress.PurchaseRequisition AS PurchaseRequisition,
  _PurchaseReqnAddress.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PurchaseReqnAddress.AddressID AS AddressID,
  _PurchaseReqnAddress.AddressType AS AddressType,
  _PurchaseReqnAddress.Plant AS Plant,
  _PurchaseReqnAddress.StorageLocation AS StorageLocation,
  _PurchaseReqnAddress.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  _PurchaseReqnAddress.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  _PurchaseReqnAddress.CareOfName AS CareOfName,
  _PurchaseReqnAddress.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  _PurchaseReqnAddress.CorrespondenceLanguage AS CorrespondenceLanguage,
  _PurchaseReqnAddress.PrfrdCommMediumType AS PrfrdCommMediumType,
  _PurchaseReqnAddress.POBox AS POBox,
  _PurchaseReqnAddress.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  _PurchaseReqnAddress.POBoxPostalCode AS POBoxPostalCode,
  _PurchaseReqnAddress.POBoxLobbyName AS POBoxLobbyName,
  _PurchaseReqnAddress.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _PurchaseReqnAddress.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  _PurchaseReqnAddress.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  _PurchaseReqnAddress.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  _PurchaseReqnAddress.DeliveryServiceNumber AS DeliveryServiceNumber,
  _PurchaseReqnAddress.AddressTimeZone AS AddressTimeZone,
  _PurchaseReqnAddress.FullName AS FullName,
  _PurchaseReqnAddress.CityName AS CityName,
  _PurchaseReqnAddress.District AS District,
  _PurchaseReqnAddress.CityCode AS CityCode,
  _PurchaseReqnAddress.HomeCityName AS HomeCityName,
  _PurchaseReqnAddress.PostalCode AS PostalCode,
  _PurchaseReqnAddress.CompanyPostalCode AS CompanyPostalCode,
  _PurchaseReqnAddress.StreetName AS StreetName,
  _PurchaseReqnAddress.StreetPrefixName AS StreetPrefixName,
  _PurchaseReqnAddress.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  _PurchaseReqnAddress.StreetSuffixName AS StreetSuffixName,
  _PurchaseReqnAddress.HouseNumber AS HouseNumber,
  _PurchaseReqnAddress.HouseNumberSupplementText AS HouseNumberSupplementText,
  _PurchaseReqnAddress.Building AS Building,
  _PurchaseReqnAddress.Floor AS Floor,
  _PurchaseReqnAddress.RoomNumber AS RoomNumber,
  _PurchaseReqnAddress.Country AS Country,
  _PurchaseReqnAddress.Region AS Region,
  _PurchaseReqnAddress.County AS County,
  _PurchaseReqnAddress.FormOfAddress AS FormOfAddress,
  _PurchaseReqnAddress.BusinessPartnerName1 AS BusinessPartnerName1,
  _PurchaseReqnAddress.BusinessPartnerName2 AS BusinessPartnerName2,
  _PurchaseReqnAddress.Nation AS Nation,
  _PurchaseReqnAddress.PhoneNumber AS PhoneNumber,
  _PurchaseReqnAddress.FaxNumber AS FaxNumber,
  _PurchaseReqnAddress.SearchTerm1 AS SearchTerm1,
  _PurchaseReqnAddress.StreetSearch AS StreetSearch,
  _PurchaseReqnAddress.CitySearch AS CitySearch,
  _PurchaseReqnAddress.BusinessPartnerName3 AS BusinessPartnerName3,
  _PurchaseReqnAddress.BusinessPartnerName4 AS BusinessPartnerName4,
  _PurchaseReqnAddress.TaxJurisdiction AS TaxJurisdiction,
  _PurchaseReqnAddress.TransportZone AS TransportZone,
  _PurchaseReqnAddress.Person AS Person,
  _PurchaseReqnAddress.PlantText AS PlantText,
  _PurchaseReqnAddress._FormOfAddress AS _FormOfAddress,
  _PurchaseReqnAddress._Region AS _Region
FROM I_PurchaseReqnAddress AS _PurchaseReqnAddress
LEFT OUTER JOIN R_PurchaseReqnItem AS _PurchaseReqnItem ON _PurchaseReqnItem.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItem.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN I_PurchaseReqn AS _PurchaseReqn ON _PurchaseReqn.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
;

Learn More