Skip to main content

S4HANA : Sourcing and Procurement - How to identify Missing Data for Supplier/Vendor ( Business Partner)


Business Requirement: -

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

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

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

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

 

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

Tables to check:

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


Call Table BUT000 and find Partner GUI ID



With this GUI ID, go to Table  "CVI_VEND_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 #  /nS_ALR_87012102

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




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


This shows  that the customers are not Created in FI, which means they were not extended to FLVN00 ( 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
Labels:

Comments

Post a Comment

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 ...
2 comments
Read more

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...
3 comments
Read more

S4HANA : How to activate Quick Cut and Paste in S4HANA

We are used to "quick cut and paste" option in ECC system to cut and paste. Let us see how this has to be activated in S4HANA In S4HANA, this indicator is not available by default for all Themes. You need to activate it. To activate it in S4HANA, first check the Option from  In the Options menu, choose Theme other than " Belize: such as Corbu or something other than Belize. This will take you to a screen Them and here you can select the Option for Quick Cut and Copy In this way it should be activated in S4HANA system. please try and let me know if you still find difficult in S4HANA
2 comments
Read more