R_PrelimBillgDocPartnerTP

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 R_PrelimBillgDocPartnerTP.
-- 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 R_PrelimBillgDocPartnerTP AS
SELECT
  cast(Partner.PrelimBillingDocument as prelim_billing_document preserving type) AS PrelimBillingDocument,
  cast(PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  Customer,
  Supplier,
  Personnel,
  ContactPerson,
  ReferenceBusinessPartner,
  case when Partner.Customer != '' then Partner.Customer when Partner.Supplier != '' then Partner.Supplier when Partner.Personnel != '00000000' then cast(Partner.Personnel as kunnr) when Partner.ContactPerson != '0000000000' then cast(Partner.ContactPerson as kunnr) else '' end as Partner AS ContactPersonaskunnrelseendasPartner,
  case Partner.AddressID when '' then case when Partner.ContactPerson != '0000000000' then cast(substring(replace(concat(_ContactPerson.FirstName, concat(' &', _ContactPerson.LastName)), '&', '') ,1,80) as ad_namtext preserving type) when Partner.Personnel != '00000000' then coalesce(_WorkAssignment.PersonFullName, _WorkAssignment._WorkforcePerson.LastName) else '' end else case when Partner.AddressObjectType = '1' then cast(concat_with_space(_OrganizationAddress.AddresseeName1, _OrganizationAddress.AddresseeName2, 1) as ad_namtext) when Partner.AddressObjectType = '2' then _PersonAddress.PersonFullName when Partner.AddressObjectType = '3' then _PersonWorkplaceAddress.PersonFullName else '' end end as FullName AS PersonFullNameelseendendasFullName,
  _PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  _OrgNamePostalAddress.StreetName AS StreetName,
  _OrgNamePostalAddress.HouseNumber AS HouseNumber,
  _OrgNamePostalAddress.PostalCode AS PostalCode,
  _OrgNamePostalAddress.Country AS Country,
  _OrgNamePostalAddress.Region AS Region,
  _OrgNamePostalAddress.DistrictName AS DistrictName,
  _OrgNamePostalAddress.CityName AS CityName,
  _OrgNamePostalAddress.POBox AS POBox,
  _OrgNamePostalAddress.POBoxPostalCode AS POBoxPostalCode,
  _OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  _OrgNamePostalAddress.TransportZone AS TransportZone,
  AddressID,
  AddressPersonID,
  AddressObjectType,
  VATRegistration,
  UnloadingPointName,
  _OrgNamePostalAddress.AddresseeName1 AS BusinessPartnerName1,
  _OrgNamePostalAddress.AddresseeName2 AS BusinessPartnerName2,
  _OrgNamePostalAddress.AddresseeName3 AS BusinessPartnerName3,
  _OrgNamePostalAddress.AddresseeName4 AS BusinessPartnerName4,
  SDDocPartnerAddressRefType,
  _PrelimBillingDocument.SalesOrganization AS SalesOrganization,
  _PrelimBillingDocument.BillingDocumentType AS BillingDocumentType,
  _PrelimBillingDocument.IsRelevantForAccrual AS IsRelevantForAccrual,
  _PrelimBillingDocument.PBDIsInMyResponsibility AS PBDIsInMyResponsibility,
  _WorkAssignment._WorkforcePerson.PersonExternalID AS PersonExternalID,
  _OrgNamePostalAddress._Country AS _Country,
  _OrgNamePostalAddress._Region AS _Region
FROM I_PrelimBillingDocPartner AS Partner
LEFT OUTER JOIN I_ContactPerson AS _ContactPerson ON ContactPerson = _ContactPerson.ContactPerson  -- association [0..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunction = _PartnerFunction.PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_Language AS _CorrespondenceLanguage ON CorrespondenceLanguage = _CorrespondenceLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_FormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress  -- association [0..1]
LEFT OUTER JOIN I_TransportationZone AS _TransportationZone ON transportzone = _TransportationZone.TransportZone AND country = _TransportationZone.CountryCode  -- association [0..1]
LEFT OUTER JOIN I_WorkAssignment AS _WorkAssignment ON Personnel = _WorkAssignment.WorkAssignment  -- association [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 I_AddrOrgNamePostalAddress AS _OrgNamePostalAddress ON AddressID = _OrgNamePostalAddress.AddressID AND _OrgNamePostalAddress.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_AddressPersonName 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]
;