P_FqmbalanceP

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_FqmbalanceP.
-- 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: PFQMBALANCEP

CREATE VIEW P_FqmbalanceP AS
SELECT
  P_Fqmtransactiondate.TransactionDate AS TransactionDate,
  P_FqmflowP.CreatedByUser AS CreatedByUser,
  P_FqmflowP.LastChangedByUser AS LastChangedByUser,
  P_FqmflowP.OriginSystem AS OriginSystem,
  P_FqmflowP.OriginApplication AS OriginApplication,
  P_FqmflowP.OriginDocument AS OriginDocument,
  P_FqmflowP.OriginTransaction AS OriginTransaction,
  P_FqmflowP.OriginTransQualifier AS OriginTransQualifier,
  P_FqmflowP.CashFlow AS OriginFlowId,
  P_FqmflowP.OriginSystemRl AS OriginSystemRl,
  P_FqmflowP.OriginApplicationRl AS OriginApplicationRl,
  P_FqmflowP.OriginDocumentRl AS OriginDocumentRl,
  P_FqmflowP.OriginTransactionRl AS OriginTransactionRl,
  P_FqmflowP.OriginTransQualifierRl AS OriginTransQualifierRl,
  P_FqmflowP.OriginFlowIdRl AS OriginFlowIdRl,
  P_FqmflowP.CertaintyLevel AS CertaintyLevel,
  P_FqmflowP.FlowCategory AS FlowCategory,
  P_FqmflowP.FlowType AS FlowType,
  P_FqmflowP.PaymentMethodCode AS PaymentMethodCode,
  P_FqmflowP.GLAccount AS GLAccount,
  sum(P_FqmflowP.Amount) AS Amount,
  P_FqmflowP.Currency AS Currency,
  P_FqmflowP.ProductType AS ProductType,
  P_FqmflowP.FinancialTransactionType AS FinancialTransactionType,
  P_FqmflowP.TrmActivityCategory AS TrmActivityCategory,
  P_FqmflowP.SecurityClass AS SecurityClass,
  P_FqmflowP.TrmSecurityAccount AS TrmSecurityAccount,
  P_FqmflowP.Portfolio AS Portfolio,
  P_FqmflowP.HouseBank AS HouseBank,
  P_FqmflowP.HouseBankAccount AS HouseBankAccount,
  P_FqmflowP.BankAccountId AS BankAccountId,
  P_FqmflowP.CompanyCode AS CompanyCode,
  P_FqmflowP.Customer AS Customer,
  P_FqmflowP.Vendor AS Vendor,
  P_FqmflowP.Partner AS Partner,
  P_FqmflowP.Material AS Material,
  P_FqmflowP.BusinessArea AS BusinessArea,
  P_FqmflowP.ProfitCenter AS ProfitCenter,
  P_FqmflowP.Project AS Project,
  P_FqmflowP.CostCenter AS CostCenter,
  P_FqmflowP.PartnerCompany AS PartnerCompany,
  P_FqmflowP.LiquidityItem AS LiquidityItem,
  P_FqmflowP.Segment AS Segment,
  P_FqmflowP.PlanningLevel AS PlanningLevel,
  P_FqmflowP.PlanningGroup AS PlanningGroup,
  P_FqmflowP.AssignedCompanyCode AS AssignedCompanyCode,
  P_FqmflowP.DocumentReferenceID AS DocumentReferenceID,
  P_FqmflowP.Characteristics AS Characteristics,
  P_FqmflowP.AssignmentReference AS AssignmentReference,
  P_FqmflowP.ReferenceDocument AS ReferenceDocument,
  P_FqmflowP.FiscalYear AS FiscalYear,
  P_FqmflowP.KeyFigure AS KeyFigure
FROM P_Fqmtransactiondate
LEFT OUTER JOIN P_FqmflowP ON /* join condition not captured in parsed metadata */
;