A_PurgInfoRecdOrgPlantData

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 A_PurgInfoRecdOrgPlantData.
-- 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: APINPLORG

CREATE VIEW A_PurgInfoRecdOrgPlantData AS
SELECT
  PurchasingInfoRecord,
  PurchasingInfoRecordCategory,
  PurchasingOrganization,
  Plant,
  CreatedByUser,
  CreationDate,
  IsMarkedForDeletion,
  PurchasingGroup,
  Currency,
  MinimumPurchaseOrderQuantity,
  StandardPurchaseOrderQuantity,
  MaterialPlannedDeliveryDurn,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  LastReferencingPurchaseOrder,
  LastReferencingPurOrderItem,
  _PurgInfoRecd.Material AS Material,
  _PurgInfoRecd.Supplier AS Supplier,
  _PurgInfoRecd.MaterialGroup AS MaterialGroup,
  _PurgInfoRecd.PurgDocOrderQuantityUnit AS PurgDocOrderQuantityUnit,
  cast(NetPriceAmount as abap.sstring(50)) AS NetPriceQuantityUnit,
  NetPriceAmount,
  MaterialPriceUnitQty,
  PurchaseOrderPriceUnit,
  PriceValidityEndDate,
  ShippingInstruction,
  InvoiceIsGoodsReceiptBased,
  TaxCode,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  MaximumOrderQuantity,
  IsRelevantForAutomSrcg,
  SupplierQuotation,
  SupplierQuotationDate,
  MinRemainingShelfLife,
  IsEvaluatedRcptSettlmtAllowed,
  IsPurOrderAllwdForInbDeliv,
  IsOrderAcknRqd,
  IsRetMatlAuthznRqdBySupplier,
  IsCashDiscountGranted,
  MaterialConditionGroup,
  PurchasingDocumentDate,
  ShelfLifeExpirationDatePeriod,
  IsEndOfPurposeBlocked,
  SupplierConfirmationControlKey,
  PricingDateControl,
  TimeDependentTaxValidFromDate,
  TaxCountry,
  MaterialRoundingProfile,
  MatlMstrTxtIsNotRlvtForPOItm,
  ProductionVersion
FROM I_PurgInfoRecdOrgPlantData
LEFT OUTER JOIN A_PurchasingInfoRecord AS _PurgInfoRecd ON PurchasingInfoRecord = _PurgInfoRecd.PurchasingInfoRecord  -- association [1..1]
LEFT OUTER JOIN A_PurInfoRecdPrcgCndnValidity AS _PurInfoRecdPrcgCndnValidity ON PurchasingInfoRecord = _PurInfoRecdPrcgCndnValidity.PurchasingInfoRecord AND PurchasingInfoRecordCategory = _PurInfoRecdPrcgCndnValidity.PurchasingInfoRecordCategory AND PurchasingOrganization = _PurInfoRecdPrcgCndnValidity.PurchasingOrganization  -- association [0..*]
LEFT OUTER JOIN A_PurgInfoRecdOrgPOText AS _PurInfoRecdPurOrgText ON PurchasingInfoRecord = _PurInfoRecdPurOrgText.PurchasingInfoRecord AND PurchasingInfoRecordCategory = _PurInfoRecdPurOrgText.PurchasingInfoRecordCategory AND PurchasingOrganization = _PurInfoRecdPurOrgText.PurchasingOrganization AND Plant = _PurInfoRecdPurOrgText.Plant  -- association [0..*]
;