C_SumzdJITCallDelivAddrOutput

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_SumzdJITCallDelivAddrOutput.
-- 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: CJITCALLDELADROP

CREATE VIEW C_SumzdJITCallDelivAddrOutput AS
SELECT
  JITCallNumber,
  Plant,
  _Plant.PlantName AS PlantName,
  _AddressPhoneNmbrAddress.PhoneAreaCodeSubscriberNumber AS PlantPhoneNumber,
  _AddressPhoneNmbrAddress.PhoneExtensionNumber AS PlantPhoneNumberExtension,
  _AddressFaxNumberAddress.FaxAreaCodeSubscriberNumber AS PlantFaxNumber,
  _AddressFaxNumberAddress.FaxExtensionNumber AS PlantFaxNumberExtension,
  _OrganizationAddress.StreetName AS PlantStreetName,
  _OrganizationAddress.PostalCode AS PlantPostalCode,
  _OrganizationAddress.CityName AS PlantCityName,
  _OrganizationAddress.Country AS PlantCountry,
  _OrganizationAddress.Region AS PlantRegion,
  _AddressEmailAddress.EmailAddress AS PlantEmailAddress,
  cast('' as ablad) AS UnloadingPointName,
  cast('' as dsnam) AS MRPControllerName,
  cast('' as dstel) AS MRPControllerPhoneNumber,
  cast('' as pk_requirement_date_form ) AS SumzdJITCallPlndDelivDate,
  cast('' as pabluz) AS SumzdJITCallPlndDelivTime,
  cast('' as lines) AS PlantAddressLine1Text,
  cast('' as lines) AS PlantAddressLine2Text,
  cast('' as lines) AS PlantAddressLine3Text,
  cast('' as lines) AS PlantAddressLine4Text,
  cast('' as lines) AS PlantAddressLine5Text,
  cast('' as lines) AS PlantAddressLine6Text,
  cast('' as lines) AS PlantAddressLine7Text,
  cast('' as lines) AS PlantAddressLine8Text,
  Supplier,
  OutputPartnerForSumzdJITCall
FROM I_SummarizedJITCallOutput
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN C_SummarizedJITCallOutput AS _SumzdJITCallOutput ON JITCallNumber = _SumzdJITCallOutput.JITCallNumber  -- association [1..1]
LEFT OUTER JOIN I_AddrCurDefaultEmailAddress AS _AddressEmailAddress ON _AddressEmailAddress.AddressID = I_SummarizedJITCallOutput.AddressID AND _AddressEmailAddress.AddressPersonID is initial  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltLandlinePhoneNmbr AS _AddressPhoneNmbrAddress ON _AddressPhoneNmbrAddress.AddressID = I_SummarizedJITCallOutput.AddressID AND _AddressPhoneNmbrAddress.AddressPersonID is initial  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDefaultFaxNumber AS _AddressFaxNumberAddress ON _AddressFaxNumberAddress.AddressID = I_SummarizedJITCallOutput.AddressID AND _AddressFaxNumberAddress.AddressPersonID is initial  -- association [0..1]
LEFT OUTER JOIN I_OrganizationAddress AS _OrganizationAddress ON _OrganizationAddress.AddressID = I_SummarizedJITCallOutput.AddressID AND _OrganizationAddress.AddressRepresentationCode is initial AND _OrganizationAddress.AddressPersonID is initial  -- association [0..1]
;