Source table and Field required

[Former Member]

Hi,

Could you pls help me out to get Source table and Field name for the below.

1. Sales office Country.

2. Order count at Item level.

3. Net revenue at Item level excluding Tax.

All the helpful answers will be rewared with points.

Regards,

Venkat

[Former Member]

hi venkat

for order count you can use the combination of the fields in the table VBAP-VBELN and VBAP-POSNR

Regards

srini

[Former Member]

Hi Venkat,

Below is the Source Table,

Sales Office - ADDR1_DATA-COUNTRY

What is Order count?

Net value(Header Level) - VBAK-NETWR

Net Value(Item Level) -VBAP-NETPR

Tax -VBAP-MWSBP

Regards,

Chandrasekhr Reddy