I_PurgInfoRecordWWithDraft

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 I_PurgInfoRecordWWithDraft.
-- 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: IINFRECWITHORGWD

CREATE VIEW I_PurgInfoRecordWWithDraft AS
SELECT
  Document.PurchasingInfoRecord AS PurchasingInfoRecord,
  Document.Plant AS Plant,
  Document.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingInfoRecord AS PurchasingInfoRecordForEdit,
  Document.PurchasingOrganization AS PurchasingOrganizationForEdit,
  Document.PurchasingInfoRecordCategory AS PurchasingInfoRecordCatForEdit,
  Document.Plant AS PlantForEdit,
  Document.Supplier AS Supplier,
  Document.Material AS Material,
  case when Document.MaterialGroup = '' then I_Material.MaterialGroup else Document.MaterialGroup end as MaterialGroup AS MaterialGroupendasMaterialGroup,
  Document.CreationDate AS CreationDate,
  Document.IsDeleted AS IsDeleted,
  Document.PurchasingInfoRecordDesc AS PurchasingInfoRecordDesc,
  Document.PurgDocOrderQuantityUnit AS PurgDocOrderQuantityUnit,
  Document.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  Document.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  Document.SupplierMaterialNumber AS SupplierMaterialNumber,
  Document.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  Document.SupplierPhoneNumber AS SupplierPhoneNumber,
  Document.BaseUnit AS BaseUnit,
  Document.SupplierMaterialGroup AS SupplierMaterialGroup,
  Document.PriorSupplier AS PriorSupplier,
  Document.AvailabilityStartDate AS AvailabilityStartDate,
  Document.AvailabilityEndDate AS AvailabilityEndDate,
  Document.VarblPurOrdUnitIsActive AS VarblPurOrdUnitIsActive,
  Document.Manufacturer AS Manufacturer,
  Document.IsRegularSupplier AS IsRegularSupplier,
  Document.CreatedByUser AS CreatedByUser,
  Document.IsMarkedForDeletion AS IsMarkedForDeletion,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.Currency AS Currency,
  Document.MinimumPurchaseOrderQuantity AS MinimumPurchaseOrderQuantity,
  Document.StandardPurchaseOrderQuantity AS StandardPurchaseOrderQuantity,
  Document.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  Document.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  Document.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  Document.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  Document.LastReferencingPurchaseOrder AS LastReferencingPurchaseOrder,
  Document.LastReferencingPurOrderItem AS LastReferencingPurOrderItem,
  Document.NetPriceAmount AS NetPriceAmount,
  Document.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  Document.PurchaseOrderPriceUnit AS PurchaseOrderPriceUnit,
  Document.PriceValidityEndDate AS PriceValidityEndDate,
  Document.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  Document.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  Document.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  Document.TaxCode AS TaxCode,
  Document.TimeDependentTaxValidFromDate AS TimeDependentTaxValidFromDate,
  Document.TaxCountry AS TaxCountry,
  Document.IncotermsClassification AS IncotermsClassification,
  Document.IncotermsTransferLocation AS IncotermsTransferLocation,
  Document.IncotermsLocation1 AS IncotermsLocation1,
  cast( '' as tminco_loc_1_id ) AS IncotermsLocation1Identifier,
  cast( '' as tminco_loc_1_id ) AS IncotermsLocation2Identifier,
  cast( '' as tminco_loc_d_id ) AS IncotermsDvtgLocIdentifier,
  cast( '' as tminco_loc_d_descr ) AS IncotermsDvtgLocDescription,
  Document.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  Document.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  Document.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  Document.MaximumOrderQuantity AS MaximumOrderQuantity,
  Document.NoDaysReminder1 AS NoDaysReminder1,
  Document.NoDaysReminder2 AS NoDaysReminder2,
  Document.NoDaysReminder3 AS NoDaysReminder3,
  Document.ProductPurchasePointsQty AS ProductPurchasePointsQty,
  Document.ProductPurchasePointsQtyUnit AS ProductPurchasePointsQtyUnit,
  Document.ReturnAgreement AS ReturnAgreement,
  Document.SupplierCertOriginCat AS SupplierCertOriginCat,
  Document.SupplierCertOriginNumber AS SupplierCertOriginNumber,
  Document.SupplierCertValidityEndDate AS SupplierCertValidityEndDate,
  Document.SupplierCertOriginCountry AS SupplierCertOriginCountry,
  Document.SupplierCertOriginRegion AS SupplierCertOriginRegion,
  Document.SuplrCertOriginClassfctnNumber AS SuplrCertOriginClassfctnNumber,
  Document.SupplierQuotation AS SupplierQuotation,
  Document.SupplierQuotationDate AS SupplierQuotationDate,
  Document.MinRemainingShelfLife AS MinRemainingShelfLife,
  Document.ShippingInstruction AS ShippingInstruction,
  Document.IsEvaluatedRcptSettlmtAllowed AS IsEvaluatedRcptSettlmtAllowed,
  Document.IsPurOrderAllwdForInbDeliv AS IsPurOrderAllwdForInbDeliv,
  Document.IsOrderAcknRqd AS IsOrderAcknRqd,
  Document.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  Document.MaterialRoundingProfile AS MaterialRoundingProfile,
  Document.MaterialStagingTime AS MaterialStagingTime,
  Document.ProductUnitGroup AS ProductUnitGroup,
  Document.IsRetMatlAuthznRqdBySupplier AS IsRetMatlAuthznRqdBySupplier,
  Document.IsCashDiscountGranted AS IsCashDiscountGranted,
  Document.MaterialConditionGroup AS MaterialConditionGroup,
  Document.PricingDateControl AS PricingDateControl,
  Document.IncotermsLocation2 AS IncotermsLocation2,
  Document.IncotermsVersion AS IncotermsVersion,
  Document.SupplierSubrange AS SupplierSubrange,
  Document.PurchasingDocumentDate AS PurchasingDocumentDate,
  Document.SupplierSubrangeSortNumber AS SupplierSubrangeSortNumber,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.ShelfLifeExpirationDatePeriod AS ShelfLifeExpirationDatePeriod,
  Document.PurgInfoRecNonStockItmSortTerm AS PurgInfoRecNonStockItmSortTerm,
  cast('' as bstme) AS UnitOfEntry,
  cast('' as meins) AS UnitOfMeasure,
  cast(NetPriceAmount as abap.sstring(50)) AS NetPriceQuantityUnit,
  cast('00000000' as abap.dats(8)) AS ValidityStartDate,
  cast('00000000' as abap.dats(8)) AS ValidityEndDate,
  cast('' as kalsm_d) AS TaxCalculationProcedure,
  cast('' as bukrs) AS CompanyCode,
  cast(Document.IsRelevantForAutomSrcg as xfeld ) AS IsRelevantForAutomSrcg
