C_PurInfoRecordWithOrg

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_PurInfoRecordWithOrg.
-- 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: CPURINFORECORG

CREATE VIEW C_PurInfoRecordWithOrg AS
SELECT
  Plant,
  cast(PurchasingInfoRecordCategory as vdm_inforecordcategory preserving type ) AS PurchasingInfoRecordCategory,
  PurchasingOrganization,
  PurchasingInfoRecord,
  cast( '' as xfeld ) AS PurchasingInfoRecordIsAdvanced,
  PurchasingInfoRecordForEdit,
  PurchasingInfoRecordCatForEdit,
  PurchasingOrganizationForEdit,
  PlantForEdit,
  Supplier,
  I_PurgInfoRecordWWithDraft.Material AS Material,
  MaterialGroup,
  CreationDate,
  PurchasingInfoRecordDesc,
  PurgDocOrderQuantityUnit,
  UnitOfEntry,
  UnitOfMeasure,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  SupplierMaterialNumber,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  BaseUnit,
  SupplierMaterialGroup,
  PriorSupplier,
  AvailabilityStartDate,
  AvailabilityEndDate,
  VarblPurOrdUnitIsActive,
  Manufacturer,
  IsRegularSupplier,
  CreatedByUser,
  IsMarkedForDeletion,
  PurchasingGroup,
  Currency,
  MinimumPurchaseOrderQuantity,
  StandardPurchaseOrderQuantity,
  MaterialPlannedDeliveryDurn,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  LastReferencingPurchaseOrder,
  ShippingInstruction,
  LastReferencingPurOrderItem,
  cast( '0' as iprei) AS NetPriceAmount,
  NetPriceQuantityUnit,
  cast( 0 as epein ) AS MaterialPriceUnitQty,
  PurchaseOrderPriceUnit,
  PriceValidityEndDate,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  InvoiceIsGoodsReceiptBased,
  TaxCode,
  TaxCode AS TaxCodeName
FROM I_PurgInfoRecordWWithDraft
LEFT OUTER JOIN C_PurInfCondPeriod AS _PurInfCndPeriodWithDraft ON _PurInfCndPeriodWithDraft.PurchasingInfoRecord = PurchasingInfoRecord AND _PurInfCndPeriodWithDraft.Plant = Plant AND _PurInfCndPeriodWithDraft.PurchasingOrganization = PurchasingOrganization AND _PurInfCndPeriodWithDraft.PurchasingInfoRecordCategory = PurchasingInfoRecordCategory  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureStdVH AS _PurchaseOrderPriceUnit ON _PurchaseOrderPriceUnit.UnitOfMeasure = PurchaseOrderPriceUnit  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = Currency  -- association [0..1]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON _TaxCalculationProcedure.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN C_MM_TaxCodeValueHelp AS _TaxCodeVH ON _TaxCodeVH.TaxCode = TaxCode AND _TaxCodeVH.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN C_MM_IncotermValueHelp AS _IncotermsClassification ON _IncotermsClassification.IncotermsClassification = IncotermsClassification AND _IncotermsClassification.IncotermsVersion = IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureStdVH AS _BaseUnit ON _BaseUnit.UnitOfMeasure = BaseUnit  -- association [0..1]
LEFT OUTER JOIN C_ProductUnitOfMeasureVH AS _PurgDocOrderQuantityUnit ON _PurgDocOrderQuantityUnit.UnitOfMeasure = PurgDocOrderQuantityUnit  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _MaterialValueHelp ON _MaterialValueHelp.Material = Material AND _MaterialValueHelp.Plant = PlantForEdit  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupValueHelp ON _MaterialGroupValueHelp.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_PurgInfoRecordSupplierVH AS _SupplValueHelp ON _SupplValueHelp.Supplier = Supplier  -- association [0..*]
LEFT OUTER JOIN C_MM_PlantValueHelp AS _PlantValueHelp ON _PlantValueHelp.Plant = PlantForEdit AND _PlantValueHelp.PurchasingOrganization = PurchasingOrganizationForEdit  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrgValueHelp ON _PurchasingOrgValueHelp.PurchasingOrganization = PurchasingOrganizationForEdit  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroupValueHelp ON _PurchasingGroupValueHelp.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_MM_PointsUnitOfMeasure AS _PointsUnitOfMeasure ON _PointsUnitOfMeasure.UnitOfMeasure = ProductPurchasePointsQtyUnit  -- association [0..1]
LEFT OUTER JOIN C_MM_PriceDateCatValueHelp AS _PriceDateCatValueHelp ON _PriceDateCatValueHelp.PricingDateControl = PricingDateControl  -- association [0..1]
LEFT OUTER JOIN C_Mm_Rmareqvaluehelp AS _Rmareqvaluehelp ON _Rmareqvaluehelp.IsRetMatlAuthznRqdBySupplier = IsRetMatlAuthznRqdBySupplier  -- association [0..1]
LEFT OUTER JOIN C_Mm_VarOrderUnitValueHelp AS _VarOrderUnitValueHelp ON _VarOrderUnitValueHelp.VarblPurOrdUnitActvtnStatus = VarblPurOrdUnitIsActive  -- association [0..1]
LEFT OUTER JOIN C_MM_MinRmgShelfLifeExprtnDPVH AS _MinRmgShelfLifeExprtnDPV ON _MinRmgShelfLifeExprtnDPV.ShelfLifeExpirationDatePeriod = ShelfLifeExpirationDatePeriod  -- association [0..1]
LEFT OUTER JOIN C_MM_SupplierSubrangeValueHelp AS _SupplierSubrangeValueHelp ON _SupplierSubrangeValueHelp.SupplierSubrange = SupplierSubrange AND _SupplierSubrangeValueHelp.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN C_PurgInfoRecordSupplierVH AS _ManufacturerVH ON _ManufacturerVH.Supplier = Manufacturer  -- association [0..*]
LEFT OUTER JOIN C_PurgInfoRecordSupplierVH AS _PriorSupplVH ON _PriorSupplVH.Supplier = PriorSupplier  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON _MaterialText.Material = Material AND _MaterialText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_PurgInfoRecordCategory AS _PurgInfoRecdMassUpdtCatVH ON _PurgInfoRecdMassUpdtCatVH.PurchasingInfoRecordCategory = PurchasingInfoRecordCatForEdit  -- association [0..1]
LEFT OUTER JOIN C_Mm_ConfirmationControlVH AS _ConfirmationControlVH ON SupplierConfirmationControlKey = _ConfirmationControlVH.SupplierConfirmationControlKey  -- association [1..1]
LEFT OUTER JOIN I_Country AS _TaxCountry ON TaxCountry = _TaxCountry.Country  -- association [1..1]
LEFT OUTER JOIN C_Mm_Shipinstructionvaluehelp AS _ShipInstructionValueHelp ON ShippingInstruction = _ShipInstructionValueHelp.ShippingInstruction  -- association [0..1]
;