R_PPS_PurOrderContactDraft

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_PPS_PurOrderContactDraft.
-- 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_PPS_PurOrderContactDraft AS
SELECT
  PurchaseOrder,
  PPSContactPersonUUID,
  DraftUUID,
  ParentDraftUUID,
  PurchasingDocumentCategory,
  PPSSqncNmbrOfContactPerson,
  PPSContactCategory,
  PPSContactPerson,
  BusinessPartnerName,
  PurchasingDocumentType,
  _ContactText.PPSContactCategoryText AS PPSContactCategoryText,
  _ContactFunc.PPSContactFunction AS PPSContactFunction,
  _ContactFunc.PPSContactFunctionText AS PPSContactFunctionText,
  _ContactConfig.PPSContactCategoryIsMandatory AS PPSContactCategoryIsMandatory,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges,
  PPSFieldChangeIndicatorBinary
FROM pps_po_contact_d
LEFT OUTER JOIN R_PPS_PurchaseOrderDraft AS _PurchaseOrd ON PurchaseOrder = _PurchaseOrd.PurchaseOrder AND ParentDraftUUID = _PurchaseOrd.DraftUUID  -- association [1..1]
LEFT OUTER JOIN I_PPS_ContactCategoryText AS _ContactText ON PPSContactCategory = _ContactText.PPSContactCategory AND _ContactText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PPS_ContactCategoryBasic AS _ContactFunc ON PPSContactCategory = _ContactFunc.PPSContactCategory  -- association [1..1]
LEFT OUTER JOIN I_PPS_PurgDocCntctCategory AS _ContactConfig ON PPSContactCategory = _ContactConfig.PPSContactCategory AND PurchasingDocumentCategory = _ContactConfig.PurchasingDocumentCategory AND PurchasingDocumentType = _ContactConfig.PurchasingDocumentType  -- association [1..1]
;