T Code SQVI

[Former Member]

I am using the data source Join Tables and i m joining 4 tables KNVP,VBRK,LIKP ,MARD and selected some fields and execute after execute i m giving the input in the selected fields and than execute .

It says no data selected.

Plz help me out .... i dnt know wt to do.

cheers

shalsa007.........

[Former Member]

Customer number

Sales organization

Delivery

Storage location

Material number

Profit center

Plant

these feilds i wanna join. How to give the proper primary and foreign keys plz explain me......

Customer SOrg Dv Bill.doc. SOrg Profit ctr Material Plnt SLoc

280662 0001 01 700090129 RIL 60020 PY002134 PG54 7001

this is shown below tht ruler...i dnt know how these values are coming .....

Plz explain me with example.

Cheers

shalsa007.......

[jiteshmehta]

Dear Shailesh

you can get all this fields in LIKP & LIPS only just select table join and take this two tables, all primary & foreign keys are defined

Customer number - Sold-to party, LIKP-KUNAG or Ship-to party , LIKP-KUNNR

Sales organization - LIKP-VKORG

Delivery - LIKP-VBELN

Storage location -LIPS-LGORT

Material number - LIPS-MATNR

Profit center - LIPS-PRCTR

Plant -LIPS-WERKS

This will be sufficient for your query and still you want some extra fields select Logical database will creating query and select VLV Logical database

Reward points if useful

Regards

Jitesh

[jiteshmehta]

Dear Shailesh

Please note the following

KNVP is table for Customer Master Partner Functions

VBRK is Billing: Header Data

LIKP is Delivery Header Data

MARD is Storage Location Data for Material

if you want to join this then proper primary key and foreign key assignment has to be done, if it is not done then you will not get the data.

If you can explain what fields you want in your query we can help you.

Also if you want sales invoice then use Logical Database as Data Source and

and select VFV as logical database.

Do revert if you need help

Regards

Jitesh