I_JVAPartnerBillingCube

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

CREATE VIEW I_JVAPartnerBillingCube 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
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_JntVntrFundCrcyByEquityGrp AS _TransCrcyAsFundCrcy ON _TransCrcyAsFundCrcy.CompanyCode = CompanyCode AND _TransCrcyAsFundCrcy.JointVenture = JointVenture AND _TransCrcyAsFundCrcy.JointVentureEquityGroup = JointVentureEquityGroup AND _TransCrcyAsFundCrcy.JointVentureFundingCrcy = TransactionCurrency  -- association [0..1]
LEFT OUTER JOIN I_JVADefaultFundCrcy AS _DefaultFundCrcy ON _DefaultFundCrcy.CompanyCode = CompanyCode AND _DefaultFundCrcy.JointVenture = JointVenture AND _DefaultFundCrcy.JointVentureEquityGroup = JointVentureEquityGroup  -- association [0..1]
;