C_PurgOrdMassUpdtStruc

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_PurgOrdMassUpdtStruc.
-- 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: CPOMASUPDTSTRT

CREATE VIEW C_PurgOrdMassUpdtStruc AS
SELECT
  FormattedPurDoc,
  FormattedPurchasingDocItem,
  PurchaseOrder,
  PurchaseOrderItem,
  NumberOfPurchaseOrderItems,
  ParentNode,
  NumberOfItems,
  ReleaseDateTime,
  InternalComment,
  MemoLine,
  DefectCodeText,
  ItemIsSelectedForProcessing,
  PurgDocMassUpdtIsSimulated,
  Supplier,
  PurchasingOrganization,
  PurchaseOrderType AS PurchasingDocumentType,
  PurchasingDocumentOrigin,
  CompanyCode,
  Plant,
  Material,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PurchasingGroup,
  DocumentCurrency,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  SupplyingSupplier,
  IncotermsClassification,
  IncotermsTransferLocation,
  InvoicingParty,
  InvoicingPartyName,
  ExchangeRate,
  IncotermsVersion,
  HeaderIncotermsLoc1,
  HeaderIncotermsLoc2,
  PaymentTermsName,
  IncotermsClassificationName,
  SupplierName,
  PurchasingDocumentTypeName,
  PurchasingOrganizationName,
  PurchasingGroupName,
  PurchasingDocumentDeletionCode,
  ManufacturerMaterial,
  StorageLocation,
  StorageLocationName,
  MaterialGroup,
  MaterialGroupName,
  PurchasingInfoRecord,
  SupplierMaterialNumber,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  NetPriceQuantity,
  NetAmount,
  TaxCode,
  PriceIsToBePrinted,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  UnderdelivTolrtdLmtRatioInPct,
  ValuationType,
  IsCompletelyDelivered,
  IsFinallyInvoiced,
  PurchaseOrderItemCategory,
  AccountAssignmentCategory,
  _AccountAssignCategoryVH.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  BaseUnit,
  EffectiveAmount,
  ItemNetWeight,
  ItemWeightUnit,
  TaxJurisdiction,
  _PurOrdTaxJurisdictionValHelp.TaxJurisdictionName AS TaxJurisdictionName,
  InternationalArticleNumber,
  SupplierConfirmationControlKey,
  ProfitCenter,
  PricingDateControl,
  ItemVolume,
  ItemVolumeUnit,
  ItemIncotermsClassification,
  ItemIncotermsTransferLocation,
  SupplierSubrange,
  ServicePackage,
  EvaldRcptSettlmtIsAllowed,
  IsReturnsItem,
  EarmarkedFunds,
  EarmarkedFundsItem,
  IncotermsLocation1,
  IncotermsLocation2,
  ServicePerformer,
  ProductType,
  ProductTypeName,
  OrderPriceUnit,
  IsBusinessPurposeCompleted,
  PurchasingDocumentStatus,
  MaterialName,
  PurchaseOrderItemText,
  PlantName,
  CompanyCodeName,
  PurchasingDocumentStatusName,
  PurgDocItemCategoryName,
  SemanticObject,
  cast(' ' as abap.char( 16 )) AS NumberOfScheduleLines,
  cast ('0000' as eeten) AS ScheduleLine,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  cast ('00000000' as eindt) AS ScheduleLineDeliveryDate,
  cast (0 as etmen) AS ScheduleLineOrderQuantity,
  PurchaseOrderQuantityUnit
FROM P_PurchaseOrderMassUpdate
LEFT OUTER JOIN C_PurgOrdMassUpdtNode AS _Node ON FormattedPurDoc = _Node.FormattedPurDoc  -- association [0..1]
LEFT OUTER JOIN C_MM_AccountAssignCatValueHelp AS _AccountAssignCategoryVH ON AccountAssignmentCategory = _AccountAssignCategoryVH.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN C_MM_TaxJurisdictionVH AS _PurOrdTaxJurisdictionValHelp ON _PurOrdTaxJurisdictionValHelp.TaxJurisdiction = TaxJurisdiction  -- association [0..1]
LEFT OUTER JOIN I_ProcmtPricingDateControl AS _PricingDateControlValHelp ON _PricingDateControlValHelp.PricingDateControl = PricingDateControl  -- association [0..1]
;