Abap Query

[Former Member]

Hi all,

I want to join four tables VTTK, VTTP, LIKP and VBAK in ABAP query.

VTTK - Shipment number & wight, Shipment creation date

VTTP - Delivery number

LIKP - Sold to & Ship to

VBAK - Sales area & Sales office

Selection criteria will be Shipment creation date and sales area.

I have created everything and when i give the selection parameter system is not displaying any records.But records are there

Anybody knows where I went wrong

Regards

Mano

[former_member192897]

Go to SQVI and Check the Field List and Selection Screen.

[former_member188076]

Hi Mano

However it is very difficult to understand the reason without checking the link between the tables which is maintained in SQVI. But my suggestion is to link the table as :- VBAK-LIKP-VTTK-VTTP, and use VBELN to join the tables with respect to follow-on document nos. as per the document flow.

Regards

AA

[Former Member]

Dear AA,

I have linked the table like this

VTTK - VTTP - LIKP - VBFA - VBAK .System is allowing me to link the table like this

Selection criteria is shipemnt date created and the output will be shipemnt number, Delivery number, weight, sold to, ship to, Dis cha, div, sales office, sales group

I neter the date in the selection screen and system is not displaying any records but the records are found

Reagrds

Mano

[Former Member]

Hi,

Please check your query Table Joining with the Primary and Secondary Keys.