SAP HANA

Orders, credit and ledger questions, answered straight from SAP HANA.

Try Dot with SAP HANARead the docs

Dot writes HANA SQL against the tables you choose.

Threadanalytics

Sarah Chen9:41 AM

@Dot Which customers are over their credit limit and still have open orders?

1 reply

DotAPP9:42 AM

9 steps · 51s · Access Online

Six customers, €2.1M over their limits. Two have orders due to ship this week.

Sources: SAP HANA’s KNKK and VBAK.

Here is the data.

CustomerOver limitOpen orders
Bergmann AG€640K3
Lindqvist AB€410K5
Ortega SA€380K2

Threadanalytics

Ryan Ortiz9:41 AM

@Dot List our open sales orders over €50K that are past their requested delivery date.

1 reply

DotAPP9:42 AM

8 steps · 42s · Access Online

Nine orders worth €1.3M. The oldest is 18 days late.

Sources: SAP HANA’s VBAK and VBEP.

Here is the data.

OrderValueLate by
4500183€212K18 days
4500219€164K11 days
4500231€98K6 days

Threadanalytics

Priya Shah9:41 AM

@Dot Which of our cost centers posted the most manual journal entries last quarter?

1 reply

DotAPP9:42 AM

10 steps · 58s · Access Online

Facilities posted 1,240, triple any other cost center. Most came in the quarter’s last week.

Source: SAP HANA’s ACDOCA.

Chart

Connect SAP HANA

  • Dedicated user and read-only role
  • Works with SAP HANA Cloud
  • Two Dot IPs to allowlist

More in Databases & spreadsheets

Connect your data.

Start for Free