P_LDC_W_STATUS

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

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