C_PPS_DeobligationGroupItem

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 C_PPS_DeobligationGroupItem.
-- 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 C_PPS_DeobligationGroupItem AS
SELECT
  PurchaseOrder AS PurchasingDocument,
  PurchaseOrderItem AS PurchasingDocumentItem,
  PPSGroupUUID,
  cast( '' as pps_e_doc_cat preserving type ) AS PurchasingDocumentCategory,
  DocumentCategoryText,
  cast( PPSFrmtdPurOrdItm as pps_e_dobgln_frmtd_doc_num preserving type ) AS PPSFrmtdPurgDocItm,
  PPSGroupName,
  _ItemStatus._Text[1:Language = $session.system_language ].PPSGroupItemStatusText AS PPSDeobligationStatusText,
  PPSPurOrderItemStatus AS PPSPurgDocumentItemStatus,
  cast ( PPSGroupItemStatusCode as pps_e_dobgln_grp_itm_status) AS PPSGroupItemStatusCode,
  cast ( CreationDateTime as pps_e_dobgln_added_on preserving type ) AS CreationDateTime,
  PurchaseOrderQuantityUnit,
  DocumentCurrency,
  PPSOpenGoodsReceiptQuantity,
  PPSOpenGoodsReceiptAmount,
  PPSOpenInvoiceReceiptAmount,
  PPSOpenServiceEntrySheetAmount,
  cast ( NetAmount as pps_e_deobligation_total_amt ) AS NetAmount,
  PPSSmartDocumentNumber,
  PPSPurOrderItemStatusText AS PPSPurgDocumentItemStatusText,
  PPSOrigin
FROM I_PPS_PurOrdDoblgnGrpItm
-- UNION ALL with additional select branch(es): I_PPS_PurReqnDoblgnGrpItm
;