P_FQMFLOWCASH

CDS View
76 Fields 5 CDS Views

P_FQMFLOWCASH is a CDS View in S/4HANA. It contains 76 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
FQM_CMSND_SOURCE view from New CMSND data source from fqm flow
I_CashFlowRecnclnDataBasic view from BASIC Cash Flow With Reconciliation Data
P_CashFlowCombn view from BASIC
P_CashRequestFollowingFlows view from BASIC
P_FqmbalanceCASH view left_outer BASIC

Fields (76)

KeyField CDS FieldsUsed in Views
KEY CashFlow CashFlow,OriginFlowId 3
KEY OriginApplication OriginApplication 3
KEY OriginDocument OriginDocument 3
KEY OriginSystem OriginSystem 3
KEY OriginTransaction OriginTransaction 3
KEY OriginTransQualifier OriginTransQualifier 3
KEY ValidFrom ValidFrom 3
KEY ValidTo ValidTo 3
AccountingDocument AccountingDocument 2
AccountingDocumentItem AccountingDocumentItem 2
AccountingDocumentType AccountingDocumentType 2
Amount AmountInTransactionCurrency 1
AssignedCompanyCode AssignedCompanyCode,SourceCompanyCode 3
AssignmentReference AssignmentReference 1
BankAccountId BankAccountId,BankAccountInternalID 3
BankStatementItem BankStatementItem 2
BankStatementShortKey BankStatementShortKey 2
BaseAmount AmountInCompanyCodeCurrency 1
BaseCurrency BaseCurrency,CompanyCodeCurrency 2
BusinessArea BusinessArea 3
CertaintyLevel CertaintyLevel 3
Characteristics Characteristics 1
cmm_state cmm_state 2
cmm_statistics_indicator cmm_statistics_indicator 2
CompanyCode CompanyCode 3
ContractNumber ContractNumber 2
CostCenter CostCenter 3
CreatedByUser CreatedByUser 3
CreationDateTime CreationDateTime 2
Currency Currency,TransactionCurrency 3
Customer Customer 3
DocumentItemText DocumentItemText 2
DocumentReferenceID DocumentReferenceID 1
fi_due_date fi_due_date 1
FinancialAccountType FinancialAccountType 2
FinancialTransactionType FinancialTransactionType 3
FiscalPeriod FiscalPeriod 2
FiscalYear FiscalYear 3
flow_id flow_id 2
FlowCategory FlowCategory 1
FlowType FlowType 1
Fund Fund 2
GLAccount GLAccount 3
GrantID GrantID 2
HouseBank HouseBank 3
HouseBankAccount HouseBankAccount 3
IsValid IsValid 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 3
LiquidityItem LiquidityItem 3
Material Material 3
OriginApplicationRl OriginApplicationRl 1
OriginDocumentRl OriginDocumentRl 1
OriginFlowIdRl OriginFlowIdRl 1
OriginSystemRl OriginSystemRl 1
OriginTransactionRl OriginTransactionRl 1
OriginTransQualifierRl OriginTransQualifierRl 1
Owner Owner 2
Partner BusinessPartner,Partner 3
PartnerCompany PartnerCompany 3
PaymentMethodCode PaymentMethod,PaymentMethodCode 3
PlanningGroup CashPlanningGroup,PlanningGroup 3
PlanningLevel PlanningLevel 3
Portfolio Portfolio 3
PostingDate PostingDate 2
ProductType ProductType 3
ProfitCenter ProfitCenter 3
Project Project,WBSElementInternalID 3
rel_status rel_status 2
SecurityClass SecurityClass 3
Segment Segment 3
TransactionDate TransactionDate 2
TrmActivityCategory TrmActivityCategory 1
TrmSecurityAccount TrmSecurityAccount 3
ValueDate ValueDate 2
Vendor Vendor 3

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_FQMFLOWCASH (
    CASHFLOW,
    ORIGINAPPLICATION,
    ORIGINDOCUMENT,
    ORIGINSYSTEM,
    ORIGINTRANSACTION,
    ORIGINTRANSQUALIFIER,
    VALIDFROM,
    VALIDTO,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNT,
    ASSIGNEDCOMPANYCODE,
    ASSIGNMENTREFERENCE,
    BANKACCOUNTID,
    BANKSTATEMENTITEM,
    BANKSTATEMENTSHORTKEY,
    BASEAMOUNT,
    BASECURRENCY,
    BUSINESSAREA,
    CERTAINTYLEVEL,
    CHARACTERISTICS,
    CMM_STATE,
    CMM_STATISTICS_INDICATOR,
    COMPANYCODE,
    CONTRACTNUMBER,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATETIME,
    CURRENCY,
    CUSTOMER,
    DOCUMENTITEMTEXT,
    DOCUMENTREFERENCEID,
    FI_DUE_DATE,
    FINANCIALACCOUNTTYPE,
    FINANCIALTRANSACTIONTYPE,
    FISCALPERIOD,
    FISCALYEAR,
    FLOW_ID,
    FLOWCATEGORY,
    FLOWTYPE,
    FUND,
    GLACCOUNT,
    GRANTID,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    ISVALID,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LIQUIDITYITEM,
    MATERIAL,
    ORIGINAPPLICATIONRL,
    ORIGINDOCUMENTRL,
    ORIGINFLOWIDRL,
    ORIGINSYSTEMRL,
    ORIGINTRANSACTIONRL,
    ORIGINTRANSQUALIFIERRL,
    OWNER,
    PARTNER,
    PARTNERCOMPANY,
    PAYMENTMETHODCODE,
    PLANNINGGROUP,
    PLANNINGLEVEL,
    PORTFOLIO,
    POSTINGDATE,
    PRODUCTTYPE,
    PROFITCENTER,
    PROJECT,
    REL_STATUS,
    SECURITYCLASS,
    SEGMENT,
    TRANSACTIONDATE,
    TRMACTIVITYCATEGORY,
    TRMSECURITYACCOUNT,
    VALUEDATE,
    VENDOR,
    PRIMARY KEY (CASHFLOW, ORIGINAPPLICATION, ORIGINDOCUMENT, ORIGINSYSTEM, ORIGINTRANSACTION, ORIGINTRANSQUALIFIER, VALIDFROM, VALIDTO)
);

Learn More