P_ML_Balance_Bcf

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 P_ML_Balance_Bcf.
-- 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_CalendarDate : calendardate

CREATE VIEW P_ML_Balance_Bcf AS
SELECT
  it.CompanyCode AS CompanyCode,
  it.SourceLedger AS Ledger,
  it.GLAccount AS GLAccount,
  it.FiscalYear AS FiscalYear,
  it.AccountingDocument AS AccountingDocument,
  it.LedgerGLLineItem AS LedgerGLLineItem,
  it.Product AS Product,
  it.Product AS Material,
  it.CostEstimate AS CostEstimate,
  it.ChartOfAccounts AS ChartOfAccounts,
  it.AccountingDocumentType AS AccountingDocumentType,
  it.ValuationArea AS ValuationArea,
  it.InventoryValuationType AS InventoryValuationType,
  it.FiscalPeriod AS FiscalPeriod,
  it.FiscalYearVariant AS FiscalYearVariant,
  it.LedgerFiscalYear AS LedgerFiscalYear,
  it.PostingDate AS PostingDate,
  it.PostingDate AS MatlDocLatestPostgDate,
  it.ReferenceDocument AS ReferenceDocument,
  it.ReferenceDocumentType AS ReferenceDocumentType,
  it.BusinessTransactionType AS BusinessTransactionType,
  it.DocumentDate AS DocumentDate,
  it.ProfitCenter AS ProfitCenter,
  it.CostCenter AS CostCenter,
  it.Segment AS Segment,
  it.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  it.LastChangeDateTime AS LastChangeDateTime,
  it.FiscalYearPeriod AS FiscalYearPeriod,
  it.PurchasingDocument AS PurchasingDocument,
  it.OrderID AS ProductionOrder,
  it.TransactionTypeDetermination AS TransactionTypeDetermination,
  it.ProductGroup AS MaterialGroup,
  it.ProductGroup AS ProductGroup,
  _MaterialValuation.MaterialValuationClass AS MaterialValuationClass,
  _MaterialValuation.InventoryValuationCategory AS InventoryValuationCategory,
  it.ControllingArea AS ControllingArea,
  it.Plant AS Plant,
  it.MaterialLedgerProcessType AS MaterialLedgerProcessType,
  it.MaterialLedgerCategory AS MaterialLedgerCategory,
  it.IsSupplierStockValuation AS IsSupplierStockValuation,
  it.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  it.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  it.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  it.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  it.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  ml.FromFiscalYear AS FromFiscalYear,
  ml.CompanyCodeCurrencyRole AS CompanyCodeCurrencyRole,
  ml.GlobalCurrencyRole AS GlobalCurrencyRole,
  ml.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  ml.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
  ml.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
  ml.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
  ml.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
  ml.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
  ml.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
  ml.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role,
  it.CompanyCodeCurrency AS CompanyCodeCurrency,
  it.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  it.SlsPriceAmountInCoCodeCrcy AS SlsPriceAmountInCoCodeCrcy,
  it.GlobalCurrency AS GroupCurrency,
  it.AmountInGlobalCurrency AS AmountInGroupCurrency,
  it.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  it.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  it.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  it.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  it.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  it.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  it.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  it.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  it.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  it.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  it.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  it.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  it.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  it.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  it.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  it.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  it.CostSourceUnit AS CostSourceUnit,
  it.ValuationQuantity AS InventoryQty,
  it._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  it._ChartOfAccounts AS _ChartOfAccounts,
  it._Segment AS _Segment,
  it._CompanyCode AS _CompanyCode,
  it._Ledger AS _Ledger,
  it._ProfitCenter AS _ProfitCenter,
  it._CostCenter AS _CostCenter,
  it._CompanyCodeCurrency AS _CompanyCodeCurrency,
  it._GlobalCurrency AS _GlobalCurrency,
  it._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  it._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  it._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  it._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  it._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  it._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  it._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  it._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  it._CostSourceUnit AS _CostSourceUnit,
  it._ControllingArea AS _ControllingArea,
  it._Product AS _Product
FROM P_ML_CoCode_Ledger_BCF
INNER JOIN I_GLAccountLineItemRawData AS it ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialValuation AS _MaterialValuation ON _MaterialValuation.CostEstimate = it.CostEstimate AND _MaterialValuation.Material = it.Product AND _MaterialValuation.ValuationArea = it.ValuationArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON _BusinessTransactionType.BusinessTransactionType = it.BusinessTransactionType  -- association [0..1]
;