P_ACCGO_SI_PPMT_FEES

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 P_ACCGO_SI_PPMT_FEES.
-- 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: P_PPMT_FEE_SI

CREATE VIEW P_ACCGO_SI_PPMT_FEES AS
SELECT
  Prepayment.PrepaymentAgreement AS PrepaymentAgreement,
  Prepayment.PrepaymentAgreementStatus AS PrepaymentAgreementStatus,
  Prepayment.PrepaymentAgrmtLinkStatus AS PrepaymentAgrmtLinkStatus,
  Prepayment.PrepaymentAgrmtPostingStatus AS PrepaymentAgrmtPostingStatus,
  fee_td.fee_id AS fee_id,
  fee_td.version AS version,
  fee_td.doctype AS doctype,
  fee_td.docid AS docid,
  fee_td.docitem AS docitem,
  fee_td.docsubitem AS docsubitem,
  fee_td.docyear AS docyear,
  fee_td.sequence_no AS sequence_no,
  fee_td.fee_obsolete AS fee_obsolete,
  fee_td.fee_storage AS fee_storage,
  fee_td.alloc_mode AS alloc_mode,
  fee_td.valid_status AS valid_status,
  fee_td.calongq AS calongq,
  fee_td.duplmsg AS duplmsg,
  fee_td.not_relevant AS not_relevant,
  fee_td.free_att1 AS free_att1,
  fee_td.free_att2 AS free_att2,
  fee_td.free_att3 AS free_att3,
  fee_td.free_att4 AS free_att4,
  fee_td.free_att5 AS free_att5,
  fee_td.free_att6 AS free_att6,
  fee_td.free_att7 AS free_att7,
  fee_td.free_att8 AS free_att8,
  fee_td.free_att9 AS free_att9,
  fee_td.free_att10 AS free_att10,
  fee_td.add_gross AS add_gross,
  fee_td.incld_ns AS incld_ns,
  fee_td.rel_accrual AS rel_accrual,
  fee_td.rate_assign AS rate_assign,
  fee_td.rel_sep_time AS rel_sep_time,
  fee_td.rate_raw AS rate_raw,
  fee_td.rate AS rate,
  fee_td.currency_ext AS currency_ext,
  fee_td.currency AS currency,
  fee_td.quantity AS quantity,
  fee_td.uom AS fee_rate_uom,
  fee_td.header_uom AS header_uom,
  fee_td.rate_type AS rate_type,
  fee_td.char_desc AS char_desc,
  fee_td.uom_type AS uom_type,
  fee_td.doctyperef AS doctyperef,
  fee_td.docidref AS docidref,
  fee_td.docitemref AS docitemref,
  fee_td.docyearref AS docyearref,
  fee_td.fee_calc_amt AS fee_calc_amt,
  fee_td.fee_amt_curr AS fee_amt_curr,
  fee_td.fx_rate AS fx_rate,
  fee_td.created_by AS created_by,
  fee_td.changed_by AS changed_by,
  fee_td.event AS event,
  fee_td.is_prorated AS is_prorated,
  fee_td.review AS review,
  fee_td.fee_cat AS fee_cat,
  fee_td.gl_account AS gl_account,
  fee_td.location AS location,
  fee_td.fee_name AS fee_name,
  fee_td.fee_name_ext AS fee_name_ext,
  fee_td.fee_type AS fee_type,
  fee_td.int_desc AS int_desc,
  fee_td.ext_desc AS ext_desc,
  fee_td.status AS status,
  fee_td.valid_from AS valid_from,
  fee_td.valid_to AS valid_to,
  fee_td.contract_pl AS contract_pl,
  fee_td.nom_item AS nom_item,
  fee_td.order_item AS order_item,
  fee_td.po_item AS po_item,
  fee_td.sto_item AS sto_item,
  fee_td.ldc_load AS ldc_load,
  fee_td.ldc_unload AS ldc_unload,
  fee_td.stlmnt_unit AS stlmnt_unit,
  fee_td.set_basis AS set_basis,
  fee_td.set_futures AS set_futures,
  fee_td.set_flat AS set_flat,
  fee_td.set_fx_basis AS set_fx_basis,
  fee_td.set_fx_flat AS set_fx_flat,
  fee_td.lift_basis AS lift_basis,
  fee_td.lift_future AS lift_future,
  fee_td.lift_flat AS lift_flat,
  fee_td.lift_fx_flat AS lift_fx_flat,
  fee_td.overfill AS overfill,
  fee_td.weight_event AS weight_event,
  fee_td.gl_source AS gl_source,
  fee_td.pcf_flat_fee AS pcf_flat_fee,
  fee_td.pcf_calc_ref AS pcf_calc_ref,
  fee_td.rel_pp_stl AS rel_pp_stl
FROM P_ACCGO_FEE_DTLS AS fee_td
;