The data is fetched from APO to BI using MALO and MALA datasource.
When checked the wanted fields like "distribution demand TLB confirmed" in RSA3, we find the VALUES are blank.
(Our requirement was to postponed the projected stock (LOTS) by the shipment date based on the planning book - the malo and mala data source does not have start date or shipment date. Hence, we are referring to the material location and adding the GI time to the CALMONTH taking the avaerage day as 15 in the end routine. Later adding the TLB confirmed value for that month and deducting at a later month when the TLB confirmed is actually takes place
Unfortunately, we find that "distribution demand TLB confirmed" in RSA3 extraction is filling blank values.
1. If there is any ways, we can fill the VALUES of "distribution demand TLB confirmed" in RSA3 MALO and MALA datasource extraction
2. We are referring say 15 as the day in calmonth to add to the GI time, which is expected to bring diffferent result for few months.
Any other way we can work out this scenario - We have already seen APO order detail customized data source and this is based on order number and if we want to look up on this to check the shipment data which is available, our MALO and MALA datasource does not have order number and I understand this looks into live cache, hence, the logic we had created applies to all the cal month for the material /location leading to wrong data in huge
Require your expertise suggestions.
Thanking you in advance.