I_GrossBillByVntrC

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_GrossBillByVntrC.
-- 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: IGRSSBILLJVC
-- Parameters: P_LedgerFiscalYear : gjahr, P_FiscalPeriod : poper

CREATE VIEW I_GrossBillByVntrC 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.CutbackCostObject AS CutbackCostObject,
  JVItem.GLAccountType AS GLAccountType,
  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,
  JVItem._JointVentureMasterFld.JointVentureType AS JointVentureType,
  JVItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  JVItem.JointVentureEquityType AS JointVentureEquityType,
  JVItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  JVItem.JntVntrRcvryCodeIsBillable AS JntVntrRcvryCodeIsBillable,
  JVItem.JntVntrRcvryCodeIsRlvtToBillg AS JntVntrRcvryCodeIsRlvtToBillg,
  JVItem.JointVenturePartner AS BusinessPartner,
  JVItem.Customer AS Customer,
  JVItem.JointVentureBillingType AS JointVentureBillingType,
  JVItem.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  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,
  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._GLAccountType AS _GLAccountType,
  JVItem._DebitCreditCode AS _DebitCreditCode,
  JVItem._ControllingArea AS _ControllingArea,
  JVItem._CostCenter AS _CostCenter,
  JVItem._BusinessArea AS _BusinessArea,
  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
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]
LEFT OUTER JOIN I_JVACtbckAcctMappgIntraBsc AS _CutbackAccntMappingCompCode ON _CutbackAccntMappingCompCode.CompanyCode = CompanyCode AND _CutbackAccntMappingCompCode.FromGLAccount <= GLAccount AND _CutbackAccntMappingCompCode.ToGLAccount >= GLAccount AND JntVntrRcvryCodeIsBillable = 'X'  -- association [0..*]
LEFT OUTER JOIN I_JVACtbckCOAAcctMappgIntraBsc AS _CutbackAccntMappingCntrlArea ON _CutbackAccntMappingCntrlArea.JVAChartOfAccounts = ChartOfAccounts AND _CutbackAccntMappingCntrlArea.FromGLAccount <= GLAccount AND _CutbackAccntMappingCntrlArea.ToGLAccount >= GLAccount AND JntVntrRcvryCodeIsBillable = 'X'  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CutbackCostCenter ON _CutbackCostCenter.ObjectInternalID = CutbackCostObject AND _CutbackCostCenter.ValidityStartDate <= $session.user_date AND _CutbackCostCenter.ValidityEndDate >= $session.user_date AND _CutbackCostCenter.ControllingArea = ControllingArea AND _CutbackCostCenter.CostCenter = CostCenter  -- association [0..*]
LEFT OUTER JOIN I_OrderBasic AS _CutbackOrder ON _CutbackOrder.ObjectInternalID = CutbackCostObject  -- association [0..*]
LEFT OUTER JOIN I_ProjectNetwork AS _CutbackNetwork ON _CutbackNetwork.ProjectNetworkObject = CutbackCostObject  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _CutbackWBSElement ON _CutbackWBSElement.WBSElementObject = CutbackCostObject  -- association [0..*]
LEFT OUTER JOIN I_JVACtbckCostCtrMappgIntraBsc AS _CutbackCostCenterMapping ON _CutbackCostCenterMapping.CompanyCode = CompanyCode AND _CutbackCostCenterMapping.JVAFromCostCenter <= CostCenter AND _CutbackCostCenterMapping.JVAToCostCenter >= CostCenter  -- association [0..*]
LEFT OUTER JOIN I_JVACtbckWBSMappgIntraBsc AS _CutbackWBSElementMapping ON _CutbackWBSElementMapping.CompanyCode = CompanyCode AND _CutbackWBSElementMapping.JVAFromProject <= WBSElementExternalID AND _CutbackWBSElementMapping.JVAToProject >= WBSElementExternalID  -- association [0..*]
LEFT OUTER JOIN I_JVACtbckOrdMappgIntraBsc AS _CutbackOrderMapping ON _CutbackOrderMapping.CompanyCode = CompanyCode AND _CutbackOrderMapping.JVAFromOrder <= OrderID AND _CutbackOrderMapping.JVARangeToOrder >= OrderID  -- association [0..*]
;