P_SubcontrgOrdItemMntr

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_SubcontrgOrdItemMntr.
-- 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: PSUBCONTRORDMNTR

CREATE VIEW P_SubcontrgOrdItemMntr AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  FormattedPurchasingDocItem,
  PurchasingDocumentItemText,
  Assembly,
  AssemblyName,
  Plant,
  Subcontractor,
  MaterialGroup,
  AccountAssignmentCategory,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  StorageLocation,
  RequirementTracking,
  PurchasingDocumentCategory,
  PurchasingDocumentCategoryName,
  PurchasingDocumentType,
  PurchasingDocumentTypeName,
  SchedAgrmtValidityStatus,
  case when PurchasingDocumentCategory = 'F' then cast ('' as abap.char(10)) when PurchasingDocumentCategory = 'L' then cast (_ValidityStatusVH.Name as abap.char(10)) end as StatusDescription AS char10endasStatusDescription,
  ValidityStartDate,
  ValidityEndDate,
  PurchaseOrderType,
  PurchaseOrderTypeName,
  OrderQuantity,
  NetAmount,
  TargetAmount,
  ReleasedQuantity,
  ReleasedAmount,
  GoodsReceiptQty,
  GoodsReceiptAmountInCoCodeCrcy,
  StillToBeDeliveredQuantity,
  StillToBeDeliveredValue,
  ScheduleLineDeliveryDate,
  cast(ScheduleLineOpenQty as nextscheddelivqty_ll) AS OpenPurchaseOrderQuantity,
  cast(' ' as vdm_component) AS MaterialComponent,
  cast(' ' as vdm_thirdptysuplr) AS Supplier,
  cast(' ' as vdm_nextschedshipgsts) AS ShippingStatus,
  cast (' ' as vdm_nextschedshipgsts) AS ShippingStatusText,
  cast('00000000' as vdm_nextschedshipgdte) AS RequirementDate,
  cast(0 as nextschedshipgqty_ll) AS RequiredQuantity,
  DocumentCurrency,
  OrderQuantityUnit AS PurchaseOrderQuantityUnit,
  OrderQuantityUnit AS BaseUnit,
  SupplierIsSubcontractor,
  MRPArea
FROM P_SubcontrgItemQtyAndValueCalc
LEFT OUTER JOIN C_MM_ValidityStatusValHelp AS _ValidityStatusVH ON SchedAgrmtValidityStatus = _ValidityStatusVH.Status  -- association [0..1]
;