Skip to Content
Author's profile photo Former Member

No Data Extracted for 2LIS_11_V_SSL.

I am using 2LIS_11_V_SSL data source to extract essential information about the delivery of order schedule lines to SAP BW system and loading into 0SD_O04 – Open Request Schedule Line DSO to calculate backorder quantity.

I have noticed that some order items are not extracted.

I was trying to fill the setup tables with the selection of sales document number in OLI7BW transaction but it is not extracted for the 2LIS_11_V_SSL Data Source as a result.

Please see the below findings why it is not extracted.

The fixed quantity indicator (VBAP-FIXMG) is set for an item, but the confirmed quantity is zero (VBEP-BMENG = 0).

1.Fixed date and quantity.JPG

2.VBAP.JPG

 

The item therefore receives the VBUP-LFSTA = SPACE (‘irrelevant’) delivery status and is not extracted for the 2LIS_11_V_SSL data source as a result.

VBUP.JPG

If you remove the fixed quantity indicator, the item becomes delivery relevant.

You now expect the item to be extracted to BW as a new record.

Thanks,

Shankar

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Thanks for sharing this useful piece of Information.

      Regards,

      AL

      Author's profile photo Raman Korrapati
      Raman Korrapati

      Very useful information. Thanks for sharing with screen shots.

      Regards

      Raman

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Thanks for sharing your experiance..it will useful to people who are going to use same datasource 🙂 .

      Author's profile photo Former Member
      Former Member

      kol blog. Thanks for sharring

      Author's profile photo Former Member
      Former Member

      Thanks for this valuable information

      Author's profile photo Former Member
      Former Member

      Nice blog Shankar.

      Thanks for Sharing.. 🙂

      Regards,

      Poorna

      Author's profile photo Harish Allachervu
      Harish Allachervu

      Informative thanks for sharing.

      Regards,

      Harish

      Author's profile photo Former Member
      Former Member

      Very useful !

      Regards,

      LS

      Author's profile photo Former Member
      Former Member

      Good.