Skip to main content

S4HANA SD : How to identify incomplete Data in the Customer Master ( Business Partner)


Business Requirement: -

When we have Auto Sales Order Creation enabled in S4HANA through RPA ( Robotic Process Automation), Sales orders will get created through RPA Mechanism. 

In this scenario, we get a file with Customer and Products which will be fetched by RPA programs to Create sales orders.  As system is processing data automatically, there could be chance that few of the master Data of Customer is not complete which can forbid creation of Sales order.

To Ensure all the data is complete, we need to check the file of Customer with Incompleteness Data transaction

We know in S4HANA,  we are not manually creating  Customers, instead it is automatically created through Business Partner.

So, at first we need to identify the Customer Numbers for Respective Business Partners though CVI Link Tables

Tables to check:

Assume a BP is Created with 1118, we need to find Corresponding customer for it. So

Call Table BUT000 and find Partner GUI ID




With this GUI ID, go to Table  "CVI_CUST_LINK"

in this way, we ca identify the customers for all BPs.

once the customer is identified,  our Task is to  find missing Data ( incomplete data for customers)

Call Transaction #  OV50

In this Screen we have  option to find Missing Data from FI or SD perspective.

After Key -in the customers,  execute to identify the missing data



This shows  that the customers are not Created in FI, which means they were not extended to FLCU00 ( BP Role)


Similarly, identify the missing Data for Sales specific



This way you can identify the missing Data for a given list of customers

Good Luck


Comments

Popular posts from this blog

SAP PM/CS / EAM : Refurbishment Process

Refurbishment A refurbishment order is a standard Maintenance Order type. In customizing for order, we first create an order type ( such as PM04) In the configuration we have to create a new order type in OIOA and activate this for Refurbishment process. Process flow: Business process steps 1. Damaged equipment/ spares if can be repaired will be done by the PM order of type PM04 2. Equipment/Spares needs repairing should have the item code if it is serialized item then with the serial number. 3. Item should have the valuation type for repair category too. 4. Create PR through refurbishment order for repair of the item with split valuation type of repair. Proper G/L codes and order for the repair indent should be provided in the indent 5. After approval of the requisition, the requisition and item should be send to the stores/Purchase section for further actions. 6. Stock will get updated after MIGO of the item 7. The activity type cost ...

S4HANA-Project Systems Operative Indicators in WBS- CJ20N

  Use and Purpose of Operative Indicators in WBS elements When a customer Requests for ATO or ETO process where we create a Project with Integration between SD and PS ( project systems) As a First step we create a Project in CJ20N and under the Project we will Create Multiple WBS elements which has to be set for Operative Indicators This article deals with Operative Indicators in WBS elements. WE Use Operative Indicators to define characteristics of WBS and to specify which tasks WBS can perform during Execution In General, we have three Operative Indicators such as 1. Planning Indicator 2. Account Assignment Indicator 3. Billing Indicator Planning Element: WBS Elements will be set for planning Element,if we we want a plan cost to be enabled For Example, While Creating a Project- Manufacturing an Equipment. We will Create different WBS elements for each Level such as Design, Procurement of components, Production, Assembly and Installation. During Each state some cost is incurred an...

SAP SD - Advance Return Management for customer Returns

In all Sales Business Cycles, Returns from customers are Normal, Returns can be expected when 1.  Customers expected Quality is  not met by the  product delivered 2. Some times Customers Orders more products than it is required 3.  DOA or Miss shipments ( wrong Products delivered). In above all cases, Customers will return the material,  and these returns can be handeleted by ADVANCE RETURNS MANAGEMENT ADVANCE RETURN ORDER :                            Advance Return Order is the document  which initiates the Customer Returns                         It Controls , how a return should happen and its Results We have to enter   RETURN  REASON :  Reason for Customer Reason MATERIAL RECEIVED :  Identifies that the Physical material in the warehouse and initiates immediate delivery ...