R_PPSPurgDocUpdtReqItemDraft

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_PPSPurgDocUpdtReqItemDraft.
-- 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_PPSPurgDocUpdtReqItemDraft AS
SELECT
  PPSPurgDocUpdtRequest,
  PPSPurgDocUpdtRequestItem,
  PPSPurgDocUpdtReqItemStatus,
  PPSItemAllocatedAmount,
  PPSPurgDocUpdtReqItmStsCritlty,
  PPSPurgDocNumber,
  PurchasingDocumentItem,
  PurchasingDocumentVersion,
  PPSRequestedAmount,
  PPSUnfundedAmount,
  DocumentCurrency,
  PurchasingDocumentItemCategory,
  ProductTypeCode,
  Material,
  AccountAssignmentCategory,
  PurgConfigurableItemNumber,
  PPSConfigurableLineItemNumber,
  Plant,
  CompanyCode,
  PurchasingDocumentType,
  PPSFundedAmount,
  PurchasingDocumentCategory,
  _PPSNovationReqItmStsText[1:Language = $session.system_language].PPSNvtnRequestItemStatusText AS PPSNvtnRequestItemStatusText,
  PPSNovationRequestItemStatus,
  PPSNovationReqPurgDocNetAmount,
  PurchasingDocumentCategoryName,
  PurchasingDocumentDescription,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges,
  ApplicationJobDescription,
  ApplicationLogHandle,
  ValidityStartDate,
  ValidityEndDate,
  SemanticObject,
  PPSSmartDocumentNumber
FROM pps_purupdi_d
LEFT OUTER JOIN I_PPSNovationReqItmStsText AS _PPSNovationReqItmStsText ON PPSNovationRequestItemStatus = _PPSNovationReqItmStsText.PPSNovationRequestItemStatus  -- association [1..*]
LEFT OUTER JOIN I_PPSPurgDocUpdtReqItemStsTxt AS _ItemStatusText ON PPSPurgDocUpdtReqItemStatus = _ItemStatusText.DomainValue AND _ItemStatusText.Language = $session.system_language  -- association [1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON _MaterialText.Language = $session.system_language AND Material = _MaterialText.Material  -- association [0..1]
LEFT OUTER JOIN I_AcctAssignmentCategoryText AS _AcctAssignmentCategoryText ON _AcctAssignmentCategoryText.Language = $session.system_language AND _AcctAssignmentCategoryText.AccountAssignmentCategory = AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PPS_PurgDocumentExtension AS _PurgDocumentExtension ON PPSPurgDocNumber = _PurgDocumentExtension.PurchasingDocument  -- association [1]
;