I am new to SAP. I have to fetch data from billing tables for which i am using LIS structures. But there are few more filed on which i need to report on which are in delivery and sales tables. Can I append these fields to the LIS strucuture using Sales Document Number as a KEY.
sorry for my misunderstanding, but when we call about LIS structures we refer to the 'old' LIS structures (as the S601, S602, S603 and so on..)...
2LIS_12_VCITM is one of the so-called Logistic Cockpit datasources and you can enhance it without problem (in theory)...create an append from RSA6 for your extract structure (double-click on 2LIS_12_VCITM, double-click on his extract structure, then create the append with your ZZ* fields), then fill them with the specific user-exit EXIT_SAPLRSAP_001 (previously assigned to a project in CMOD) with some SELECT statement from your sales and billing tables !
If you want some more detail (or if you want to let me know with some details your requirements)...
you are perfectly right, with the normal exit you wil get into trouble, when dealing with "changable" fields in the enhancement (you won't get a delta update).
You speak of the MCS-enhancements (MCS10001, MCS50001, MCS60001), which can be used to enhance the MC-Structures for sales orders and so on. The infos for the enhancement are pretty good and helpful for the implementation.
But almost the same applies to this enhancements, every time you select something in your exit, which can be independently changed, you won't get an update, when its changed.
You have to be aware of this fact, when you enrich the structures with such fields.
you can not enhance the LO Cockpit Data Sources via RSA6. The option has been disabled in RSA6 some years ago. The reason is that the cockpit (LBWE) needs to be aware of all fields that are appended to a LO extract structure.
Otherwise regenerating the extract structure (happens when you change it via cockpit or when you upgrade the PlugIn) may result in errors or in lost fields.
If you want to enhance the LO Cockpit Data Sources please always start with appending the LIS communication structures (shown on the right hand side in the maintenance dialogue of the cockpit, e.g. MCVBAP, MCEKKO, ...).
Those appended fields will be automatically available in the cockpit. Now you only have to find a way to fill them with data (there are other posts about that in this thread).
thanks for your suggestion, but if you want to have a survey of different available methods when you want to enhance a LC datasource, take a look to /people/sap.user72/blog/2005/02/14/logistic-cockpit--when-you-need-more--first-option-enhance-it ...
Anyway, you can enhance your datasource via RSA6 simply following what I described "(...) create an append from RSA6 for your extract structure (double-click on 2LIS_12_VCITM, double-click on his extract structure, then create the append with your ZZ* fields), then fill them (...)" .... in this way you can add fields, but not delta-relevant. If you enhance your communication structure (and nothing else), the problem still exists.
There is no perfect answer, but only good solution taking into account every peculiarity of your scenario.
please try your suggestion with a recent PI/PI_BASIS release. You will get the error message R8525 ("DataSource 2LIS_12_VCITM does not allow append structures").
This is true for all recent PI_BASIS releases and all Cockpit Data Sources.
Furthermore, if you would try to enhance an extract structure without the LO cockpit knowing it, you will face the following major risk:
If SAP in a future release decides to deliver a field as part of the extract structure you enhanced, that has the same name than one of the fields you appended, then the upgrade will fail with an activation error. Please have a look at my OSS note 489259, reason 1 in the solution part.
Of course this is not a risk, if you only append ZZ* fields.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.