_AGGREGATEDCASHFLOW
_AGGREGATEDCASHFLOW is an SAP database table in S/4HANA. It contains 92 fields.
Fields (92)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | bal_type | bal_type,Bal_Type_Ext | 1 |
| KEY | bankaccountid | BankAccountInternalID | 1 |
| KEY | BusinessArea | BusinessArea | 1 |
| KEY | cashgroup | SummarizationGroup | 1 |
| KEY | cashgroupterm | SummarizationTerm | 1 |
| KEY | cashplanninggroup | CashPlanningGroup | 1 |
| KEY | certaintylevel | CertaintyLevel | 1 |
| KEY | companycode | CompanyCode | 1 |
| KEY | currency | Currency | 1 |
| KEY | Direction | Direction | 1 |
| KEY | FiDocumentType | FiDocumentType | 1 |
| KEY | glaccount | GLAccount | 1 |
| KEY | housebank | HouseBank | 1 |
| KEY | housebankaccount | HouseBankAccount | 1 |
| KEY | liquidityitem | LiquidityItem | 1 |
| KEY | overdueplanninglevel | OverduePlanningLevel | 1 |
| KEY | paymentmethod | PaymentMethod | 1 |
| KEY | planninglevel | PlanningLevel | 1 |
| KEY | ProfitCenter | ProfitCenter | 1 |
| KEY | Segment | Segment | 1 |
| KEY | TradingPartner | TradingPartner | 1 |
| convert_day1 | Convert_data1 | 1 | |
| convert_day10 | Convert_data10 | 1 | |
| convert_day11 | Convert_data11 | 1 | |
| convert_day12 | Convert_data12 | 1 | |
| convert_day13 | Convert_data13 | 1 | |
| convert_day14 | Convert_data14 | 1 | |
| convert_day15 | Convert_data15 | 1 | |
| convert_day16 | Convert_data16 | 1 | |
| convert_day17 | Convert_data17 | 1 | |
| convert_day18 | Convert_data18 | 1 | |
| convert_day19 | Convert_data19 | 1 | |
| convert_day2 | Convert_data2 | 1 | |
| convert_day20 | Convert_data20 | 1 | |
| convert_day21 | Convert_data21 | 1 | |
| convert_day22 | Convert_data22 | 1 | |
| convert_day23 | Convert_data23 | 1 | |
| convert_day24 | Convert_data24 | 1 | |
| convert_day25 | Convert_data25 | 1 | |
| convert_day26 | Convert_data26 | 1 | |
| convert_day27 | Convert_data27 | 1 | |
| convert_day28 | Convert_data28 | 1 | |
| convert_day29 | Convert_data29 | 1 | |
| convert_day3 | Convert_data3 | 1 | |
| convert_day30 | Convert_data30 | 1 | |
| convert_day31 | Convert_data31 | 1 | |
| convert_day32 | Convert_data32 | 1 | |
| convert_day4 | Convert_data4 | 1 | |
| convert_day5 | Convert_data5 | 1 | |
| convert_day6 | Convert_data6 | 1 | |
| convert_day7 | Convert_data7 | 1 | |
| convert_day8 | Convert_data8 | 1 | |
| convert_day9 | Convert_data9 | 1 | |
| convert_overdue | Convert_overdue | 1 | |
| costcenter | CostCenter | 1 | |
| day1 | data1 | 1 | |
| day10 | data10 | 1 | |
| day11 | data11 | 1 | |
| day12 | data12 | 1 | |
| day13 | data13 | 1 | |
| day14 | data14 | 1 | |
| day15 | data15 | 1 | |
| day16 | data16 | 1 | |
| day17 | data17 | 1 | |
| day18 | data18 | 1 | |
| day19 | data19 | 1 | |
| day2 | data2 | 1 | |
| day20 | data20 | 1 | |
| day21 | data21 | 1 | |
| day22 | data22 | 1 | |
| day23 | data23 | 1 | |
| day24 | data24 | 1 | |
| day25 | data25 | 1 | |
| day26 | data26 | 1 | |
| day27 | data27 | 1 | |
| day28 | data28 | 1 | |
| day29 | data29 | 1 | |
| day3 | data3 | 1 | |
| day30 | data30 | 1 | |
| day31 | data31 | 1 | |
| day32 | data32 | 1 | |
| day4 | data4 | 1 | |
| day5 | data5 | 1 | |
| day6 | data6 | 1 | |
| day7 | data7 | 1 | |
| day8 | data8 | 1 | |
| day9 | data9 | 1 | |
| fund | Fund | 1 | |
| grantid | GrantID | 1 | |
| overdue | overdue | 1 | |
| reconcil_status | reconcil_status | 1 | |
| rel_status | rel_status | 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 _AGGREGATEDCASHFLOW (
BAL_TYPE,
BANKACCOUNTID,
BUSINESSAREA,
CASHGROUP,
CASHGROUPTERM,
CASHPLANNINGGROUP,
CERTAINTYLEVEL,
COMPANYCODE,
CURRENCY,
DIRECTION,
FIDOCUMENTTYPE,
GLACCOUNT,
HOUSEBANK,
HOUSEBANKACCOUNT,
LIQUIDITYITEM,
OVERDUEPLANNINGLEVEL,
PAYMENTMETHOD,
PLANNINGLEVEL,
PROFITCENTER,
SEGMENT,
TRADINGPARTNER,
CONVERT_DAY1,
CONVERT_DAY10,
CONVERT_DAY11,
CONVERT_DAY12,
CONVERT_DAY13,
CONVERT_DAY14,
CONVERT_DAY15,
CONVERT_DAY16,
CONVERT_DAY17,
CONVERT_DAY18,
CONVERT_DAY19,
CONVERT_DAY2,
CONVERT_DAY20,
CONVERT_DAY21,
CONVERT_DAY22,
CONVERT_DAY23,
CONVERT_DAY24,
CONVERT_DAY25,
CONVERT_DAY26,
CONVERT_DAY27,
CONVERT_DAY28,
CONVERT_DAY29,
CONVERT_DAY3,
CONVERT_DAY30,
CONVERT_DAY31,
CONVERT_DAY32,
CONVERT_DAY4,
CONVERT_DAY5,
CONVERT_DAY6,
CONVERT_DAY7,
CONVERT_DAY8,
CONVERT_DAY9,
CONVERT_OVERDUE,
COSTCENTER,
DAY1,
DAY10,
DAY11,
DAY12,
DAY13,
DAY14,
DAY15,
DAY16,
DAY17,
DAY18,
DAY19,
DAY2,
DAY20,
DAY21,
DAY22,
DAY23,
DAY24,
DAY25,
DAY26,
DAY27,
DAY28,
DAY29,
DAY3,
DAY30,
DAY31,
DAY32,
DAY4,
DAY5,
DAY6,
DAY7,
DAY8,
DAY9,
FUND,
GRANTID,
OVERDUE,
RECONCIL_STATUS,
REL_STATUS,
PRIMARY KEY (BAL_TYPE, BANKACCOUNTID, BUSINESSAREA, CASHGROUP, CASHGROUPTERM, CASHPLANNINGGROUP, CERTAINTYLEVEL, COMPANYCODE, CURRENCY, DIRECTION, FIDOCUMENTTYPE, GLACCOUNT, HOUSEBANK, HOUSEBANKACCOUNT, LIQUIDITYITEM, OVERDUEPLANNINGLEVEL, PAYMENTMETHOD, PLANNINGLEVEL, PROFITCENTER, SEGMENT, TRADINGPARTNER)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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