Skip to Content
author's profile photo Former Member
Former Member

Need Help in understanding the JV Doc Types

I am a non-SAP guy working at the database level, I have been asked to join different tables and fetch the following missing data. Can someone please help me out?

The JV Doc Types are available in the following tables:

AZGL4ODS00
AZGL4ONE00
AZGL4TWO00
AZGL4THR00
AZGL4FOUR00

I was informed that we should use the Document Number as a key and search for the required fields.
Can you please help me figure out in finding the following fields and the table names that would have the relevant data:

Material Group Code
Baseline Date
payment date
invoice quantity uom
country
po line number
invoice quantity
Purchasing Group
Net Spend in USD
Purchasing Organization
standard price
inv rc qty
unit price
std price currency
price unit
Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Dec 26, 2013 at 08:42 AM

    Hi,

    Please check with MM consultant, might be helpful.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 26, 2013 at 08:47 AM

    Try in SQVI T code to check joins between all tables:

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 12:54 PM

    My first query would be are the following fields valid for a JV Doc Type in General Ledger type Items:

    Material Group Code
    Baseline Date
    payment date
    invoice quantity uom
    country
    po line number
    invoice quantity
    Purchasing Group
    Net Spend in USD
    Purchasing Organization
    standard price
    inv rc qty
    unit price
    std price currency
    price unit


    If yes, then how do I find these entries using joins. I already looked into BDEG, BKPF Tables.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 01:55 PM

    Hi Subhankar,

    Is it all the fields are available in BDEG and BKPF Tables. Then You create View for this tables and fetch data.

    Steps:

    Go to se11 t-code

    Select View Radio Button ---> Provide the name

    Then Create

    Give the Join Conditions and observe all fields are available or not..

    Provide this view in the Generic Extraction with Table/View in Transaction code RSO2.

    Based on Generic Extraction with Table/view create the datasource.

    Thanks,

    Purushotham.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 01:57 PM

    Subhankar,

    When I am asked to create a report from data about which I have no understanding, my first step is to consult with the functional analyst that installed the solution, or at least the one who is responsible for maintaining the solution. I have never seen the tables you mentioned, so I suspect they are only used when a specific solution is created (perhaps the Joint Venture Accounting solution?)

    The most expert functional analysts will know the tables involved and how SAP posts the data. Even less expert analysts will know which transactions are used, and the business conditions under which the transactions are executed. He also should have a basic understanding of the Master data required to support the solution. From this information, the report developer can use his expertise to determine which tables to select for extraction and display.

    You posted this question in a BW forum. If you don't get enough help here, you might want to consider closing this question here, and then re-posting it in the forum for the functional area of the data you wish to report on.

    Best Regards & Good Luck,

    DB49

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.