how data will store in sap ecc mara table

[Former Member]

hi all,

i am new to sap mdg.

if i create material reuest then data will store in staging area.but after aproval of req .wht happen?

means in mara table how these entries are stored which are created by create request application in sap mdg

is there any procedure or coding required to post data from mdg to sap ecc standard tables.

please reply

kanchan

[Former Member · Accepted solution]

Hi

In the activation step, it brings the data from the staging table to the mara tables. Material basic data and classification are out of the box. You are not required to do any coding.

For e.g. If you want to write into the MARC table, then you have to extend the data model using the extension guide. No coding is needed

[Former Member · Accepted solution]

hi thanks for reply,

but after activation also data is not storing in mara table .it in staging tables only and in staging table i am able to see only matnr not other data like weight , old material no etc..

i copied standard mm data model and did ui and workflow configuration

workflow template ws75700040 used plz help me.

[former_member193350 · Accepted solution]

Hi,

For storing the data in ECC table, it needs to be moved from staging area(unapproved) to active area(approved).

Below are the steps for storing the data in MARA Table:

1.  Need to Activate Data Model named as "MM".

2.  After activating the data you need to configure Rule Based Workflow.

3.  When you click on rule based workflow it will open a browser window inside that you need to give type of change request like(Create material,Update material etc). A BRF+ code will open there you can assign the processor and also see all the steps.

4. Go to worflow builder through SWDD tcode.

5. Standard Workflow template is WS60800086.

If you find this answers useful, Please Reward some points to me and close this thread.

Regards

Prateek Agarwal

[Former Member · Accepted solution]

plz help me not able to store data from mdg to ecc.

in our case mdg and ecc is on same server.so what procedure need to use to post data in mara table from staging tables

[Former Member · Accepted solution]

hi pratik

thanks for reply ..

i did configuration but then also not able to post data in ecc tables ..

[Former Member · Accepted solution]

can u tell me ....what is happening after approval, is there any error reflected, might be some configuration is wrong

[Former Member · Accepted solution]

Hi,

if all configuration is correct, please check workflow number assigned is correct or not, under 

• General Settings->Process Modeling->Create Change Request Type.

and

check

• General Settings->Process Modeling->Workflow->Activate Type Linkage.
• For BUS2250, make sure that receiver type should be empty and type linkage should be checked.

Regards

Nitish Sharma

[Former Member · Accepted solution]

hi nitish,

thanks for reply ..

no error data gets activated in staging tables..but not able to see in mara tables..

i checked configuration evrything is ok..

reply

[Former Member · Accepted solution]

did you check workflow number and active type linkage??

[Former Member · Accepted solution]

yes its correct

[Former Member · Accepted solution]

Hi,

you said you are using ws75700040, use WS60800086. you have to reconfigure again. this scenario is working fine with me with WS60800086.

[Former Member · Accepted solution]

no i am using WS60800086 template only

[Former Member · Accepted solution]

hi nitish,

WS60800086 is rule based workflow..

can u please give details for configuration step wise..

thanks

kanchi

[Former Member · Accepted solution]

Hi Kanchi,

What do you mean by saying data is getting Activated in the staging area.

If it is showing as Active in STAGING TABLE itself,then you are using flex option.

Data enters into SAP ECC only if you use REUSE option.

This [flex] happens if you have assigned reuse area as "MDG" instead of "MATERIAL" for any of the entity types you have created.

Also I saw you mentioning STAGING AREA consists only of MATNR. Actually other corresponding info will be stored in other similar Staging tables.

So please check all your entity types in data model for reuse areas whether you have mentioned "MDG" or "Material".

Note: If it is blank, it means "MATERIAL", so need to worry.

Please confirm this I'll assist you further.

Regarding Workflow, if you are using simple workflow WS75700040, then you have to assign agents through "Process MOdelling"->"Workflows"->"Other MDG Workflows"->"Assign Processor to Workflow step Number".

If you are using rule based workflow WS60800086, then you have to do it using BRF+.

So confirm the mode and I'll assist you.

[former_member193350 · Accepted solution]

Hi kanchi,

As you have mentioned  that data is getting approved but it is not moving to MARA table. and also u have checked the active type linkage and workflow number.

I think you need to once check your workflow, you need to assign the processor to the workflow in the decision tables of BRF+  and also need to activate BADI by jsut going into process modeling.

Please revert.

Regards

Prateek agarwal

[Former Member · Accepted solution]

Hii Kanchi

I hope you configured change request type and activated data model where you will assign workflow number as i mentioned above with screenshots. after that assign priorities ,reason and all ,you have to activate type linkage as i mentioned above. Than open your brf+ code

Inside this you see the decision tables named as:-

§  DT_NON_USER_AGT_GRP_MAT01

§  DT_USER_AGT_GRP_MAT01

