C_PurCtrItemAddress

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_PurCtrItemAddress.
-- 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: CPURCTRITMADDR

CREATE VIEW C_PurCtrItemAddress AS
SELECT
  Document.PurchaseContract AS PurchaseContract,
  Document.PurchaseContractItem AS PurchaseContractItem,
  Document.AddressID AS AddressID,
  Document.PurchaseContractItemForEdit AS PurchaseContractItemForEdit,
  Document.AddressIDForEdit AS AddressIDForEdit,
  Document.PurchaseContractForEdit AS PurchaseContractForEdit,
  Document.Plant AS Plant,
  Document.CareOfName AS CareOfName,
  Document.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  Document.CorrespondenceLanguage AS CorrespondenceLanguage,
  Document.PrfrdCommMediumType AS PrfrdCommMediumType,
  Document.POBox AS POBox,
  Document.POBoxLobbyName AS POBoxLobbyName,
  Document.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  Document.POBoxPostalCode AS POBoxPostalCode,
  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.ConsigneeName3 AS ConsigneeName3,
  Document.ConsigneeName4 AS ConsigneeName4,
  Document.TaxJurisdiction AS TaxJurisdiction,
  Document.TransportZone AS TransportZone,
  Document.PhoneNumber AS PhoneNumber,
  Document.MobilePhoneNumber AS MobilePhoneNumber,
  Document.FaxNumber AS FaxNumber,
  Document.EmailAddress AS EmailAddress
FROM I_PurCtrAddressWD AS Document
LEFT OUTER JOIN C_ContractMaintainItem AS _PurchaseContractItemWD ON _PurchaseContractItemWD.PurchaseContractItem = PurchaseContractItem AND _PurchaseContractItemWD.PurchaseContract = PurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_ContractMaintain AS _PurchaseContractWD ON PurchaseContract = _PurchaseContractWD.PurchaseContract  -- association [1..1]
;