P_purgdocconf

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 P_purgdocconf.
-- 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.
-- SQL view name: PPURDOCCON

CREATE VIEW P_purgdocconf AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  ScheduleLine,
  SupplierConfirmationCategory,
  ScheduleLineUniqueID,
  MaterialName,
  AccountAssignmentCategory,
  CompanyCodeName,
  PurchasingGroup,
  ConfirmationControl,
  PurchasingOrganization,
  Material,
  MaterialGroup,
  PlantName,
  PurchasingOrganizationName,
  PurchasingGroupName,
  PurchasingDocumentName,
  PurchasingDocumentType,
  DocumentDate,
  DelivDateCategory,
  Supplier,
  DocumentCurrency,
  SupplierName,
  PurchasingDocumentCategory,
  OrderQuantity,
  NetAmount,
  PurchasingDocumentDeletionCode,
  CompanyCode,
  PurchasingDocumentItemCategory,
  NetPriceAmount,
  NetPriceQuantity,
  MaterialNumber,
  ShortText,
  Plant,
  OrderUnit,
  CummulativeSheduleQuantity,
  PurchasingCategory,
  PurgCatName,
  AcctAssignmentCategoryName,
  ScheduleLineDeliveryDate,
  SupplierConfCategoryName,
  OrderedQuantity,
  BalanceQuantity,
  KeyDate,
  ItemPrice,
  ValidityStartDate,
  ValidityEndDate,
  TargetAmount,
  RequirementTracking,
  StorageLocation,
  StorageLocationName,
  NetValueAmount,
  PurchasingProcessingStatus,
  PurgDocExternalItemCategory,
  PurgDocItemCategoryName,
  CommittedQuantity,
  ScheduleLineCommittedAmount,
  case when CommittedQuantity is null then OrderedQuantity else cast( OrderedQuantity - CommittedQuantity as abap.quan(13,3) ) end as ScheduleLinePndgQtyInStkUnit AS quan133endasScheduleLinePndgQtyInStkUnit,
  CreationDate,
  cast( case when DurationToNextStatusInDays <= weekday1 and DurationToNextStatusInDays >= 0 then '2' when DurationToNextStatusInDays > weekday1 then '3' else '1' end as abap.char( 10 ) ) as DurationToNextStatusInDays AS char10asDurationToNextStatusInDays,
  case when (_SAItemGR.ReleasedQuantity is null) then cast (0 as abap.quan(13,3)) else _SAItemGR.ReleasedQuantity end as ReleasedQuantity AS ReleasedQuantityendasReleasedQuantity,
  case when (_SAItemGR.GoodsReceiptQty is null or GoodsReceiptIsExpected <> 'X') then cast(0 as abap.quan(13,3)) else _SAItemGR.GoodsReceiptQty end as GoodsReceiptQty AS GoodsReceiptQtyendasGoodsReceiptQty
FROM P_Purgdocument
LEFT OUTER JOIN I_PurchaseOrderStatus AS _PurchaseOrderStatus ON _PurchaseOrderStatus.PurchaseOrder = PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_Schedgagrmthdr AS _SAHeader ON PurchasingDocument = _SAHeader.SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN P_SchedgAgrmtItmGRQty AS _SAItemGR ON _SAItemGR.SchedulingAgreement = PurchasingDocument AND _SAItemGR.SchedulingAgreementItem = PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN P_PurgDocMissingSuplrConf AS _PurgDocMissingSuplrConf ON _PurgDocMissingSuplrConf.PurchasingDocument = PurchasingDocument AND _PurgDocMissingSuplrConf.PurchasingDocumentItem = PurchasingDocumentItem  -- association [1..1]
;