C_PurchaseOrderItemMassUpdate

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_PurchaseOrderItemMassUpdate.
-- 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: CPOITMMASSUPDATE

CREATE VIEW C_PurchaseOrderItemMassUpdate AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  cast(concat(concat(PurchaseOrder, '/'), PurchaseOrderItem) as vdm_formattedpurchaseorditm preserving type) AS FormattedPurchaseOrderItem,
  PurchaseOrderItemText,
  MaterialGroup,
  _MaterialGroup._Text[1:Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  Material,
  _Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrder._Supplier.SupplierName AS SupplierName,
  AccountAssignmentCategory,
  cast ('00000000' as eindt) AS ScheduleLineDeliveryDate,
  cast ('00000000' as eindt) AS SourceScheduleLineDeliveryDate,
  cast (0 as abap.int4) AS NumberOfScheduleLines,
  cast ('0' as etmen) AS ScheduleLineOrderQuantity,
  cast ('' as bstme) AS PurchaseOrderQuantityUnit,
  cast ('00000000' as mmpur_servproc_period_start) AS PerformancePeriodStartDate,
  cast ('00000000' as mmpur_servproc_period_end) AS PerformancePeriodEndDate,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  Plant,
  _Plant.PlantName AS PlantName,
  _PurchaseOrderStatus.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  _PurchaseOrderStatus.PurchasingDocumentStatusName AS PurchasingDocumentStatusName,
  _PurchaseOrder.CompanyCode AS CompanyCode,
  _PurchaseOrder._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrder._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  _PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrderItemCategory,
  _PurgDocumentItemCategory._Text[1:Language = $session.system_language].PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  _PurgDocumentItemCategory._Text[1:Language = $session.system_language].PurgDocItemCategoryName AS PurgDocItemCategoryName,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrder._PurchaseOrderType._Text[1:Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  ProductType,
  _ProductType._Text[1:Language = $session.system_language].Name AS Name,
  _PurchaseOrder.PaymentTerms AS PaymentTerms,
  _PurchaseOrder._PaymentTerms._Text[1:Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  _PurchaseOrder.IncotermsClassification AS IncotermsClassification,
  _PurchaseOrder._IncotermsClassification._Text[1:Language = $session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  _PurchaseOrder.InvoicingParty AS InvoicingParty,
  _PurchaseOrder._InvoicingParty.SupplierFullName AS InvoicingPartyName,
  ManufacturerMaterial,
  _ManufacturerMaterial._Text[1:Language = $session.system_language].MaterialName AS ManufacturerName,
  MultipleAcctAssgmtDistribution,
  _DistributionIndicator._Text[1:Language = $session.system_language].DistributionKeyText AS DistributionKeyText,
  PartialInvoiceDistribution,
  ProfitCenter,
  BaseUnit,
  ItemWeightUnit,
  ItemWeightUnit AS WeightUnit,
  SupplierConfirmationControlKey,
  _ConfirmationControlVH.SupplierConfControlKeyName AS SupplierConfControlKeyName,
  DocumentCurrency,
  UnlimitedOverdeliveryIsAllowed,
  ValuationType,
  IsCompletelyDelivered,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  _PurchaseOrder.CashDiscount1Days AS CashDiscount1Days,
  _PurchaseOrder.CashDiscount2Days AS CashDiscount2Days,
  _PurchaseOrder.NetPaymentDays AS NetPaymentDays,
  _PurchaseOrder.CashDiscount1Percent AS CashDiscount1Percent,
  _PurchaseOrder.CashDiscount2Percent AS CashDiscount2Percent,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  EffectiveAmount,
  _PurchaseOrder.ExchangeRate AS ExchangeRate,
  IsFinallyInvoiced,
  GoodsReceiptIsExpected,
  _PurchaseOrder.SupplyingSupplier AS SupplyingSupplier,
  _PurchaseOrder._SupplyingSupplier.SupplierFullName AS SupplierFullName,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  IncotermsClassification AS ItemIncotermsClassification,
  _PurchaseOrder.IncotermsLocation1 AS HeaderIncotermsLoc1,
  _PurchaseOrder.IncotermsLocation2 AS HeaderIncotermsLoc2,
  IncotermsLocation1,
  IncotermsLocation2,
  _PurchaseOrder.IncotermsVersion AS IncotermsVersion,
  _PurchaseOrder._IncotermsVersion._Text[1:Language = $session.system_language].IncotermsVersionName AS IncotermsVersionName,
  InternationalArticleNumber,
  ItemNetWeight,
  GoodsReceiptIsNonValuated,
  OrderPriceUnit,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  EvaldRcptSettlmtIsAllowed,
  ServicePackage,
  NetPriceQuantity,
  PricingDateControl,
  _PricingDateControl._Text[1:Language = $session.system_language].PricingDateControlText AS PricingDateControlText,
  PriceIsToBePrinted,
  PurchasingInfoRecord,
  IsReturnsItem,
  _PurchaseOrder.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  ServicePerformer,
  _ServicePerformer.PersonFullName AS PersonFullName,
  SupplierMaterialNumber,
  SupplierSubrange,
  TaxCode,
  TaxJurisdiction,
  _PurchaseOrder.SupplierPhoneNumber AS SupplierPhoneNumber,
  _PurchaseOrder.ValidityStartDate AS ValidityStartDate,
  _PurchaseOrder.ValidityEndDate AS ValidityEndDate,
  OrderQuantity,
  ItemVolume,
  ItemVolumeUnit,
  ItemVolumeUnit AS VolumeUnit,
  PurchasingDocumentDeletionCode,
  _DeltnIndVH._Text[1:Language = $session.system_language].PurDocDeletionCodeName AS PurDocDeletionCodeName,
  cast('00000000000000' as abap.char( 30 )) AS ReleaseDateTime,
  cast ('' as abap.char( 120 )) AS InternalComment,
  cast ('' as abap.sstring( 1332 )) AS PurchasingDocInclusionList,
  cast ('' as abap.sstring( 1332 )) AS PurchasingDocExclusionList,
  cast ('' as abap.char( 1 )) AS PurOrdItemsAreSelected,
  cast ('' as abap.char( 1 )) AS PurOrdHeadersAreSelected,
  cast ('' as abap.char( 1 )) AS PurgDocMassUpdtIsSimulated,
  cast ('false' as abap.char(4)) AS ErrorFlagIsSet,
  cast ('' as boole_d ) AS WarningFlagIsSet
FROM I_PurchaseOrderItem
LEFT OUTER JOIN I_PurchaseOrderStatusText AS _PurchaseOrderStatus ON PurchaseOrder = _PurchaseOrderStatus.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_POMassUpdtDelivSchedItm AS _ScheduleLine ON PurchaseOrder = _ScheduleLine.PurchaseOrder AND PurchaseOrderItem = _ScheduleLine.PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN I_PurgDocDeletionIndicator AS _DeltnIndVH ON PurchasingDocumentDeletionCode = _DeltnIndVH.PurchasingContractDeletionCode  -- association [1..1]
LEFT OUTER JOIN C_MassUpdtConfCtrlVH AS _ConfirmationControlVH ON SupplierConfirmationControlKey = _ConfirmationControlVH.SupplierConfirmationControlKey  -- association [1..1]
LEFT OUTER JOIN I_ProcmtPricingDateControl AS _PricingDateControl ON PricingDateControl = _PricingDateControl.PricingDateControl  -- association [1..1]
LEFT OUTER JOIN I_AcctAssgmtDistrIndicator AS _DistributionIndicator ON MultipleAcctAssgmtDistribution = _DistributionIndicator.MultipleAcctAssgmtDistribution  -- association [1..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _MaterialVH ON _MaterialVH.Material = Material AND _MaterialVH.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrganizationVH ON PurchasingOrganization = _PurchasingOrganizationVH.PurchasingOrganization  -- association [0..1]
;