§  DT_SINGLE_VAL_MAT01

•    To assign processors to workflow go to Decision Table   DT_USER_AGT_GRP_MAT01(for material) 
•   Inside that table for condition alias you have to give User agent value like name of the users who handle the request.
• You can edit this table by clicking on edit.

                          Then

• Inside Process Modeling->Workflows->Other MDG Workflow,   You need to activate all the BADI by just selecting one and click on display and then click on activate.

Then

• Go to Workflow builder through SWDD transaction code (T-code):
• You can see the task by either double clicking the node or select task from navigation area.
• You can check whether a particular task is assigned to any agent or it is a background one.You can see the task in task properties.Either one option should be green i.e. agent assignment or background processing. If both options are gray. Click the symbol and then click attributes. And select general task.

and check link

http://scn.sap.com/thread/3158672

i already mentioned above points with screenshots to you in this link. Please check, i am sure your scenario will work.

Please reward point if you find contents suitable.

Regards

Nitish Sharma

[Former Member · Accepted solution]

hi ,

i wann save data in ECC so which reuse area..i used MATERIAL only

. and i am using role based workflow for this

WS60800086 ..so please suggest the configuration steps..

kanchi

[Former Member · Accepted solution]

Ok,

1.Create Change request and assign workflow number.

2.Then Activate Type Linkage using MDGIMG.

3. Then perform changing of background tasks to general tasks as mentioned in SAP HELP.

General Settings Process Modeling Workflow Configure Workflow Tasks

4.Then perform changes in user agents assignment through

General Settings Process Modelling Workflow Rule-Based Workflow Configure Rule-Based Workflow

Give the change request number in the screen and proceed.

5.Then under "Decision Tables" forlder you can see three tables.Goto User Agent Decision Table and perform changes over there.

In user Agent type give "US" and in User Agent Value give "Your User Name".

[Former Member · Accepted solution]

hi nitish,

gettting error in workflow ws6080086 step Check it is single agent group process

can u plz help me

kanchi

[Former Member · Accepted solution]

what error it is coming??

yeah single is assigned for a particular step.

[Former Member · Accepted solution]

can you send me a screenshot of the error and details in which step it is coming??

[Former Member · Accepted solution]

hi

i am getting error in workflow

step name is "Check If Single Agent-Group Processing"

at this step error is coming ...

Error in getting proper agent group; no agent group found

thanks

kanchi

[Former Member · Accepted solution]

Hi kanchi

I think you have choosen the object type group or role(may be its your requirement), but for assigning single agent for a particular step(for eg approval), select single agent(us) object type and assign user.

May be you are selecting role under user type and not assigning any user to it, or assign wrong user id.

Regards

Nitish Sharma

[Former Member · Accepted solution]

hi nitish,

ya i checked i ahve given US and user name in value ..and agent group as 001 ...but i am getting proper agent group not found ..we need to create agent grp is it so plz reply

kanchi

[Former Member · Accepted solution]

no its not needed, bt its depened upon ur requirement, try with agent grp, let see error still persist or not.....if possible please send me a screenshot....

[Former Member · Accepted solution]

hi nitish

when i create material i am getting error in workflow . workflow is started but at step Check If Single Agent-Group Processing..getting error

i have used agent gropu as 001 ...

i have checked in workflow log same error 

Error in getting proper agent group; no agent group found

plz help

[Former Member · Accepted solution]

hi nitish,

for create material application  i did below steps:-

1) activated data model

2) created change request

3) ui configuration checked

4) workflow configuration:- brf+ , activate linckage and evrything

used template ws6080086

now tested but data will in activate state only

there are 2 steps only

1) create request then it goes to approved mail box

2) approver activate ...

after activation we r able to see data in active state in stading tables..

but though data not able to see in mara table..

is there any thing we need to do in workflow means add any task for posting data in ecc mara table

plz reply

kanchi..

[Former Member · Accepted solution]

yeah thts fine.....is the approver is getting the data to approve on his screen.??

[Former Member · Accepted solution]

yes approver is able to see activate button to activate data..

please help me

[Former Member · Accepted solution]

did you activate data model "MM" under data modelling->edit data model

and also check  DT_SINGLE_VAL_MAT01

last step should be cr previous step 08(approved,to be replicated).

[Former Member · Accepted solution]

hi nitish,

using create material application i am able to approve data and after that data will store in staging tables with active state but not in ECC tables.

in our case MDG and ECC on same server. so please help how post data in this  case..

ws6080086 this workflow we are using .and data is stored in stading table /1MD/MD________09j

now we want to post data in ECC MARA table in the same server.

here server and target system are same..

thanks

kanchi

[Former Member · Accepted solution]

hi,

ya i ckecked its o8 step only as u metioned ..

not getting exactly...whts the issue..