2007 Jul 30 8:07 AM
Hi,
I got a functional Spec as follows:
<b>
Source SAP table n field</b> : Pick the first date that meets the following selection criteria: For Planned Orders: PLAF table, Order Finish date + GR Processing time (If the date falls on weekend then the planned date is the next available weekday). Conversion Indicator is checked; SOBES = "7" (Stock Transfer). Select only Planned Orders where AUFFX = "X" (firmed.) Use tables ZMD04_TZ1, ZMD04_TZ2, ZMD04_TZ3 to extract Production Orders. For Purchase Orders, use Delivery date + GR Processing time (If the date falls on weekend then the planned date is the next available weekday). For Purchase Reqs, use Delivery date + GR Processing time (If the date falls on weekend then the planned date is the next available weekday) from table EBAN
Filter: PSTYP not equal "7" (Stock Transfer), deletion Indicator not equal to 'X'.
Need to do the above calculation to display date of 1st firmed RCPT.
Please help.
Hi,
I got a functional Spec as follows:
<b>
Source SAP table n field</b> : Pick the first date that meets the following selection criteria: For Planned Orders: PLAF table, Order Finish date + GR Processing time (If the date falls on weekend then the planned date is the next available weekday). Conversion Indicator is checked; SOBES = "7" (Stock Transfer). Select only Planned Orders where AUFFX = "X" (firmed.) Use tables ZMD04_TZ1, ZMD04_TZ2, ZMD04_TZ3 to extract Production Orders. For Purchase Orders, use Delivery date + GR Processing time (If the date falls on weekend then the planned date is the next available weekday). For Purchase Reqs, use Delivery date + GR Processing time (If the date falls on weekend then the planned date is the next available weekday) from table EBAN
Filter: PSTYP not equal "7" (Stock Transfer), deletion Indicator not equal to 'X'.
Need to do the above calculation to display date of 1st firmed RCPT.
Please help.
2007 Jul 30 8:10 AM
Hi Shobana,
For planned order: order finish date + GR processing time
if conversion indicator is checked & sobes = 7.
<b>
Regards,
Azhar</b>
2007 Jul 30 8:11 AM
Hi shobana
Can u please elaborate ur functional spec.
Regards,
Azhar
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |