T_PurchaseReqnDeliveryAdd

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 T_PurchaseReqnDeliveryAdd.
-- 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: IPURREQNDEL000WD

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