I_JointVentureDetails

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_JointVentureDetails.
-- 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: IJNTVNTR

CREATE VIEW I_JointVentureDetails AS
SELECT
  cast( jv.bukrs as fis_bukrs preserving type ) AS CompanyCode,
  jv.vname AS JointVenture,
  eg.egrup AS JntOpgAgrmtEquityGrp,
  bp.partn AS JointVenturePartner,
  jv.vtype AS JointVentureType,
  jv.operator AS Operator,
  jv.taxcode AS TaxCode,
  jv.vclass AS JointVentureClass,
  jv.joa AS JntOpgAgrmt,
  jv.fundgroup AS JntVntrFundingGroup,
  jv.payterms AS PaymentTerms,
  jv.bmethod AS JointVentureBillingType,
  jv.itd AS JntVntrInceptionToDateBillg,
  jv.cruser AS CreatedByUser,
  jv.crtime AS JntVntrTimeCreated,
  jv.crdate AS JntVntrDateCreated,
  jv.chuser AS LastChangedByUser,
  jv.chtime AS JntVntrTimeLastChanged,
  jv.chdate AS JntVntrDateLastChanged,
  jv.bformat AS JntVntrBillgFormat,
  jv.vactive AS JntVntrBillgCutbackIsBlk,
  jv.txjcd AS TaxJurisdiction,
  jv.outpayterm AS JntVntrOutPaymentTerms,
  jv.outtaxcode AS JntVntrOutTaxCode,
  jv.txjcd2 AS JntVntrTaxJurisdiction,
  jv.nbformat AS JntVntrNonBillgFormat,
  jv.bfreq AS JntVntrBillgFrqcy,
  jv.ovrdf AS JntVntrDrillingPayRate,
  jv.ovrnd AS JntVntrNonDrillingPayRate,
  jv.pcocostc AS JntVntrParentCoOvhdExpnCostCtr,
  jv.pcoprojk AS JntVntrParentCoOvhdProject,
  jv.pcoordnr AS JntVntrParentCoOvhdExpnOrder,
  jv.kostl AS JntVntrSubstituteCostCtr,
  jv.checkfc AS JntVntrCrcyIsFundingCrcy,
  jv.property AS JntVntrProperty,
  _CompanyCode.Currency AS Currency,
  jv.billthres AS JntVntrBillgThldDebit,
  jv.billthresc AS JntVntrBillgThldCredit,
  jv.billthresa AS JntVntrBillgThldIsActive,
  jv.pschem AS JntVntrPaymentTermSchema,
  _CompanyCode._Currency AS _Currency
FROM t8jv AS jv
LEFT OUTER JOIN t8jf AS eg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t8jq AS bp 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_JntOpgAgrmt AS _JntOpgAgrmt ON CompanyCode = _JntOpgAgrmt.CompanyCode AND JntOpgAgrmt = _JntOpgAgrmt.JntOpgAgrmt  -- association [1..1]
LEFT OUTER JOIN I_JntVntrEquityGrp AS _JntVntrEquityGrp ON CompanyCode = _JntVntrEquityGrp.CompanyCode AND JointVenture = _JntVntrEquityGrp.JointVenture AND JntOpgAgrmtEquityGrp = _JntVntrEquityGrp.JntOpgAgrmtEquityGrp  -- association [1..1]
LEFT OUTER JOIN I_JntVntrPartOwnrEquityShr AS _JntVntrPartOwnrEquityShr ON CompanyCode = _JntVntrPartOwnrEquityShr.CompanyCode AND JointVenture = _JntVntrPartOwnrEquityShr.JointVenture AND JntOpgAgrmtEquityGrp = _JntVntrPartOwnrEquityShr.JntOpgAgrmtEquityGrp AND JointVenturePartner = _JntVntrPartOwnrEquityShr.JointVenturePartner  -- association [1..1]
LEFT OUTER JOIN I_JointVentureDesc AS _JointVentureDesc ON CompanyCode = _JointVentureDesc.CompanyCode AND JointVenture = _JointVentureDesc.JointVenture  -- association [0..*]
LEFT OUTER JOIN I_JointVentureMasterFld AS _JointVentureMasterFld ON CompanyCode = _JointVentureMasterFld.CompanyCode AND JointVenture = _JointVentureMasterFld.JointVenture  -- association [1..1]
;