cancel
Showing results for 
Search instead for 
Did you mean: 

Sales Orders against a Contract in BW

former_member374954
Participant
0 Kudos

Hi Guys,

I have a requirement where User wants to see all the Sales order created against a Contract. How can we do that? Any suggestions?

Regards

Prashant

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi Prashant,

Did you checked the communication structure for the 2LIS_11_VASCL, I can see the field.

Please check it once throughly,

Thanks,
Naveen

Answers (2)

Answers (2)

sander_vanwilligen
Active Contributor
0 Kudos

Hi Prashant,

Please check DataSource 2LIS_11_VAITM. Here you can find the fields VGBEL (Document number of the reference document) and VGPOS (Item number of the reference item) which should reference the contract / scheduling agreement.

Best regards,

Sander

0 Kudos

Hi Prashant,

All the sales orders created against a contract can be fetched by using 2LIS_11_VASCL datasource,

The field VGBEL contains the Contract number for Sales order(VBELN) created against it.

In this way we can fulfil the requirement, we have used it in the same way earlier.

Thanks,

Naveen

former_member374954
Participant
0 Kudos

Are you sure about this? Please see below link, I dont find this column in the Datasource at all.

Extraction SD Sales: Document Schedule Line - Enterprise Sales and Distribution - SAP Library

Regards

Prashant