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
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  -- 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..*]
LEFT OUTER JOIN I_JVACtbckNtwkMappgIntraBsc AS _CutbackNetworkMapping ON _CutbackNetworkMapping.CompanyCode = CompanyCode AND _CutbackNetworkMapping.JVAFromNetwork <= ProjectNetwork AND _CutbackNetworkMapping.JVAToNetwork >= ProjectNetwork  -- association [0..*]
;