P_FqmbalanceCASH

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_FqmbalanceCASH.
-- 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: PFQMBALANCECASH

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