P_CASHFLOWCOMBN
P_CASHFLOWCOMBN is a CDS View in S/4HANA. It contains 60 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CashFlow | view | from | BASIC | Cash Flow |
| I_CashFlowItemExtendBasic | view | from | BASIC | Cash Flow Item Basic |
| I_CashRecnclnCashFlowBasic | view | from | BASIC | Cash Reconciliation Cash Flow |
Fields (60)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CashFlow | CashFlow | 1 |
| KEY | flow_id | CashFlowID | 2 |
| KEY | OriginApplication | OriginApplication | 2 |
| KEY | OriginDocument | OriginDocument | 2 |
| KEY | OriginSystem | OriginSystem | 1 |
| KEY | OriginTransaction | OriginTransaction | 1 |
| KEY | OriginTransQualifier | OriginTransactionQualifier | 1 |
| KEY | ValidFrom | ValidFrom | 1 |
| AccountingDocument | AccountingDocument | 2 | |
| AccountingDocumentItem | AccountingDocumentItem | 1 | |
| AccountingDocumentType | AccountingDocumentType | 1 | |
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | 1 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 2 | |
| BankAccountInternalID | BankAccountInternalID | 2 | |
| BankStatementItem | BankStatementItem | 2 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessPartner | BusinessPartner | 1 | |
| CashPlanningGroup | CashPlanningGroup | 1 | |
| CertaintyLevel | CertaintyLevel | 2 | |
| cmm_state | MemoRecordStatus | 1 | |
| cmm_statistics_indicator | MemoRecordStatisticItem | 1 | |
| CompanyCode | CompanyCode | 2 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 1 | |
| ContractNumber | AssetContract | 1 | |
| CostCenter | CostCenter | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| Customer | Customer | 1 | |
| DocumentItemText | DocumentItemText | 2 | |
| ExpirationDate | ExpirationDate | 2 | |
| 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 | 2 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| LiquidityItem | LiquidityItem | 2 | |
| Material | Material | 1 | |
| Owner | CashTransactionOwner | 1 | |
| PartnerCompany | PartnerCompany | 1 | |
| PaymentMethod | PaymentMethod | 1 | |
| PlanningLevel | PlanningLevel | 2 | |
| Portfolio | Portfolio | 1 | |
| PostingDate | PostingDate | 1 | |
| ProductType | FinancialInstrumentProductType | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| rel_status | CashReleaseStatus | 2 | |
| SecurityClass | SecurityClass | 1 | |
| Segment | Segment | 1 | |
| SourceCompanyCode | SourceCompanyCode | 1 | |
| TransactionCurrency | TransactionCurrency | 2 | |
| TransactionDate | TransactionDate | 2 | |
| 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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CASHFLOWCOMBN (
CASHFLOW,
FLOW_ID,
ORIGINAPPLICATION,
ORIGINDOCUMENT,
ORIGINSYSTEM,
ORIGINTRANSACTION,
ORIGINTRANSQUALIFIER,
VALIDFROM,
ACCOUNTINGDOCUMENT,
ACCOUNTINGDOCUMENTITEM,
ACCOUNTINGDOCUMENTTYPE,
AMOUNTINCOMPANYCODECURRENCY,
AMOUNTINTRANSACTIONCURRENCY,
BANKACCOUNTINTERNALID,
BANKSTATEMENTITEM,
BUSINESSAREA,
BUSINESSPARTNER,
CASHPLANNINGGROUP,
CERTAINTYLEVEL,
CMM_STATE,
CMM_STATISTICS_INDICATOR,
COMPANYCODE,
COMPANYCODECURRENCY,
CONTRACTNUMBER,
COSTCENTER,
CREATEDBYUSER,
CUSTOMER,
DOCUMENTITEMTEXT,
EXPIRATIONDATE,
FI_DUE_DATE,
FINANCIALACCOUNTTYPE,
FINANCIALTRANSACTIONTYPE,
FISCALPERIOD,
FISCALYEAR,
FUND,
GLACCOUNT,
GRANTID,
HOUSEBANK,
HOUSEBANKACCOUNT,
ISVALID,
LASTCHANGEDBYUSER,
LIQUIDITYITEM,
MATERIAL,
OWNER,
PARTNERCOMPANY,
PAYMENTMETHOD,
PLANNINGLEVEL,
PORTFOLIO,
POSTINGDATE,
PRODUCTTYPE,
PROFITCENTER,
REL_STATUS,
SECURITYCLASS,
SEGMENT,
SOURCECOMPANYCODE,
TRANSACTIONCURRENCY,
TRANSACTIONDATE,
TRMSECURITYACCOUNT,
VALUEDATE,
VENDOR,
PRIMARY KEY (CASHFLOW, FLOW_ID, ORIGINAPPLICATION, ORIGINDOCUMENT, ORIGINSYSTEM, ORIGINTRANSACTION, ORIGINTRANSQUALIFIER, VALIDFROM)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA