I_JntVntrCoCodeParam

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_JntVntrCoCodeParam.
-- 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: IJVCOPARAM

CREATE VIEW I_JntVntrCoCodeParam AS
SELECT
  bukrs AS CompanyCode,
  itd AS JntVntrInceptionToDateBillg,
  int_us AS JointVentureRegion,
  opaccnumb AS Operator,
  corpvent AS JointVentureCorporate,
  corpeqgp AS JointVentureCorporateEquityGrp,
  corprecind AS JVACorpFundedRcvryCode,
  corpvbacri AS JVAVentureFundedCorpRcvryCode,
  taxin AS TaxCode,
  taxout AS JntVntrOutTaxCode,
  txjcd AS JntVntrTaxJurisdiction,
  xsetcon AS JntVntrConstructionExclsnSet,
  xsetcat AS JntVntrCatastropheExclsnSet,
  xper1 AS JVAExclsnAcctSetPercentProdg,
  xper2 AS JVAExclsnAcctSetPercentDev,
  xsetcap AS JntVntrCapitalExclsnSet,
  noncomp AS JntVntrNonCompulsoryRate,
  rldnr AS Ledger,
  _CompanyCode.Currency AS Currency,
  billthres AS JntVntrBillgThldDebit,
  billthresc AS JntVntrBillgThldCredit,
  _t8js.invlevel AS InvoicingLevel,
  _CompanyCode._Currency AS _Currency
FROM t8jz
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN t8js AS _t8js ON t8jz.bstruct = _t8js.bstruct  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
;