SAP BW profile , /SAPTRX/EH_INFO and 0SCEM_1 not all data populate.

[former_member215909]

Hi,

I am trying to load data from EM (Version 7.01)  to BW. I setup BW profile and assign fields to 0SCEM_1.

I am trying to test data:

- setup BW profile and assign fields to 0SCEM_1

- Assign this BW profile to Event Handler.

- Delete Initilization table (/N/SAPTRX/BWID)

- Fillup Init Tables for particular Event Handler which I assign my BW profile.(/N/SAPTRX/BWIU)

- Extractor Checker RSA3 for 0SCEM_1

Problem:

When I check the exracted data, There are only custom fields are populate data other fields standard SAP fields like Purchase Order or Batch or Sales Order is not getting data.

I check /SAPTRX/EH_INFO table, same issue custome fields have value but other info parameter which are SAP fields (like Purchase order, Sales Order, Batch etc. ) not getting value.

Question:

1. How to get this info parameters fields in /SAPTRX/EH_INFO.

     - I check the flow from BPT , Application Object then Condition, Info parameter assign all looks fine.

2. Is any setting I need to do in BW Profile to get this fields.

Any Focus and Help will be great help.

[former_member190756 · Accepted solution]

Hello Chandresh,

which EH Type you are using for extraction?

The BW Profile is bound to an EH Type and only the data from this profile get extracted.

For own EH Types you have to create your specific BW profile.

Best regards,

Steffen

[former_member215909 · Accepted solution]

Thanks Steffen,

EH Type Details:

Type: 400_ON_HAND

BPT: ESC_SHIPMT

Rule Set: 400_RAIL_ONHAND

BW Profile: ZBWTEST1 - I created custom for this EH and assign it.

When I check:/n/SAPTRX/TSC0PDM - Control Paramente assignment,

Exa:

400_RAIL_ONHAND Profile has all 400 custom fields which works fine.

OBP10_DELIV : Profile has Delivery No, Item, Plant etc..those fields are not getting either /SAPTRX/EH_INFO table or when I use this fields in BW profile not populating in extract sturcture.

Some Reason:

Also, /SAPTRX/EH_INFO  tables not getting data for all parameters particular Sales Order and Sold to, Shipto etc. Other custom fields getting data.

so, I think Application Object belongs to those (Sold to shipto) etc.. fields related EH handler not pushing data from application system. ?

How to check this data to make sure it coming from SCM appl system before it goes to  /SAPTRX/EH_INFO or other table?

Also,

When You enhance Extract stucture by adding custom fields, Do I need to map those fields in BW profile or not..?

Thanks..Really appreciate your reply because It's hard to find resources for this help.

Chan

[former_member190756 · Accepted solution]

Yes,

you must create an append structure like /SAPTRX/APPEND_PROCUR

to structure /SAPTRX/BWTFSEH.

This append must include the fields from your EH that you want to transfer to BW.

Afterwards they are available in /SAPTRX/BWEX where you define the BW profile ZBWTEST1.

Here you map e.g. an Info Parameter to your field in the BW structure.

If you have access to service marketplace:

www.service.sap.com/rkt

-> SAP Business Suite

-> SAP SCM

-> SAP SCM 4.0

Then you find on the right side at the bottom a link to Live Expert Sessions.

There is one for BW.

Best regards,

Steffen

[former_member215909 · Accepted solution]

This append must include the fields from your EH that you want to transfer to BW.

---> Here, I need to assign fields from source table

          exa: Equipment Id =  xyz table

Afterwards they are available in /SAPTRX/BWEX where you define the BW profile ZBWTEST1.

---> IS  Enhaced field Equipment ID will appear in

          1. Target Field (BW Extract structure)

          2. Source Table Field (Info / Control Parameter ) - Source Table

Automatic after enhacement done in first step ?

If Yes, then BW Profile just map the fields correct and enhancement abap code get the real fields from source table..

Here you map e.g. an Info Parameter to your field in the BW structure.

[former_member190756 · Accepted solution]

---> Here, I need to assign fields from source table

          exa: Equipment Id =  xyz table

Yes in your new append structure

Afterwards you can map an EH attribute to this field.

This should be all.

It is also described in SPRO:

Event Management

SAP Business Information Warehouse Interface

Process for Extracting SAP BW Data

Define General Settings for Data Extraction

Define SAP BW Profiles

Define Functions for SAP BW Interface

Maybe you have to generate and activate Data Source here after Append Structure was added.

Best regards,

Steffen

[former_member215909 · Accepted solution]

Hi Steffen,

