C_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 C_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: CSUBCTRORDMNTR

CREATE VIEW C_SubcontrgOrdItemMntr AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  FormattedPurchasingDocItem,
  PurchasingDocumentItemText,
  Assembly,
  AssemblyName,
  Plant,
  Subcontractor,
  _Supplier.SupplierName AS SubcontractorName,
  MaterialGroup,
  AccountAssignmentCategory,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  StorageLocation,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName AS PurgCatName,
  RequirementTracking,
  PurchasingDocumentCategory,
  PurchasingDocumentCategoryName,
  PurchasingDocumentType,
  PurchasingDocumentTypeName,
  SchedAgrmtValidityStatus AS Status,
  StatusDescription,
  PurchaseOrderType,
  PurchaseOrderTypeName,
  DeliveryStatus,
  _DeliveryStatusText.DomainText AS DeliveryStatusDescription,
  ShippingStatus,
  ShippingStatusText,
  MaterialComponent AS Material,
  Supplier,
  ValidityStartDate,
  ValidityEndDate,
  OrderQuantity,
  NetAmount,
  TargetAmount,
  ReleasedQuantity,
  ReleasedAmount,
  GoodsReceiptQty,
  GoodsReceiptAmountInCoCodeCrcy,
  StillToBeDeliveredQuantity,
  StillToBeDeliveredValue,
  ScheduleLineDeliveryDate,
  OpenPurchaseOrderQuantity,
  RequirementDate,
  RequiredQuantity,
  DocumentCurrency,
  BaseUnit,
  PurchaseOrderQuantityUnit,
  SupplierIsSubcontractor,
  DifferenceInDays,
  MRPArea,
  _MRPAreaText.MRPAreaText AS MRPAreaText
FROM P_SubcontrgOrdItemMntr
LEFT OUTER JOIN C_MM_AccountAssignCatValueHelp AS _AccAssignValHelp ON AccountAssignmentCategory = _AccAssignValHelp.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_MRPArea AS _MRPAreaText ON MRPArea = _MRPAreaText.MRPArea  -- association [0..1]
LEFT OUTER JOIN I_ProcmtShippingStatusText AS _DeliveryStatusText ON _DeliveryStatusText.DeliveryStatus = DeliveryStatus AND _DeliveryStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Subcontractor = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGrp ON MaterialGroup = _MaterialGrp.MaterialGroup AND _MaterialGrp.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrg ON PurchasingOrganization = _PurchasingOrg.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant association[0..*] to I_ReservationItem as _ReservationItem on PurchasingDocument = _ReservationItem.PurchasingDocument AND PurchasingDocumentItem = _ReservationItem.PurchasingDocumentItem  -- association [0..1]
;