NETWR and FKIMG Fields

[former_member581554]

Hi All,

Sorry to repost my query. Mistakenly I have clicked on "Assumed Answer".

Please find below original thread:

http://scn.sap.com/message/15782170#

Thanks and Regards,

Niranjan

[sander_vanwilligen]

Hi Niranjan,

I suggest to use DataSource 2LIS_13_VDITM (Billing Document Item data). It will deliver almost all fields. The few missing fields from the conditions you have to add, e.g. a lookup in the source system or in BW.

Best regards,

Sander

[former_member581554]

Hi Sander,

Yes, You are right. I got almost all the fields. I am missing just NETWR which is present in both tables VBRK and VBRP.

Now my questions are below for enhancing the data source 2LIS_13_VDKON;

1) how to get the field NETWR and what would be the currency type?

2) From which table I should pick this field? VBRK or VBRP ?

3) Can I get the ABAP logic if possible?

Please suggest.

Thanks and Regards,

Niranjan

[sander_vanwilligen]

Hi Niranjan,

My suggestion is to use another DataSource, i.e. 2LIS_13_VDITM (Billing Document Item data). Here you have the NETWR field available w/o any enhancement. You can then do a lookup in a BW Transformation.

The field NETWR is a calculated field and present in both VBRK and VBRP. It depends on your requirement, do you need the header conditions or item conditions?

The field NETWR is always in Document Currency (i.e. WAERK).

Best regards,

Sander