P_Subcontrg3rdPtyDocsMntr

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_Subcontrg3rdPtyDocsMntr.
-- 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: PTHDPTYDOCMNTR

CREATE VIEW P_Subcontrg3rdPtyDocsMntr AS
SELECT
  PurchaseOrder AS PurchasingDocument,
  PurchaseOrderItem AS PurchasingDocumentItem,
  cast(concat(concat(PurchaseOrder, '/'), PurchaseOrderItem) as vdm_formattedpurchasedocitm ) AS FormattedPurchasingDocItem,
  cast(PurchaseOrderItemText as farp_pa_sgtxt) AS PurchasingDocumentItemText,
  cast( ' ' as bagrp) AS Assembly,
  cast(' ' as maktx ) AS AssemblyName,
  Plant,
  _Plant.PlantName AS PlantName,
  cast( Subcontractor as vdm_subcontractor) AS Subcontractor,
  _Subcontractor.SupplierName AS SubcontractorName,
  MaterialGroup,
  cast( _MaterialGroup._Text[1: Language = $session.system_language ].MaterialGroupName as ps_s4_wgbez ) AS MaterialGroupName,
  cast(AccountAssignmentCategory as knttp_ll preserving type) AS AccountAssignmentCategory,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast (_PurchaseOrder.PurchasingOrganization as ekorg_ll) AS PurchasingOrganization,
  cast ( _PurchaseOrder._PurchasingOrganization.PurchasingOrganizationName as vdm_purchasingorgname) AS PurchasingOrganizationName,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  cast (_PurchaseOrder._PurchasingGroup.PurchasingGroupName as vdm_purchasinggroupname) AS PurchasingGroupName,
  StorageLocation,
  cast (_StorageLocation.StorageLocationName as ps_s4_lgort_name ) AS StorageLocationName,
  cast(RequirementTracking as rqmttrckgnmbr_ll) AS RequirementTracking,
  PurchaseOrderCategory AS PurchasingDocumentCategory,
  _PurgDocumentCategory._Text[1: Language = $session.system_language].PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName,
  cast ('' as bsart) AS PurchasingDocumentType,
  cast ('' as batxt) AS PurchasingDocumentTypeName,
  cast ('' as abap.char(10)) AS SchedAgrmtValidityStatus,
  cast ('' as abap.char(10)) AS StatusDescription,
  cast ('00000000' as kdatb) AS ValidityStartDate,
  cast ('00000000' as kdate) AS ValidityEndDate,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrder._PurchaseOrderType._Text[1: Language = $session.system_language].PurchasingDocumentTypeName AS PurchaseOrderTypeName,
  OrderQuantity,
  NetAmount,
  cast(0 as ktwrt) AS TargetAmount,
  cast(0 as abap.quan(13,3)) AS ReleasedQuantity,
  cast(0 as vdm_releasedvalue) AS ReleasedAmount,
  cast(_QtyAndValueCalc.GoodsReceiptQty as mm_a_delivererd_quantity) AS GoodsReceiptQty,
  cast(_QtyAndValueCalc.GoodsReceiptAmountInCoCodeCrcy as mm_delivered_value) AS GoodsReceiptAmountInCoCodeCrcy,
  cast(_QtyAndValueCalc.StillToBeDeliveredQuantity as vdm_stilltobedeliveredquantity ) AS StillToBeDeliveredQuantity,
  cast(_QtyAndValueCalc.StillToBeDeliveredValue as vdm_stilltobedeliveredvalue) AS StillToBeDeliveredValue,
  cast('00000000' as vdm_nextscheddelivdte) AS ScheduleLineDeliveryDate,
  cast(0 as nextscheddelivqty_ll) AS OpenPurchaseOrderQuantity,
  cast( ' ' as vdm_nextscheddelivsts) AS DeliveryStatus,
  cast (' ' as vdm_nextscheddelivsts) AS DeliveryStatusDescription,
  cast( Material as vdm_component) AS MaterialComponent,
  _Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  cast(_PurchaseOrder.Supplier as vdm_thirdptysuplr) AS Supplier,
  _PurchaseOrder._Supplier.SupplierName AS SupplierName,
  cast( _NextDeliveryCalc.DeliveryStatus as vdm_nextschedshipgsts) AS ShippingStatus,
  cast (_NextDeliveryCalc._DeliveryStatusText.DomainText as vdm_nextschedshipgsts) AS ShippingStatusText,
  cast(_NextDeliveryCalc.ScheduleLineDeliveryDate as vdm_nextschedshipgdte) AS RequirementDate,
  cast(_QtyAndValueCalc.StillToBeDeliveredQuantity as nextschedshipgqty_ll) AS RequiredQuantity,
  DocumentCurrency,
  PurchaseOrderQuantityUnit,
  PurchaseOrderQuantityUnit AS BaseUnit,
  PurchaseOrderItemCategory,
  SupplierIsSubcontractor,
  cast( 0 as abap.int4) AS DifferenceInDays,
  MRPArea
FROM I_PurchaseOrderItem
LEFT OUTER JOIN C_POItemNextDeliveryCalc AS _NextDeliveryCalc ON PurchasingDocument = _NextDeliveryCalc.PurchaseOrder AND PurchasingDocumentItem = _NextDeliveryCalc.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN C_POItemQtyAndValueCalc AS _QtyAndValueCalc ON PurchasingDocument = _QtyAndValueCalc.PurchaseOrder AND PurchasingDocumentItem = _QtyAndValueCalc.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN C_SchedgAgrmtItmDelivCalc AS _SchedgAgrmtItmDelivCalc ON PurchasingDocument = _SchedgAgrmtItmDelivCalc.SchedulingAgreement AND PurchasingDocumentItem = _SchedgAgrmtItmDelivCalc.SchedulingAgreementItem  -- association [0..1]
-- UNION ALL with additional select branch(es): I_SchedgAgrmtItm
;