Need Help in understanding the JV Doc Types

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[former_member182196]

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

[RamanKorrapati]

Hi,

Please check with MM consultant, might be helpful.

Thanks