I_CommingleStorageQtyHistory

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_CommingleStorageQtyHistory.
-- 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: IDGRCSTORQTYHIST

CREATE VIEW I_CommingleStorageQtyHistory AS
SELECT
  appldoc AS ApplicationDocument,
  item AS ApplicationDocumentItem,
  sequence_number AS QuantityHistorySequenceNumber,
  parent_item AS QuantityHistoryParentItem,
  cast(parent_sequence as cds_dgr_qty_hstry_parnt_seq_no) AS QtyHistoryParentSequenceNumber,
  cast(child_item as cds_dgr_qty_hstry_child_item) AS QuantityHistoryChildItem,
  matnr AS Material,
  lifnr AS Creditor,
  base_stg_qty AS StorageQuantityInBaseUoM,
  cast(base_uom as cds_dgr_storage_qty_base_unit) AS StorageQuantityBaseUnit,
  storage_qty AS DailyGrainRptStorageQuantity,
  cast(uom as cds_dgr_storage_quantity_uom) AS StorageQuantityUnit,
  cast(den_conv as cds_dgr_denominator_conversion) AS ConversionFactorDnmntrValue,
  cast(num_conv as cds_dgr_numerator_conversion) AS ConversionFactorNmrtrValue,
  strg_agreement AS StorageAgreement,
  strg_agreement_item AS StorageAgreementItem,
  val_start_date AS QtyHistoryValidityStartDate,
  val_end_dat AS QtyHistoryValidityEndDate,
  no_of_days AS TotalNumberOfStorageDays,
  whr_qty AS WarehouseReceiptedQuantity,
  cast(whr_uom as cds_dgr_wrhse_receipt_qty_unit) AS WarehouseReceiptedQuantityUnit
FROM /accgo/t_strg_qh
;