C_PurchaseOrderHistoryDP

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_PurchaseOrderHistoryDP.
-- 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.

CREATE VIEW C_PurchaseOrderHistoryDP AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  PurchasingHistoryDocumentType,
  PurchasingHistoryDocumentYear,
  PurchasingHistoryDocument,
  PurchasingHistoryDocumentItem,
  PurchasingDocumentCategory,
  PurchasingGroup,
  PurchasingOrganization,
  QtyInPurchaseOrderPriceUnit,
  PurchaseOrderAmount,
  PurOrdAmountInCompanyCodeCrcy,
  Quantity,
  AccountingDocumentCreationDate,
  cast ( ManufacturerMaterial as ematn preserving type ) AS ManufacturerMaterial,
  DeliveryQuantityUnit,
  DocumentReferenceID,
  InventoryValuationType,
  DocumentDate,
  TaxCode,
  PricingDocument,
  RvslOfGoodsReceiptIsAllowed,
  Plant,
  Material,
  InvtryMgmtReferenceDocument AS ReferenceDocument,
  ReferenceDocumentFiscalYear,
  IsCompletelyDelivered,
  Currency,
  PostingDate,
  GoodsMovementType,
  PurchasingHistoryCategory,
  cast ( GRIRAcctClrgAmtInCoCodeCrcy as BT_GRIRAcctClrgAmtInCoCodeCrcy preserving type ) AS GRIRAcctClrgAmtInCoCodeCrcy,
  cast ( CompanyCodeCurrency as fis_hwaer preserving type ) AS CompanyCodeCurrency,
  cast ( PurchasingDocumentCurrency as vdm_documentcurrency preserving type ) AS DocumentCurrency,
  BaseUnit,
  OrderQuantityUnit AS PurchaseOrderQuantityUnit,
  OrderPriceUnit,
  cast( DeliveryDocumentItem as vdm_posnr_vl preserving type ) AS DeliveryDocumentItem,
  DeliveryDocument,
  ExchangeRate,
  ExchangeRateDifferenceAmount,
  IsToBeAcceptedAtOrigin,
  VltdGdsRcptBlkdQtyInOrdPrcUnit,
  VltdGdsRcptBlkdStkQtyInOrdUnit,
  InvoiceAmtInPurOrdTransacCrcy,
  GRIRAcctClrgAmtInOrdTrnsacCrcy,
  QuantityInBaseUnit,
  cast ( GRIRAcctClrgAmtInTransacCrcy as BT_GRIRAcctClrgAmtInTransCrcy preserving type ) AS GRIRAcctClrgAmtInTransacCrcy,
  QuantityInDeliveryQtyUnit,
  InvoiceAmountInFrgnCurrency,
  ShipgInstrnSupplierCompliance,
  InvoiceAmtInCoCodeCrcy,
  GdsRcptBlkdStkQtyInOrdPrcUnit,
  GdsRcptBlkdStkQtyInOrdQtyUnit,
  PurchasingDocumentType AS PurchaseOrderType,
  IsEndOfPurposeBlocked
FROM I_PurchasingDocumentHistoryBsc
LEFT OUTER JOIN C_PurchasingDocumentCategoryDP AS _PurchasingDocumentCategory ON PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..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_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_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 C_PurchasingOrganizationDP AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN C_PurchasingGroupDP AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderDP AS _PurchaseOrder ON PurchasingDocument = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderItemDP AS _PurchaseOrderItem ON PurchasingDocument = _PurchaseOrderItem.PurchaseOrder AND PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_PurSchedulingAgreementDP AS _PurSchedulingAgreementDP ON PurchasingDocument = _PurSchedulingAgreementDP.SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN C_PurSchedulingAgreementItemDP AS _PurSchedulingAgreementItemDP ON PurchasingDocument = _PurSchedulingAgreementItemDP.SchedulingAgreement AND PurchasingDocumentItem = _PurSchedulingAgreementItemDP.SchedulingAgreementItem  -- association [1..1]
;