I_PRAContract

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_PRAContract.
-- 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: IPVCONTRACT

CREATE VIEW I_PRAContract AS
SELECT
  vbeln AS PRAContract,
  cast( ktext as oiu_vdm_contract_description ) AS PRAContractDesc,
  audat AS PRAContractDate,
  kunnr AS SoldToParty,
  cast ( bukrs_vf as fis_bukrs) AS CompanyCode,
  oiu_ct_type_cd AS PRAContractType,
  oiu_appr_fl AS IsApproved,
  oiu_prev_ct_no AS PreviousPRAContract,
  oiu_cust_vend_cd AS CustomerOrSupplierType,
  oiu_mk_rep_no AS MarketingRep,
  oiu_mk_rep_isq AS MarketingRepIntrstSequNmbr,
  cast( bname as oiu_vdm_marketing_rep_name ) AS MarketingRepName,
  cast( case oiu_cust_vend_cd when 'C' then oiu_mk_rep_no end as oiu_vdm_marketing_rep_cust ) AS MarketingRepCustomer,
  cast( case oiu_cust_vend_cd when 'V' then oiu_mk_rep_no end as oiu_vdm_marketing_rep_suppl ) AS MarketingRepSupplier,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  cast( erzet as oiu_vdm_creation_time) AS CreationTime
FROM oiucm_contract
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PRAContractType AS _PRAContractType ON PRAContractType = _PRAContractType.PRAContractType  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _MarketingRepCustomer ON MarketingRepCustomer = _MarketingRepCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _MarketingRepSupplier ON MarketingRepSupplier = _MarketingRepSupplier.Supplier  -- association [0..1]
;