C_PurchaseOrderHistoryDEX

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_PurchaseOrderHistoryDEX.
-- 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: CMMPURORDHIST

CREATE VIEW C_PurchaseOrderHistoryDEX AS
SELECT
  PurchaseOrder,
  cast ( PurchaseOrderItem as vdm_purchaseorderitem preserving type ) AS PurchaseOrderItem,
  AccountAssignmentNumber,
  PurchasingHistoryDocumentType,
  PurchasingHistoryDocumentYear,
  PurchasingHistoryDocument,
  PurchasingHistoryDocumentItem,
  PurchasingHistoryCategory,
  GoodsMovementType,
  PostingDate,
  Currency,
  DebitCreditCode,
  IsCompletelyDelivered,
  ReferenceDocumentFiscalYear,
  ReferenceDocument,
  ReferenceDocumentItem,
  Material,
  Plant,
  RvslOfGoodsReceiptIsAllowed,
  PricingDocument,
  TaxCode,
  DocumentDate,
  InventoryValuationType,
  DocumentReferenceID,
  DeliveryQuantityUnit,
  cast ( ManufacturerMaterial as ematn preserving type ) AS ManufacturerMaterial,
  AccountingDocumentCreationDate,
  Quantity,
  PurOrdAmountInCompanyCodeCrcy,
  PurchaseOrderAmount,
  QtyInPurchaseOrderPriceUnit,
  GRIRAcctClrgAmtInCoCodeCrcy,
  GdsRcptBlkdStkQtyInOrdQtyUnit,
  GdsRcptBlkdStkQtyInOrdPrcUnit,
  InvoiceAmtInCoCodeCrcy,
  ShipgInstrnSupplierCompliance,
  InvoiceAmountInFrgnCurrency,
  QuantityInDeliveryQtyUnit,
  GRIRAcctClrgAmtInTransacCrcy,
  QuantityInBaseUnit,
  GRIRAcctClrgAmtInOrdTrnsacCrcy,
  InvoiceAmtInPurOrdTransacCrcy,
  VltdGdsRcptBlkdStkQtyInOrdUnit,
  VltdGdsRcptBlkdQtyInOrdPrcUnit,
  IsToBeAcceptedAtOrigin,
  ExchangeRateDifferenceAmount,
  ExchangeRate,
  DeliveryDocument,
  cast ( DeliveryDocumentItem as vdm_posnr_vl preserving type ) AS DeliveryDocumentItem,
  OrderPriceUnit,
  PurchaseOrderQuantityUnit,
  BaseUnit,
  cast ( DocumentCurrency as vdm_documentcurrency preserving type ) AS DocumentCurrency,
  cast ( CompanyCodeCurrency as fis_hwaer preserving type ) AS CompanyCodeCurrency,
  _PurchaseOrderItem.ProductType AS ProductTypeCode,
  _PurchaseOrderItem.IsStatisticalItem AS IsStatisticalItem,
  _PurchaseOrderItem.IsReturnsItem AS IsReturnsItem,
  _PurchaseOrderItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  _PurchaseOrderItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  _PurchaseOrderItem.IsFinallyInvoiced AS IsFinallyInvoiced,
  _PurchaseOrderItem.InvoiceIsExpected AS InvoiceIsExpected,
  _PurchaseOrderItem.PurchaseContract AS PurchaseContract,
  _PurchaseOrderItem.PurchaseContractItem AS PurchaseContractItem,
  _PurchaseOrderItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  _PurchaseOrderItem.PurchaseRequisition AS PurchaseRequisition,
  _PurchaseOrderItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  _PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  _PurchaseOrderItem.MaterialGroup AS ProductGroup,
  _PurchaseOrderItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  _PurchaseOrderItem.PurchasingDocumentDeletionCode AS PurgDocumentItemDeletionCode,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrder.CompanyCode AS CompanyCode,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrder.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  _PurchaseOrder.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  _PurchaseOrder.PurchasingCompletenessStatus AS PurchasingCompletenessStatus
FROM I_PurchaseOrderHistoryAPI01
LEFT OUTER JOIN C_PurchaseOrderDEX AS _PurchaseOrderDEX ON PurchaseOrder = _PurchaseOrderDEX.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderItemDEX AS _PurchaseOrderItemDEX ON PurchaseOrder = _PurchaseOrderItemDEX.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItemDEX.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_PurchaseContractDEX AS _PurchaseContract ON PurchaseContract = _PurchaseContract.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_PurchaseContractItemDEX AS _PurchaseContractItem ON PurchaseContract = _PurchaseContractItem.PurchaseContract AND PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN C_PurchaseRequisitionItemDEX AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderHistCategory AS _PurchaseOrderHistCategory ON PurchasingHistoryCategory = _PurchaseOrderHistCategory.PurchaseOrderHistCategory  -- association [1..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_InventoryValuationType AS _InventoryValuationType ON InventoryValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DeliveryQuantityUnit ON DeliveryQuantityUnit = _DeliveryQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Product AS _ManufacturerMaterial ON ManufacturerMaterial = _ManufacturerMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON DeliveryDocument = _DeliveryDocument.DeliveryDocument  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocumentItem AS _DeliveryDocumentItem ON DeliveryDocument = _DeliveryDocumentItem.DeliveryDocument AND DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderPriceUnit ON OrderPriceUnit = _OrderPriceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PurchaseOrderQuantityUnit ON PurchaseOrderQuantityUnit = _PurchaseOrderQuantityUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_ProductTypeCode AS _ProductTypeCode ON ProductTypeCode = _ProductTypeCode.ProductTypeCode  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchaseOrderItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ServicePerformer ON ServicePerformer = _ServicePerformer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;