Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

abap sd module program

former_member622718
Participant
0 Likes
935

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

4 REPLIES 4
Read only

Abinathsiva
Active Contributor
0 Likes
796

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

Read only

former_member1716
Active Contributor
0 Likes
796

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.

Read only

796

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

Read only

796

Hello Simone Milesi,

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

Cheers!