topic Re: Customer material info record upload program (BDC) in Application Development and Automation Discussions

Customer material info record upload program (BDC)

Former Member — Sun, 22 Apr 2012 15:14:18 GMT

Dear All ,

We have developed a BDC program for customer material info records upload in transaction (VD51) , in the program we have issues , technical consultant tried but not able to come up with solution.

Main problem:

1. Not able to handle duplicate records coming in the upload file i.e if there are any duplicate program should remove or should give some error message so that user can rectify the errors in the file and uploaded again

2. Customer-material relationship combination -> one to many combination not able to handle i.e one customer can have many number of material as a info records.

Also please find the attached text data for CMIR

Looking for your suggestion or inputs on this.

Note: Do we have any standard BAPI or BDC

Regards

Venkat

Re: Customer material info record upload program (BDC)

former_member585060 — Sun, 22 Apr 2012 15:52:13 GMT

Hi,

Check this function module, RV_CUSTOMER_MATERIAL_UPDATE_C, it intern calls RV_CUSTOMER_MATERIAL_UPDATE. Place break point in the first function module and try to create manually one entry in VD51 transaction, if it stops at the break point, verify what all entries are maintained in XKNMT, YKNMT and LT_CATALOG. So based the entries you fill the entries from the file to this function and execute.

I think there no standard BAPI available for VD51, only

BAPI_CUSTMATINFO_GETDETAILM

BAPI_CUSTMATINFO_GETLIST are available.

So try out with RV_CUSTOMER_MATERIAL_UPDATE.

Thanks & Regards

Bala Krishna

Re: Customer material info record upload program (BDC)

RaymondGiuseppi — Mon, 23 Apr 2012 04:45:27 GMT

.Don't use (or suggest using) any update task FM, those FM are used by standard SAP program after checking data and ususally not alone (e.g. XXX_UPDATE and XXX_UPDATE_DOCUMENT) - those are usually nothing more than open-sql statements. (not better than direct update database...)

So use BAPI (i don't think there is one), IDoc, or BDC (or standard programs that generate BDC)

Read Note 1135984 - Conditions cannot be created with BAPI_PRICES_CONDITIONS which suggests report RV14BTCI to create BDC

Regards,

Raymond

Re: Customer material info record upload program (BDC)

Former Member — Mon, 09 Dec 2013 20:00:19 GMT

Hello,

I'm looking for a solution like this ? Could you share a bit ?

I also found a OSS note 626931 that gives some insight about BTCI-solution for this object.

However, I'd rather have an IDoc solution but can't find any.

Regards