I_JVAGlobalCompanyParameter

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_JVAGlobalCompanyParameter.
-- 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: IJVAGLCOPARM

CREATE VIEW I_JVAGlobalCompanyParameter AS
SELECT
  bukrs AS CompanyCode,
  itd AS JVAInceptionToDateActiveVal,
  netaccopt AS JVANetAccountActiveVal,
  int_us AS JVARegionVal,
  opaccnumb AS JVAOperator,
  billbasis AS JVABillingBasis,
  corpvent AS JVADefaultVenture,
  corpeqgp AS JVADefaultEquityGroup,
  corprecind AS JVADefaultCostRecoveryCode,
  corpvbacri AS JVARecIndVntrFunded,
  balancvent AS JVABalancedVenturesActiveVal,
  vbank AS JVAVentureBankAccountVal,
  taxin AS JVAInputTaxCode,
  invlevel AS JVAInvoiceLevel,
  taxout AS JVAOutputTaxCode,
  txjcd AS JVATaxJurisdictionCode,
  crptaxcode AS JVACorpTaxCode,
  bstruct AS JVABillingStructure,
  xsetcon AS JVAAcctsExclCnstrctnOvhdVal,
  xsetcat AS JVAAcctsExclCatastropheOvhdVal,
  xper1 AS JVAAcctsExclPctg1OvhdRateVal,
  xper2 AS JVAAcctsExclPctg2OvhdRateVal,
  xsetcap AS JVAAccountsExclCptlOvhdVal,
  offcc AS JVADefaultOffsetCostCenterVal,
  expand AS JVALineItmsUncompressedActvVal,
  taxexpdtl AS JVATxExpndtrDetailsActvVal,
  taxper AS JVAPostTaxInNextPeriodActvVal,
  eqgnum AS JVAMaxNmbrEquityGrpsPerVntrVal,
  pomact AS JVAOperationalMonthActiveVal,
  gstno AS JVARegnGSTNumberVal,
  afabe_han AS JVADeprAreaForBookDeprVal,
  afabe_nb AS JVADeprAreaForNonBillVal,
  afabe_bi AS JVADeprAreaForGrossVal,
  crpcal AS JVACstmRtlPrcCalcActvVal,
  am_meth AS JVAPostgRuleForAstPostingsVal,
  wbind AS JVAIndexForEstBookCostVal,
  seltab AS JVATblForAddlSelFldVal,
  selfld AS JVAAddSelForCRPTransfersVal,
  cbyear AS JVACutbackYearDateVal,
  cbperi AS JVACutbackPeriodVal,
  kurst AS JVAExchangeRateTypeVal,
  offpcocc AS JVACorpParCoOvhdCostCtrVal,
  cast(offpcoproj as ps_s4_pspnr preserving type) AS JVACorpParCoOvhdProjectVal,
  offpcoornr AS JVACorpParCoOvhdOrderVal,
  postcorp AS JVAPostToDefaultVentureActvVal,
  asstvent AS JVAVntrDerivationTypeAssetsVal,
  ci_gross AS JVAGrssPostToIntrstPrtnActvVal,
  ci_fb01 AS JVACarriedIntrstPostings01Val,
  cb_tcurr AS JVAUseTransCrcyCutbackPostsVal,
  fsjvct AS JVAFldStsTypeCostCtrVal,
  fsjvot AS JVAFieldStatusTypeOrderVal,
  fsjvpt AS JVAFieldStatusTypeProjectVal,
  budgetmess AS JVAMessageImpactActiveVal,
  vidist AS JVAVentureDistrAssetLinesVal,
  op_as_part AS JVAOperatorAsPartnerActiveVal,
  kostl_corp AS JVADefaultCostCenterVal,
  am_corp_ri AS JVADfltCostRcvryCodeForAstVal,
  bank_ri_sw AS JVACostRecCodeForBkSwitchVal,
  bcurr AS JVADefaultBillingCrcyVal,
  xvba AS JVABankAccountSwitchActiveVal,
  xasst_co AS JVANoCostObjOnAstActvVal,
  _CompanyCode.Currency AS Currency,
  billthres AS JVABillingThresholdDebitAmt,
  billthresc AS JVABillingThresholdCreditAmt,
  tvarcurr AS JVATransVarInterCompAstVal,
  split_by_li AS JVASplitByLineItemVal,
  ec_use AS JVARtlPrCalcActvVal,
  billthress AS JVASprtRptSpprsdPerdsVal,
  pm_act AS JVAProductionMonthActiveVal,
  pm_eg AS JVADeriveEquityGrpProdnMnthVal,
  pm_act_year AS JVAProductionMonthFromYearVal,
  funding_active AS JVAFundingActvVal,
  intcalc_active AS JVAIntrstCalcActvVal,
  ic_auto_group AS JVAIntrstCalcAutoGrpgTypeVal,
  ic_group_ref AS JVAInterestCalcRefGroupVal,
  rldnr AS JVALedgerVal,
  coalesce(_MasterData.JVAFromYearVal, _t8jz.fryear) AS JVAFromYearVal,
  coalesce(_MasterData.JVAFromYearVal, _t8jz.frperiod) AS JVAFromPeriodVal,
  coalesce(_MasterData.JVAToYearVal, _t8jz.toyear) AS JVAToYearVal,
  coalesce(_MasterData.JVAToPeriodVal, _t8jz.toperiod) AS JVAToPeriodVal,
  coalesce(_MasterData.JVAStandardPaymentRate, _t8jz.stpay) AS JVAStandardPaymentVal,
  coalesce(_MasterData.JVANonCompulsoryBenefitsRate, _t8jz.noncomp) AS JVANonCompulsoryBenefitsVal,
  coalesce(_MasterData.JVACompulsoryBenefitsRate, _t8jz.compuls) AS JVACompulsoryBenefitsVal,
  _CompanyCode._Currency AS _Currency
FROM t8jz AS _t8jz
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JVAGlobCoCodeMDSetting AS _MasterData ON CompanyCode = _MasterData.CompanyCode  -- association [0..1]
;