v_sd_ci_item_party

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 v_sd_ci_item_party.
-- 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.
-- Parameters: P_LANGUAGE : abap.lang

CREATE VIEW v_sd_ci_item_party AS
SELECT
  vbrp.vbeln AS Document_ID,
  vbrp.posnr AS Item_ID,
  partner_function.parvw AS Partner_Function,
  partner_function.vtext AS Partner_Function_Description,
  case when item_partner.kunnr <> ' ' then item_partner.kunnr when item_partner.parnr <> '0000000000' then item_partner.parnr when item_partner.pernr <> '00000000' then item_partner.pernr end as Party_ID AS pernrendasParty_ID,
  case when item_partner.adrnp <> '' then contact_detail.name_text when item_partner.pernr <> '00000000' then _PersonWorkAgreement.PersonFullName else address_detail.name1 end as Party_Name1 AS name1endasParty_Name1,
  case when item_partner.adrnp <> '' then contact_detail.name2 else address_detail.name2 end as Party_Name2 AS name2endasParty_Name2,
  address_detail.country AS Country_Code,
  address_detail.post_code1 AS Postal_Code,
  address_detail.city1 AS City,
  address_detail.street AS Street_Name,
  address_detail.house_num1 AS House_Number,
  address_detail.addrnumber AS Address_Number,
  contact_detail.persnumber AS Address_Person_Number,
  item_partner.addr_type AS Address_Type,
  _BillingDocument.BillingDocumentType AS BillingDocumentType,
  _BillingDocument.SalesOrganization AS SalesOrganization
FROM vbrp
INNER JOIN I_BillingDocument AS _BillingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbpa AS item_partner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tpart AS partner_function ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrc AS address_detail ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp AS contact_detail ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON _PersonWorkAgreement.PersonWorkAgreement = item_partner.pernr  -- association [0..1]
LEFT OUTER JOIN E_SDDocumentPartner AS _Extension ON Document_ID = _Extension.SalesDocument AND Item_ID = _Extension.SalesDocumentItem AND Partner_Function = _Extension.PartnerFunction  -- association [1]
;