I_PurchaseReqnAddress

DDL: I_PURCHASEREQNADDRESS SQL: IPURREQNADD Type: view COMPOSITE
61 Fields 1 Data Sources 4 Associations

Purchase Requisition Address Basic View

I_PurchaseReqnAddress is a Composite CDS View that provides data about "Purchase Requisition Address Basic View" in SAP S/4HANA. It reads from 1 data source (R_PurchaseReqnItem) and exposes 61 fields with key fields PurchaseRequisition, PurchaseRequisitionItem. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseReqnItem PurchaseReqnItem from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_OrganizationAddress _OrganizationAddress $projection.DeliveryAddressID = _OrganizationAddress.AddressID and _OrganizationAddress.AddressPersonID is initial and _OrganizationAddress.AddressRepresentationCode is initial
[0..1] I_AddressPhoneNumber_2 _PhoneNumber $projection.DeliveryAddressID = _PhoneNumber.AddressID and _PhoneNumber.PhNmbrIsCurrentOverallDefault = 'X'
[0..*] I_AddrCurDefaultFaxNumber _CurrentDfltFaxNumber $projection.DeliveryAddressID = _CurrentDfltFaxNumber.AddressID
[0..1] I_StorageLocationAddress _StorageLocationAddress $projection.Plant = _StorageLocationAddress.Plant and $projection.StorageLocation = _StorageLocationAddress.StorageLocation and $projection.ItemDeliveryAddressID = _StorageLocationAddress.AddressID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPURREQNADD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Requisition 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 (61)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition R_PurchaseReqnItem PurchaseRequisition Requisition
KEY PurchaseRequisitionItem R_PurchaseReqnItem PurchaseRequisitionItem Requisn. item
AddressID _OrganizationAddress AddressID Ship-to address
DeliveryAddressID R_PurchaseReqnItem DeliveryAddressID Address
Plant R_PurchaseReqnItem Plant Valuation Area
StorageLocation R_PurchaseReqnItem StorageLocation StorageLocation
ManualDeliveryAddressID R_PurchaseReqnItem ManualDeliveryAddressID Address Number
ItemDeliveryAddressID R_PurchaseReqnItem ItemDeliveryAddressID Address
PurchasingGroup R_PurchaseReqnItem PurchasingGroup Purchasing Group
PurchaseRequisitionType R_PurchaseReqnItem PurchaseRequisitionType Order Type
PurchasingOrganization R_PurchaseReqnItem PurchasingOrganization Purchasing Organization
CareOfName _OrganizationAddress CareOfName c/o
AdditionalStreetSuffixName _OrganizationAddress StreetSuffixName2 Street 5
CorrespondenceLanguage _OrganizationAddress CorrespondenceLanguage Language
PrfrdCommMediumType _OrganizationAddress PrfrdCommMediumType Comm. Method
POBox _OrganizationAddress POBox PO Box
POBoxIsWithoutNumber _OrganizationAddress POBoxIsWithoutNumber PO Box w/o No.
POBoxPostalCode _OrganizationAddress POBoxPostalCode PO Box Postal Code
POBoxLobbyName _OrganizationAddress POBoxLobbyName PO Box Lobby
POBoxDeviatingCityName _OrganizationAddress POBoxDeviatingCityName PO Box City
POBoxDeviatingRegion _OrganizationAddress POBoxDeviatingRegion PO Region
POBoxDeviatingCountry _OrganizationAddress POBoxDeviatingCountry PO Box C/R
DeliveryServiceTypeCode _OrganizationAddress DeliveryServiceTypeCode Delvry Serv Type
DeliveryServiceNumber _OrganizationAddress DeliveryServiceNumber Delivery Service No.
AddressTimeZone _OrganizationAddress AddressTimeZone Time Zone
FullName _OrganizationAddress AddresseeFullName Full Name
CityName _OrganizationAddress CityName Name
District _OrganizationAddress DistrictName District
CityCode _OrganizationAddress CityNumber City Code
HomeCityName _OrganizationAddress VillageName Different City
PostalCode _OrganizationAddress PostalCode Postal Code
CompanyPostalCode _OrganizationAddress CompanyPostalCode Company Post Cd
StreetName _OrganizationAddress StreetName Text
StreetPrefixName _OrganizationAddress StreetPrefixName1 Street 2
AdditionalStreetPrefixName _OrganizationAddress StreetPrefixName2 Street 3
StreetSuffixName _OrganizationAddress StreetSuffixName1 Street 4
HouseNumber _OrganizationAddress HouseNumber House Number
HouseNumberSupplementText _OrganizationAddress HouseNumberSupplementText Supplement
Building _OrganizationAddress Building Building code
Floor _OrganizationAddress Floor Floor
RoomNumber _OrganizationAddress RoomNumber Room Number
Country _OrganizationAddress Country Venue: Ctry/Reg
Region _OrganizationAddress Region Venue Region
County _OrganizationAddress SecondaryRegionName County
FormOfAddress _OrganizationAddress FormOfAddress Title Key
BusinessPartnerName1 _OrganizationAddress AddresseeName1
BusinessPartnerName2 _OrganizationAddress AddresseeName2
Nation _OrganizationAddress AddressRepresentationCode Address Version
PhoneNumber _PhoneNumber PhoneAreaCodeSubscriberNumber Telephone
FaxNumber _CurrentDfltFaxNumber FaxAreaCodeSubscriberNumber Fax
SearchTerm1 _OrganizationAddress AddressSearchTerm1 Search Term 1
StreetSearch
CitySearch
BusinessPartnerName3 _OrganizationAddress AddresseeName3
BusinessPartnerName4 _OrganizationAddress AddresseeName4
TaxJurisdiction _OrganizationAddress TaxJurisdiction Tax Jurisdiction
TransportZone _OrganizationAddress TransportZone Transport Zone
Person
_FormOfAddress _OrganizationAddress _FormOfAddress
_Region _OrganizationAddress _Region
PlantText

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_PurchaseReqnAddress.
-- 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: IPURREQNADD

