topic Re: abap sd module program in Application Development and Automation Discussions

abap sd module program

former_member622718 — Tue, 17 Sep 2019 08:09:36 GMT

by using date and plant as input i need to produce output Billing Date. Type Reference. Date. Line Item

Re: abap sd module program

Abinathsiva — Tue, 17 Sep 2019 09:16:14 GMT

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....

Re: abap sd module program

former_member1716 — Tue, 17 Sep 2019 09:38:36 GMT

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.

Re: abap sd module program

SimoneMilesi — Tue, 17 Sep 2019 11:35:40 GMT

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

Re: abap sd module program

former_member1716 — Tue, 17 Sep 2019 12:05:46 GMT

Hello Simone Milesi,

I totally understand! Will keep this in mind going forward:)

Cheers!