Mohd Shahanshah Ansari

Hello All We are back with an another video on 'Automatic Data Replication Without MDG Layer'. If you're still using T-codes like MM03, LSMW, or mass processing in the MDG system? While these T-codes are optional and typically used only during emergencies, it's crucial to see these changes in the connected systems. In this video we walk you through the step-by-step process of setting up the automatic data replication, necessary configurations to ensure seamless data replication. https://lnkd.in/d6e7dfRS

64

3 Comments

SAP Message Knowledge For Dummies Message no. NR751 For object RF_BELEG, number range interval 70 does not exist FBN1   Diagnosis The database table NRIV has the delivery class 'C', i.e. the SAP default settings are only in client 000.   Procedure Create the missing number range interval in customizing.

5

#Exposing a #CDS #VIEWS as an #ODATA #Service..... Creation of CDS VIEWS and we will use these CDS views in ODATA(UI5 backend). Step -1 By Using one Statement or annotation while creation of CDS Views in ADT Tool... -------> @OData.publish: true. The above statement will create one ODATA service in the name automatically after declaring the above annotation in the CDS VIEW. Step 2.   ->. <CDS VIEW NAME>_CDS - service name At the time Activation of CDS SAP will generate some runtime artifacts which are below are the 4 runtime artifacts and total four classes are generated by SAP Model provider class(super class )and it's extension class( sub class ) and Data provider class( super class )and it's extension class ( sub class ). MPC - Model provider class & it's extension DPC - Data provider class & it's extension STUBS - Nothing but methods SERVICE - SAP provides one service name Every ODATA service contains 5 methods 5 Stubs or Methods..... 1.Get Entity 2.Get Entity Set 3.Create Entity 4.Delete Entity 5.Update Entity Step 3. We need to register the above service ( <CDS VIEW NAME>_CDS) to Gate way client by using below T code . /IWFND/MAINT_SERVICE... Step 4 Last step we need to maintain the ODATA service by using the below T code... /IWFND/GW_CLIENT.... Here One HTTP URL will appear in that our CDS View Service will exist. If everything will execute successfully the the response will appear as Green else Red. The Generated URL will be utilised by Front end UI5 developers and as well as other Front end developers.....URL data contains in the XML view which will utilise many other domain Front end Developers as well.... #SAP #HANA #CDS #VIEWS #ODATA #HIGH #PERFORMANCE.....

1

 SAP Business Technology Platform (BTP) is crucial for applying AI and impacting the business. AI and machine learning capabilities are transforming business by automating routine tasks, which in turn frees up valuable resources for innovation.

4

Exploring the Need for the Initial Modifier in SAP Commerce Ever wondered why the Initial Modifier is so crucial in SAP Commerce? Understanding its role can significantly enhance your data modeling and initialization process in projects. I’ve detailed the concept, its importance, and practical scenarios in my latest blog post. If you’re working with SAP Commerce Cloud, this article might clarify a critical aspect of your setup! 👉 Check it out here: Need of Initial Modifier in SAP Commerce,https://lnkd.in/gZumykiA Let me know your thoughts or experiences with the Initial Modifier in the comments. Let's learn and grow together! #SAPCommerceCloud #Hybris #DataModeling #ECommerce #SAP #B2CAccelerator #ECommerceDevelopment #CustomDevelopment #SAPDevelopers #HybrisDevelopment #ECommerceSolutions #DigitalTransformation #JavaDevelopment #TechBlog #SAPCommerceTips #B2CInnovation #SAPcommercecloudsimplifed #hybris #Innovation #Technology #FutureOfWork

12

🌟 Step-by-Step Guide: System Copy in SAP 🌐 1️⃣ Preparation and Planning - 📅 Schedule downtime and backup. - 📊 Analyze system dependencies. 2️⃣ Export from Source System - 🛠️ Freeze changes and export data. 3️⃣ Import into Target System - 🚀 Install target system and import data. 4️⃣ Post-Copy Activities - 🔄 Adjust configurations and perform checks. 5️⃣ Validation and Testing - ✅ Test performance and functionality. 6️⃣ Documentation and Handover - 📄 Document procedures and train teams. 🤝🏻Follow me for fresh content 🤝🏻 Muthumayandi Yadava #BMY #BMYSAP #SAP_BASIS_Solutions #india #europe #germany #world #usa #southafrica #malaysia #singapore #mexico #egypt #erpgurus #technology #sapimplementation

