Data quality check in customer tables for MDG Customer reporting purpose
The document is about a report for displaying the corresponding customer details using a simple ABAP program with ALV display, using input file that have BP numbers.
It consist of multiple select conditions that will fetch and display the BP number, GUID, Customer number, address details of customer , company code details of the customer, and sales area data. Also a check box is available if the program need to select the customer credit details as well. The program is executed in live system for data quality check and to identify the missing mandatory fields in ERP tables.
Steps are given below
- Prepare the input file with BP numbers in a notepad
2. The program is using GUI_Upload for fetching data from input file and the file is to be placed in local system
3. It will collect corresponding business partner GUID from BUT000
4. Using the busness partner GUID it will fetch the corresponding customer from CVI_CUST_LINK
5. Using customer number get the details from KNA1, KNB1 and KNVV for customer general, company code and sales area details
6. The reports selects those fields which are mandatory for my system and this needs to be modified according to the mandatory/ custom fields in system
7. If the check box is checked for customer credit then it will fetch the fields from KNKK table as well
8. After giving input and execute, an ALV display is available with BP number, GUID, customer number, customer company code , and sales area details and customer credit details
Hi Nivedita,
thank you for posting this tool.
Still you need to be aware that your report does not handle the actual field property customizing of SAP ECC at all. SAP ECC allows defining mandatory field according to the actual data that is just being entered.
As example, a company code 0001 might have fields A, B and C as mandatory ones, whereas company code 0002 requires X, Y, and Z. This is only one of many option that exist for defining mandatory fields.
Keep this in mind when using the report. It might not determine everything missing completely.
Best regards
Michael
Hello Michael,
Thanks very much for your input and I will keep that in mind.
For the scenario you mentioned, we were sorting in excel file only and making the report separate for each company code or account group. For example if we have to find if the sales district is missing, which is mandatory for only one sales organization, this is done using excel. This report is not sufficient to handle such scenarios.