I_PRAProdBalcngAgreement

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_PRAProdBalcngAgreement.
-- 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_PRAProdBalcngAgreement AS
SELECT
  pba_no AS ProductBalancingAgreement,
  eff_from_dt AS EffectiveFromDate,
  eff_to_dt AS EffectiveToDate,
  cast( pba_grp as oiubl01_pba_group preserving type ) AS ProductBalancingAgreementGroup,
  cast( product_grp as oiubl01_product_grp preserving type ) AS BalancingProductGroup,
  pba_de AS ProdBalcngAgreementDescription,
  cast( meas_grp_id as oiu_meas_grp_id preserving type ) AS PRAMeasurementGroupID,
  bl_basis AS BalancingBasis,
  prpr_nm AS ProfilePreparerName,
  prpr_phone AS PreparerPhoneNumber,
  legal_loc AS LegalLocationDescription,
  detl_rpt_fl AS ReportIsDetailed,
  ext_pba_no AS ExtProdBalcngAgreementNumber,
  loevm AS RecordIsMarkedForDeletion,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime,
  ext_rpt_fl AS ReportingIsExternal,
  change_user AS LastChangedByUser,
  change_timestamp AS LastChangeDateTime
FROM oiubl01_pba
LEFT OUTER JOIN I_PRAProdBalcngAgreementGroup AS _BalancingAgreementGroup ON ProductBalancingAgreementGroup = _BalancingAgreementGroup.ProductBalancingAgreementGroup  -- association [0..1]
LEFT OUTER JOIN I_PRABalancingProductGroup AS _BalancingProductGroup ON BalancingProductGroup = _BalancingProductGroup.BalancingProductGroup  -- association [0..1]
LEFT OUTER JOIN I_PRADelivNtwkMsmtGrp AS _MeasurementGroup ON PRAMeasurementGroupID = _MeasurementGroup.PRAMeasurementGroupID  -- association [0..1]
;