P_PurgOrgLvlInfoRecdMassUpdt

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_PurgOrgLvlInfoRecdMassUpdt.
-- 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: PPIRPOLMASS

CREATE VIEW P_PurgOrgLvlInfoRecdMassUpdt AS
SELECT
  PurchasingInfoRecord,
  PurchasingInfoRecordCategory,
  PurchasingOrganization,
  Plant,
  _Plant.PlantName AS PlantName,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _InfoRecordCategoryVH._Text.PurchasingInfoRecordTitle AS CategoryDescription,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  MaterialConditionGroup,
  IsMarkedForDeletion,
  _PurchasingInfoRecord.Material AS Material,
  _InfoRecdMassUpdtMatlGrp._Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  _PurchasingInfoRecord.Supplier AS Supplier,
  _PurchasingInfoRecord._Supplier.SupplierName AS SupplierName,
  _PurchasingInfoRecord.SupplierSubrange AS SupplierSubrange,
  _InfoRecdMassUpdtMatlGrp.MaterialGroup AS MaterialGroup,
  _InfoRecdMassUpdtMatlGrp._MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  case _PurchasingInfoRecord.CreationDate when (' ') then '00000000' else _PurchasingInfoRecord.CreationDate end as CreationDate AS CreationDateendasCreationDate,
  _PurchasingInfoRecord.IsDeleted AS IsDeleted,
  _PurchasingInfoRecord.PurchasingInfoRecordDesc AS PurchasingInfoRecordDesc,
  _PurchasingInfoRecord.SupplierMaterialNumber AS SupplierMaterialNumber,
  _PurchasingInfoRecord.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  _PurchasingInfoRecord.SupplierPhoneNumber AS SupplierPhoneNumber,
  _PurchasingInfoRecord.SupplierMaterialGroup AS SupplierMaterialGroup,
  _PurchasingInfoRecord.PriorSupplier AS PriorSupplier,
  _PurchasingInfoRecord.VarblPurOrdUnitIsActive AS VarblPurOrdUnitIsActive,
  _PurchasingInfoRecord.Manufacturer AS Manufacturer,
  _PurchasingInfoRecord.IsRegularSupplier AS IsRegularSupplier,
  _PurchasingInfoRecord.NoDaysReminder1 AS NoDaysReminder1,
  _PurchasingInfoRecord.NoDaysReminder2 AS NoDaysReminder2,
  _PurchasingInfoRecord.NoDaysReminder3 AS NoDaysReminder3,
  _PurchasingInfoRecord.ProductPurchasePointsQty AS ProductPurchasePointsQty,
  _PurchasingInfoRecord.ProductPurchasePointsQtyUnit AS ProductPurchasePointsQtyUnit,
  _PurchasingInfoRecord.ReturnAgreement AS ReturnAgreement,
  _PurchasingInfoRecord.SupplierCertOriginCat AS SupplierCertOriginCat,
  _PurchasingInfoRecord.SupplierCertOriginNumber AS SupplierCertOriginNumber,
  _PurchasingInfoRecord.SupplierCertOriginCountry AS SupplierCertOriginCountry,
  _PurchasingInfoRecord.SupplierCertOriginRegion AS SupplierCertOriginRegion,
  _PurchasingInfoRecord.SuplrCertOriginClassfctnNumber AS SuplrCertOriginClassfctnNumber,
  _PurchasingInfoRecord.PurgDocOrderQuantityUnit AS PurgDocOrderQuantityUnit,
  _PurchasingInfoRecord.BaseUnit AS BaseUnit,
  _PurchasingInfoRecord.SupplierSubrangeSortNumber AS SupplierSubrangeSortNumber,
  _PurchasingInfoRecord.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  _PurchasingInfoRecord.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  MinimumPurchaseOrderQuantity,
  StandardPurchaseOrderQuantity,
  MaterialPlannedDeliveryDurn,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  InvoiceIsGoodsReceiptBased,
  TaxCode,
  TimeDependentTaxValidFromDate,
  TaxCountry,
  IncotermsClassification,
  _IncotermsClassificationText.IncotermsClassificationName AS IncotermsClassificationName,
  IncotermsLocation1,
  IncotermsLocation2,
  MaximumOrderQuantity,
  cast(IsRelevantForAutomSrcg as xfeld) AS IsRelevantForAutomSrcg,
  IncotermsVersion,
  _IncotermsVersionText.IncotermsVersionName AS IncotermsVersionName,
  MinRemainingShelfLife,
  ShippingInstruction,
  _ShippingInstructionText.ShippingInstructionName AS ShippingInstructionName,
  IsEvaluatedRcptSettlmtAllowed,
  IsOrderAcknRqd,
  SupplierConfirmationControlKey,
  _SupplierConfControlKeyText.SupplierConfControlKeyName AS SupplierConfControlKeyName,
  MaterialRoundingProfile,
  MaterialStagingTime,
  ProductUnitGroup,
  IsRetMatlAuthznRqdBySupplier,
  _IsRMARequired.SuplrRetMatAuthNumberReqName AS SuplrRetMatAuthNumberReqName,
  IsCashDiscountGranted,
  PricingDateControl,
  _PricingDateControl.PricingDateControlText AS PricingDateControlText,
  CreatedByUser,
  _UserContactCard.FullName AS CreatedByUserName,
  ShelfLifeExpirationDatePeriod,
  _ShelfLifeExpDatePeriod.DomainText AS ShelfLifeExpirationDateText,
  IncotermsTransferLocation,
  ProductionVersion,
  PurchaseOrderPriceUnit
FROM I_PurgInfoRecdOrgPlantData
LEFT OUTER JOIN I_PurchasingInfoRecord AS _PurchasingInfoRecord ON _PurchasingInfoRecord.PurchasingInfoRecord = PurchasingInfoRecord  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecordCategory AS _InfoRecordCategoryVH ON _InfoRecordCategoryVH.PurchasingInfoRecordCategory = PurchasingInfoRecordCategory  -- association [0..1]
LEFT OUTER JOIN P_InfoRecdMassUpdtMatlGrp AS _InfoRecdMassUpdtMatlGrp ON _InfoRecdMassUpdtMatlGrp.PurchasingInfoRecord = PurchasingInfoRecord  -- association [1..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON _IncotermsClassificationText.IncotermsClassification = IncotermsClassification AND _IncotermsClassificationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersionText AS _IncotermsVersionText ON _IncotermsVersionText.IncotermsVersion = IncotermsVersion AND _IncotermsVersionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Shippinginstructiontext AS _ShippingInstructionText ON _ShippingInstructionText.ShippingInstruction = ShippingInstruction AND _ShippingInstructionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupplierConfControlKeyText AS _SupplierConfControlKeyText ON _SupplierConfControlKeyText.SupplierConfirmationControlKey = SupplierConfirmationControlKey AND _SupplierConfControlKeyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_IsRMARequired AS _IsRMARequired ON _IsRMARequired.IsRetMatlAuthznRqdBySupplier = IsRetMatlAuthznRqdBySupplier AND _IsRMARequired.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PricingDateControlTxt AS _PricingDateControl ON _PricingDateControl.PricingDateControl = PricingDateControl AND _PricingDateControl.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON _UserContactCard.ContactCardID = CreatedByUser  -- association [1..1]
LEFT OUTER JOIN I_ProcurementDomainValues AS _ShelfLifeExpDatePeriod ON _ShelfLifeExpDatePeriod.Name = 'DATTP' AND _ShelfLifeExpDatePeriod.DomainValue = ShelfLifeExpirationDatePeriod AND _ShelfLifeExpDatePeriod.Language = $session.system_language  -- association [0..1]
;