I_GrossPartNetByCostCtrEntyC

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

CREATE VIEW I_GrossPartNetByCostCtrEntyC AS
SELECT
  JVItem.CompanyCode AS CompanyCode,
  JVItem.Ledger AS Ledger,
  JVItem.FiscalYear AS FiscalYear,
  JVItem.AccountingDocument AS AccountingDocument,
  JVItem.LedgerGLLineItem AS LedgerGLLineItem,
  JVItem.FiscalYearVariant AS FiscalYearVariant,
  JVItem.FiscalPeriod AS FiscalPeriod,
  JVItem.PostingDate AS PostingDate,
  JVItem.LedgerFiscalYear AS LedgerFiscalYear,
  JVItem.GLRecordType AS GLRecordType,
  JVItem.ChartOfAccounts AS ChartOfAccounts,
  JVItem.GLAccount AS GLAccount,
  JVItem.DebitCreditCode AS DebitCreditCode,
  JVItem.ControllingArea AS ControllingArea,
  JVItem.CostCenter AS CostCenter,
  JVItem.ProfitCenter AS ProfitCenter,
  JVItem.BusinessArea AS BusinessArea,
  JVItem.MasterFixedAsset AS MasterFixedAsset,
  JVItem.FixedAsset AS FixedAsset,
  JVItem.AssetTransactionType AS AssetTransactionType,
  JVItem.OrderID AS OrderID,
  JVItem.ProjectNetwork AS ProjectNetwork,
  JVItem.WBSElementInternalID AS WBSElementInternalID,
  JVItem.WBSElementExternalID AS WBSElementExternalID,
  JVItem.JointVenture AS JointVenture,
  Venture.JointVentureType AS JointVentureType,
  JVItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  JVItem.JointVentureEquityType AS JointVentureEquityType,
  EqGroup.JntVntrOperatedShare AS JntVntrOperatedShare,
  PShare.JntVntrEquityShare AS JntVntrEquityShare,
  JVItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  cast( $parameters.P_JointVenturePartner as jv_part_cds preserving type ) AS JointVenturePartner,
  JVPars.Operator AS Operator,
  JVItem.JointVentureBillingType AS JointVentureBillingType,
  JVItem.BaseUnit AS BaseUnit,
  JVItem.Quantity AS Quantity,
  JVItem.Supplier AS Supplier,
  JVItem.AccountingDocumentType AS AccountingDocumentType,
  JVItem.FinancialAccountType AS FinancialAccountType,
  JVItem.Segment AS Segment,
  JVItem.Customer AS Customer,
  JVItem.SalesOrganization AS SalesOrganization,
  JVItem.ValuationArea AS ValuationArea,
  JVItem.Plant AS Plant,
  JVItem.DistributionChannel AS DistributionChannel,
  JVItem.OrganizationDivision AS OrganizationDivision,
  JVItem.ServiceDocument AS ServiceDocument,
  JVItem.SalesDocument AS SalesDocument,
  JVItem.AssetClass AS AssetClass,
  PShare.JntVntrInterestType AS JntVntrInterestType,
  JVItem.TransactionCurrency AS TransactionCurrency,
  cast( curr_to_decfloat_amount( JVItem.AmountInTransactionCurrency ) as jv_cp_netamt_tc_dec ) AS AmountInTransactionCrcyDcml,
  JVItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( curr_to_decfloat_amount( JVItem.AmountInCompanyCodeCurrency ) as jv_cpamt_cc_dec ) AS AmountInCompanyCodeCrcyDcml,
  JVItem.GlobalCurrency AS GlobalCurrency,
  cast( curr_to_decfloat_amount( JVItem.AmountInGlobalCurrency ) as jv_cp_netamt_gc_dec ) AS AmountInGlobalCurrencyDcml,
  JVItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  cast( curr_to_decfloat_amount( JVItem.AmountInBalanceTransacCrcy ) as jv_cpamt_btc_dec ) AS AmountInBalanceTransacCrcyDcml,
  JVItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  cast( curr_to_decfloat_amount( JVItem.AmountInFreeDefinedCurrency1 ) as jv_cpamt_cc_dec ) AS AmountInFreeDefinedCry1Dcml,
  cast( curr_to_decfloat_amount( JVItem.AmountInFreeDefinedCurrency2 ) as jv_cpamt_cc_dec ) AS AmountInFreeDefinedCry2Dcml,
  cast( curr_to_decfloat_amount( JVItem.AmountInFreeDefinedCurrency3 ) as jv_cpamt_cc_dec ) AS AmountInFreeDefinedCry3Dcml,
  cast( curr_to_decfloat_amount( JVItem.AmountInFreeDefinedCurrency4 ) as jv_cpamt_cc_dec ) AS AmountInFreeDefinedCry4Dcml,
  cast( curr_to_decfloat_amount( JVItem.AmountInFreeDefinedCurrency5 ) as jv_cpamt_cc_dec ) AS AmountInFreeDefinedCry5Dcml,
  cast( curr_to_decfloat_amount( JVItem.AmountInFreeDefinedCurrency6 ) as jv_cpamt_cc_dec ) AS AmountInFreeDefinedCry6Dcml,
  cast( curr_to_decfloat_amount( JVItem.AmountInFreeDefinedCurrency7 ) as jv_cpamt_cc_dec ) AS AmountInFreeDefinedCry7Dcml,
  cast( curr_to_decfloat_amount( JVItem.AmountInFreeDefinedCurrency8 ) as jv_cpamt_cc_dec ) AS AmountInFreeDefinedCry8Dcml,
  JVItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  JVItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  JVItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  JVItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  JVItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  JVItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  JVItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  cast( JVItem.JVAFundingCurrency as jv_fundcur preserving type ) AS JVAFundingCurrency1,
  cast( curr_to_decfloat_amount( JVItem.AmountInJVAFundingCurrency ) as jv_cpamt_cc_dec ) AS AmountInJVAFundingCurrencyDcml,
  JVItem._Ledger AS _Ledger,
  JVItem._CompanyCode AS _CompanyCode,
  JVItem._FiscalYear AS _FiscalYear,
  JVItem._JournalEntry AS _JournalEntry,
  JVItem.FunctionalArea AS FunctionalArea,
  JVItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  JVItem._ChartOfAccounts AS _ChartOfAccounts,
  JVItem._DebitCreditCode AS _DebitCreditCode,
  JVItem._ControllingArea AS _ControllingArea,
  JVItem._BusinessArea AS _BusinessArea,
  JVItem._CostCenter AS _CostCenter,
  JVItem._ProfitCenter AS _ProfitCenter,
  JVItem._Order AS _Order,
  JVItem._ProjectNetwork AS _ProjectNetwork,
  JVItem._TransactionCurrency AS _TransactionCurrency,
  JVItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  JVItem._GlobalCurrency AS _GlobalCurrency,
  JVItem._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  JVItem._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  JVItem._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  JVItem._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  JVItem._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  JVItem._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  JVItem._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  JVItem._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  JVItem._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  JVItem._BaseUnit AS _BaseUnit,
  JVItem._JointVentureMasterFld AS _JointVentureMasterFld,
  JVItem._JntVntrRecoveryInd AS _JntVntrRecoveryInd,
  JVItem._JntVntrEquityGrp AS _JntVntrEquityGrp,
  JVItem._JntVntrEquityTypeMaster AS _JntVntrEquityTypeMaster,
  JVItem._FiscalYearVariant AS _FiscalYearVariant,
  JVItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  JVItem._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  JVItem._MasterFixedAsset AS _MasterFixedAsset,
  JVItem._JointVenturePayrollType AS _JointVenturePayrollType,
  JVItem._AssetTransactionType AS _AssetTransactionType,
  JVItem._WBSElementBasicData AS _WBSElementBasicData,
  JVItem._WBSElementExternalID AS _WBSElementExternalID,
  JVItem._Supplier AS _Supplier,
  JVItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  JVItem._AccountingDocumentType AS _AccountingDocumentType,
  JVItem._Customer AS _Customer,
  JVItem._CurrentCostCenter AS _CurrentCostCenter,
  JVItem._CurrentProfitCenter AS _CurrentProfitCenter,
  JVItem._SalesDocument AS _SalesDocument,
  JVItem._FixedAsset AS _FixedAsset,
  JVItem.ServiceDocumentType AS ServiceDocumentType,
  JVItem._DistributionChannel AS _DistributionChannel,
  JVItem._ServiceDocument AS _ServiceDocument
FROM I_JVALineItemCube AS JVItem
INNER JOIN I_JntVntrCoCodeParam AS JVPars ON /* join condition not captured in parsed metadata */
INNER JOIN I_JointVentureMasterFld AS Venture ON /* join condition not captured in parsed metadata */
INNER JOIN I_JntVntrPartOwnrEquityShr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JntVntrBusinessPartner AS _JntVntrBusinessPartner ON CompanyCode = _JntVntrBusinessPartner.CompanyCode AND JointVenturePartner = _JntVntrBusinessPartner.JointVenturePartner  -- association [0..1]
LEFT OUTER JOIN I_GrssPrtNetByCsCtrEntyDSt AS _DocumentStore ON _DocumentStore.tra_companycode = CompanyCode AND _DocumentStore.tra_ledger = Ledger AND _DocumentStore.tra_fiscalyear = FiscalYear AND _DocumentStore.tra_00011 = AccountingDocument AND _DocumentStore.tra_00039 = LedgerGLLineItem  -- association [0..1]
;