I_JointVentureMasterFld

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_JointVentureMasterFld.
-- 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: IJVMSTFLD

CREATE VIEW I_JointVentureMasterFld AS
SELECT
  bukrs AS CompanyCode,
  cast(vname as jv_name_cds preserving type ) AS JointVenture,
  payterms AS JointVenturePaymentTerms,
  bmethod AS JointVentureBillingMethod,
  vtype AS JointVentureType,
  operator AS JointVentureOperator,
  taxcode AS JointVentureTaxCode,
  vclass AS JVAVentureClass,
  itd AS JntVntrInceptionToDateData,
  cruser AS JointVentureCreatedByUser,
  cast( crtime as jv_crtime_cds ) AS JntVntrTimeCreated,
  crdate AS JntVntrDateCreated,
  chuser AS JointVentureLastChangedByUser,
  bformat AS JntVntrBillgFormat,
  joa AS JntOpgAgrmt,
  vactive AS JntVntrBillgCutbackIsBlk,
  txjcd AS JntVntrTaxJurisdiction,
  outpayterm AS JntVntrOutPaymentTerms,
  outtaxcode AS JntVntrOutTaxCode,
  txjcd2 AS JntVntrOutTaxJurisdiction,
  nbformat AS JntVntrNonBillgFormat,
  bfreq AS JntVntrBillgFrqcy,
  ovrdf AS JntVntrDrillingPayRate,
  ovrnd AS JntVntrNonDrillingPayRate,
  pcocostc AS JntVntrParentCoOvhdExpnCostCtr,
  cast ( pcoprojk as ps_s4_pspnr preserving type ) AS JntVntrParentCoOvhdProject,
  pcoordnr AS JntVntrParentCoOvhdExpnOrder,
  kostl AS JntVntrSubstituteCostCtr,
  fundgroup AS JntVntrFundingGroup,
  checkfc AS JntVntrCrcyIsFundingCrcy,
  property AS JntVntrProperty,
  _CompanyCode.Currency AS Currency,
  billthres AS JntVntrBillgThldDebit,
  billthresc AS JntVntrBillgThldCredit,
  billthresa AS JntVntrBillgThldIsActive,
  pschem AS JntVntrPaymentTermSchema,
  ic_group AS JVAVentureIntrstCalcGrpID,
  _CompanyCode._Currency AS _Currency
FROM t8jv
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JointVentureDesc AS _JointVentureDesc ON CompanyCode = _JointVentureDesc.CompanyCode AND JointVenture = _JointVentureDesc.JointVenture  -- association [0..*]
LEFT OUTER JOIN I_JntOpgAgrmtText AS _JntOpgAgrmtText ON CompanyCode = _JntOpgAgrmtText.CompanyCode AND JntOpgAgrmt = _JntOpgAgrmtText.JntOpgAgrmt  -- association [0..*]
;