158

6 Comments

SAP Message Knowledge For Dummies Message no. NR751 For object RF_BELEG, number range interval 70 does not exist FBN1

6

forward message

4

1 Comment

🚀 HANA Performance Troubleshooting: Key Tips for Optimal Performance 🔍 Identify Bottlenecks: - 🔍 Analyze workload using SQL trace - 🕵️ Check expensive statements 📊 Optimise Queries: - 📌 Use proper indexing - ✂️ Avoid unnecessary calculations 🔧 System Configuration: - 💾 Ensure sufficient memory allocation - ⚙️ Optimise CPU usage 🛠️ Regular Maintenance: - 📈 Update statistics regularly - 🩺 Perform regular system health checks 💡 Proactive Monitoring: - 🖥️ Use HANA cockpit for real-time monitoring - 🔔 Set up alerts for critical metrics 📄 Detailed Guide Available! For an in-depth guide on HANA performance troubleshooting. 👉 👇 👈 🔗 Stay tuned for more insights on SAP HANA performance! 💬 Have questions? Share them in the comments below!

58

Understanding the Importance of CDS in SAP CAP ------------------------------------------------------ In the realm of SAP's Cloud Application Programming Model (CAP), Core Data Services (CDS) plays a pivotal role in shaping how applications are modeled, developed, and operated. Let's delve into why CDS is crucial and how it enhances the capabilities of SAP CAP. What is CDS? Core Data Services is a data modeling infrastructure in SAP HANA that provides a powerful and efficient way to define and consume semantically rich data models. It serves as a central mechanism for defining data models that are reusable across different layers of an application stack. Importance in SAP CAP: ------------------------- 1. Unified Data Modeling: CDS offers a unified approach to define and consume data models across SAP applications. In SAP CAP, this means developers can use CDS to define entities, associations, annotations, and other artifacts in a consistent manner. This unified model is essential for maintaining coherence and consistency across different application modules and services. 2. Integration with SAP HANA: SAP HANA, with its in-memory database capabilities, leverages CDS to define data models directly in the database layer. This integration is crucial for optimizing data access and performance, as CDS definitions are translated into native HANA artifacts, such as tables, views, and indexes. 3. Query Capabilities: CDS supports advanced query capabilities, enabling developers to express complex queries using SQL-like syntax directly within their application code. This simplifies data retrieval and manipulation tasks, reducing the effort required to implement and maintain efficient data access logic. 4. Annotations and Metadata:  Annotations in CDS provide a powerful mechanism to enrich data models with additional metadata, such as UI hints, constraints, and semantic information. This metadata is instrumental in enhancing application usability, ensuring data integrity, and guiding the behavior of UI components. 5. Cross-Platform Support: Beyond SAP HANA, CDS is designed to be interoperable with various SAP technologies and non-SAP databases. This cross-platform support makes it easier to build hybrid applications that span multiple environments and integrate seamlessly with existing enterprise landscapes. 6. Development Efficiency: By abstracting complex data modeling tasks into declarative definitions, CDS improves development efficiency. Developers can focus more on application logic and business requirements, relying on CDS to handle the intricacies of data modeling and persistence. New to CDS and want to upgrade, Consider joining my masterclass. https://lnkd.in/g4dUW-Ff

126

10 Comments

