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