C_PurchaseReqnDelivAdd

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 C_PurchaseReqnDelivAdd.
-- 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: CPURREQNDELIVADD

CREATE VIEW C_PurchaseReqnDelivAdd AS
SELECT
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.AddressID AS AddressID,
  Document.AddressIDForEdit AS AddressIDForEdit,
  Document.AddressType AS AddressType,
  _AddressTypeVH.AddressTypeDesc AS AddressTypeDesc,
  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,
  Document._FormOfAddress AS _FormOfAddress,
  Document._Region AS _Region
FROM T_PurchaseReqnDeliveryAdd AS Document
LEFT OUTER JOIN C_PurchaseReqnItem AS _PurchaseReqnItem ON _PurchaseReqnItem.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItem.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN C_PurchaseReqnHeader AS _PurchaseReqn ON _PurchaseReqn.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN C_MM_CountryValueHelp AS _CountryValueHelp ON _CountryValueHelp.Country = Country  -- association [0..1]
LEFT OUTER JOIN C_MM_RegionValueHelp AS _RegionValueHelp ON _RegionValueHelp.Region = Region AND _RegionValueHelp.Country = Country  -- association [0..1]
LEFT OUTER JOIN C_PurchaseReqnAddressTypeVH AS _AddressTypeVH ON _AddressTypeVH.AddressType = AddressType  -- association [0..1]
;