update MD62 value?

[former_member224727]

Hi Expert,

We have business requirement to update MD62 (Planned independent req) through excel...Can we do it? Please suggest solution...

Requirement:

For material ABC we already have MD62 value. We have two version xx for monthly req plan & yy for weekly req plan...So business will give us value of material ABC in excel with version xx/yy. So they want system to auto update excisting value with excel input. So I'm not sure what I need to do for this req..I was thinking to write ABAP program which will take input excel file & update MD62 value.

Can we do this way? Please suggest solution.

[sjeevan · Accepted solution]

Yes, I would suggest ABAP program too, as you'd have more control over it. You can use the simple program in the link below to understand uploading excel file to internal table

Link

BAPI below for reference

BAPI	Description
BAPI_REQUIREMENTS_CHANGE	Planned independent requirement: Change planned independent reqmt
BAPI_REQUIREMENTS_CREATE	Planned Independent Requirements: Create Planned Independent Reqmts
BAPI_REQUIREMENTS_GETDETAIL	Planned Independent Requirements: Display Details for Pland Indep. Req
BAPI_REQUIREMENTS_SIMULATE	Planned Independent Requirements: Simulate Creating/Changing PlndIndep

[former_member224727 · Accepted solution]

So as per your conversation I would be able to update MD62 value using BAPI - "BAPI_REQUIREMENTS_CHANGE". Please correct if my understanding wrong.

[sjeevan · Accepted solution]

Yes, that's right. BAPI_REQUIREMENTS_CREATE will give an error if data already exist, so, my suggestion would be, on the selection screen you can put radio buttons one to create and one to change and use the function module BAPI_REQUIREMENTS_CHANGE to change the data, this gives more flexibility to the user in case they ever want to create and change data by uploading from excel.

[former_member184701]

dear, you also would try to use the SCAT or SECATT . It works perfectly with Excel uploads and you can link any t-code (in your particular situation it is MD62)

regards,

[former_member224727]

I'm not sure how to use SCAT or SECATT..It would help if you give details steps.