ACDOCA

Std model

cash flow

loads of schedules - does it make sense to add a planning model for data capture? eg goodwill breakdown

I dont think it does the YTD model anymore

They run quarterly. projecting the 3rd Q forwards to predict the end picture

View does not implement the logic for extension ledgers (just basis ledgers)

Includes Balances Brought Forward (000)

1TL_S4HR_I_GLAccountLineItemRawData

Retain all 402 fields even though SAP Business Content has 60 fields less. As the BCT is based on SAP 2023, I assume that these are new fields

Source Ledger = 0L, CO, LG, LT, TX (will always be specified)

Fiscal Year = I guess can be specified

1TL_S4HR_I_OperationalAcctgDocItem

Adds flag for cleared, based on date

2TL_HARM_I_GLAccountLineItemRawData

Persist after union for performance

remove additional amount/quantity fields

Perform any calculations likes tonnes conversion and potentially conversion to budget group currency

Set as Delta Capture

Requires delete and recreate and you lose all the conversions

Changing name to replicate the corresponding CDS in S/4

Dates: cast to DATE

Could I combine with the next level?

Would love to add XREF from BSEG

I_LedgerSourceLedger joined to I_LedgerCompanyCodeCrcyRoles to provide all the ledgers available to a company code

This has the effect of exploding the rows to ensure that all ledgers are created for every source ledger

Calculations: derive when statistical assignments for WBS, Sales Doc, Order, Cost Centre

pic shows as relational, sap is fact

2TL_HARM_I_OperationalAcctgDocItem

Persist after union for performance  

2VR_HARM_I_OperationalAcctgDocItem

Adds flag for cleared, based on date

Remove redundant measures

Join ActPlan N:N SemTagGLAccount (filter for validity dates and excld FunctArea)

Can we reduce initial projection?

Need to add headcount somewhere, maybe here?

Create parameters for FinStatemtVersion and Category

Reduce dimensions (need to align to our needs)

Add associations

see BCT help doc

join on Leading Ledger

This model provides monthly balances from GLAccountLineItemLeadingLedger.  Convert SQL to graphical?

Every month includes all postings belonging to this month and all postings from the past, and aggregates the data as cumulative balances

Therefore, it excludes all postings with Fiscal Period ‘000’, which can be viewed as balance carry-forward items, which otherwise would lead to double counted values.

This model provides monthly balances from GLAccountLineItemLeadingLedger. Convert SQL to graphical

The semantic tags based on functional areas are not considered in this model. Every month includes all postings belonging to this month and all postings from the past, and aggregates the data as cumulative balances

Therefore, it excludes all postings with Fiscal Period ‘000’, which can be viewed as balance carry-forward items, which otherwise would lead to double counted values.

This model provides monthly balances from GLAccountLineItemLeadingLedger. Convert SQL to graphical

The semantic tag assignments only consider G/L Accounts. Each month shows the changes or postings that occurred in this month.

The values of the Financial Data Model Configuration (SAP_FI_IL_FinancialDataModelConfiguration) table are not fixed and can be changed by the user. If you define a G/L Account Hierarchy before joining with G/L Account with Semantic Tag (IL), you restrict the data from Journal Entry item Operational View to a single G/L Account Hierarchy by default. This is a requirement for Net Working Capital Time Series Consumption (SAP_FI_RL_NetWorkingCapitalTimeSeries). 

Combines data from “Journal Entry Balance Time Series”, “Journal Entry Balance Semantic Tag Time Series” and “Journal Entry Semantic Tag Time Series”.

Some semantic tag KPIs must include data from the past months, whereas others need to consider only the movements of the relevant months.

Every branch introduces a calculated field UnionBranch which is included in some KPIs to check which type of data should be considered. 

• ‘BALANCE’ selects data from Journal Entry Balance Time Series,
• 'SEMTAGBAL' from Journal Entry Balance Semantic Tag Time Series and
• 'SEMTAG' from Journal Entry Semantic Tag Time Series.

