_AGGREGATEDCASHFLOW

_AGGREGATEDCASHFLOW is an SAP database table in S/4HANA. It contains 92 fields.

Fields (92)

KeyField CDS FieldsUsed 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)
);