/PF1/I_BATCHITEM

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 /PF1/I_BATCHITEM.
-- 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: /PF1/IV_BTCHITM

CREATE VIEW /PF1/I_BATCHITEM AS
SELECT
  guid,
  pi_date,
  pi_no,
  time_part,
  pi_stat,
  tech_stat,
  pi_kind,
  flg_posted,
  flg_reserved,
  flg_error,
  flg_fh_error,
  flg_eh_error,
  disp_stat,
  flg_tchain,
  ref_route,
  ref_clearing,
  ref_am_area,
  ref_item_ext,
  flg_add_info,
  ref_coll_no,
  ref_cust_grp,
  ref_customer,
  ref_cust_sgm,
  country,
  bankkey,
  bic,
  iban,
  acct_no,
  acct_cur,
  holder,
  clrsysidcd,
  ref_country,
  ref_bankkey,
  ref_bic,
  ref_iban,
  ref_acct_no,
  ref_acct_cur,
  ref_holder,
  val_date,
  val_time,
  act_val_date,
  pi_post_date,
  pi_post_time,
  pl_clr_date,
  pl_clr_time,
  tr_curr,
  tr_amount,
  tr_fee,
  fee_debcred,
  fee_info,
  a_amount,
  a_amount_fee,
  exchngrate,
  trans_type,
  process,
  priority,
  cheque_no,
  return_code,
  ev_id,
  flg_internal,
  split_indi,
  item_group,
  ev_id_opo,
  risk_score,
  bam_id,
  pi_range,
  pi_kind_003,
  pi_range_003,
  pi_kind_004,
  pi_range_004,
  pi_kind_acq,
  pi_range_acq,
  due_date,
  mandate_id,
  uci,
  costcenter,
  bus_area,
  unit,
  pn_number,
  pn_year,
  crusr,
  crdat,
  crtim,
  chusr,
  chdat,
  chtim,
  rlusr,
  rldat,
  rltim
FROM /pf1/db_item
;