FROM P_PurgInfoRecordWithOrgData AS Document
LEFT OUTER JOIN I_Material ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_PurchasingInforecord AS _PurchasingInforecordExtension ON _PurchasingInforecordExtension.PurchasingInfoRecord = PurchasingInfoRecord  -- association [0..1]
LEFT OUTER JOIN E_PurInfoRecWithOrgDraft AS _PurInfoRecOrgDraftExtension ON _PurInfoRecOrgDraftExtension.DraftUUID = Document.PurgInfoRecdDrftID  -- association [0..1]
LEFT OUTER JOIN E_PurgInfoRecdOrgPlantData AS _PurgInfoRecdOrgPlantExtension ON _PurgInfoRecdOrgPlantExtension.PurchasingInfoRecord = PurchasingInfoRecord AND _PurgInfoRecdOrgPlantExtension.PurchasingInfoRecordCategory = PurchasingInfoRecordCategory AND _PurgInfoRecdOrgPlantExtension.PurchasingOrganization = PurchasingOrganization AND _PurgInfoRecdOrgPlantExtension.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_PurInfCndPeriodWithDraft AS _PurInfCndPeriodWithDraft ON _PurInfCndPeriodWithDraft.Plant = Plant AND _PurInfCndPeriodWithDraft.PurchasingInfoRecordCategory = PurchasingInfoRecordCategory AND _PurInfCndPeriodWithDraft.PurchasingOrganization = PurchasingOrganization AND _PurInfCndPeriodWithDraft.PurchasingInfoRecord = PurchasingInfoRecord  -- association [0..*]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganizationForEdit  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = PlantForEdit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure 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_PurchasingGroup AS _PurchasingGroup ON _PurchasingGroup.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON _TaxCode.TaxCode = TaxCode  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON _IncotermsClassification.IncotermsClassification = IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecdOrgPlantData AS _PurgInfoRecdOrgPlantData ON _PurgInfoRecdOrgPlantData.PurchasingInfoRecord = PurchasingInfoRecordForEdit  -- association [0..*]
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON _MaterialGroup.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON _BaseUnit.UnitOfMeasure = BaseUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PurgDocOrderQuantityUnit ON _PurgDocOrderQuantityUnit.UnitOfMeasure = PurgDocOrderQuantityUnit  -- association [0..1]
LEFT OUTER JOIN I_Country AS _TaxCountry ON TaxCountry = _TaxCountry.Country  -- association [1..1]
;