SQL Section with SAP B1 and SAP S/4HANA

My Knowledge of SQLServer | SAPHANA databases with SAP B1 | SAP S/4HANA

I have been working with SAP B1 for more then 3 years and SAP S/4HANA for almost 1 year. This SQL queries has been written and successfully executed. I'm pleased to share it and would be even happier if someone gains some ideas from seeing this. 🤜

SAP B1

Queries

• FormatSearch
• Approval
• Notification (trigger)
• OtherQuery

Reports & Crystal Reports

• Reports
• Forms
• Crystal Reports

SAP S4/HANA

I have attempted to utilize the standard table. however, Something hard to searching and use it.

DIM

• Calendar
• GLAccountMaster
• CustomerMaster
• ProductMaster
• Plant
• StorageLocation
• Machine
• CostElement
• CostCenter

FACT

• Ratio
• ProductWeight
• Actual&Plan