Question:
Dear fans,
I have the requirement of calculating the logistics period, i.e.
all the whole weeks in a month belong to that logistic period, the week may be 5 days or 7 days, for the week that falls in 2 months , if it is 5 days a week, it is checked to see if the 3rd day falls in the present month , if yes then logistic period is the same month else , the week falls in the next month, and for a week with 7 days it is check to see if the 4th day of the week falls in the same month if yes then the week belongs to the same month else falls in the next month.
Answer:
Where is the question ?
If you look for the abap code, I suggest to use the abap forum.
Ch
Answer:
Dear CHC,
this is a BW related question , in supply chain management, where we have to update rules to determine the logistics period
Answer:
Dear,
I am not clear in my explanation, Please let me know, as it is a bit urgent.
Answer:
It's not clear to me... as CHC asked before: where is the question?
When do you have 5 day weeks and when 7 day weeks? I don't see the logic in that one...
Which level of detail is coming into BW?
Answer:
Dear EL,
It all depends on the working days of a company , few may have 5 days working and the ohters 7 days, and this is for demand forecasting and the data is coming from a custom defined lis structure from R/3, which has the 0calmonth from which are to populate an additional KF, which contains the logistics period.
if not please let me know i can give more details.
thanks.
Answer:
Hi ,
I am not clear abt exact question .. Here is some thought ..
Create ODS for each company code with 5 days or 7 weeks ..
In transfer rule , u can read ODS and derive a logic for period !
Is it n't sounds ok !
Answer:
Well , I shall try to put it in a better way.
I have data for the cal mon./ year comming from R/3 . from this data I have to .
1. find the whole weeks in a month ( say Jan ) i.e. the weeks that completely fall in the month and assign them to a logistic period (Jan.)
2. for the weeks that fall in 2 months ( say Jan & Feb ), the month that has more days for that week is the logistic period for that week . Say for example the last week of Jan. has 2 days and the first week of Feb. has 5 days then the last week of Jan. falls into the logistic period of Feb.
thanks.
Answer:
I have data for the cal mon./ year comming from R/3 . from this data I have to .
bsr, if you have to classify your record in a logistic period based on a week determination, I hope that you at least receive the week level, not the month level as you mentionned.
Now, if you have this information, the easiest way is to built in BW a table that will classify weeks 1-2-3-4 in month 1, 5-6-7... in month 2 and soon. Based on the week you receive in the record, you just have to do a lookup via this table to convert into month.
To deal with the fact the record can be a 5day or a 7day based company, I also suppose you have an indicator in the record that will deliver you that information. So, you keep the same idea, but you add a key in your lookup table that will be distinguish between 5day/7day.
Thus, you could have A1-A2-A3-A4 in month 1, and B1-B2-B3-B4-B5 in month 1.
If this is the kind of idea you were looking for, you just have to ensure you have the necessary indicators (weeks, 5day or 7day) and
the rest is only abap implementation.
Of course, this idea needs maintenance of the table, but you can also implement the logic 100% in the abap routine by calculations.
Ch
Answer:
CHC thanks a lot this helps.