P_ACCGO_ACRUAL_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_ACRUAL_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_ACCRUALFEE

CREATE VIEW P_ACCGO_ACRUAL_FEES AS
SELECT
  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_id AS fee_id,
  fee_td.version AS version,
  fee_td.side AS side,
  fee_td.fee_obsolete AS fee_obsolete,
  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.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.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.rate_type AS rate_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.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,
  appdoc_data.appldoc AS appldoc,
  appdoc_data.item AS item,
  appdoc_data.sub_item AS sub_item,
  appdoc_data.appldoc_type AS appldoc_type,
  appdoc_data.contract AS contract,
  appdoc_data.contract_itm AS contract_itm,
  appdoc_data.uis_evnt_id AS uis_evnt_id,
  appdoc_data.ob_delivery AS ob_delivery,
  appdoc_data.order_type AS order_type,
  appdoc_data.order_no AS order_no,
  appdoc_data.order_itm AS order_itm,
  appdoc_data.order_side AS order_side,
  appdoc_data.item_qty AS gross_qty,
  appdoc_data.item_uom AS gross_uom,
  appdoc_data.applied_qty_raw AS laq_qty,
  appdoc_data.appl_uom AS laq_uom,
  appdoc_data.material AS material,
  appdoc_data.qrep_guid AS qrep_guid,
  appdoc_data.qrep_version AS qrep_version,
  appdoc_data.created_by AS created_by,
  appdoc_data.created_on AS created_on,
  appdoc_data.changed_by AS changed_by,
  appdoc_data.changed_on AS changed_on,
  appdoc_data.plant AS plant,
  appdoc_data.company_code AS company_code,
  appdoc_data.sales_org AS sales_org,
  appdoc_data.purch_org AS purch_org,
  appdoc_data.dist_chnl AS dist_chnl,
  appdoc_data.division AS division,
  appdoc_data.purch_grp AS purch_grp,
  appdoc_data.supplier AS supplier,
  appdoc_data.nomtk AS nomtk,
  appdoc_data.nomnr AS nomnr,
  appdoc_data.nomit AS nomit,
  appdoc_data.assgmt_guid AS assgmt_guid,
  appdoc_data.settl_doc AS settl_doc,
  appdoc_data.settl_yr AS settl_yr,
  appdoc_data.settl_cat AS settl_cat,
  appdoc_data.settl_type AS settl_type,
  appdoc_data.settl_side AS settl_side,
  appdoc_data.doc_typ AS doc_typ,
  appdoc_data.settl_item AS settl_item,
  appdoc_data.adj_uom AS adj_uom,
  appdoc_data.doc_curr AS doc_curr,
  appdoc_data.unit_uom AS unit_uom,
  appdoc_data.contract_qty AS contract_qty,
  appdoc_data.contract_uom AS contract_uom,
  appdoc_data.document_qty AS document_qty,
  appdoc_data.document_uom AS document_uom
FROM /accgo/t_fee_asg AS fee_td
INNER JOIN p_appldoc_data AS appdoc_data ON /* join condition not captured in parsed metadata */
INNER JOIN p_accgo_stor_dtl AS appdoc_data ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): /accgo/t_fee_asg
;