💡 𝗧𝘆𝗽𝗲𝘀 𝗼𝗳 𝗦𝗔𝗣 𝗣𝗿𝗼𝗷𝗲𝗰𝘁𝘀 𝗬𝗼𝘂’𝗹𝗹 𝗚𝗲𝘁 𝘁𝗼 𝗪𝗼𝗿𝗸 𝗢𝗻 💡 In the world of SAP, there are different types of projects that consultants get involved in. Lets understand in brief: --------------------------------------- 1️⃣ 𝗜𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻 : This is where it all begins! Imagine you’ve just bought a new house, but it’s empty. You need to set up everything from scratch—furniture, appliances, utilities, etc. In an SAP implementation project, the company starts fresh by setting up SAP to manage its business processes. Everything is designed and configured for the first time. ♨ Example: A manufacturing company decides to implement SAP to handle their entire production process, from raw materials to finished goods to Finance P&L statement , Supply chain to delivery. 2️⃣ 𝗥𝗼𝗹𝗹𝗼𝘂𝘁 You’ve set up your house, now you want to set up another one the same way. In an SAP rollout project, SAP is already implemented in one location, and now the company wants to expand the same setup to other regions or subsidiaries with minor adjustments. ♨ Example: After successfully implementing SAP in its headquarters, the company now rolls it out to its branches in other countries, with a few tweaks for local requirements. 3️⃣ 𝗨𝗽𝗴𝗿𝗮𝗱𝗲 Think of this as renovating your house—upgrading the kitchen, adding new technology, or refreshing the interiors. An SAP upgrade project is about updating the system to the latest version or adding new features to improve functionality and performance. ♨ Example: A company using SAP ECC upgrades to SAP S/4HANA to take advantage of real-time analytics and improved performance. 4️⃣ 𝗦𝘂𝗽𝗽𝗼𝗿𝘁 & 𝗠𝗮𝗶𝗻𝘁𝗲𝗻𝗮𝗻𝗰𝗲 Now that your house is set up, you’ll need ongoing support—fixing any issues, cleaning, and keeping everything running smoothly. In an SAP support & maintenance project, the team ensures that the system runs efficiently, troubleshoots problems, and performs regular upkeep. ♨ Example: A company’s sales team faces a technical issue during a critical time. The SAP support team steps in to fix the issue, while the maintenance team ensures the system stays optimized and up-to-date. ------------------------------------------- 𝗘𝘃𝗲𝗿𝘆 𝘁𝘆𝗽𝗲 𝗼𝗳 𝗽𝗿𝗼𝗷𝗲𝗰𝘁 𝗯𝗿𝗶𝗻𝗴𝘀 𝗶𝘁𝘀 𝗼𝘄𝗻 𝘀𝗲𝘁 𝗼𝗳 𝗰𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲𝘀 𝗮𝗻𝗱 𝗿𝗲𝘄𝗮𝗿𝗱𝘀. 👉 If you’re an SAP consultant, you’ll likely get to experience a mix of these projects over your career. And remember, each project is a stepping stone for your growth! 🚀 #SAPProjects #SAPConsulting #Implementation

125

28 Comments

SAP BW 7.5 to SAP Datasphere: Why It’s Time to Skip SAP BW/4HANA and Embedded Analytics Why Migrate from SAP BW 7.5 to SAP Datasphere? https://lnkd.in/e-PpnBnM #sap #sapdatasphere #migrateSAPBW

62

🚀 Automating QVD Load Logging in Qlik Sense! 🚀 In data projects, tracking QVD load performance and data quality is crucial. I had developed a QVD Log Loader program which was quite useful and it not only loads multiple QVD files from a directory but also logs essential details — making it easier to monitor and optimize QVD loads in Qlik Sense. Here’s what the program tracks: ✅ File Name ✅ Load Date and Time ✅ Row Count ✅ Field Names 🔍 Why This Matters: Whether you’re managing large-scale data pipelines or ensuring data quality, having an automated logging system helps identify potential bottlenecks and improve the efficiency of data loading processes. Here’s the subroutine that powers the logging process: // Define paths SET vQvdDirectory = 'C:\Data\QVDs\'; // Replace with your QVD folder path SET vLogTable = 'QVDLoadLog'; // Name of the log table // Create Log Table if it doesn't exist IF NoOfRows($(vLogTable)) = 0 THEN $(vLogTable): LOAD 'FileName' AS FileName, 'LoadDateTime' AS LoadDateTime, 'RowCount' AS RowCount, 'FieldNames' AS FieldNames AUTOGENERATE 0; ENDIF // Load QVD files and log details FOR EACH File in FileList('$(vQvdDirectory)*.qvd') // Load the QVD data temporarily to capture details TempTable: LOAD * FROM [$(File)] (qvd); // Get metadata LET vFileName = '$(File)'; LET vLoadDateTime = Now(); LET vRowCount = NoOfRows('TempTable'); LET vFieldNames = Concat(FieldName(IterNo() - 1, 'TempTable'), ', '); // Insert log record $(vLogTable): LOAD '$(vFileName)' AS FileName, '$(vLoadDateTime)' AS LoadDateTime, $(vRowCount) AS RowCount, '$(vFieldNames)' AS FieldNames AUTOGENERATE 1; // Drop temporary table to clear memory DROP TABLE TempTable; NEXT // Display the log table LOAD * RESIDENT $(vLogTable); 🛠 How It Works: The script dynamically loops through each QVD, captures metadata, and logs details into a summary table for easy tracking and reporting. Example Log Table Output: FileName LoadDateTime RowCount FieldNames Sales.qvd 2024-11-05 10:00:00 1,500,000 Date, CustomerID, SalesAmount, … This QVD Log Loader program is a great example of how scripting and automation can drive efficiencies in Qlik Sense development. It’s an essential tool for anyone looking to streamline their QVD management process. 💡 Tip: Automating repetitive tasks like this lets you focus more on deriving insights and value from your data rather than handling backend processes. #QlikSense #DataAnalytics #QVDLoader #Automation #DataEngineering #DataQuality #QlikScripting #DataManagement #QlikTips

