Skip to Content
0
Former Member
Dec 24, 2007 at 06:17 AM

Hello frields!

26 Views

I have to connect following fields from 18 tables.

Please send me the query how to get the data collectively in the output.

What wil be my approach?

Order No VBAK-VBELN

Sales Org VBAK-VKORG

Sales Org description Not required

Order Date VBAK-ERDAT

Purchase Order # VBKD-BSTKD

Purchase Order Date VBKD-BSTDK

Order Reason code VBAK-AUGRU

Order Reason description TVAUT-BEZEI

Partner Type TPAR-NRART(VBPA) - Note there will be 4 partners on each Sales Order

Partner Type description TPART-VTEXT(VBPA)

Partner no VBPA-KUNNR

Partner name1 ADRC-NAME1

Partner Name2 ADRC-NAME2

Partner Address 1 ADRC-STREET

Partner Address 2 ADRC-STRSUPPL1

Partner Address 3 ADRC-STRSUPPL2

Partner Address 4 ADRC-STRSUPPL3

City ADRC-CITY1

DISTRICT ADRC-CITY2

Country ADRC-COUNTRY

Post Code ADRC-POSTCODE1

PO BOX ADRC-POBOX

Partner email SZA1_D0100-SMTP_ADDR

Material no VBKD(MARA-MATNR)

Material Division VBAP-SPART

Product Line and Edition code VBAP-MVGR1

Product Line and Edition Desc TVM1T-BEZEI

Product Name code VBAP-MVGR2

ProductName Desc TVM2T-BEZEI

Product Version Code VBAP-MVGR3

Product Version Desc TVM3T-BEZEI

Product Platform Code VBAP-MVGR4

Product Platform Desc TVM4T-BEZEI

Product App Server Code VBAP-MVGR5

Product App Server Desc TVM5T-BEZEI

Compiler Code VBAP-KONDM

Compiler Desc V_T178-VTEXT

LanguageCode VBKD-KONDA

LanguageDesc V_T188-VTEXT

Runtime Band Code VBAP-VKAUS

Runtime Band description TVLV-BEZEI(chk table in vbap)

Support Start Date VBKD-BSTDK

Support End Date VBKD-BSTDK_E

Support Level Code

VBKD-KDKG2

Support Level Desc TVKGG-VTEXT( chk table inVBRP)

Order Quantity VBAP-KWMENG

Net Price VBAP-NETWR

Currency VBAP-WAERK