P_LDC_DATA

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_LDC_DATA.
-- 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: PLDCDATA
-- Parameters: iv_prefix : abap.char( 2 )

CREATE VIEW P_LDC_DATA AS
SELECT
  hdr.mandt AS mandt,
  hdr.uis_key AS uis_key,
  evnt.uis_evnt_key AS uis_evnt_key,
  hdr.uis_id AS uis_id,
  hdr.uis_type AS uis_type,
  hdr.group_id AS group_id,
  hdr.vendor AS vendor,
  hdr.customer AS customer,
  hdr.gs_addr_flag AS gs_addr_flag,
  hdr.merge_key AS merge_key,
  hdr.scalp_rel AS scalp_rel,
  hdr.block_vsplt AS block_vsplt,
  hdr.ext_uis_id AS ext_uis_id,
  hdr.created_by AS hdr_crt_by,
  cast(hdr.created_on as /accgo/e_change_timestamp preserving type) AS hdr_crt_on,
  hdr.changed_by AS hdr_chg_by,
  cast(hdr.changed_on as /accgo/e_change_timestamp preserving type) AS hdr_chg_on,
  hdr.merge_id AS merge_id,
  evnt.parent_key AS parent_key,
  evnt.event_type AS event_type,
  evnt.purchase_org AS purchase_org,
  evnt.material AS material,
  evnt.trace_id AS trace_id,
  evnt.ticket AS ticket,
  evnt.ticket_rc AS ticket_rc,
  evnt.evnt_loc_typ AS evnt_loc_typ,
  evnt.evnt_loc AS evnt_loc,
  evnt.rec_loc_typ AS rec_loc_typ,
  evnt.rec_loc AS rec_loc,
  evnt.appl_instr AS appl_instr,
  evnt.on_acc_of AS on_acc_of,
  evnt.tc_id AS tc_id,
  evnt.tc_item AS tc_item,
  evnt.po_id AS po_id,
  evnt.po_item AS po_item,
  evnt.sto_id AS sto_id,
  evnt.sto_item AS sto_item,
  evnt.so_id AS so_id,
  evnt.so_item AS so_item,
  evnt.del_id AS del_id,
  evnt.del_item AS del_item,
  evnt.bol AS bol,
  evnt.bol_date AS bol_date,
  evnt.nom_key AS nom_key,
  evnt.nom_id AS nom_id,
  evnt.nom_item AS nom_item,
  evnt.mot AS mot,
  evnt.trnsp_grp AS trnsp_grp,
  evnt.driver_id AS driver_id,
  evnt.license AS license,
  evnt.vehicle_id AS vehicle_id,
  evnt.lead_car_no AS lead_car_no,
  evnt.no_of_cars AS no_of_cars,
  evnt.barge_id AS barge_id,
  evnt.vessel_id AS vessel_id,
  evnt.booking_no AS booking_no,
  evnt.descr AS descr,
  evnt.load_rt AS load_rt,
  evnt.dis_rt AS dis_rt,
  evnt.del_period AS del_period,
  evnt.source_loc AS source_loc,
  evnt.load_rt_qty AS load_rt_qty,
  evnt.load_rt_tim AS load_rt_tim,
  evnt.del_pd_uom AS del_pd_uom,
  evnt.dis_rt_qty AS dis_rt_qty,
  evnt.dis_rt_tim AS dis_rt_tim,
  evnt.vktra AS vktra,
  evnt.means_trnspt AS means_trnspt,
  evnt.inco_terms AS inco_terms,
  evnt.ev_action AS ev_action,
  evnt.ev_bin AS ev_bin,
  evnt.ev_storage AS ev_storage,
  evnt.comments AS comments,
  evnt.released_by AS released_by,
  evnt.posting_date AS posting_date,
  evnt.dpa_number AS dpa_number,
  evnt.werks AS werks,
  evnt.created_by AS created_by,
  cast(evnt.created_on as /accgo/e_change_timestamp preserving type) AS created_on,
  evnt.changed_by AS changed_by,
  cast(evnt.changed_on as /accgo/e_change_timestamp preserving type) AS changed_on,
  evnt.item AS item,
  concat($parameters.iv_prefix,concat(hdr.uis_id,evnt.item)) AS objnr,
  mbs_rel AS LDCIsMultipleBuySellRelevant
FROM /accgo/t_uishdr AS hdr
INNER JOIN /accgo/t_uisevnt AS evnt ON /* join condition not captured in parsed metadata */
;