I_JVAPartnerBillingEntyCube

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_JVAPartnerBillingEntyCube.
-- 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_JVAPartnerBillingEntyCube 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.LedgerFiscalYear AS LedgerFiscalYear,
  JVItem.PostingDate AS PostingDate,
  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,
  JVItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  cast ( EqGroup.JntVntrOperatedShare as abap.char(16) ) AS JntVntrOperatedShare,
  cast ( PShare.JntVntrEquityShare as abap.char(16) ) AS JntVntrEquityShare,
  JVItem.Customer AS Customer,
  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.SalesDocument AS SalesDocument,
  JVItem.SalesOrganization AS SalesOrganization,
  JVItem.ServiceDocumentType AS ServiceDocumentType,
  JVItem.ValuationArea AS ValuationArea,
  JVItem.Plant AS Plant,
  JVItem.DistributionChannel AS DistributionChannel,
  JVItem.OrganizationDivision AS OrganizationDivision,
  JVItem.ServiceDocument AS ServiceDocument,
  JVItem.AssetClass AS AssetClass,
  JVItem.FunctionalArea AS FunctionalArea,
  JVItem.TransactionCurrency AS TransactionCurrency,
  cast(JVItem.AmountInTransactionCurrency as jv_itdamt_tc preserving type) AS ITDAmtInTC,
  JVItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast(JVItem.AmountInCompanyCodeCurrency as jv_itdamt_cc preserving type) AS ITDAmtInCCrcy,
  JVItem.GlobalCurrency AS GlobalCurrency,
  cast(JVItem.AmountInGlobalCurrency as jv_itdamt_gc preserving type) AS ITDAmtInGCrcy,
  JVItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  cast(JVItem.AmountInBalanceTransacCrcy as jv_itdamt_btc preserving type) AS ITDAmtInBlTCrcy,
  JVItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  cast(JVItem.AmountInFreeDefinedCurrency1 as jv_itdamt_fdc1 preserving type) AS ITDAmtInFDCrcy1,
  JVItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  cast(JVItem.AmountInFreeDefinedCurrency2 as jv_itdamt_fdc2 preserving type) AS ITDAmtInFDCrcy2,
  JVItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  cast(JVItem.AmountInFreeDefinedCurrency3 as jv_itdamt_fdc3 preserving type) AS ITDAmtInFDCrcy3,
  JVItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  cast(JVItem.AmountInFreeDefinedCurrency4 as jv_itdamt_fdc4 preserving type) AS ITDAmtInFDCrcy4,
  JVItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  cast(JVItem.AmountInFreeDefinedCurrency5 as jv_itdamt_fdc5 preserving type) AS ITDAmtInFDCrcy5,
  JVItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  cast(JVItem.AmountInFreeDefinedCurrency6 as jv_itdamt_fdc6 preserving type) AS ITDAmtInFDCrcy6,
  JVItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  cast(JVItem.AmountInFreeDefinedCurrency7 as jv_itdamt_fdc7 preserving type) AS ITDAmtInFDCrcy7,
  JVItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  cast(JVItem.AmountInFreeDefinedCurrency8 as jv_itdamt_fdc8 preserving type) AS ITDAmtInFDCrcy8,
  cast( JVItem.JVAFundingCurrency as jv_fundcur preserving type ) AS JVAFundingCurrency1,
  cast( JVItem.AmountInJVAFundingCurrency as jv_itdamt_fundc1 preserving type ) AS ITDAmtInFundCrcy,
  JVItem._CompanyCode AS _CompanyCode,
  JVItem._Ledger AS _Ledger,
  JVItem._FiscalYear AS _FiscalYear,
  JVItem._JournalEntry AS _JournalEntry,
  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._DistributionChannel AS _DistributionChannel,
  JVItem._ServiceDocument AS _ServiceDocument
FROM I_JVALineItemCube AS JVItem
INNER JOIN I_JointVentureMasterFld AS Venture ON /* join condition not captured in parsed metadata */
INNER JOIN I_JntVntrEquityGrp AS EqGroup ON /* join condition not captured in parsed metadata */
INNER JOIN I_JntVntrBusinessPartner AS Partner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JntVntrBusinessPartner AS _JntVntrBusinessPartner ON _JntVntrBusinessPartner.CompanyCode = CompanyCode AND _JntVntrBusinessPartner.JointVenturePartner = JointVenturePartner  -- association [0..1]
LEFT OUTER JOIN I_JVAPartnerBillingEntyDSt AS _DocumentStore ON _DocumentStore.tra_companycode = CompanyCode AND _DocumentStore.tra_ledger = Ledger AND _DocumentStore.tra_fiscalyear = FiscalYear AND _DocumentStore.tra_00028 = AccountingDocument AND _DocumentStore.tra_00022 = LedgerGLLineItem  -- association [0..1]
;