P_Fqmbalance

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_Fqmbalance.
-- 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: PFQMBALANCE

CREATE VIEW P_Fqmbalance AS
SELECT
  P_Fqmtransactiondate.TransactionDate AS TransactionDate,
  P_Fqmflow.ValidFrom AS ValidFrom,
  P_Fqmflow.ValidTo AS ValidTo,
  P_Fqmflow.CreatedByUser AS CreatedByUser,
  P_Fqmflow.LastChangedByUser AS LastChangedByUser,
  P_Fqmflow.OriginSystem AS OriginSystem,
  P_Fqmflow.OriginApplication AS OriginApplication,
  P_Fqmflow.OriginDocument AS OriginDocument,
  P_Fqmflow.OriginTransaction AS OriginTransaction,
  P_Fqmflow.OriginTransQualifier AS OriginTransQualifier,
  P_Fqmflow.OriginFlowId AS OriginFlowId,
  P_Fqmflow.OriginSystemRl AS OriginSystemRl,
  P_Fqmflow.OriginApplicationRl AS OriginApplicationRl,
  P_Fqmflow.OriginDocumentRl AS OriginDocumentRl,
  P_Fqmflow.OriginTransactionRl AS OriginTransactionRl,
  P_Fqmflow.OriginTransQualifierRl AS OriginTransQualifierRl,
  P_Fqmflow.OriginFlowIdRl AS OriginFlowIdRl,
  P_Fqmflow.CertaintyLevel AS CertaintyLevel,
  P_Fqmflow.FlowCategory AS FlowCategory,
  P_Fqmflow.FlowType AS FlowType,
  P_Fqmflow.PaymentMethodCode AS PaymentMethodCode,
  P_Fqmflow.GLAccount AS GLAccount,
  sum(P_Fqmflow.Amount) AS Amount,
  P_Fqmflow.Currency AS Currency,
  P_Fqmflow.ProductType AS ProductType,
  P_Fqmflow.FinancialTransactionType AS FinancialTransactionType,
  P_Fqmflow.TrmActivityCategory AS TrmActivityCategory,
  P_Fqmflow.SecurityClass AS SecurityClass,
  P_Fqmflow.TrmSecurityAccount AS TrmSecurityAccount,
  P_Fqmflow.Portfolio AS Portfolio,
  P_Fqmflow.HouseBank AS HouseBank,
  P_Fqmflow.HouseBankAccount AS HouseBankAccount,
  P_Fqmflow.BankAccountId AS BankAccountId,
  P_Fqmflow.CompanyCode AS CompanyCode,
  P_Fqmflow.Customer AS Customer,
  P_Fqmflow.Vendor AS Vendor,
  P_Fqmflow.Partner AS Partner,
  P_Fqmflow.Material AS Material,
  P_Fqmflow.BusinessArea AS BusinessArea,
  P_Fqmflow.ProfitCenter AS ProfitCenter,
  P_Fqmflow.Project AS Project,
  P_Fqmflow.CostCenter AS CostCenter,
  P_Fqmflow.PartnerCompany AS PartnerCompany,
  P_Fqmflow.LiquidityItem AS LiquidityItem,
  P_Fqmflow.Segment AS Segment,
  P_Fqmflow.PlanningLevel AS PlanningLevel,
  P_Fqmflow.PlanningGroup AS PlanningGroup,
  P_Fqmflow.AssignedCompanyCode AS AssignedCompanyCode,
  P_Fqmflow.DocumentReferenceID AS DocumentReferenceID,
  P_Fqmflow.Characteristics AS Characteristics,
  P_Fqmflow.AssignmentReference AS AssignmentReference,
  P_Fqmflow.ReferenceDocument AS ReferenceDocument,
  P_Fqmflow.FiscalYear AS FiscalYear,
  P_Fqmflow.KeyFigure AS KeyFigure
FROM P_Fqmtransactiondate
LEFT OUTER JOIN P_Fqmflow ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocument ON OriginDocumentRl = _AccountingDocument.OriginalReferenceDocument AND OriginApplication = _AccountingDocument.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND ReferenceDocument = _JournalEntry.AccountingDocument AND FiscalYear = _JournalEntry.FiscalYear  -- association [0..1]
;