"Ship to Country Field" in AR Ageing Report

[Former Member]

HI There,

We have a <<removed by moderator>> requirement to enhance the existing report to enhance with the "Ship to Country" field.

Can anyone name the field and table from where we can get the "Ship to Country" field.

Here, the reports are based on the Customer Number (KUNNR ) Mapped to 0DEBITOR

and Accounting Document number (BELNR) Mapped to 0AC_DOC_NO

I think we have "Ship to Country" field from SD tables, but not sure how to get bring that into 0FI_AR_04.

Please advise

Thanks

Vandana

Edited by: kishan P on Feb 29, 2012 7:53 PM

[former_member199691 · Accepted solution]

Customer in accounting document may not be the Ship To.

You can stage the partnership data from KNVP table, which will give you the Ship To party for a Customer for unique combination of Sales Org, Sales Division and Distribution Channel. This master data can be used to get Ship To Country.

I am not sure if Accounting Document will have Ship To details, if not, one way is to get this information from Customer master data as exaplained above.

Another method can be to do a look up and store the ship to information in cube so that you can use Ship To Country as free characteristics.

For that you can look up Invoice document to get to Ship To.

I hope that helps.

Regards,

Gaurav

[anindya_bose]

Vandana

0FI_AR_4 has a field called LAND1 , should be mapped to 0COUNTRY.

To be sure just check the Data in LAND1 whether matching with Country of 0DEBITOR ( Attribute)

Regards

Anindya

Edited by: Anindya Bose on Feb 28, 2012 2:28 AM

[Former Member]

Gaurav,

Thanks for your suggestion.

What you said is right, in KNVP table PARVW (Partner Functions) populated code WE (Country Ship to Party).

Based on your suggestion, i verified the data in Invoice as well as Billing Document datasource 2LIS_13_VDITM, and in that LAND1 populates the same data as that of code WE from PARVW field from KNVP (VBPA table also has the same field, which populates Ship to country, payer country & bill to country codes)

The reason for going 2LIS_13_VDITM is to get the data by using look ups. I dont know how it would be easier getting the same data from KNVP table.

Its still open, please suggest me if you think my design is wrong. Thanks

Vandana

Edited by: vandana_ir on Mar 4, 2012 7:23 PM

[former_member199691]

getting data from KNVP will be helpful where reference document for accounting document is not Invoice. In that case, you can use Customer in the accounting doc to get the Ship To Country from KNVP.

Regards,

Gaurav

[Former Member]

Hi Vandana,

You can use Country attribute from 0DEBITOR master data, which is eventually a reference object to 0CUSTOMER which holds all customer related info.

-- Selva