P_FQMFLOWSCOPE

CDS View
59 Fields 1 CDS Views

Cash Flow with Scope

P_FQMFLOWSCOPE is a CDS View in S/4HANA. Cash Flow with Scope. It contains 59 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CashFlowByScopeForAccounting view from BASIC Cash Flow with Scope

Fields (59)

KeyField CDS FieldsUsed in Views
KEY CashFlow CashFlow 1
KEY flow_id CashFlowID 1
KEY OriginApplication OriginApplication 1
KEY OriginDocument OriginDocument 1
KEY OriginSystem OriginSystem 1
KEY OriginTransaction OriginTransaction 1
KEY OriginTransQualifier OriginTransactionQualifier 1
KEY ValidFrom ValidFrom 1
KEY ValidTo ValidTo 1
AccountingDocument AccountingDocument 1
AccountingDocumentItem AccountingDocumentItem 1
AccountingDocumentType AccountingDocumentType 1
Amount AmountInTransactionCurrency 1
AssignedCompanyCode SourceCompanyCode 1
BankAccountId BankAccountInternalID 1
BankStatementItem BankStatementItem 1
BusinessArea BusinessArea 1
CertaintyLevel CertaintyLevel 1
CompanyCode CompanyCode 1
ContractNumber AssetContract 1
CostCenter CostCenter 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
Currency TransactionCurrency 1
Customer Customer 1
DocumentDate DocumentDate 1
DocumentItemText DocumentItemText 1
fi_due_date NetDueDate 1
FinancialAccountType FinancialAccountType 1
FinancialTransactionType FinancialTransactionType 1
FiscalPeriod PostingFiscalPeriod 1
FiscalYear FiscalYear 1
Fund Fund 1
GLAccount GLAccount 1
GrantID GrantID 1
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
IsValid IsValid 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
LiquidityItem LiquidityItem 1
Material Material 1
Owner CashTransactionOwner 1
Partner BusinessPartner 1
PartnerCompany PartnerCompany 1
PaymentMethodCode PaymentMethod 1
PlanningGroup CashPlanningGroup 1
PlanningLevel PlanningLevel 1
Portfolio Portfolio 1
PostingDate PostingDate 1
ProductType FinancialInstrumentProductType 1
ProfitCenter ProfitCenter 1
rel_status CashReleaseStatus 1
SecurityClass SecurityClass 1
Segment Segment 1
TransactionDate TransactionDate 1
TrmSecurityAccount SecurityAccount 1
ValueDate ValueDate 1
Vendor Supplier 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Cash Flow with Scope
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_FQMFLOWSCOPE (
    CASHFLOW,
    FLOW_ID,
    ORIGINAPPLICATION,
    ORIGINDOCUMENT,
    ORIGINSYSTEM,
    ORIGINTRANSACTION,
    ORIGINTRANSQUALIFIER,
    VALIDFROM,
    VALIDTO,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNT,
    ASSIGNEDCOMPANYCODE,
    BANKACCOUNTID,
    BANKSTATEMENTITEM,
    BUSINESSAREA,
    CERTAINTYLEVEL,
    COMPANYCODE,
    CONTRACTNUMBER,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATETIME,
    CURRENCY,
    CUSTOMER,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FI_DUE_DATE,
    FINANCIALACCOUNTTYPE,
    FINANCIALTRANSACTIONTYPE,
    FISCALPERIOD,
    FISCALYEAR,
    FUND,
    GLACCOUNT,
    GRANTID,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    ISVALID,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LIQUIDITYITEM,
    MATERIAL,
    OWNER,
    PARTNER,
    PARTNERCOMPANY,
    PAYMENTMETHODCODE,
    PLANNINGGROUP,
    PLANNINGLEVEL,
    PORTFOLIO,
    POSTINGDATE,
    PRODUCTTYPE,
    PROFITCENTER,
    REL_STATUS,
    SECURITYCLASS,
    SEGMENT,
    TRANSACTIONDATE,
    TRMSECURITYACCOUNT,
    VALUEDATE,
    VENDOR,
    PRIMARY KEY (CASHFLOW, FLOW_ID, ORIGINAPPLICATION, ORIGINDOCUMENT, ORIGINSYSTEM, ORIGINTRANSACTION, ORIGINTRANSQUALIFIER, VALIDFROM, VALIDTO)
);

Learn More