I_JntOpgAgrmt

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_JntOpgAgrmt.
-- 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: IJOA

CREATE VIEW I_JntOpgAgrmt AS
SELECT
  bukrs AS CompanyCode,
  joa AS JntOpgAgrmt,
  contract AS JntVntrContractNmbr,
  payset AS JntVntrPayrollClearingSet,
  xsetcon AS JntVntrConstructionExclsnSet,
  xsetcat AS JntVntrCatastropheExclsnSet,
  conrule AS JntVntrConstructionOvhdRule,
  catrule AS JntVntrCatastropheOvhdRule,
  per1 AS JVAOvhdPercentProdg,
  xper1 AS JVAExclsnAcctSetPercentProdg,
  per2 AS JVAOvhdPercentDev,
  xper2 AS JVAExclsnAcctSetPercentDev,
  exprule AS JntVntrExplorationOvhdRule,
  drlrule AS JntVntrDrillingOvhdRule,
  xsetcap AS JntVntrCapitalExclsnSet,
  offcc AS JntVntrOvhdOffsetCostCtr,
  joaprth AS JntOpgAgrmtProdgWellThld,
  recdoc AS JntVntrOvhdRecurringDoc,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  flatrate AS JntVntrOvhdFlatRateAmt,
  escal AS JntVntrExpnIsEscalated,
  aclass AS JntOpgAgrmtClass,
  cruser AS JntOpgAgrmtCreatedByUser,
  case when crtime is null or crtime = '' then cast('000000' as abap.tims) else cast(substring(crtime, 1, 6) as abap.tims) end as JntOpgAgrmtCreationTime AS timsendasJntOpgAgrmtCreationTime,
  chuser AS JntOpgAgrmtLastChangedByUser,
  case when chtime is null or chtime = '' then cast('000000' as abap.tims) else cast(substring(chtime, 1, 6) as abap.tims) end as JntOpgAgrmtLastChangedTime AS timsendasJntOpgAgrmtLastChangedTime,
  drillp AS JntVntrPrioPerdDrillingIsCalc,
  allwbs AS JntVntrWBSElmntOvhdIsCalc,
  dfpay AS JntOpgAgrmtDrillingPayRate,
  ndpay AS JntOpgAgrmtNonDrillingPayRate
FROM t8ju
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_JntOpgAgrmtClass AS _JntOpgAgrmtClass ON CompanyCode = _JntOpgAgrmtClass.CompanyCode AND JntOpgAgrmtClass = _JntOpgAgrmtClass.JntOpgAgrmtClass  -- association [1..1]
LEFT OUTER JOIN I_JntOpgAgrmtText AS _JntOpgAgrmtText ON CompanyCode = _JntOpgAgrmtText.CompanyCode AND JntOpgAgrmt = _JntOpgAgrmtText.JntOpgAgrmt  -- association [0..*]
LEFT OUTER JOIN I_JntOpgAgrmtEquityTypeGrp AS _JntOpgAgrmtEquityTypeGrp ON CompanyCode = _JntOpgAgrmtEquityTypeGrp.CompanyCode AND JntOpgAgrmt = _JntOpgAgrmtEquityTypeGrp.JntOpgAgrmt  -- association [0..*]
LEFT OUTER JOIN I_JntOpgAgrmtPartShr AS _JntOpgAgrmtPartShr ON CompanyCode = _JntOpgAgrmtPartShr.CompanyCode AND JntOpgAgrmt = _JntOpgAgrmtPartShr.JntOpgAgrmt  -- association [0..*]
;