ESH_N_JNTVNTR

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 ESH_N_JNTVNTR.
-- 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: ESH_L_JNTVNTR
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_JNTVNTR AS
SELECT
  COMPANYCODE,
  JOINTVENTURE,
  JNTOPGAGRMT,
  JNTVNTRBILLGCUTBACKISBLK,
  _JNTVNTRBILLGEXTRACTMETHTEXT[1: LANGUAGE = $parameters. P_Language].JNTVNTRBILLGEXTRACTMETHTEXT AS JNTVNTRBILLGEXTRACTMETHTEXT,
  JNTVNTRFUNDINGGROUP,
  JNTVNTRINCEPTIONTODATEDATA,
  JOINTVENTUREBILLINGMETHOD,
  JOINTVENTUREBILLINGTYPE,
  _JOINTVENTUREBILLINGTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].JOINTVENTUREBILLINGTYPETEXT AS JOINTVENTUREBILLINGTYPETEXT,
  JOINTVENTURECLASS,
  _JOINTVENTURECLASS._JOINTVENTURECLASSTEXT[1: LANGUAGE = $parameters. P_Language].JOINTVENTURECLASSDESCRIPTION AS JOINTVENTURECLASSDESCRIPTION,
  JOINTVENTURECREATEDBYUSER,
  _JOINTVENTUREDESC[1: LANGUAGE = $parameters. P_Language].JOINTVENTURENAME AS JOINTVENTURENAME,
  JOINTVENTUREOPERATOR,
  JOINTVENTUREPAYMENTTERMS,
  _JOINTVENTURESTATUSTEXT[1: LANGUAGE = $parameters. P_Language].JOINTVENTURESTATUSTEXT AS JOINTVENTURESTATUSTEXT,
  JOINTVENTURETYPE,
  _JOINTVENTURETYPE[1: ddlanguage = $parameters. P_Language].ddtext AS JOINTVENTURETYPETEXT,
  JVAVENTURECLASS
FROM I_JOINTVENTUREMASTER
LEFT OUTER JOIN dd07t AS _JOINTVENTURETYPE ON JointVentureType=_JOINTVENTURETYPE.domvalue_l AND _JOINTVENTURETYPE.domname='JV_VTYPE' AND _JOINTVENTURETYPE.as4local='A'  -- association [0..*]
;