I_PRAMaintUnitVntrTract

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 I_PRAMaintUnitVntrTract.
-- 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 I_PRAMaintUnitVntrTract AS
SELECT
  oiu_do_puc.bukrs AS CompanyCode,
  oiu_do_puc.unit_vname AS PRAUnitVenture,
  oiu_do_puc.comb_pd_cd AS PRACombinedProductCode,
  oiu_do_puc.eff_from_dt AS PRAUnitVentureEffctvFrmDte,
  oiu_do_tr.puc_no AS PRAUnitVentureUseCtrlNmbr,
  oiu_do_tr.seq_no AS PRAUnitVentureTractSqncNmbr,
  oiu_do_tr.bukrs AS ProcessingCompanyCode,
  oiu_do_tr.vname AS PRAJointVenture,
  oiu_do_tr.doi_no AS DivisionOfInterest,
  oiu_do_tr.tr_no AS PRAUnitVentureTractNumber,
  oiu_do_tr.tr_part_fact_pc AS PRAUnitVntrTractPartcipnPct,
  oiu_do_tr.tr_nm AS PRAUnitVentureTractName,
  oiu_do_tr.oiu_cruser AS CreatedByUser,
  oiu_do_tr.oiu_timestamp AS CreationDateTime
FROM oiu_do_tr
INNER JOIN oiu_do_puc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PRAJointVenture AS _JointVenture ON CompanyCode = _JointVenture.CompanyCode AND PRAUnitVenture = _JointVenture.PRAJointVenture  -- association [1..1]
LEFT OUTER JOIN I_PRAMaintCmbndProdCode AS _PRAMaintCmbndProdCode ON _PRAMaintCmbndProdCode.PRACombinedProductCode = PRACombinedProductCode  -- association [1..1]
;