P_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 P_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.
-- SQL view name: PPOMASSUPDATE

CREATE VIEW P_PurchaseOrderMassUpdate AS
SELECT
  cast(I_PurchaseOrder.PurchaseOrder as abap.char(25)) AS FormattedPurDoc,
  cast(I_PurchaseOrder.PurchaseOrder as abap.char(16)) AS FormattedPurchasingDocItem,
  I_PurchaseOrder.PurchaseOrder AS PurchaseOrder,
  cast('' as vdm_purchaseorderitem) AS PurchaseOrderItem,
  cast('00000000000000' as abap.char( 30 )) AS ReleaseDateTime,
  cast ('' as abap.char( 120 )) AS InternalComment,
  cast ('' as abap.sstring( 1332 )) AS MemoLine,
  cast ('' as abap.sstring( 1332 )) AS DefectCodeText,
  cast ('' as abap.char( 1 )) AS ItemIsSelectedForProcessing,
  cast ('' as abap.char( 1 )) AS PurgDocMassUpdtIsSimulated,
  _POCount.NumberOfPurchaseOrderItems AS NumberOfPurchaseOrderItems,
  cast ( '0' as abap.char(1)) AS HierarchyNodeLevel,
  cast ( ' ' as abap.char(16)) AS ParentNode,
  cast ('expanded' as abap.char(8)) AS DrillDownState,
  cast(0 as abap.int4 ) AS NumberOfItems,
  Supplier,
  I_PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  I_PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrderDate,
  PurchasingDocumentOrigin,
  CompanyCode,
  cast ('' as ewerk) AS Plant,
  cast ('' as matnr) AS Material,
  PaymentTerms,
  _PaymentTerms._Text[1: Language = $session.system_language ].PaymentTermsName AS PaymentTermsName,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  I_PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  DocumentCurrency,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  SupplyingSupplier,
  IncotermsClassification,
  _IncotermsClassification._Text[1: Language = $session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  IncotermsTransferLocation,
  InvoicingParty,
  cast (ExchangeRate as abap.quan( 9, 5 )) AS ExchangeRate,
  _Supplier.SupplierName AS SupplierName,
  IncotermsVersion,
  _PurchaseOrderType._Text[1: Language = $session.system_language ].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  cast(IncotermsLocation1 as vdm_h_inco2_l ) AS HeaderIncotermsLoc1,
  cast(IncotermsLocation2 as vdm_h_inco3_l ) AS HeaderIncotermsLoc2,
  PurchasingDocumentDeletionCode,
  cast ('' as ematnr) AS ManufacturerMaterial,
  cast ('' as vdm_storage_location) AS StorageLocation,
  cast ('' as matkl) AS MaterialGroup,
  cast ('' as infnr) AS PurchasingInfoRecord,
  cast ('' as idnlf) AS SupplierMaterialNumber,
  cast ('0' as bpumz) AS OrderPriceUnitToOrderUnitNmrtr,
  cast ('0' as bpumn) AS OrdPriceUnitToOrderUnitDnmntr,
  cast ('0' as umbsz) AS OrderItemQtyToBaseQtyNmrtr,
  cast ('0' as umbsn) AS OrderItemQtyToBaseQtyDnmntr,
  cast ('0' as vdm_price_unit) AS NetPriceQuantity,
  cast ('0' as netwr) AS NetAmount,
  cast ('' as mwskz) AS TaxCode,
  cast ('' as prsdr) AS PriceIsToBePrinted,
  cast ('0' as uebto) AS OverdelivTolrtdLmtRatioInPct,
  cast ('' as uebtk) AS UnlimitedOverdeliveryIsAllowed,
  cast ('0' as untto) AS UnderdelivTolrtdLmtRatioInPct,
  cast ('' as bwtar_d) AS ValuationType,
  cast ('' as elikz) AS IsCompletelyDelivered,
  cast ('' as erekz) AS IsFinallyInvoiced,
  cast ('' as pstyp) AS PurchaseOrderItemCategory,
  cast('' as ptext_d) AS PurgDocItemCategoryName,
  cast ('' as knttp) AS AccountAssignmentCategory,
  cast ('' as vrtkz) AS MultipleAcctAssgmtDistribution,
  cast ('' as twrkz) AS PartialInvoiceDistribution,
  cast ('' as wepos) AS GoodsReceiptIsExpected,
  cast ('' as weunb) AS GoodsReceiptIsNonValuated,
  cast ('' as repos) AS InvoiceIsExpected,
  cast ('' as webre) AS InvoiceIsGoodsReceiptBased,
  cast ('' as lagme) AS BaseUnit,
  cast ('0' as effwr) AS EffectiveAmount,
  cast ('0' as ntgew) AS ItemNetWeight,
  cast ('' as gewei) AS ItemWeightUnit,
  cast ('' as txjcd) AS TaxJurisdiction,
  cast ('' as ean11) AS InternationalArticleNumber,
  cast ('' as bstae) AS SupplierConfirmationControlKey,
  cast ('' as prctr) AS ProfitCenter,
  cast ('' as meprf) AS PricingDateControl,
  cast ('0' as volum) AS ItemVolume,
  cast ('' as voleh) AS ItemVolumeUnit,
  cast ('' as inco1) AS ItemIncotermsClassification,
  cast ('' as inco2) AS ItemIncotermsTransferLocation,
  cast ('' as ltsnr) AS SupplierSubrange,
  cast ('' as packno) AS ServicePackage,
  cast ('' as xersy) AS EvaldRcptSettlmtIsAllowed,
  cast ('' as retpo) AS IsReturnsItem,
  cast ('' as kblnr) AS EarmarkedFunds,
  cast ('' as kblpos) AS EarmarkedFundsItem,
  cast ('' as inco2_l) AS IncotermsLocation1,
  cast ('' as inco3_l) AS IncotermsLocation2,
  cast ('' as serviceperformer) AS ServicePerformer,
  cast ('' as producttype) AS ProductType,
  cast ('' as bprme) AS OrderPriceUnit,
  cast ('' as maktx) AS MaterialName,
  cast ('' as txz01) AS PurchaseOrderItemText,
  cast ('' as werks_name) AS PlantName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast ('' as kalsm_d) AS TaxCalculationProcedure,
  _Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  cast ('' as abap.char( 2 )) AS PurchasingDocumentStatus,
  cast ('' as ddtext) AS PurchasingDocumentStatusName,
  cast ('PurchaseOrder' as abap.char( 40 )) AS SemanticObject,
  cast ('' as meins) AS PurchaseOrderQuantityUnit,
  cast ('' as lgort_name) AS StorageLocationName,
  cast ('' as wgbez) AS MaterialGroupName,
  cast ('' as product_type_description) AS ProductTypeName,
  _InvoicingParty.SupplierName AS InvoicingPartyName,
  cast('00000000' as performanceperiodstartdate) AS PerformancePeriodStartDate,
  cast('00000000' as mmpur_servproc_period_end) as PerformancePeriodEndDate AS char25asFormattedPurDoc,
  cast ('00000000' as kdatb) AS ValidityStartDate,
  cast ('00000000' as kdate) AS ValidityEndDate,
  _ScheduleLine.PerformancePeriodEndDate AS PerformancePeriodEndDate
FROM I_PurchaseOrder
INNER JOIN C_Purchaseorderitemcount AS _POCount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseOrderScheduleLine AS _ScheduleLine ON _Item.PurchaseOrder = _ScheduleLine.PurchaseOrder AND _Item.PurchaseOrderItem = _ScheduleLine.PurchaseOrderItem AND _Item.ProductType = '2'  -- association [0..1]
-- UNION with additional select branch(es): I_PurchaseOrderItem
;