What is A_PurReqAddDelivery in SAP S/4HANA?

A_PurReqAddDelivery is a composite CDS view in SAP S/4HANA. Delivery Address It contains 58 fields.

Which tables does A_PurReqAddDelivery read from?

A_PurReqAddDelivery reads data from: P_PurReqAddDelivery.

What VDM layer is A_PurReqAddDelivery?

A_PurReqAddDelivery is classified as a Composite view that combines data from multiple basic views.

A_PurReqAddDelivery

DDL: A_PURREQADDDELIVERY SQL: APURREQADDDELIV Type: view COMPOSITE

58 Fields 1 Data Sources 4 Associations

Delivery Address

A_PurReqAddDelivery is a Composite CDS View that provides data about "Delivery Address" in SAP S/4HANA. It reads from 1 data source (P_PurReqAddDelivery) and exposes 58 fields with key fields PurchaseRequisition, PurchaseRequisitionItem. It has 4 associations to related views.

Data Sources (1)

Source	Alias	Join Type
P_PurReqAddDelivery	_PurchaseReqnAddress	from

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	A_PurchaseRequisitionItem	_PurchaseReqnItem	`_PurchaseReqnItem.PurchaseRequisition = $projection.PurchaseRequisition and _PurchaseReqnItem.PurchaseRequisitionItem = $projection.PurchaseRequisitionItem`
[1..1]	A_PurchaseRequisitionHeader	_PurchaseReqn	`_PurchaseReqn.PurchaseRequisition = $projection.PurchaseRequisition`
[1..1]	I_Address	_Address	`$projection.AddressID = _Address.AddressID`
[1..1]	I_Address_2	_Address_2	`$projection.ItemDeliveryAddressID = _Address_2.AddressID and $projection.PersonNumber = _Address_2.AddressPersonID and _Address_2.AddressRepresentationCode is initial`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	APURREQADDDELIV	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
AbapCatalog.compiler.compareFilter	true	view
EndUserText.label	Delivery Address	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.createEnabled	false	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	false	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view

Fields (58)

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

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 A_PurReqAddDelivery.
-- 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: APURREQADDDELIV

CREATE VIEW A_PurReqAddDelivery AS
SELECT
  _PurchaseReqnAddress.PurchaseRequisition AS PurchaseRequisition,
  _PurchaseReqnAddress.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PurchaseReqnAddress.DeliveryAddressID AS AddressID,
  _PurchaseReqnAddress.Plant AS Plant,
  _PurchaseReqnAddress.AddressType AS AddressType,
  _PurchaseReqnAddress.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  _PurchaseReqnAddress.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  _Address.CareOfName AS CareOfName,
  _Address.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  _Address.CorrespondenceLanguage AS CorrespondenceLanguage,
  _Address.PrfrdCommMediumType AS PrfrdCommMediumType,
  _Address.POBox AS POBox,
  _Address.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  _Address.POBoxPostalCode AS POBoxPostalCode,
  _Address.POBoxLobbyName AS POBoxLobbyName,
  _Address.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _Address.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  _Address.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  _Address.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  _Address.DeliveryServiceNumber AS DeliveryServiceNumber,
  _Address.AddressTimeZone AS AddressTimeZone,
  _Address.FullName AS FullName,
  _Address.CityName AS CityName,
  _Address.District AS District,
  _Address.CityCode AS CityCode,
  _Address.HomeCityName AS HomeCityName,
  _Address.PostalCode AS PostalCode,
  _Address.CompanyPostalCode AS CompanyPostalCode,
  _Address.StreetName AS StreetName,
  _Address.StreetPrefixName AS StreetPrefixName,
  _Address.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  _Address.StreetSuffixName AS StreetSuffixName,
  _Address.HouseNumber AS HouseNumber,
  _Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  _Address.Building AS Building,
  _Address.Floor AS Floor,
  _Address.RoomNumber AS RoomNumber,
  _Address.Country AS Country,
  _Address.Region AS Region,
  _Address.County AS County,
  case _Address.FormOfAddress when '' then _Address_2.FormOfAddress else _Address.FormOfAddress end as FormOfAddress AS FormOfAddressendasFormOfAddress,
  _Address.BusinessPartnerName1 AS BusinessPartnerName1,
  _Address.BusinessPartnerName2 AS BusinessPartnerName2,
  _Address.Nation AS Nation,
  _Address.PhoneNumber AS PhoneNumber,
  _Address.FaxNumber AS FaxNumber,
  _Address.SearchTerm1 AS SearchTerm1,
  _Address.StreetSearch AS StreetSearch,
  _Address.CitySearch AS CitySearch,
  _Address.BusinessPartnerName3 AS BusinessPartnerName3,
  _Address.BusinessPartnerName4 AS BusinessPartnerName4,
  _Address.TaxJurisdiction AS TaxJurisdiction,
  _Address.TransportZone AS TransportZone,
  _Address.Person AS Person,
  _Address_2.AddresseeFullName AS AddresseeFullName,
  I_BusinessPartner.PersonNumber AS PersonNumber
FROM P_PurReqAddDelivery AS _PurchaseReqnAddress
LEFT OUTER JOIN A_PurchaseRequisitionItem AS _PurchaseReqnItem ON _PurchaseReqnItem.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItem.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN A_PurchaseRequisitionHeader AS _PurchaseReqn ON _PurchaseReqn.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN I_Address AS _Address ON AddressID = _Address.AddressID  -- association [1..1]
LEFT OUTER JOIN I_Address_2 AS _Address_2 ON ItemDeliveryAddressID = _Address_2.AddressID AND PersonNumber = _Address_2.AddressPersonID AND _Address_2.AddressRepresentationCode is initial  -- association [1..1]
;

Depth:

A_PurReqAddDelivery view

P_PurReqAddDelivery view