This model provides monthly balances based on journal entry line items in leading ledger joint with operational accounting document items (sourced from I_OperationalAcctgDocItem) to get details whether these items are sales-related or not (IsSalesRelated indicator). Journal Entry Operational View Time Series focuses only on normal documents (AccountingDocumentCategory = ‘’) and journal entries related to a customer (FinancialAccountType = ‘D’= or supplier (FinancialAccountType = ‘K’).

ACDOCA (GLAccountLineItemLeadingLedger) + BSEG (OperationalAcctgDocItem)

This will add the 3 XREF fields

4MA_R2RGLR_SemanticTags

ProfitLossSemanticTagKPIs

Currency handling: select single based on role

Quantity Conversion: 

Measures: 19 restricted by Semantic tags and simple calculations

Variables: FinStatemtVersion, Category, Date

Provides a balance and movements for the entire TB (not sure why called inventory) - includes semantic tags

Dimensions: a limited set - will have to review if adequate

Currency handling: select single based on role

Quantity Conversion: 

Measures: 19 restricted by Semantic tags and simple calculations

Variables: FinStatemtVersion, Category, Date

This model is the data source of the overview page of the Working Capital Dashboard. It combines data from different areas such as Cash, Accounts Receivables, Accounts Payables, and Inventory. “Net Working Capital Balance Time Series Union” (SAP_FI_HL_NetWorkingCapitalBalanceTimeSeriesUnion) combines these areas and defines the first KPIs as a basis for the KPIs defined in “Net Working Capital Time Series Consumption” (SAP_FI_RL_NetWorkingCapitalTimeSeries).

The Net Working Capital Balance Time Series dataflow (SAP_FI_DF_NetworkingCapitalBalance) retrieves the data from “Net Working Capital Balance Time Series Union” and aggregates an interim result that is stored in the Net Working Capital Balance Time Series table. When you combine data from multiple areas, this may result in complex KPIs on top and may lead to serious performance issues, as live data from the inbound layer is processed to calculate the KPIs. To prevent this, an interim result is stored and updated hourly via the Net Working Capital Persist Task Chain task chain (SAP_FI_TC_NetWorkingCapitalPersist).

“Net Working Capital Rolling Time Series” (SAP_FI_HL_NwcRolling12MonTimeSeries) takes the interim result and creates an additional accumulated sum of rolling 12-month period. Dataflow “Net Working Capital Rolling Time Series” (SAP_FI_DF_NetWorkingCapitalRolling) aggregates this rolling 12-month period data to an interim result and stores its result in “Net Working Capital Balance Time Series Table”. The goal is to be able to calculate moving averages for specific KPI’s available in the Overview-Page and analytical Model “Net Working Capital Time Series Consumption”.

This analytical model is the data source for the Open Payables/Receivables charts on the Accounts Payables/Receivables pages of the Working Capital Dashboard. It provides overdue payables/receivables, future payables/receivables, and total payables/receivables in the point of Key Date. This analytical model distinguishes open items to overdue and future items by the comparison of posting date and net due date of open invoice items.

AP/AR Line-Item Base View (SAP_FI_HL_APARLineItemBase) returns cleared vendor and customer items from "SAP_FI_HL_JournalEntryItemOperationalView" that are sales-related, for example, invoice and credit memo, and excludes the statistical items and items from recurring documents. It will only return those items that are posted in the leading ledger, which is controlled by an inner join to "SAP_FI_Ledger". This model includes those items that have been posted counting from the value of the input parameter “Key Date” (P_KEYDATE) and still not cleared at the point of Key Date.

AP/AR Open Item with Reference Join (SAP_FI_HL_APAROpenItemWRJ) selects open items with an invoice reference from the AP/AR Line Item Base View (SAP_FI_HL_APARLineItemBase). When calculating arrears days for partial payment cases for base invoice items, the net due date of the reference item would be used instead of the net due date of the base item.

AP/AR Open Item no Reference Join (SAP_FI_HL_APAROpenItemNORJ) selects open items with no invoice reference from the AP/AR Line Item Base View (SAP_FI_HL_APARLineItemBase). In this case, the net due date of the base item is retrieved for further calculation.

AP/AR Line Item Union View (SAP_FI_HL_APARLineItemUnion) links AP/AR Open Item with the Reference Join (SAP_FI_HL_APAROpenItemWRJ) view and the AP/AR Open Item no Reference Join (SAP_FI_HL_APAROpenItemNORJ) view, which retrieves dimensions and amounts fields for both direct payment and partial payment cases of open items for further calculation.

AP/AR Open Item (SAP_FI_HL_APAROpenItem) is based on the AP/AR Line Item Union View (SAP_FI_HL_APARLineItemUnion), which calculates the days between the key date and net due date of open items and expose the minus as “NetDueArrearsDays”. As this view is used both for AP and AR page, the “ItemCategory” field is added according to “FinancialAccountType” to distinguish AP and AR items for the Working Capital Dashboard.

This analytical model is the data source for the Days Sales Outstanding (DSO) charts on the Accounts Receivable page of the Working Capital Dashboard. It provides per calendar month the measures DSO, Best Possible DSO and the DSO 12 months before. Days Sales Outstanding (DSO) is to measure the time elapsed between the completion of a sale and the collection of the revenue, that is, the time taken to process accounts receivable items. This analytical model calculates DSO according to the direct calculation method. The direct calculation method is based on original documents. The period of time between posting an invoice (posting date) and receiving the payment for the invoice (clearing date) is calculated for the relevant document line item to provide accurate results.

This analytical model is the data source for the DPO charts in the Accounts Payable page of the Working Capital Dashboard. This model provides measures DPO and corresponding DPO 12 months before according to the direct calculation method. Direct Days Payables Outstanding (DPO) is calculated based on the period of time between posting an invoice (posting date) and actual paying for the invoice (clearing date) along with the invoice amount.

sourced fromtable fqm_flow which i assume we dont use (FinServices)  

Consumption View for Forecast Cash Balance & Flow

This model is the data source for the discount charts on the Accounts Payable page of the Working Capital Dashboard. This model provides measures realized discount, lost discount, discounted spend, and discount realization rate, which is calculated based on the discount-related fields on invoice line items along with the invoice amount.

This model is the data source of On-time Payment Rate on the top-right corner of the Account Payable page of the Working Capital Dashboard. This model provides measures on-time payment rate from year to Key Date and its comparison rate of the whole last calendar year based on the date comparison between actual paying for the invoice (clearing date) and proposed payment date for the invoice (net due date) along with the invoice number count.

On Time Payment Rate Base (SAP_FI_HL_OnTimePaymentRateBase) returns cleared vendor items from SAP_FI_HL_JournalEntryItemOperationalView, which are sales-related, for example, and exclude the statistical items and items from recurring documents. It will only return those items that are posted in the leading ledger, which is controlled via an inner join to SAP_FI_Ledger. This model includes those items that have been cleared in the last 24 months counting from the value of the input parameter “Key Date” (P_KEYDATE). The view counts the number of invoice line items as InvoiceNumber and marks the invoice items by the date comparison of ClearingDate and NetDueDate. Invoice items whose ClearingDate before NetDueDate would be counted as OntimeInvoiceNumber while for items whose ClearingDate after NetDueDate would be counted as OverDueInvoiceNumber.

can i do the same for other areas besides WCap above?

Amount In Global Currency * -1

Calculated

Inverted amount when Semantic Tag = 'AMORINASST'

Restricted

Inverted amount when Semantic Tag = 'RECO_COS'

Restricted

Inverted amount when Semantic Tag = 'DPRTASSET'

Restricted

Inverted amount when Semantic Tag = 'GROSS_REV'

Restricted

Inverted amount when Semantic Tag = 'INCOMETAX'

Restricted

Inverted amount when Semantic Tag = 'PL_RESULT'

Restricted

Inverted amount when Semantic Tag = 'RECO_REV'

Restricted

Amount in Global Currency when Semantic Tag = 'EMPLEXP'

Restricted

Inverted amount when Semantic Tag = 'OPEREXP'

Restricted

Inverted amount when Semantic Tag = 'RECO_REV'

Restricted

Recognized Revenue + COGS

Calculated

(Gross Profit / Recognized Revenue) * 100

Calculated

COGS + Operating Expense

Calculated

Recognized Revenue + Total Operating Expense

Calculated

Amount in Currency Role Currency (AmountInCurrencyRoleCurrency)

Source measure for every measure described here. This measure distinguishes between Amount in Global Currency and Amount in Company Code Currency.

Capital Employed (CapitalEmployed)

TotalAssets-CurrentLiabilities

Cash Asset Ratio (CashAssetRatio)

Liquidity/CurrentLiabilities based on semantic tag 'CSH_CSHEQV' and 'CURLIABEQU'.

Cash Asset Ratio Last (CashAssetRatioLast)

CashAssetRatio with exception aggregation LAST

Cost Of Sales (CostOfSalesAmount)

Shows SemanticTag = 'RECO_COS' assigned movements within a month. UnionBranch = ‘SEMTAG’.

Current Liabilities – LAST (CurrentLiabilities)

Displays SemanticTag = 'CURLIABEQU' assigned balances cumulated on month level with exception aggregation LAST. UnionBranch = ‘SEMTAGBAL’.

EBIT (EBIT)

NetIncomeAmount-(IncomeTax+Interest)

Income Tax (IncomeTax)

Displays SemanticTag = 'INCOMETAX' assigned movements within a month. UnionBranch = ‘SEMTAG’.

Interest (Interest)

Displays SemanticTag = 'INTEREST' assigned movements within a month. UnionBranch = ‘SEMTAG’.

Liquidity – LAST (Liquidity)

Displays SemanticTag = 'CSH_CSHEQV' assigned balances cumulated on month level with exception aggregation LAST. UnionBranch = ‘SEMTAGBAL’.

Marketable Securities – LAST (MarketableSecuritiesAmount)

Displays SemanticTag = 'MARK_SEC' assigned balances cumulated on month level with exception aggregation LAST. UnionBranch = ‘SEMTAGBAL’.

Net Income (NetIncomeAmount)

Displays SemanticTag = 'PL_RESULT' assigned movements within a month. UnionBranch = ‘SEMTAG’.

Number Of Days In Month (NumberOfDaysInMonth)

Displays the number of days of every month based on Time Series Date that provides the end date of a month.

Numbers Of Days In Month Max (NumbersOfDaysInMonthMax)

MAximum Number of Days In Month to provide the number of days of the selected time range.

Quick Ratio (QuickRatio)

TotalLiquidityLast/CurrentLiabilities

ROCE (ROCE)

Refers to a financial ratio that assesses the profitability and capital efficiency of a company by dividing EBIT by Capital Employed. Capital Employed = Total Assets - Current Liabilities, which are based on Semantic Tag 'ASSET' and 'CURLIABEQU'.

Formula: EBIT/CapitalEmployed

ROCE Last (ROCELast)

LAST of ROCE

Total Assets – LAST (TotalAssets)

Shows SemanticTag = 'ASSET' assigned balances cumulated on a monthly basis with exception aggregation LAST. UnionBranch = ‘SEMTAGBAL’.

Total Inventory (TotalInventory)

Displays data assigned with TransactionTypeDetermination = 'BSX' cumulated on a monthly basis. UnionBranch = ‘BALANCE’.

Total Inventory Average (TotalInventoryAverage)

Average of Total Inventory based on Time Series Date that provides the end date of a month.

Total Liquidity (TotalLiquidity)

Displays your Total Liquidity based on 'Cash and Cash Equivalence' (Semantic Tag 'CSH_CSHEQV'), 'Marketable Securities' (Semantic Tag 'MARK_SEC'), and 'Accounts Receivables'. Accounts Receivables includes all open invoices up to the current month (Financial Account Type = 'D' and isOpen = 'X').

Formula: SemanticTag = 'CSH_CSHEQV' or ( SemanticTag = 'ACCREC2') or SemanticTag = 'MARK_SEC'.

Total Liquidity Last (TotalLiquidityLast)

Displays Total Liquidity balances cumulated on a monthly basis with exception aggregation LAST.

Transaction Amount

Company Amount

Group Amount

Quantity