C_MassUpdtPurgDocsMsgDets

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_MassUpdtPurgDocsMsgDets.
-- 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: CDOCMSGDET

CREATE VIEW C_MassUpdtPurgDocsMsgDets AS
SELECT
  SimulationJobUUID,
  SystemMessageNumber,
  SystemMessageIdentification,
  SystemMessageType,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  PurchasingDocument,
  PurchasingDocumentItem,
  _PurchaseOrderHeader.Supplier AS Supplier,
  _PurchaseOrderHeader._Supplier.SupplierName AS SupplierName,
  _PurchaseOrderHeader.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrderHeader._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchaseOrderHeader.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrderHeader._PurchaseOrderType._Text[1:Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _PurchaseOrderHeader.PurchaseOrderDate AS PurchaseOrderDate,
  _PurchaseOrderItem.CompanyCode AS CompanyCode,
  _PurchaseOrderHeader._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PurchaseOrderItem.Plant AS Plant,
  _PurchaseOrderItem._Plant.PlantName AS PlantName,
  _PurchaseOrderItem.Material AS Material,
  _PurchaseOrderItem._Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  _PurchaseOrderHeader.PaymentTerms AS PaymentTerms,
  _PurchaseOrderHeader._PaymentTerms._Text[1:Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  _PurchaseOrderHeader.CashDiscount1Days AS CashDiscount1Days,
  _PurchaseOrderHeader.CashDiscount2Days AS CashDiscount2Days,
  _PurchaseOrderHeader.NetPaymentDays AS NetPaymentDays,
  _PurchaseOrderHeader.CashDiscount1Percent AS CashDiscount1Percent,
  _PurchaseOrderHeader.CashDiscount2Percent AS CashDiscount2Percent,
  _PurchaseOrderHeader.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrderHeader._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  _PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  _PurchaseOrderHeader.ValidityStartDate AS ValidityStartDate,
  _PurchaseOrderHeader.ValidityEndDate AS ValidityEndDate,
  _PurchaseOrderHeader.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  _PurchaseOrderHeader.SupplierPhoneNumber AS SupplierPhoneNumber,
  _PurchaseOrderHeader.SupplyingSupplier AS SupplyingSupplier,
  _PurchaseOrderHeader._SupplyingSupplier.SupplierFullName AS SupplierFullName,
  _PurchaseOrderHeader.IncotermsClassification AS IncotermsClassification,
  _PurchaseOrderHeader._IncotermsClassification._Text[1:Language = $session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  _PurchaseOrderHeader.InvoicingParty AS InvoicingParty,
  _PurchaseOrderHeader._InvoicingParty.SupplierFullName AS InvoicingPartyName,
  _PurchaseOrderHeader.ExchangeRate AS ExchangeRate,
  _PurchaseOrderHeader.IncotermsVersion AS IncotermsVersion,
  _PurchaseOrderHeader._IncotermsVersion._Text[1:Language = $session.system_language].IncotermsVersionName AS IncotermsVersionName,
  _PurchaseOrderHeader.IncotermsLocation1 AS HeaderIncotermsLoc1,
  _PurchaseOrderHeader.IncotermsLocation2 AS HeaderIncotermsLoc2,
  _PurchaseOrderItem.StorageLocation AS StorageLocation,
  _PurchaseOrderItem._StorageLocation.StorageLocationName AS StorageLocationName,
  _PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  _PurchaseOrderItem._MaterialGroup._Text[1:Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  _PurchaseOrderItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  _PurchaseOrderItem.SupplierMaterialNumber AS SupplierMaterialNumber,
  _PurchaseOrderItem.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  _PurchaseOrderItem.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  _PurchaseOrderItem.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  _PurchaseOrderItem.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  _PurchaseOrderItem.NetPriceQuantity AS NetPriceQuantity,
  _PurchaseOrderItem.NetAmount AS NetAmount,
  _PurchaseOrderItem.TaxCode AS TaxCode,
  _PurchaseOrderItem.PriceIsToBePrinted AS PriceIsToBePrinted,
  _PurchaseOrderItem.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  _PurchaseOrderItem.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  _PurchaseOrderItem.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  _PurchaseOrderItem.ValuationType AS ValuationType,
  _PurchaseOrderItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  _PurchaseOrderItem.IsFinallyInvoiced AS IsFinallyInvoiced,
  _PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  _PurchaseOrderItem.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  _PurchaseOrderItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  _PurchaseOrderItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  _PurchaseOrderItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  _PurchaseOrderItem.InvoiceIsExpected AS InvoiceIsExpected,
  _PurchaseOrderItem.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  _PurchaseOrderItem.BaseUnit AS BaseUnit,
  _PurchaseOrderItem.EffectiveAmount AS EffectiveAmount,
  _PurchaseOrderItem.ItemNetWeight AS ItemNetWeight,
  _PurchaseOrderItem.ItemWeightUnit AS ItemWeightUnit,
  _PurchaseOrderItem.TaxJurisdiction AS TaxJurisdiction,
  _PurchaseOrderItem.InternationalArticleNumber AS InternationalArticleNumber,
  _PurchaseOrderItem.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  _PurchaseOrderItem._ConfirmationControlVH.SupplierConfControlKeyName AS SupplierConfControlKeyName,
  _PurchaseOrderItem.PricingDateControl AS PricingDateControl,
  _PurchaseOrderItem.ItemVolume AS ItemVolume,
  _PurchaseOrderItem.ItemVolumeUnit AS ItemVolumeUnit,
  _PurchaseOrderItem.IncotermsClassification AS ItemIncotermsClassification,
  _PurchaseOrderItem.SupplierSubrange AS SupplierSubrange,
  _PurchaseOrderItem.ServicePackage AS ServicePackage,
  _PurchaseOrderItem.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  _PurchaseOrderItem.IsReturnsItem AS IsReturnsItem,
  _PurchaseOrderItem.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  _PurchaseOrderItem.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  _PurchaseOrderItem.IncotermsLocation1 AS IncotermsLocation1,
  _PurchaseOrderItem.IncotermsLocation2 AS IncotermsLocation2,
  _PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  _PurchaseOrderItem.ProductType AS ProductType,
  _PurchaseOrderItem._ProductType._Text[1:Language = $session.system_language].Name AS ProductTypeName,
  _PurchaseOrderItem.OrderPriceUnit AS OrderPriceUnit,
  _PurchaseOrderStatus.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  _PurchaseOrderStatus.PurchasingDocumentStatusName AS PurchasingDocumentStatusName,
  _PurchaseOrderItem.PurchaseOrderItemText AS PurchaseOrderItemText
FROM P_SimlnLogSingleSuccess
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrderHeader ON PurchasingDocument = _PurchaseOrderHeader.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN P_PurchaseOrderItemsImpacted AS _PurchaseOrderItem ON PurchasingDocument = _PurchaseOrderItem.PurchaseOrder AND PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderStatusText AS _PurchaseOrderStatus ON PurchasingDocument = _PurchaseOrderStatus.PurchaseOrder  -- association [0..1]
;