2019 Sep 17 9:09 AM
by using date and plant as input i need to produce output Billing Date. Type Reference. Date. Line Item
Hi Manoj requirement is not clear, as per your question hope you need to get Sales data of given date against a plant, assuming that you can get details in VBRK and VBRP table by filtering posting date in vbrk and followed by pass vbeln and plant in vbrp....
2019 Sep 17 10:16 AM
Hi Manoj requirement is not clear, as per your question hope you need to get Sales data of given date against a plant, assuming that you can get details in VBRK and VBRP table by filtering posting date in vbrk and followed by pass vbeln and plant in vbrp....
2019 Sep 17 10:38 AM
Hello You have to write a Join statement on VBRK and VBRP,
VBRK-FKDAT is the Billing Date Field
VBRP-WERKS is the plant field.
All the fields from these two tables can be taken by giving your input values to the fields(mentioned above) in the where condition.
2019 Sep 17 12:35 PM
Sorry Satish, i downvoted your reply not because it's wrong, but because i think spoon feeding isn't the best way to help 🙂
Manoj would have a better answer, imho, helping him to understand the requirement (exposing it fully) and being "hinted" and guided to the solution.
Again, no grudge.
Simone
2019 Sep 17 1:05 PM
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |