I_ACMAppDocumentItem

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_ACMAppDocumentItem.
-- 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: IACMAPPITEMDET

CREATE VIEW I_ACMAppDocumentItem AS
SELECT
  appldoc AS ApplicationDocument,
  item AS ReferenceApplicationItem,
  side AS ReferenceApplicationSide,
  sub_item AS ACMApplicationDocumentSubItem,
  item_guid AS ContractApplicationItemUUID,
  budat AS DocumentDate,
  appl_objnr AS ObjectInternalID,
  stl_objnr AS ACMSettlementStatusObject,
  concat('X5',concat(appldoc,item)) AS ACMStorageStatusObject,
  matnr AS Material,
  werks AS Plant,
  uis_id AS LoadDataCaptureObjId,
  uis_guid AS LDCKey,
  strg_start_date AS StorageStartDate,
  strg_end_date AS StorageEndDate,
  whr_type AS WarehouseReceiptType,
  whr_id AS WarehouseReceiptNo,
  whr_start_date AS WarehouseReceiptStartDate,
  whr_end_date AS WarehouseReceiptEndDate,
  obligation_type AS WarehouseReceiptObligationType,
  cast( whr_qty as abap.dec( 15, 3 ) ) AS ACMWarehouseReceiptQtyVal,
  whr_uom AS WarehouseReceiptedQuantityUnit,
  cast( open_whr_qty as abap.dec( 15, 3 ) ) AS ACMWarehouseReceiptOpenQtyVal,
  open_whr_uom AS WarehouseReceiptedOpenQtyUnit,
  strg_rates_locked AS StorageRatesLockedValue,
  strg_free_days AS StorageFreeDaysValue,
  strg_agreement AS StorageAgreement,
  strg_agreement_item AS StorageAgreementItem,
  created_by AS ApplDocumentCreatedBy,
  changed_by AS ApplDocumentChangedBy,
  tstmp_to_dats( created_on, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as ApplicationItemCreatedOnDate AS clientNULLasApplicationItemCreatedOnDate,
  tstmp_to_dats( changed_on, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as ApplicationItemChangedOnDate AS clientNULLasApplicationItemChangedOnDate,
  delivery_date_eod AS DeliveryDate,
  load_location AS ACMApplDocContrOptnLoadLoc,
  discharge_loc AS ACMApplDocContrOptnDschrgdLoc,
  crop_season_id AS ACMContractOptionsCropSeasonID,
  source_loc AS ACMContrOptionsSourceLocation,
  vktra AS ModeOfTransport,
  means_trnspt AS ACMContrOptionsMnsOfTransport,
  del_period AS DeliveryStartDate,
  del_period_end AS DeliveryEndDate,
  cast(lifnr as lifnr preserving type ) AS ReferenceVendor,
  cast(kunnr as kunnr preserving type ) AS CustomerNum,
  item_uom AS UnitOfMeasure,
  spot_eod AS ACMApplOvwSpotFlag,
  delv_qty_menge AS ACMDecimalGrossQuantity,
  cast( adjusted_qty_dec as abap.quan( 13, 3 ) ) AS ACMNetQuantity,
  umrez AS ConversionFactorNmrtrValue,
  umren AS ConversionFactorDnmntrValue
FROM /accgo/t_cas_cai AS Item
;