BW Content and Extractors

Product Cost Forecast and Simulation – how to enhance with tariffs

Summary: This blog describes a concept how to enhance the SAP HANA-optimzed Business Warehouse content Product Cost Forecast and Simulation by tariffs. The concept bases on the detailed product cost information, that the standard data sources can provide. SAP Business Warehouse modeling and business logic are covered in detail to explain the concept. The blog contains the following chapters: Motivation Prerequisites Outline of the Concept Implementation of the Concept   Motivation …

Read More »

How to analyze “Transaction Recorded” in SM58

Dear, Here I would like to share some experience when I analyze such kind of issue: “Very huge records with “Transaction Recorded’ status stucked in SM58 in ERP system.” Please check all the below points. Points#3 and #4 are usually the ones that need more attention. 1 – Review 527481 -> there should be at least as many dialog as non-dialog work processes. Please ensure there are enough dialogs. 2 – Review 74141 -> ensure that your …

Read More »

BI Content Releases in ‘Development and/or Maintenance’.

BI Content 7.57 BI Content 7.57 requires SAP NetWeaver 7.4. Relase Notes and Documentation Installation or Upgrade Note Support Package Note BI Content 7.37 and BI Content 7.47 BI Content 7.37 requires SAP NetWeaver 7.3. BI Content 7.47 requires SAP NetWeaver 7.3 Including Enhancement Package 1. BI Content 7.47 requires SAP NetWeaver 7.4. Relase Notes and Documentation Installation or Upgrade Note Support Package Note BI Content 7.07 (maintenance only) requires …

Read More »

Application Developed Business Content and Extractors

Overview BI Content is a preconfigured set of consistent metadata in SAP BW that represents the entire process flow from extraction of data originating in SAP systems, to data warehousing, to reporting. Providing complete solutions for business information needs, BI Content enables fast and cost-effective implementation of SAP BW. Follow this space to get latest news on BI Content features, releases, and support packages. Key Topics New SAP HANA-optimized Business …

Read More »

SAP BW 0CLM_INVOICE DataSource for Collections – Implementation Lessons Learned

A client I worked with recently chose to implement Collections while still on Netweaver 7.0 SP4 (SAP_APPL 7.0 SP04) in the ECC system. Instead of implementing the required service packs, the client chose to try to implement by SAP Note and Correction Instructions. Lessons Learned: Service Pack Upgrades are always easier than SAP Notes and Correction Instructions. (I knew this before, but now it’s tattooed on my forehead!) Starting in …

Read More »

Generic Delta – How to extract CRM Order User Status Changes

CRM Order Status often gets changed in various stages such as Approved, Completed, and Rejected etc.      Analytics Report is required to track all the change history for the various above user statuses in a CRM Order Header: Who approved it  or rejected it or completed it When it got approved or rejected or completed. CRM Tables: CRMD _ORDERADM_H: Header Table for all CRM Transactions. CRM_JCDS: Change History for System/User Statuses. …

Read More »

BW: Infopackage Request is showing no. of fetched records but is in Yellow State for too long

This is a very common error which can drive you nuts. Symptoms: You have executed the infopackage and it is showing number of records transferred. Now this number is not increasing but request is in still yellow state. Actions: 1- Check ST22 in BW system. 2- Please check If there is any recent “CX_SY_OPEN_SQL_DB”  dump having short text “SQL error in the database when accessing a table”. 3- Select “Information …

Read More »

SAP BW Reporting For Credit Limit and Credit Exposure.

In SAP R3/ECC, Credit Limit is stored as part of credit limit master data table KNKK and Credit Exposure is getting populated in different tables using Function Module. This document illustrates, How to fetch the data for Credit Limit and Credit Exposure for a particular customer for its respective credit control area.   What is Customer Credit Limit? A credit limit defines the maximum amount of credit that you are willing …

Read More »

SAP BW COPA Extraction in detail, Delta Mechanisms and few challenges faced during Implementation

Applies to: SAP NetWeaver Business Warehouse (formerly BI) – SAP BW 3.5 & 7.x. Versions. Summary: The article articulates the step by step procedure for the generation of the COPA DataSource at the ECC R/3 back-end level along with Delta mechanisms and talk about the few challenges faced while extracting the data during implementation. Table of Contents: 1. Introduction 2. Following is the Scenarios with explanation:      a. Generating the …

Read More »

Comparison between 0FI_AR/AP_4 and 0FI_AR/AP_30 DataSources

Comparison between 0FI_AR/AP_4 and 0FI_AR/AP_30 Datasources Background/Scope of Document Demonstrating the Delta functionality and differences between 0FI_AR/AP_4 and 0FI_AR/AP_30 Datasources. We came across a scenario, where we were using the ECC DS 0FI_AR_30 at the back-end level for BODS development Project. However, after performing the initial load in BODS, we are not able to fetch the Delta records/data from the DataSource. About the DataSources The DataSources FI_AR_4 and FI_AR_30 extracts …

Read More »

Do you want to Get SAP Courses?

Get SAP Courses and Training, Videos, Other Useful Resources
Join Now
Written by SAP Expert TEAM.
close-link
New Registration