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 ...

SAP SD/CS/PS /PM : System status and User Status a differentiation

In SAP, Master Data and Transaction data is controlled by system status.  But there are certain limitation where system status cannot be used, In such instances a User status can be used. We will see how a system status and User status functions in a particular transaction. Let's understand what is "SYSTEM STATUS" and  "USER STATUS" from system perspective. SYSTEM STATUS:-                                                       A system status is set by the system automatically upon executing a function. It                            Specifies that a particular function was carried out on an Object, be it a                            Transaction ( like Service Order) or a master Data ( serial Nu...

S4HANA/ SD/PP/PS/CS---- Requirements Type and its determination in Sales Order

This Article focuses on Requirement Type and how it is determined in Sales Order. Also  the strategy of Requirement and its Usage Definition of Requirements Type:                Requirement Type Identifies different Requirements like Sales Order, Delivery Requirements,  individual Customer Requirements, Make To Order  or Assembly to Order. Requirements Type uses Planning strategy which has specific strategy for specific Process Requirements Type along with Requirements Class plays a Significant role in determining relevant Functions like, Costing, Settlement, Result analysis, Accounting Indicators,  Special Stock  Indicators, Valuation settings Determining the Requirements Type: To determine  Requirements Type at Sales Order, a sequence of Strategies are defined in Standard Let us check these Strategies 1.  At First, system will check the MATERIAL MASTER--> MRP  3 View-->Strategy...