93

8 Comments

SAP CLOUD FOR DUMMIES Uploading Non-PO Referenced Invoice for Materials Learn how to:   ·       Upload an invoice Uploading Non-PO Referenced Invoice for Materials Businesses receive Invoices from suppliers in different formats like PDF, JPEG, PNG, XML etc. as attachments in mails. These documents then have to be manually created in the SAP S/4HANA cloud system and is a time consuming 

11

1 Comment

To ensure high-quality data governance in SAP without compromising speed, consider these strategies: **Automation:** * **Leverage SAP Tools:** Utilize SAP Data Services, Information Steward, and Master Data Governance (MDG) for automated data profiling, cleansing, and validation. * **Third-Party Integration:** Incorporate third-party tools for advanced data quality capabilities and integration with other systems. * **ETL Automation:** Automate data extraction, transformation, and loading processes to streamline data flows and reduce manual intervention. **Policy and Governance:** * **Clear Data Ownership:** Define clear ownership and responsibilities for data assets to ensure accountability. * **Standardized Data Definitions:** Establish consistent data definitions and classifications across the organization to improve data consistency and understanding. * **Access Controls:** Implement robust access controls to protect sensitive data and prevent unauthorized access. * **Regular Data Audits:** Conduct regular data audits to identify and address data quality issues proactively. **Monitoring and Alerting:** * **Real-time Monitoring:** Implement real-time monitoring of data quality metrics to detect anomalies and potential issues. * **Automated Alerts:** Set up automated alerts to notify relevant stakeholders of critical data quality issues. * **Data Profiling:** Use data profiling techniques to assess data completeness, accuracy, and consistency. **Prioritization and Incremental Improvement:** * **Focus on High-Impact Data:** Prioritize data that has the greatest impact on business decisions and critical processes. * **Incremental Improvements:** Implement data governance measures in stages to minimize disruption and maximize benefits. **Culture and Collaboration:** * **Data Literacy:** Promote data literacy among employees to foster a data-driven culture. * **Cross-Functional Collaboration:** Encourage collaboration between data stewards, business users, and IT teams to ensure alignment and effective data governance. * **Agile Approach:** Adopt agile methodologies to adapt to changing business needs and quickly implement data governance improvements. By combining these strategies, you can establish a robust data governance framework that balances data quality, speed, and agility in your SAP environment.

5

1 Comment

The full form of WRICEFF Please check below SAP CHANNEL https://lnkd.in/dUhgn6EV #sap #sapfico #sapcommunity @Wouter van Heddeghem

13

Hi All, I'm facing an issue while exporting data from SAP HANA tables to Parquet files in Azure Data Factory (ADF) using copy data activity. The pipeline fails with an error related to invalid column names in the Parquet files. The error message indicates that the column names are invalid and cannot contain certain characters such as [,;{}()\n\t=]. Upon investigation, it appears that some column names in the SAP HANA tables contain spaces and special characters, which seem to be causing the issue during the conversion process. I'm looking for guidance on how to handle this issue effectively. Is there a recommended approach or workaround to ensure successful data export from SAP HANA to Parquet files in Azure Data Factory, especially when dealing with column names containing spaces or special characters? Any insights or suggestions would be greatly appreciated. Thank you! ---  Zach Wilson Sagar Prajapati Ramesh Retnasamy Ankur Ranjan Deepak Goyal

31

11 Comments