C_JVAOperatorCostObjPg

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 C_JVAOperatorCostObjPg.
-- 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: COPTRCOSTOBJPG

CREATE VIEW C_JVAOperatorCostObjPg AS
SELECT
  CompanyCode,
  FiscalPeriod,
  LedgerFiscalYear,
  JointVenture,
  JointVentureEquityGroup,
  UniqueItemIdentifier,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  _CostType._Text[1:Language = $session.system_language].JntVntrCostTypeText AS JntVntrCostTypeText,
  JointVentureType
FROM I_JVAConsolidatedGLAcctCost
LEFT OUTER JOIN I_JVAJointVentureCostType AS _CostType ON _CostType.JntVntrCostType = UniqueItemIdentifier  -- association [0..1]
LEFT OUTER JOIN C_JVAVentureGrossCostDetObjPg AS _GrossCost ON _GrossCost.CompanyCode = CompanyCode AND _GrossCost.JointVenture = JointVenture AND _GrossCost.JointVentureEquityGroup = JointVentureEquityGroup AND _GrossCost.FiscalPeriod = FiscalPeriod AND _GrossCost.LedgerFiscalYear = LedgerFiscalYear AND _GrossCost.UniqueItemIdentifier = UniqueItemIdentifier  -- association [0..*]
LEFT OUTER JOIN C_JVAOperatorNetCostDetObjPg AS _OpNetCost ON _OpNetCost.CompanyCode = CompanyCode AND _OpNetCost.JointVenture = JointVenture AND _OpNetCost.JointVentureEquityGroup = JointVentureEquityGroup AND _OpNetCost.FiscalPeriod = FiscalPeriod AND _OpNetCost.LedgerFiscalYear = LedgerFiscalYear AND _OpNetCost.UniqueItemIdentifier = UniqueItemIdentifier  -- association [0..*]
LEFT OUTER JOIN C_JVAVentureWrkgCptlDetObjPg AS _WrkgCptl ON _WrkgCptl.CompanyCode = CompanyCode AND _WrkgCptl.JointVenture = JointVenture AND _WrkgCptl.JointVentureEquityGroup = JointVentureEquityGroup AND _WrkgCptl.FiscalPeriod = FiscalPeriod AND _WrkgCptl.LedgerFiscalYear = LedgerFiscalYear AND _WrkgCptl.UniqueItemIdentifier = UniqueItemIdentifier  -- association [0..*]
LEFT OUTER JOIN C_JVAYearToDateDetObjPg AS _YearToDate ON _YearToDate.CompanyCode = CompanyCode AND _YearToDate.JointVenture = JointVenture AND _YearToDate.JointVentureEquityGroup = JointVentureEquityGroup AND ( _YearToDate.LedgerFiscalYear = LedgerFiscalYear AND _YearToDate.FiscalPeriod >= '001' AND _YearToDate.FiscalPeriod <= FiscalPeriod ) AND _YearToDate.UniqueItemIdentifier = UniqueItemIdentifier  -- association [0..*]
LEFT OUTER JOIN C_JVAInceptionToDateDetObjPg AS _InceptionToDate ON _InceptionToDate.CompanyCode = CompanyCode AND _InceptionToDate.JointVenture = JointVenture AND _InceptionToDate.JointVentureEquityGroup = JointVentureEquityGroup AND ( ( _InceptionToDate.LedgerFiscalYear = LedgerFiscalYear AND _InceptionToDate.FiscalPeriod >= '001' AND _InceptionToDate.FiscalPeriod <= FiscalPeriod ) OR( _InceptionToDate.LedgerFiscalYear < LedgerFiscalYear AND _InceptionToDate.FiscalPeriod >= '001' AND _InceptionToDate.FiscalPeriod <= '012' ) ) AND _InceptionToDate.UniqueItemIdentifier = UniqueItemIdentifier  -- association [0..*]
;