R_PPS_PurOrdItmForDoblgnTP

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_PurOrdItmForDoblgnTP.
-- 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_PurOrdItmForDoblgnTP AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  cast ( concat_with_space( concat( ltrim( PurchaseOrder, '0' ), ' /' ), ltrim( PurchaseOrderItem , '0' ), 1 ) as pps_po_frmtd_itm ) AS PPSFrmtdPurOrdItm,
  PurchaseOrderCategory,
  PurchasingGroup,
  CompanyCode,
  Supplier,
  DocumentCurrency,
  cast(CreatedByUser as pps_e_createdby preserving type ) AS CreatedByUser,
  MaterialGroup,
  ManufacturerMaterial,
  cast(CreationDate as pps_e_creation preserving type ) AS CreationDate,
  PurchasingParentItem,
  PPSConfigurableLineItemNumber,
  PurchaseOrderItemCategory,
  PPSIsPrcgArrgmtChildItm,
  PPSPurOrderItemStatus,
  NetAmount,
  Plant,
  PPSOptionalItemStatus,
  PPSIsOptionalItem,
  PPSPurgDocItmDoblgnStatus,
  PurchaseOrderItemText,
  PurchaseOrderQuantityUnit,
  PurgConfigurableItemNumber,
  PPSFiscalYear,
  cast( PurchasingOrganization as pps_e_purchasing_organization preserving type ) AS PurchasingOrganization,
  cast( PurchaseOrderType as pps_e_deobligation_doc_type preserving type ) AS PurchaseOrderType,
  cast( ProductTypeCode as pps_e_item_category preserving type ) AS ProductTypeCode,
  PPSResponsiblePurchaser,
  PurgDocAggrgdSubitemCategory,
  _DeobligationGroup.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  cast(_DeobligationGroup.PPSPurgDocNumber as pps_e_purg_doc_number preserving type ) AS PPSPurgDocNumber,
  _DeobligationGroup.PurchasingDocumentItem AS PurchasingDocumentItem,
  _DeobligationGroup.PPSGroupUUID AS PPSGroupUUID,
  _DeobligationGroup.PPSGroupStatusCode AS PPSGroupStatusCode,
  _DeobligationGroup.PPSGroupName AS PPSGroupName,
  _DeobligationGroup.PPSGroupRunCompletionDateTime AS PPSGroupRunCompletionDateTime,
  _DeobligationGroup.PPSOrigin AS PPSOrigin,
  cast( _DeobligationGroup.ApplicationLogHandle as pps_e_doblgn_log_handle preserving type ) AS ApplicationLogHandle,
  _DeobligationGroup.CreationDateTime AS CreationDateTime,
  _DeobligationGroup.LastChangeDateTime AS LastChangeDateTime,
  _DeobligationGroup.ChangedBy AS ChangedBy,
  PurchasingIsItemSet
FROM R_PPS_PurOrdItmForDoblgnHN
LEFT OUTER JOIN R_PPS_PurOrdItmForDoblgnTP AS _HierarchyParent ON PurchaseOrder = _HierarchyParent.PurchaseOrder AND PurchasingParentItem = _HierarchyParent.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategoryText AS _PurgDocumentItemCategoryText ON _PurgDocumentItemCategoryText.Language = $session.system_language AND _PurgDocumentItemCategoryText.PurchasingDocumentItemCategory = PurchaseOrderItemCategory  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchaseOrderTypeText ON _PurchaseOrderTypeText.PurchasingDocumentType = PurchaseOrderType AND _PurchaseOrderTypeText.PurchasingDocumentCategory = 'F' AND _PurchaseOrderTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON PPSResponsiblePurchaser = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_PPS_GroupItemDetail AS _DeobligationGroup ON PurchaseOrder = _DeobligationGroup.PPSPurgDocNumber AND PurchaseOrderItem = _DeobligationGroup.PurchasingDocumentItem AND _DeobligationGroup.PPSOrigin = 'DO'  -- association [0..1]
LEFT OUTER JOIN I_PPSGroupItemStatusCodeVH AS _ItemStatus ON PPSGroupItemStatusCode = _ItemStatus.DomainValue  -- association [0..1]
LEFT OUTER JOIN I_PPS_ProductTypeCodeText AS _ProductTypeCodeText ON _ProductTypeCodeText.ProductTypeCode = ProductTypeCode AND _ProductTypeCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON _UserContactCard.ContactCardID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;