P_FqmbalanceTRMMM

DDL: P_FQMBALANCETRMMM SQL: PFQMBALANCETRMMM Type: view BASIC
51 Fields 2 Data Sources

P_FqmbalanceTRMMM is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (P_FqmflowTRMMM, P_Fqmtransactiondate) and exposes 51 fields with key field TransactionDate.

Data Sources (2)

SourceAliasJoin Type
P_FqmflowTRMMM P_FqmflowTRMMM left_outer
P_Fqmtransactiondate P_Fqmtransactiondate from

Annotations (9)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PFQMBALANCETRMMM view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY TransactionDate P_Fqmtransactiondate TransactionDate Value Date
CreatedByUser P_FqmflowTRMMM CreatedByUser User Name
LastChangedByUser P_FqmflowTRMMM LastChangedByUser User Name
OriginSystem P_FqmflowTRMMM OriginSystem LogSys: Formula
OriginApplication P_FqmflowTRMMM OriginApplication Origin Application
OriginDocument P_FqmflowTRMMM OriginDocument Source Doc. ID
OriginTransaction P_FqmflowTRMMM OriginTransaction Source Trans. ID
OriginTransQualifier P_FqmflowTRMMM OriginTransQualifier Trans. Qualifier
OriginFlowId P_FqmflowTRMMM CashFlow Source Flow ID
OriginSystemRl P_FqmflowTRMMM OriginSystemRl Logical system
OriginApplicationRl P_FqmflowTRMMM OriginApplicationRl Source Application
OriginDocumentRl P_FqmflowTRMMM OriginDocumentRl Source Doc. ID
OriginTransactionRl P_FqmflowTRMMM OriginTransactionRl Source Trans. ID
OriginTransQualifierRl P_FqmflowTRMMM OriginTransQualifierRl Trans. Qualifier
OriginFlowIdRl P_FqmflowTRMMM OriginFlowIdRl Source Flow ID
CertaintyLevel P_FqmflowTRMMM CertaintyLevel Certainty Level
FlowCategory P_FqmflowTRMMM FlowCategory Flow Category
FlowType P_FqmflowTRMMM FlowType Update Type
PaymentMethodCode P_FqmflowTRMMM PaymentMethodCode Pymt Meth.
GLAccount P_FqmflowTRMMM GLAccount General Ledger
Amount
Currency P_FqmflowTRMMM Currency Valuation Crcy
ProductType P_FqmflowTRMMM ProductType Product Type Group
FinancialTransactionType P_FqmflowTRMMM FinancialTransactionType Transact. Type
TrmActivityCategory P_FqmflowTRMMM TrmActivityCategory Activity Cat.
SecurityClass P_FqmflowTRMMM SecurityClass Security Class
TrmSecurityAccount P_FqmflowTRMMM TrmSecurityAccount Securities Acct
Portfolio P_FqmflowTRMMM Portfolio Portfolio
HouseBank P_FqmflowTRMMM HouseBank House Bank
HouseBankAccount P_FqmflowTRMMM HouseBankAccount House Bank Account
BankAccountId P_FqmflowTRMMM BankAccountId Technical ID
CompanyCode P_FqmflowTRMMM CompanyCode Receiver Company Code
Customer P_FqmflowTRMMM Customer Sold-to Party
Vendor P_FqmflowTRMMM Vendor Vendor
Partner P_FqmflowTRMMM Partner With Partner
Material P_FqmflowTRMMM Material Vehicle Model
BusinessArea P_FqmflowTRMMM BusinessArea Business Area
ProfitCenter P_FqmflowTRMMM ProfitCenter Profit Center
Project P_FqmflowTRMMM Project WBS Element
CostCenter P_FqmflowTRMMM CostCenter Cost Center
PartnerCompany P_FqmflowTRMMM PartnerCompany Trading Partner
LiquidityItem P_FqmflowTRMMM LiquidityItem Liquidity Item
Segment P_FqmflowTRMMM Segment Segment number
PlanningLevel P_FqmflowTRMMM PlanningLevel Planning Level
PlanningGroup P_FqmflowTRMMM PlanningGroup Planning group
AssignedCompanyCode P_FqmflowTRMMM AssignedCompanyCode Company Code
DocumentReferenceID P_FqmflowTRMMM DocumentReferenceID Reference
Characteristics P_FqmflowTRMMM Characteristics Characteristics
AssignmentReference P_FqmflowTRMMM AssignmentReference Assignment Reference
ReferenceDocument P_FqmflowTRMMM ReferenceDocument Reference Document
FiscalYear P_FqmflowTRMMM FiscalYear G/L Fiscal Year

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_FqmbalanceTRMMM.
-- 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: PFQMBALANCETRMMM

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

Learn More