CREATE VIEW I_PurchaseReqnAddress AS
SELECT
  PurchaseReqnItem.PurchaseRequisition AS PurchaseRequisition,
  PurchaseReqnItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _OrganizationAddress.AddressID AS AddressID,
  PurchaseReqnItem.DeliveryAddressID AS DeliveryAddressID,
  PurchaseReqnItem.Plant AS Plant,
  PurchaseReqnItem.StorageLocation AS StorageLocation,
  PurchaseReqnItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  PurchaseReqnItem.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  PurchaseReqnItem.PurchasingGroup AS PurchasingGroup,
  PurchaseReqnItem.PurchaseRequisitionType AS PurchaseRequisitionType,
  PurchaseReqnItem.PurchasingOrganization AS PurchasingOrganization,
  _OrganizationAddress.CareOfName AS CareOfName,
  _OrganizationAddress.StreetSuffixName2 AS AdditionalStreetSuffixName,
  _OrganizationAddress.CorrespondenceLanguage AS CorrespondenceLanguage,
  _OrganizationAddress.PrfrdCommMediumType AS PrfrdCommMediumType,
  _OrganizationAddress.POBox AS POBox,
  _OrganizationAddress.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  _OrganizationAddress.POBoxPostalCode AS POBoxPostalCode,
  _OrganizationAddress.POBoxLobbyName AS POBoxLobbyName,
  _OrganizationAddress.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _OrganizationAddress.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  _OrganizationAddress.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  _OrganizationAddress.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  _OrganizationAddress.DeliveryServiceNumber AS DeliveryServiceNumber,
  _OrganizationAddress.AddressTimeZone AS AddressTimeZone,
  _OrganizationAddress.AddresseeFullName AS FullName,
  _OrganizationAddress.CityName AS CityName,
  _OrganizationAddress.DistrictName AS District,
  _OrganizationAddress.CityNumber AS CityCode,
  _OrganizationAddress.VillageName AS HomeCityName,
  _OrganizationAddress.PostalCode AS PostalCode,
  _OrganizationAddress.CompanyPostalCode AS CompanyPostalCode,
  _OrganizationAddress.StreetName AS StreetName,
  _OrganizationAddress.StreetPrefixName1 AS StreetPrefixName,
  _OrganizationAddress.StreetPrefixName2 AS AdditionalStreetPrefixName,
  _OrganizationAddress.StreetSuffixName1 AS StreetSuffixName,
  _OrganizationAddress.HouseNumber AS HouseNumber,
  _OrganizationAddress.HouseNumberSupplementText AS HouseNumberSupplementText,
  _OrganizationAddress.Building AS Building,
  _OrganizationAddress.Floor AS Floor,
  _OrganizationAddress.RoomNumber AS RoomNumber,
  _OrganizationAddress.Country AS Country,
  _OrganizationAddress.Region AS Region,
  _OrganizationAddress.SecondaryRegionName AS County,
  _OrganizationAddress.FormOfAddress AS FormOfAddress,
  _OrganizationAddress.AddresseeName1 AS BusinessPartnerName1,
  _OrganizationAddress.AddresseeName2 AS BusinessPartnerName2,
  _OrganizationAddress.AddressRepresentationCode AS Nation,
  _PhoneNumber.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  _CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber AS FaxNumber,
  _OrganizationAddress.AddressSearchTerm1 AS SearchTerm1,
  '' AS StreetSearch,
  '' AS CitySearch,
  _OrganizationAddress.AddresseeName3 AS BusinessPartnerName3,
  _OrganizationAddress.AddresseeName4 AS BusinessPartnerName4,
  _OrganizationAddress.TaxJurisdiction AS TaxJurisdiction,
  _OrganizationAddress.TransportZone AS TransportZone,
  cast('' as ad_persnum ) AS Person,
  _OrganizationAddress._FormOfAddress AS _FormOfAddress,
  _OrganizationAddress._Region AS _Region,
  PurchaseReqnItem._Plant.PlantName AS PlantText
FROM R_PurchaseReqnItem AS PurchaseReqnItem
LEFT OUTER JOIN I_OrganizationAddress AS _OrganizationAddress ON DeliveryAddressID = _OrganizationAddress.AddressID AND _OrganizationAddress.AddressPersonID is initial AND _OrganizationAddress.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _PhoneNumber ON DeliveryAddressID = _PhoneNumber.AddressID AND _PhoneNumber.PhNmbrIsCurrentOverallDefault = 'X'  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDefaultFaxNumber AS _CurrentDfltFaxNumber ON DeliveryAddressID = _CurrentDfltFaxNumber.AddressID  -- association [0..*]
LEFT OUTER JOIN I_StorageLocationAddress AS _StorageLocationAddress ON Plant = _StorageLocationAddress.Plant AND StorageLocation = _StorageLocationAddress.StorageLocation AND ItemDeliveryAddressID = _StorageLocationAddress.AddressID  -- association [0..1]
;

Learn More