I_JVAPartnerNetByCostObjC

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_JVAPartnerNetByCostObjC.
-- 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: IPARTNETCOC
-- Parameters: P_LedgerFiscalYear : gjahr, P_FiscalPeriod : poper, P_JointVenturePartner : jv_part

CREATE VIEW I_JVAPartnerNetByCostObjC AS
SELECT
  CompanyCode,
  Ledger,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  FiscalYearVariant,
  FiscalPeriod,
  PostingDate,
  LedgerFiscalYear,
  GLRecordType,
  ChartOfAccounts,
  GLAccount,
  DebitCreditCode,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  BusinessArea,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  OrderID,
  ProjectNetwork,
  WBSElementInternalID,
  WBSElementExternalID,
  JointVenture,
  JointVentureType,
  JointVentureEquityGroup,
  JointVentureEquityType,
  JntVntrOperatedShare,
  JntVntrEquityShare,
  JointVentureCostRecoveryCode,
  JointVenturePartner,
  Operator,
  JointVentureBillingType,
  BaseUnit,
  Quantity,
  Supplier,
  AccountingDocumentType,
  FinancialAccountType,
  Segment,
  Customer,
  SalesOrganization,
  ValuationArea,
  Plant,
  DistributionChannel,
  OrganizationDivision,
  ServiceDocument,
  SalesDocument,
  AssetClass,
  JntVntrInterestType,
  TransactionCurrency,
  CurPerdAmtInTC,
  YrToDteAmtInTransacCrcy,
  ITDAmtInTC,
  cast( ( CurPerdAmtInTC * JVACurPeriodNetSharePercent ) as jv_cp_netamt_tc ) AS CurPerdNetAmtInTC,
  cast( ( YrToDteAmtInTransacCrcy * JVAYearToDateNetSharePercent ) as jv_ytd_netamt_tc ) AS YTDNetAmtInTC,
  cast( ( ITDAmtInTC * ITDNetSharePercent ) as jv_itd_netamt_tc ) AS ITDNetAmtInTC,
  cast( ( AmountInTransactionCurrency * JVASuspendSharePercent ) as jv_sus_shramt_tc ) AS SuspShrAmtInTC,
  cast( ( NetProfitIntrstAmtInTC * NetProfitIntrstShrPercent ) as jv_npi_shramt_tc ) AS NetProfitIntrstShrAmtInTC,
  CompanyCodeCurrency,
  CurPerdAmtInCCrcy,
  YearToDateAmountInCoCodeCrcy,
  ITDAmtInCCrcy,
  cast( ( CurPerdAmtInCCrcy * JVACurPeriodNetSharePercent ) as jv_cp_netamt_cc ) AS CurPerdNetAmtInCCrcy,
  cast( ( YearToDateAmountInCoCodeCrcy * JVAYearToDateNetSharePercent ) as jv_ytd_netamt_cc ) AS YTDNetAmtInCCrcy,
  cast( ( ITDAmtInCCrcy * ITDNetSharePercent ) as jv_itd_netamt_cc ) AS ITDNetAmtInCCrcy,
  cast( ( AmountInCompanyCodeCurrency * JVASuspendSharePercent ) as jv_sus_shramt_cc ) AS SuspShrAmtInCCrcy,
  cast( ( NetProfitIntrstAmtInCCrcy * NetProfitIntrstShrPercent ) as jv_npi_shramt_cc ) AS NetProfitIntrstShrAmtInCCrcy,
  GlobalCurrency,
  CurPerdAmtInGCrcy,
  YearToDateAmountInGlobalCrcy,
  ITDAmtInGCrcy,
  cast( ( CurPerdAmtInGCrcy * JVACurPeriodNetSharePercent ) as jv_cp_netamt_gc ) AS CurPerdNetAmtInGCrcy,
  cast( ( YearToDateAmountInGlobalCrcy * JVAYearToDateNetSharePercent ) as jv_ytd_netamt_gc ) AS YTDNetAmtInGCrcy,
  cast( ( ITDAmtInGCrcy * ITDNetSharePercent ) as jv_itd_netamt_gc ) AS ITDNetAmtInGCrcy,
  cast( ( AmountInGlobalCurrency * JVASuspendSharePercent ) as jv_sus_shramt_gc ) AS SuspShrAmtInGCrcy,
  cast( ( NetProfitIntrstAmtInGCrcy * NetProfitIntrstShrPercent ) as jv_npi_shramt_gc ) AS NetProfitIntrstShrAmtInGCrcy,
  BalanceTransactionCurrency,
  CurPerdAmtInBlTCrcy,
  YearToDateAmountInBalTransCrcy,
  ITDAmtInBlTCrcy,
  cast( ( CurPerdAmtInBlTCrcy * JVACurPeriodNetSharePercent ) as jv_cp_netamt_btc ) AS CurPerdNetAmtInBlTCrcy,
  cast( ( YearToDateAmountInBalTransCrcy * JVAYearToDateNetSharePercent ) as jv_ytd_netamt_btc ) AS YTDNetAmtInBlTCrcy,
  cast( ( ITDAmtInBlTCrcy * ITDNetSharePercent ) as jv_itd_netamt_btc ) AS ITDNetAmtInBlTCrcy,
  cast( ( AmountInBalanceTransacCrcy * JVASuspendSharePercent ) as jv_sus_shramt_btc ) AS SuspShrAmtInBlTCrcy,
  cast( ( NetProfitIntrstAmtInBlTCrcy * NetProfitIntrstShrPercent ) as jv_npi_shramt_btc ) AS NetProfitIntrstShrAmtInBlTCrcy,
  FreeDefinedCurrency1,
  CurPerdAmtInFDCrcy1,
  YearToDateAmountInFDCrcy1,
  ITDAmtInFDCrcy1,
  cast( ( CurPerdAmtInFDCrcy1 * JVACurPeriodNetSharePercent ) as jv_cp_netamt_fdc1 ) AS CurPerdNetAmtInFDCrcy1,
  cast( ( YearToDateAmountInFDCrcy1 * JVAYearToDateNetSharePercent ) as jv_ytd_netamt_fdc1 ) AS YTDNetAmtInFDCrcy1,
  cast( ( ITDAmtInFDCrcy1 * ITDNetSharePercent ) as jv_itd_netamt_fdc1 ) AS ITDNetAmtInFDCrcy1,
  cast( ( AmountInFreeDefinedCurrency1 * JVASuspendSharePercent ) as jv_sus_shramt_fdc1 ) AS SuspShrAmtInFDCrcy1,
  cast( ( NetProfitIntrstAmtInFDCrcy1 * NetProfitIntrstShrPercent ) as jv_npi_shramt_fdc1 ) AS NetProfitIntrstShrAmtInFDCrcy1,
  FreeDefinedCurrency2,
  CurPerdAmtInFDCrcy2,
  YearToDateAmountInFDCrcy2,
  ITDAmtInFDCrcy2,
  cast( ( CurPerdAmtInFDCrcy2 * JVACurPeriodNetSharePercent ) as jv_cp_netamt_fdc2 ) AS CurPerdNetAmtInFDCrcy2,
  cast( ( YearToDateAmountInFDCrcy2 * JVAYearToDateNetSharePercent ) as jv_ytd_netamt_fdc2 ) AS YTDNetAmtInFDCrcy2,
  cast( ( ITDAmtInFDCrcy2 * ITDNetSharePercent ) as jv_itd_netamt_fdc2 ) AS ITDNetAmtInFDCrcy2,
  cast( ( AmountInFreeDefinedCurrency2 * JVASuspendSharePercent ) as jv_sus_shramt_fdc2 ) AS SuspShrAmtInFDCrcy2,
  cast( ( NetProfitIntrstAmtInFDCrcy2 * NetProfitIntrstShrPercent ) as jv_npi_shramt_fdc2 ) AS NetProfitIntrstShrAmtInFDCrcy2,
  FreeDefinedCurrency3,
  CurPerdAmtInFDCrcy3,
  YearToDateAmountInFDCrcy3,
  ITDAmtInFDCrcy3,
  cast( ( CurPerdAmtInFDCrcy3 * JVACurPeriodNetSharePercent ) as jv_cp_netamt_fdc3 ) AS CurPerdNetAmtInFDCrcy3,
  cast( ( YearToDateAmountInFDCrcy3 * JVAYearToDateNetSharePercent ) as jv_ytd_netamt_fdc3 ) AS YTDNetAmtInFDCrcy3,
  cast( ( ITDAmtInFDCrcy3 * ITDNetSharePercent ) as jv_itd_netamt_fdc3 ) AS ITDNetAmtInFDCrcy3,
  cast( ( AmountInFreeDefinedCurrency3 * JVASuspendSharePercent ) as jv_sus_shramt_fdc3 ) AS SuspShrAmtInFDCrcy3,
  cast( ( NetProfitIntrstAmtInFDCrcy3 * NetProfitIntrstShrPercent ) as jv_npi_shramt_fdc3 ) AS NetProfitIntrstShrAmtInFDCrcy3,
  FreeDefinedCurrency4,
  CurPerdAmtInFDCrcy4,
  YearToDateAmountInFDCrcy4,
  ITDAmtInFDCrcy4,
  cast( ( CurPerdAmtInFDCrcy4 * JVACurPeriodNetSharePercent ) as jv_cp_netamt_fdc4 ) AS CurPerdNetAmtInFDCrcy4,
  cast( ( YearToDateAmountInFDCrcy4 * JVAYearToDateNetSharePercent ) as jv_ytd_netamt_fdc4 ) AS YTDNetAmtInFDCrcy4,
  cast( ( ITDAmtInFDCrcy4 * ITDNetSharePercent ) as jv_itd_netamt_fdc4 ) AS ITDNetAmtInFDCrcy4,
  cast( ( AmountInFreeDefinedCurrency4 * JVASuspendSharePercent ) as jv_sus_shramt_fdc4 ) AS SuspShrAmtInFDCrcy4,
  cast( ( NetProfitIntrstAmtInFDCrcy4 * NetProfitIntrstShrPercent ) as jv_npi_shramt_fdc4 ) AS NetProfitIntrstShrAmtInFDCrcy4,
  FreeDefinedCurrency5,
  CurPerdAmtInFDCrcy5,
  YearToDateAmountInFDCrcy5,
  ITDAmtInFDCrcy5,
  cast( ( CurPerdAmtInFDCrcy5 * JVACurPeriodNetSharePercent ) as jv_cp_netamt_fdc5 ) AS CurPerdNetAmtInFDCrcy5,
  cast( ( YearToDateAmountInFDCrcy5 * JVAYearToDateNetSharePercent ) as jv_ytd_netamt_fdc5 ) AS YTDNetAmtInFDCrcy5,
  cast( ( ITDAmtInFDCrcy5 * ITDNetSharePercent ) as jv_itd_netamt_fdc5 ) AS ITDNetAmtInFDCrcy5,
  cast( ( AmountInFreeDefinedCurrency5 * JVASuspendSharePercent ) as jv_sus_shramt_fdc5 ) AS SuspShrAmtInFDCrcy5,
  cast( ( NetProfitIntrstAmtInFDCrcy5 * NetProfitIntrstShrPercent ) as jv_npi_shramt_fdc5 ) AS NetProfitIntrstShrAmtInFDCrcy5,
  FreeDefinedCurrency6,
  CurPerdAmtInFDCrcy6,
  YearToDateAmountInFDCrcy6,
  ITDAmtInFDCrcy6,
  cast( ( CurPerdAmtInFDCrcy6 * JVACurPeriodNetSharePercent ) as jv_cp_netamt_fdc6 ) AS CurPerdNetAmtInFDCrcy6,
  cast( ( YearToDateAmountInFDCrcy6 * JVAYearToDateNetSharePercent ) as jv_ytd_netamt_fdc6 ) AS YTDNetAmtInFDCrcy6,
  cast( ( ITDAmtInFDCrcy6 * ITDNetSharePercent ) as jv_itd_netamt_fdc6 ) AS ITDNetAmtInFDCrcy6,
  cast( ( AmountInFreeDefinedCurrency6 * JVASuspendSharePercent ) as jv_sus_shramt_fdc6 ) AS SuspShrAmtInFDCrcy6,
  cast( ( NetProfitIntrstAmtInFDCrcy6 * NetProfitIntrstShrPercent ) as jv_npi_shramt_fdc6 ) AS NetProfitIntrstShrAmtInFDCrcy6,
  FreeDefinedCurrency7,
  CurPerdAmtInFDCrcy7,
  YearToDateAmountInFDCrcy7,
  ITDAmtInFDCrcy7,
  cast( ( CurPerdAmtInFDCrcy7 * JVACurPeriodNetSharePercent ) as jv_cp_netamt_fdc7 ) AS CurPerdNetAmtInFDCrcy7,
  cast( ( YearToDateAmountInFDCrcy7 * JVAYearToDateNetSharePercent ) as jv_ytd_netamt_fdc7 ) AS YTDNetAmtInFDCrcy7,
  cast( ( ITDAmtInFDCrcy7 * ITDNetSharePercent ) as jv_itd_netamt_fdc7 ) AS ITDNetAmtInFDCrcy7,
  cast( ( AmountInFreeDefinedCurrency7 * JVASuspendSharePercent ) as jv_sus_shramt_fdc7 ) AS SuspShrAmtInFDCrcy7,
  cast( ( NetProfitIntrstAmtInFDCrcy7 * NetProfitIntrstShrPercent ) as jv_npi_shramt_fdc7 ) AS NetProfitIntrstShrAmtInFDCrcy7,
  FreeDefinedCurrency8,
  CurPerdAmtInFDCrcy8,
  YearToDateAmountInFDCrcy8,
  ITDAmtInFDCrcy8,
  cast( ( CurPerdAmtInFDCrcy8 * JVACurPeriodNetSharePercent ) as jv_cp_netamt_fdc8 ) AS CurPerdNetAmtInFDCrcy8,
  cast( ( YearToDateAmountInFDCrcy8 * JVAYearToDateNetSharePercent ) as jv_ytd_netamt_fdc8 ) AS YTDNetAmtInFDCrcy8,
  cast( ( ITDAmtInFDCrcy8 * ITDNetSharePercent ) as jv_itd_netamt_fdc8 ) AS ITDNetAmtInFDCrcy8,
  cast( ( AmountInFreeDefinedCurrency8 * JVASuspendSharePercent ) as jv_sus_shramt_fdc8 ) AS SuspShrAmtInFDCrcy8,
  cast( ( NetProfitIntrstAmtInFDCrcy8 * NetProfitIntrstShrPercent ) as jv_npi_shramt_fdc8 ) AS NetProfitIntrstShrAmtInFDCrcy8,
  JVAFundingCurrency1,
  CurPerdAmtInFundCrcy,
  YearToDateAmountInFundCrcy,
  ITDAmtInFundCrcy,
  cast( ( CurPerdAmtInFundCrcy * JVACurPeriodNetSharePercent ) as jv_cp_netamt_fundc1 ) AS CurPerdNetAmtInFundCrcy,
  cast( ( YearToDateAmountInFundCrcy * JVAYearToDateNetSharePercent ) as jv_ytd_netamt_fundc1 ) AS YTDNetAmtInFundCrcy,
  cast( ( ITDAmtInFundCrcy * ITDNetSharePercent ) as jv_itd_netamt_fundc1 ) AS ITDNetAmtInFundCrcy,
  cast( ( AmountInJVAFundingCurrency * JVASuspendSharePercent ) as jv_sus_shramt_fundc1 ) AS SuspShrAmtInFundCrcy,
  cast( ( NetPrftIntrstShrAmtInFundCrcy * NetProfitIntrstShrPercent ) as jv_npi_shramt_fundc1 ) AS NetPrftIntrstShrAmtInFundCrcy,
  JVACurPeriodNetSharePercent,
  JVAYearToDateNetSharePercent,
  ITDNetSharePercent,
  JVASuspendSharePercent,
  NetProfitIntrstShrPercent,
  AmountInTransactionCurrency,
  NetProfitIntrstAmtInTC,
  AmountInCompanyCodeCurrency,
  NetProfitIntrstAmtInCCrcy,
  AmountInGlobalCurrency,
  NetProfitIntrstAmtInGCrcy,
  AmountInBalanceTransacCrcy,
  NetProfitIntrstAmtInBlTCrcy,
  AmountInFreeDefinedCurrency1,
  NetProfitIntrstAmtInFDCrcy1,
  AmountInFreeDefinedCurrency2,
  NetProfitIntrstAmtInFDCrcy2,
  AmountInFreeDefinedCurrency3,
  NetProfitIntrstAmtInFDCrcy3,
  AmountInFreeDefinedCurrency4,
  NetProfitIntrstAmtInFDCrcy4,
  AmountInFreeDefinedCurrency5,
  NetProfitIntrstAmtInFDCrcy5,
  AmountInFreeDefinedCurrency6,
  NetProfitIntrstAmtInFDCrcy6,
  AmountInFreeDefinedCurrency7,
  NetProfitIntrstAmtInFDCrcy7,
  AmountInFreeDefinedCurrency8,
  NetProfitIntrstAmtInFDCrcy8,
  AmountInJVAFundingCurrency,
  NetProfitIntrstAmtInFundCrcy,
  FunctionalArea,
  ServiceDocumentType
FROM I_GrossPartNetByCostCtrC
;