C_PurchaseOrderMassUpdate

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_PurchaseOrderMassUpdate.
-- 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_PurchaseOrderMassUpdate AS
SELECT
  PurchaseOrder,
  Supplier,
  I_PurchaseOrder._Supplier.SupplierName AS SupplierName,
  CompanyCode,
  I_PurchaseOrder._CompanyCode.CompanyCodeName AS CompanyCodeName,
  PurchasingOrganization,
  I_PurchaseOrder._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  I_PurchaseOrder._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  PurchaseOrderDate,
  PurchaseOrderType,
  _PurchaseOrderType._Text[1:Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PaymentTerms,
  _PaymentTerms._Text[1:Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  I_PurchaseOrder.IncotermsClassification AS IncotermsClassification,
  _IncotermsClassification._Text[1:Language = $session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  InvoicingParty,
  I_PurchaseOrder._InvoicingParty.SupplierFullName AS InvoicingPartyName,
  _PurchaseOrderStatus.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  _PurchaseOrderStatus.PurchasingDocumentStatusName AS PurchasingDocumentStatusName,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  ExchangeRate,
  DocumentCurrency,
  ValidityStartDate,
  ValidityEndDate,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  SupplyingSupplier,
  I_PurchaseOrder._SupplyingSupplier.SupplierFullName AS SupplierFullName,
  IncotermsLocation1 AS HeaderIncotermsLoc1,
  IncotermsLocation2 AS HeaderIncotermsLoc2,
  IncotermsVersion,
  _IncotermsVersion._Text[1:Language = $session.system_language].IncotermsVersionName AS IncotermsVersionName,
  cast('' as mm_vdm_single_sched) AS AllItemsHaveSingleScheduleLine,
  cast ('' as matkl) AS MaterialGroup,
  cast ('' as ewerk) AS Plant,
  cast ('' as matnr) AS Material,
  cast ('' as knttp) AS AccountAssignmentCategory,
  cast ('' as vdm_itemcategory) AS PurchaseOrderItemCategory,
  cast ('' as eloek) AS PurchasingDocumentDeletionCode,
  cast ('00000000' as eindt) AS ScheduleLineDeliveryDate,
  cast('00000000' as performanceperiodstartdate) AS PerformancePeriodStartDate,
  cast('00000000' as mmpur_servproc_period_end) AS PerformancePeriodEndDate
FROM I_PurchaseOrder
LEFT OUTER JOIN C_PurchaseOrderItemMassUpdate AS _PurchaseOrderItemMassUpdate ON PurchaseOrder = _PurchaseOrderItemMassUpdate.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_POMassUpdtDelivSchedItm AS _ScheduleLine ON PurchaseOrder = _ScheduleLine.PurchaseOrder  -- association [1..*]
LEFT OUTER JOIN I_PurchaseOrderStatusText AS _PurchaseOrderStatus ON PurchaseOrder = _PurchaseOrderStatus.PurchaseOrder  -- association [0..1]
;