Question:
Hi,
I'm extracting data from 2LIS_11_VAITM, sales order item information. I am also getting data for deliveries and billing, and a multicube joins the three.
For sales order data, I want to restrict by global status of sales order (field GBSTK of VBUK).
This field is not available in extractor.
This is available in 2LIS_11_VASTH. This is a extractor for sales order header. It only has doc number and a set of status fields.
The question is, how can I inform the status for every position?
If I put an ODS with doc number and position, I cannot update from 2LIS_11_VASTH.
If I use and ODS without position, a sales order with three positions cannot be saved (different materials, customer, ...) cannot be overwrited or mixed.
I cannot enhance 2LIS_11_VAITM because GBSTK is a status field. When status changes I need system generates two records, one to delete the information with initial status and other one adding the information for new status.
Any idea????
Regards.
Answer:
I cannot enhance 2LIS_11_VAITM because GBSTK is a status field. When status changes I need system generates two records, one to delete the information with initial status and other one adding the information for new status.
euh... take a good look again, there are status tables available
however, the field you mention doesn't seem to be in MCVBUP... maybe you can add it???
cheers,
El Belgio
[/quote]
Answer:
Hi El Belgio,
Yes, the field GBSTK is in status table MCVBUK, but not at item position (MCVBUP).
If I enhance MCVBUP I will have a problem:
I create a sales order of 200 UN. GBSTK = ' '.
I create a partial delivery of 50 UN. I get the status of sales order. It is ' '. I load it and I summarized for this status the delivered quantity.
I create other delivery of 150 UN. Status of sales order, GBSTK, changes to 'C'.
I load this data and summarize it, in this case for status 'C'.
So I have 50 UN for GBSTK ' ' and 150 for GBSTK 'C'.
Status fields have to be controlled by standar and cannot be added to extract structure in enhancement, due to this problem.
I'm triying to mix data from 2LIS_11_VAITM, 2LIS_11_V_ITM to get the same information, but I'm not sure if it will be possible.
Thanks.
Answer:
Hi,
Why don't you load the seperate datasources into a seperate ODS for each. In BW you can then combine the data, using normal loads and/or lookups, into further ODS or InfoCube. You can then arrange it in such a way that the status of the order header is added to each order position, but that the deliveries are not influenced by it.
Be aware that some of the delta mechanisms for the LO datasources are not working correctly!
Regards,
Jóska.
Answer:
Hi,
Good try, but already tested. This solution don't work because of datasource 2LIS_11_VAITM, takes information at document item.
GBSTK is in a datasource of header information.
An example.
2LIS_11_VAITM
Sales Order Item Material Customer Qty1 ...
1000 10 ABC 0001 100.23
1000 20 XYZ 0001 22.34
...
(In fact there are a lot of more characteristics).
The key of ODS should be SAles order and item. If not, positions with different materials will be overwritten.
GBSTK comes in a datasource with only Sales Order (not item position). So, I cannot mix records.
All characteristics cannot be key fields in ODS because I have more that 16.
I have tried with other datasource that has quantity remaining, and triying to get the same result.
I have two cubes and a multicube. So I have formulas to get the right result.
This solution don't work because it only works when document number is in drill-down. This is because formulas in queries are executed after aggregation.
I cannot create at cube level because it arises an error (at cube level I can indicate calculate before aggregation).
Moreover, I need to use a restricted key figure in calculation, and at cube level, if I use it, I cannot calculate formula before aggregation.
I am really lost. in one hand I cannot get the status of the sales order to exclude it from report.
By the other hand, if I use other datasource to calculate the status with numbers (GBSTK = 'C' is the same as pending quantity + delivered quantity without picking done = 0), the formula only works when document number is in drill-down.
Regards
Answer:
Why don't you use GBSTA - Over all status of SD document Item
BWquery
Answer:
hi,
i made a report of sales order status (head).
i used the normal sales header datasource and the 2LIS_11_VASTH extractor.
the data is put into two ods. then i run an infoset plus a query on them. this is, because the data needs to be joined. this can't be done by an multicube.
why to join the data ?
if the status of an order changes, the normal header extractor won't recognize it as an delta, so use both content extractors and join them via infoset.
we just report the orders that are not completely finished, so the performance of the infoset-ods is ok.
hope i helped a little bit.
greetz,
toadward