DataSource Enhancement

[Former Member]

Hi Friends!

Please tell me about DataSource enhancement,how to do that, as i don't know any thing about it, please explain in detail the procedure.

I'll appreciate if any one can provide me with a document.

Thanks.

Surya.

[Former Member · Accepted solution]

Hi Surya,

datasource enhancement process depends from which type of datasource you are using...however, generally speaking, you have to go to RSA6, choose your datasource and enhance it by creating an append on the extract structure in which you can put your own additional fields (ZZ*)...then, after saving and activating, you have to fill these fields by a specific userexit (for transactional or master data) in CMOD (through the enhancement RSAP0001, you will have to access the function module EXIT_SAPLRSAP_00n and put your own code in the Z include)...

Let me know what is your specific need !

Hope it helps...

Bye,

Roberto

[Former Member · Accepted solution]

Hi Roberto!

After a long gap....

Any way it's nice to see a reply from you.

As i told in my first post, I am new this particular topic, and i thought to learn it. That's all.

So, please explain in detail... if possible with some document.

Bye,

Surya.

[GFV · Accepted solution]

In SAPNET (http://Service.sap.com/bw) you can find a suitable doc named "How to ... Extend Master Data to incl. Social Security Number" with a sample code. The example is inherent to a Master Data Enhancement, but works in a similar way with "Movement Data".

Hope it helps

GFV

[Former Member · Accepted solution]

Hi GFV,

I don't have access to "Service.sap.com/bw".

What to do?

[Former Member · Accepted solution]

Surya,

unfortunately in the next days (and for a couple of months) I will be on a new engagement without external connection...so, this long gap will continue...

However, in the meanwhile...

For LOGISTC COCKPIT, you can enhance your datasources:

- WITH EXISTING FIELDS FROM THE COMM.STRUCTURE

go to the customizing cockpit (LBWE), maintain extract structure, select the fields from the different catalogs on the right hand side and move the fields to the extract structure on the left hand side, save your settings and system automatically creates an append to the delivered extract-structure which contains the selected fields (red traffic-light); generate datasource again (yellow traffic-light) and reactivate extract structure with delta update (green traffic-light).

- USE THE LIS ENHANCEMENT on available comm.structure

add your fields to an append structure in the appropriate communication structure (via SE11), identify the appropriate user-exit for filling the fields (e.g. MCS10001 for Sales Orders); now the fields will also be available in the customizing cockpit (LBWE) and you can therefore proceed with the steps described before in the previous bullet

- USE CUSTOM APPEND on the EXTRACT STRUCTURE (both for LC and other datasources)

follow the instructions given in the previous reply (RSA6, choose your datasource, use the specific button to enhance it or (if you are modifying an LC datasource, double-click on the extract structure (you will see an SE16 screen), create an append, insert your ZZ* fields, save. Then you have to fill these fields with user-exit (by CMOD, using the enhancement already indicated)

Remember that if you are using an LC datasource, before starting your enhancement in production system, you have to end all document postings of the affected applications, start the processing of all open V3 update entries using 'V3 Control' in LBWE, delete the setup tables of the affected applications (these should in any case be deleted after a successful initialization), fetch the delta queue data for all affected datasources by requesting the corresponding infopackages from all relevant BW systems; enhance, activate, replicate in BW and...that's all !

Bye,

Roberto

[GFV · Accepted solution]

Write me at gfv@interfree.it ... I will send you the doc.

Best regards

GFV