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

TO MAKE INACTIVE CONDITION ACTIVE IN SAP

This blogger contains details on how to set an INACTIVE CONDITION  to ACTIVE while processing Sales Order content: 1.  BUSINESS REQUIREMENT Due to some legal restrictions in Russia, Russia Local Plant cannot hold any stock for the material and hence it is non valuated which means the Standard Price is Zero ( 0 $ ) The stock will be replenished from another company code and we used our Standard Third Party process  in which PR is created which will be converted to PO and when we do GR, the Standard Price of that plant is calculated in the GR. The baseline pricing structure is mapped in such a way that VPRS is calculated from the Material master and on which 15% markup is added as base price. Since the Cost price in VPRS condition is Zero Markup calculated on VPRS will be obviously calculates to Zero and both conditions were set as INACTIVE as per the condition properties 2.  CREATE SALES ORDER we will create a sales order for a material, whose standard Price

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 and we