I_JVAJointOperatingAgrmtDetail

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_JVAJointOperatingAgrmtDetail.
-- 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: IJVAJOADETAILS

CREATE VIEW I_JVAJointOperatingAgrmtDetail AS
SELECT
  _JntOpgAgrmt.CompanyCode AS CompanyCode,
  _JntOpgAgrmt.JntOpgAgrmt AS JntOpgAgrmt,
  _JntOpgAgrmtText.JntOpgAgrmtText AS JntOpgAgrmtText,
  _JntOpgAgrmt.JntVntrContractNmbr AS JntVntrContractNmbr,
  _JntOpgAgrmt.JntVntrPayrollClearingSet AS JntVntrPayrollClearingSet,
  _JntOpgAgrmt.JntVntrConstructionExclsnSet AS JntVntrConstructionExclsnSet,
  _JntOpgAgrmt.JntVntrCatastropheExclsnSet AS JntVntrCatastropheExclsnSet,
  _JntOpgAgrmt.JntVntrConstructionOvhdRule AS JntVntrConstructionOvhdRule,
  _JntOpgAgrmt.JntVntrCatastropheOvhdRule AS JntVntrCatastropheOvhdRule,
  _JntOpgAgrmt.JVAOvhdPercentProdg AS JVAOvhdPercentProdg,
  _JntOpgAgrmt.JVAExclsnAcctSetPercentProdg AS JVAExclsnAcctSetPercentProdg,
  _JntOpgAgrmt.JVAOvhdPercentDev AS JVAOvhdPercentDev,
  _JntOpgAgrmt.JVAExclsnAcctSetPercentDev AS JVAExclsnAcctSetPercentDev,
  _JntOpgAgrmt.JntVntrExplorationOvhdRule AS JntVntrExplorationOvhdRule,
  _JntOpgAgrmt.JntVntrDrillingOvhdRule AS JntVntrDrillingOvhdRule,
  _JntOpgAgrmt.JntVntrCapitalExclsnSet AS JntVntrCapitalExclsnSet,
  _JntOpgAgrmt.JntVntrOvhdOffsetCostCtr AS JntVntrOvhdOffsetCostCtr,
  _JntOpgAgrmt.JntOpgAgrmtProdgWellThld AS JntOpgAgrmtProdgWellThld,
  _JntOpgAgrmt.JntVntrOvhdRecurringDoc AS JntVntrOvhdRecurringDoc,
  _JntOpgAgrmt.JntVntrOvhdFlatRateAmt AS JntVntrOvhdFlatRateAmt,
  _JntOpgAgrmt.JntVntrExpnIsEscalated AS JntVntrExpnIsEscalated,
  _JntOpgAgrmt.JntOpgAgrmtClass AS JntOpgAgrmtClass,
  _JntOpgAgrmt.JntOpgAgrmtDrillingPayRate AS JntOpgAgrmtDrillingPayRate,
  _JntOpgAgrmt.JntOpgAgrmtNonDrillingPayRate AS JntOpgAgrmtNonDrillingPayRate,
  _JointVentureMasterFld.JointVenture AS JointVenture,
  _JointVentureDesc.JointVentureName AS JointVentureName,
  _JointVentureMasterFld.JointVenturePaymentTerms AS JointVenturePaymentTerms,
  _JointVentureMasterFld.JointVentureBillingMethod AS JointVentureBillingMethod,
  _JointVentureMasterFld.JointVentureType AS JointVentureType,
  _JointVentureMasterFld.JointVentureOperator AS JointVentureOperator,
  _JointVentureMasterFld.JointVentureTaxCode AS JointVentureTaxCode,
  _JointVentureMasterFld.JVAVentureClass AS JVAVentureClass,
  _JointVentureMasterFld.JntVntrInceptionToDateData AS JntVntrInceptionToDateData,
  _JointVentureMasterFld.JntVntrBillgCutbackIsBlk AS JntVntrBillgCutbackIsBlk,
  _JointVentureMasterFld.JntVntrTaxJurisdiction AS JntVntrTaxJurisdiction,
  _JointVentureMasterFld.JntVntrOutPaymentTerms AS JntVntrOutPaymentTerms,
  _JointVentureMasterFld.JntVntrOutTaxCode AS JntVntrOutTaxCode,
  _JointVentureMasterFld.JntVntrOutTaxJurisdiction AS JntVntrOutTaxJurisdiction,
  _JointVentureMasterFld.JntVntrNonBillgFormat AS JntVntrNonBillgFormat,
  _JointVentureMasterFld.JntVntrBillgFrqcy AS JntVntrBillgFrqcy,
  _JointVentureMasterFld.JntVntrDrillingPayRate AS JntVntrDrillingPayRate,
  _JointVentureMasterFld.JntVntrNonDrillingPayRate AS JntVntrNonDrillingPayRate,
  _JointVentureMasterFld.JntVntrParentCoOvhdExpnCostCtr AS JntVntrParentCoOvhdExpnCostCtr,
  _JointVentureMasterFld.JntVntrParentCoOvhdProject AS JntVntrParentCoOvhdProject,
  _JointVentureMasterFld.JntVntrParentCoOvhdExpnOrder AS JntVntrParentCoOvhdExpnOrder,
  _JointVentureMasterFld.JntVntrSubstituteCostCtr AS JntVntrSubstituteCostCtr,
  _JointVentureMasterFld.JntVntrFundingGroup AS JntVntrFundingGroup,
  _JointVentureMasterFld.JntVntrCrcyIsFundingCrcy AS JntVntrCrcyIsFundingCrcy,
  _JointVentureMasterFld.JntVntrProperty AS JntVntrProperty,
  _JointVentureMasterFld.JntVntrBillgThldDebit AS JntVntrBillgThldDebit,
  _JointVentureMasterFld.JntVntrBillgThldCredit AS JntVntrBillgThldCredit,
  _JointVentureMasterFld.JntVntrBillgThldIsActive AS JntVntrBillgThldIsActive,
  _JointVentureMasterFld.JntVntrPaymentTermSchema AS JntVntrPaymentTermSchema,
  _JointVentureMasterFld.JVAVentureIntrstCalcGrpID AS JVAVentureIntrstCalcGrpID,
  _JntVntrValdInvmtGrp.JointVentureEquityGroup AS JointVentureEquityGroup,
  _JntVntrValdInvmtGrp.JointVentureEquityType AS JointVentureEquityType,
  _JntVntrValdInvmtGrp.JntVntrEquityFundingDateValue AS JntVntrEquityFundingDateValue,
  cast ( cast ( 99999999 - cast( _JntVntrValdInvmtGrp.JntVntrEquityFundingDateValue as abap.int4 ) as abap.char( 12 ) ) as abap.dats ) as JVAEquityGroupFromDate AS datsasJVAEquityGroupFromDate,
  _JntVntrValdInvmtGrp.JointVentureEquityGroupActive AS JointVentureEquityGroupActive,
  _JntVntrValdInvmtGrp.JointVentureDefBillCurrency AS JointVentureDefBillCurrency,
  _JntVntrValdInvmtGrp.JVAFundingGrpInEquityGrp AS JVAFundingGrpInEquityGrp,
  _JntVntrValdInvmtGrp.JVAEquityGroupIntrstCalcGrpID AS JVAEquityGroupIntrstCalcGrpID,
  _JointVentureIntcoVenture.JntVntrIntcoCode AS JntVntrIntcoCode,
  _JointVentureIntcoVenture.JointVentureIntcoVenture AS JointVentureIntcoVenture,
  _JointVentureIntcoVenture.JointVentureIntcoEquityGrp AS JointVentureIntcoEquityGrp,
  _JntVntrPartOwnrEquityShr.JointVenturePartner AS JointVenturePartner,
  _JntVntrPartOwnrEquityShr.JntVntrEquityShare AS JntVntrEquityShare,
  _JntVntrPartOwnrEquityShr.JntVntrOwnrIsSuspended AS JntVntrOwnrIsSuspended,
  _JntVntrPartOwnrEquityShr.JntVntrOwnrSuspendedPerd AS JntVntrOwnrSuspendedPerd,
  _JntVntrPartOwnrEquityShr.JntVntrOwnrSuspendedYr AS JntVntrOwnrSuspendedYr,
  _JntVntrPartOwnrEquityShr.JntVntrOwnrIsNotSuspended AS JntVntrOwnrIsNotSuspended,
  _JntVntrPartOwnrEquityShr.JntVntrOwnrNotSuspendedPerd AS JntVntrOwnrNotSuspendedPerd,
  _JntVntrPartOwnrEquityShr.JntVntrOwnrNotSuspendedYr AS JntVntrOwnrNotSuspendedYr,
  _JntVntrPartOwnrEquityShr.JntVntrInterestType AS JntVntrInterestType,
  _JntVntrPartOwnrEquityShr.JntVntrOpgRcvryPercent AS JntVntrOpgRcvryPercent,
  _JntVntrPartOwnrEquityShr.JntVntrDrillingRcvryPercent AS JntVntrDrillingRcvryPercent,
  _JntVntrPartOwnrEquityShr.JntVntrPayIsStppd AS JntVntrPayIsStppd,
  _JntVntrPartOwnrEquityShr.JntVntrPartWrkgIntrstPerd AS JntVntrPartWrkgIntrstPerd,
  _JntVntrPartOwnrEquityShr.JntVntrPartWrkgIntrstYrValue AS JntVntrPartWrkgIntrstYrValue,
  _JntVntrPartOwnrEquityShr.JntVntrCarriedIntrstGrp AS JntVntrCarriedIntrstGrp,
  _JntVntrPartOwnrEquityShr.JntVntrNetProfitIntrstGrp AS JntVntrNetProfitIntrstGrp,
  _JntVntrPartOwnrEquityShr.JntVntrOperatorAddressArea AS JntVntrOperatorAddressArea,
  _CompanyCode.Currency AS Currency
FROM I_JntOpgAgrmt AS _JntOpgAgrmt
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _JntOpgAgrmt.CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_JntOpgAgrmtText AS _JntOpgAgrmtText ON _JntOpgAgrmt.CompanyCode = _JntOpgAgrmtText.CompanyCode AND _JntOpgAgrmt.JntOpgAgrmt = _JntOpgAgrmtText.JntOpgAgrmt AND _JntOpgAgrmtText.Language = $session.system_language  -- association [1..1]
;