/PF1/P_DB_COLLINFO

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/P_DB_COLLINFO.
-- 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 /PF1/P_DB_COLLINFO AS
SELECT
  clearing_area AS ClearingArea,
  route_id AS RouteId,
  clearing_id AS ClearingId,
  release_status AS ReleaseStatus,
  Direction,
  collect_kind AS CollectKind,
  max_no_of_items AS MaxNoOfItems,
  max_acc_sum AS MaxAccSum,
  min_no_of_items AS MinNoOfItems,
  min_acc_sum AS MinAccSum,
  min_close_items AS MinCloseItems,
  min_close_sum AS MinCloseSum,
  cur_acc_sum AS CurAccSum,
  flg_currency AS FlgCurrency,
  flg_value_split AS FlgValueSplit,
  flg_debit_credit AS FlgDebitCredit,
  flg_coll_accts AS FlgCollAccts,
  flg_coll_pikinds AS FlgCollPikinds,
  flg_coll_postdat AS FlgCollPostdat,
  flg_show_coll AS FlgShowColl,
  flg_net_posting AS FlgNetPosting,
  flg_single_post AS FlgSinglePost,
  flg_accrued AS FlgAccrued,
  flg_reserved_it AS FlgReservedIt,
  flg_eod_close AS FlgEodClose,
  flg_coll_procdat AS FlgCollProcdat,
  flg_due_date AS FlgDueDate,
  flg_orig_msg_id AS FlgOrigMsgId,
  flg_ext_resp AS FlgExtResp,
  flg_multi_coll AS FlgMultiColl,
  flg_multi_proc AS FlgMultiProc,
  flg_lm_relevant AS FlgLmRelevant,
  collection_type AS CollectionType,
  flg_others AS FlgOthers,
  flg_fee_info AS FlgFeeInfo,
  flg_orig_po AS FlgOrigPo,
  flg_separate_sepa AS FlgSeparateSepa,
  flg_payment_method AS FlgPaymentMethod,
  flg_bcm_rule AS FlgBcmRule,
  flg_due_date_only AS FlgDueDateOnly,
  Crusr,
  Crdat,
  Crtim,
  Chusr,
  Chdat,
  Chtim,
  Rlusr,
  Rldat,
  Rltim
FROM /pf1/db_collinfo
;