C_PPS_PurchaseReqnTP

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_PurchaseReqnTP.
-- 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_PurchaseReqnTP AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionType,
  _PurchaseRequisitionDocType._TextDoc.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PurReqnDescription,
  SourceDetermination,
  _PurReqnHeaderStatus.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  CreationDate,
  IsPurReqnOvrlRel,
  PurchasingDocumentSubtype,
  LastChangeDateTime,
  PPSPurgDocClassfctnCode,
  _PurReqnHeaderStatus.PPSPurReqnItemApprovalDate AS PPSPurchaseReqnApprovalDate,
  _Classification.PPSPurgDocClassfctnTxt AS PPSPurgDocClassfctnTxt,
  PPSPurchaseReqnIsInPreparation,
  PPSFuturePostingDate,
  PPSSmartNumberHeader,
  PPSSmartNumberHeaderIsManual,
  PPSPurReqnHeaderStatus,
  _PurReqnHeaderStatusText.PurchasingDocumentStatusName AS PPSPurReqnHeaderStatusText,
  PPSPurchaseRequisitionKey,
  virtual TotalNetAmount : abap.curr(15,2) AS curr152,
  virtual Currency : abap.cuky( 5 ) AS cuky5,
  virtual PPSPurReqnHdrStatusCriticality : abap.int1 AS int1,
  virtual PurReqnHdrCurrencySourceDesc : abap.char( 60 ) AS char60,
  virtual MaterialGroup : matkl AS virtualMaterialGroupmatkl,
  virtual PurchasingGroup : ekgrp AS virtualPurchasingGroupekgrp,
  virtual GLAccount : saknr AS virtualGLAccountsaknr,
  virtual CostCenter : kostl AS virtualCostCenterkostl,
  CreatedByUser,
  _UserContactCard.UserDescription AS CreatedByUserName,
  virtual Material : matnr AS virtualMaterialmatnr,
  virtual PurchasingOrganization : ekorg AS virtualPurchasingOrganizationekorg,
  virtual PurReqnReleaseStatusName : val_text AS virtualPurReqnReleaseStatusNameval_text,
  virtual PPSOpenTextURL : pps_e_opentext_url AS virtualPPSOpenTextURLpps_e_opentext_url,
  virtual PurReqnOrigin : abap.char(1) AS char1,
  virtual PurReqnOriginDesc : val_text AS virtualPurReqnOriginDescval_text,
  virtual PPSGroupName : pps_e_group_name AS virtualPPSGroupNamepps_e_group_name,
  virtual UICT_HideSmartNumberHeader : boolean AS virtualUICT_HideSmartNumberHeaderboolean,
  virtual UICT_HideOpenText : boolean AS virtualUICT_HideOpenTextboolean,
  virtual UICT_HideItemSmmryFacet : boolean AS virtualUICT_HideItemSmmryFacetboolean,
  virtual UICT_IsThirdPartySales : boolean AS virtualUICT_IsThirdPartySalesboolean
FROM R_PPS_PurchaseReqnTP
LEFT OUTER JOIN C_PPS_PurReqnItmDocTot AS _ItemDocumentTotal ON PurchaseRequisition = _ItemDocumentTotal.PurchaseRequisition  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurgDocBudgetOverviewC AS _PurgDocBudgetOverview ON PurchaseRequisition = _PurgDocBudgetOverview.ReferenceDocument  -- association [0..*]
;