I already enhaced the 0SCEM_1 by xyz fields say..Those fields are not available either info/control/ext ..in BW profile.

2. Assign fields in exit_SAPLRSAP001

exa: xyz = db-field.

3. in BW Profile I see those XYZ field

Question:

In BW Profile, XYZ enhaced fields as Target I see but I dont have anything to assing from info/control/ext str...and that's reason we enhaced in extrct. structure..

when I check in RSA3, I see those fields but no value.

so if we enhaced fields in 0SCEM_1 then

Do we need to MAP fields in BW profile..?

If YES, then How source field we will get because its enhanced field in ds.

Thanks for your big help.

Chan

[former_member190756 · Accepted solution]

Yes you have to map it:

Here you should see e.g. all Info Parameters when entering 2 in Source Table in field Source Field.

In Target Field you should have the fields from the enhanced BW data source /SAPTRX/BWTFSEH.

Then you can map and save. Afterwards the extraction should work.

Best regards,

Steffen

[former_member215909 · Accepted solution]

Thanks Steffen,

I get this part assignment of enhacement field in BW profile.

Question:

Newly enhaced field (ZZxyx) I can see as Target field in BW profile but Source field (Info Parameter) I can't have matching field.

As per you said..EH must have this field..If I don't have this field in EH then how to enhace this info parameter in EH.

I check following mapping

/N/SAPTRX/TSC0PD

/N/SAPTRX/TSC0PD

and

Check

table: /SAPTRX/EH_INFO

I attached images..Please, see

Do I need to add my ZZxyz field (enhaced in 0SCEM_1) in this mapping..

I guess its EM configuration things..I am BW developer.

[former_member190756 · Accepted solution]

Hello,

yes the info parameter must be created(/SAPTRX/TSC0PD) and mapped(/SAPTRX/TSC0PDM).

Then you see it in BW customizing.

But the value must be sent from somewhere. Info Parameters come either from creating/updating EHs or by sending an Event Message.

So you should clarify in your project how this will work and from where the value is coming.

Best regards,

Steffen

[former_member215909 · Accepted solution]

Great Help..I want to assign Point. How?

[former_member215909 · Accepted solution]

Hi Steffen,

Last Question (may be haaa !!):

we enhaced 0SCEM_1 with ZZxyz field and ABAP code to fill this field

Exa:

zzXYZ = /SAPRCX/EQUIPX- XYZ  table

1. Why we need  info parameter in EH or Event Message to get value.Becaue we are assign value in extract structre from  /SAPRCX/EQUIPX- XYZ  table.

2. BW Profile: zzXYZ field mapping what is use for ..it just only mapping or feeding value to field also.

Means,

Where this custom field getting value

- extract structre enhacement abap code

or

- BW profile mapping and get value from /SAPTRX/EH_INFO or other Parameter table

Thanks for reply..It really help ful for us.

I check all resource SPRO and others but they dont specific clear answer.

Thanks again..

Chan

[former_member190756 · Accepted solution]

Normally you have Info Parameters on the EH. Stored in /SAPTRX/EH_INFO.

During extraction the Info Parameters from the EH were mapped according to BW Profile to BW extract structure.

If you have own coding where you fill the value i think you don't need the mapping here.

Where did you do the coding? I don't know the Railcar extension for EM in detail.

Did you maintain a Plug In Funtion in /SAPTRX/BWEX?

Best regards,

Steffen

[former_member215909 · Accepted solution]

first we append the fields at  0scem_1 ds, extract structure /SAPTRX/BWTFSEH

then, Function exit  EXIT_SAPLRSAP_001 , add abap code like..

zzxyz file = getting value from  /SAPRCX/EQUIPX- XYZ table value.

Plug In Funtion in /SAPTRX/BWEX - This way if code here it will populate the data without having value in stored in EH /SAPTRX/EH_INFO.?

Thanks,

Chan

[former_member190756 · Accepted solution]

Yes,

you can check function module /SAPTRX/BW_PCM10_ITEM.

You have changing parameters for all BW structures:

REFERENCE(CT_BWTFSEH) TYPE  /SAPTRX/TYT_BWTFSEH

*"     REFERENCE(CT_BWTFSEE) TYPE  /SAPTRX/TYT_BWTFSEE

*"     REFERENCE(CT_BWTFSEG) TYPE  /SAPTRX/TYT_BWTFSEG

Best regards,

Steffen

[former_member215909 · Accepted solution]

Hi Steffen,

Thanks for reply.

Yes. After Enhacement of Extract Structure 0SCEM_1..Adding field and writing ABAP code in User Exit. It populate data when I check in Extractor Checker.

Thanks,

Chan Patel