hi dear
i want Create DB view to hold all header sales document data on the following tables:
VBAK, VBKD, VBUK, KNA1 as follow:
FROM VBAK:
Sales Document
Created on
Time
Created by
Doc. Currency
Division
Sales Group
Sales Office
FROM VBKD:
Price group
Customer group
Sales district
Price List
Incoterms
Payt Terms
FROM VBUK:
Overall status
Totals status
Pricing
Document cat.
Document object
FROM KNA1:
Name
Name 2
City
Postal Code
Govern.Code
Search term
Street
Telephone 1
Fax Number
One-time acct
Address
2. i want also Select and display all data from that view from program code, sales order will be the only parameter.
Any pointers in this regard are very much helpful.
Regards
Waseem Hesham
Bluesky
