P_FQMFLOWCASHPOS

CDS View
55 Fields 2 CDS Views

One Exposure Flows ( CASH )

P_FQMFLOWCASHPOS is a CDS View in S/4HANA. One Exposure Flows ( CASH ). It contains 55 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FQM_CMSND_SOURCE_POS view from New CMSND data source from fqm flow CP
I_CashPositionFlow view from BASIC Cash Position Flow

Fields (55)

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
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
Currency TransactionCurrency 1
Customer Customer 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
LastChangedByUser LastChangedByUser 1
LiquidityItem LiquidityItem 1
Material Material 1
MemoRecordExpirationDateTime MemoRecordExpirationDateTime 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
TreasuryActivityCategory TreasuryActivityCategory 1
TrmSecurityAccount SecurityAccount 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.

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

Learn More