Skip to Content
avatar image
Former Member

Country - Which table/field is this data held

Hello experts

When I look at list of Business Partners I can see they are per Country. Please can someone advise what database table/field this country information is? I want to write query which includes BP country along with Sales data

Thank you for assistance

Karen

capture.jpg (53.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 02, 2017 at 10:25 AM

    Hi

    try OCRY

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 02, 2017 at 01:09 PM

    Hi,

    It depends on which address do you want to use, ShipTo or BillTo

    ShipTo => OCRD.[MailCountr]

    BillTo => OCRD.[Country]

    Add comment
    10|10000 characters needed characters exceeded