P_BillgProcDocPartnerAddress

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 P_BillgProcDocPartnerAddress.
-- 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.

CREATE VIEW P_BillgProcDocPartnerAddress AS
SELECT
  cast(Partner.BillingDocument as billing_process_document preserving type) AS BillingProcessDocument,
  cast(PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  Personnel,
  ContactPerson,
  AddressID,
  AddressPersonID,
  AddressObjectType,
  _OrgNamePostalAddress.StreetPrefixName1 AS StreetPrefixName1,
  _OrgNamePostalAddress.StreetPrefixName2 AS StreetPrefixName2,
  _OrgNamePostalAddress.StreetName AS StreetName,
  _OrgNamePostalAddress.StreetSuffixName1 AS StreetSuffixName1,
  _OrgNamePostalAddress.StreetSuffixName2 AS StreetSuffixName2,
  _OrgNamePostalAddress.HouseNumber AS HouseNumber,
  _OrgNamePostalAddress.PostalCode AS PostalCode,
  _OrgNamePostalAddress.DistrictName AS DistrictName,
  _OrgNamePostalAddress.CityName AS CityName,
  _OrgNamePostalAddress.POBox AS POBox,
  _OrgNamePostalAddress.POBoxPostalCode AS POBoxPostalCode,
  _OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  _OrgNamePostalAddress.Country AS Country,
  _OrgNamePostalAddress._Country._Text[1: Language=$session.system_language].CountryName AS CountryName,
  _OrgNamePostalAddress.Region AS Region,
  _OrgNamePostalAddress._Region._RegionText[1: Language=$session.system_language].RegionName AS RegionName,
  _OrgNamePostalAddress.TransportZone AS TransportZone,
  _OrgNamePostalAddress._TransportationZone._Text[1: Language=$session.system_language].TransportZoneDescription AS TransportZoneDescription,
  _OrgNamePostalAddress._Country AS _Country,
  _OrgNamePostalAddress._Region AS _Region
FROM I_BillingDocumentPartnerBasic AS Partner
LEFT OUTER JOIN I_ContactPerson AS _ContactPerson ON ContactPerson = _ContactPerson.ContactPerson  -- association [0..1]
LEFT OUTER JOIN I_WorkAssignment AS _WorkAssignment ON Personnel = _WorkAssignment.WorkAssignment  -- association [1]
LEFT OUTER JOIN I_TransportationZone AS _TransportationZone ON transportzone = _TransportationZone.TransportZone AND country = _TransportationZone.CountryCode  -- association [0..1]
LEFT OUTER JOIN I_OrganizationAddress AS _OrganizationAddress ON AddressID = _OrganizationAddress.AddressID AND AddressPersonID = _OrganizationAddress.AddressPersonID AND AddressObjectType = '1' AND _OrganizationAddress.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_PersonAddress AS _PersonAddress ON AddressID = _PersonAddress.AddressID AND AddressPersonID = _PersonAddress.AddressPersonID AND AddressObjectType = '2' AND _PersonAddress.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkplaceAddress AS _PersonWorkplaceAddress ON AddressID = _PersonWorkplaceAddress.AddressID AND AddressPersonID = _PersonWorkplaceAddress.AddressPersonID AND AddressObjectType = '3' AND _PersonWorkplaceAddress.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN P_BillingAddrOrgNamePostalAddr AS _OrgNamePostalAddress ON AddressID = _OrgNamePostalAddress.AddressID AND _OrgNamePostalAddress.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN P_BillingAddressPersonName AS _PersonName ON AddressPersonID = _PersonName.AddressPersonID AND _PersonName.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltLandlinePhoneNmbr AS _CurrentDfltLandlinePhoneNmbr ON AddressID = _CurrentDfltLandlinePhoneNmbr.AddressID AND AddressPersonID = _CurrentDfltLandlinePhoneNmbr.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDefaultEmailAddress AS _CurrentDfltEmailAddress ON AddressID = _CurrentDfltEmailAddress.AddressID AND AddressPersonID = _CurrentDfltEmailAddress.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltMobilePhoneNumber AS _CurrentDfltMobilePhoneNumber ON AddressID = _CurrentDfltMobilePhoneNumber.AddressID AND AddressPersonID = _CurrentDfltMobilePhoneNumber.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDefaultFaxNumber AS _CurrentDfltFaxNumber ON AddressID = _CurrentDfltFaxNumber.AddressID AND AddressPersonID = _CurrentDfltFaxNumber.AddressPersonID  -- association [0..1]
;